Financial Aid May be AVAILABLE, to those that qualify

SAS and Information Technology Courses

 

30 Hours

SAS I: Fundamentals of SAS Programming

 

Prerequisites:
1. University degree in math, statistics, actuarial science, medicine, public health, pharmaceutics, economics, financial service, computer science, business administration and engineering
2. Work experience in one of the fields listed above.


This course is designed to provide students with the knowledge and skills in Statistical Analysis System (SAS) for a position as a SAS programmer/data analyst.  It introduces basic SAS concepts, SAS language components, and teaches you how to create SAS programs.  Upon completion of this subject, students will be able to write SAS program codes independently and perform statistical descriptions.  This subject serves as a pre-requisite for the Advanced SAS Programming course, which is designed for those who want to work in a higher level data analysis position.
30 Hours

SAS II: Advanced SAS Programming

 

Prerequisites: SAS I- Fundamentals of SAS Programming


This course covers evaluation of DATA step compilation and execution, data management, do loop within observation and among observations, complex application of character functions, comprehensive applications of DATA and PROC steps, efficiency of SAS programming, and brief introduction of SQL and MACRO in data manipulation.
35 Hours

Statistical Modeling using SAS

 

Prerequisites:
1. SAS II: Advanced SAS Programming;
2. Successful completion of Business Project with SAS is strongly recommended.


This course covers advanced statistical topics with a focus on building data models using SAS technology. The topics in this course include logistic regression, linear regression, statistical tests, segmentation, using classification and regression tree, and association. Upon successful completion of this subject, students will be able to function as a data modeling analyst or take similar positions.
15 Hours

Data Analysis Project using SAS

 

Prerequisites:
1. SAS II: Advanced SAS Programming
2. Approval from the SAS instructor


This course will provide students with an opportunity to apply the SAS programming knowledge and skills gained from SAS I & II to complete a comprehensive project in a data analysis working environment. Students will select one of the business scenarios as his/her project which fits his/her interest and work experience. Students will be required to complete the project with some supervision from the project instructor. Upon completion of this project, students will be able to work as an SAS Programmer, Data Analyst, Credit Risk Analyst, Research Analyst, Marketing Analyst, Statistician, etc.
40 Hours

SQL Programming for Data Analysts and Statisticians

 

Prerequisites: basic computer programming knowledge


This intensive course is designed to help students build relational database designs and programming and then apply those skills to any SQL-based product. Students will learn, step-by-step, how to create a database, create tables, enforce data integrity, query and modify data, and implement advanced data access techniques.
30 Hours

Advanced Microsoft Excel

 

Prerequisites: Intermediate MS Excel


This course is designed for students who have interest in data analysis using Microsoft Excel. It covers the following topics: financial functions, statistical functions, pivot table, v-Lookups, data manipulation and macros. Students are required to complete a data analysis project using Microsoft Excel.
40 Hours

Business Intelligence and SAP Crystal Reports

 

Prerequisites: Computer Literacy


In this course, students will learn how to develop sophisticated reports using Crystal Reports – an industry leading report-writing tool. They will learn how to connect to various corporate data sources, such as SQL Server, Oracle, Microsoft Access, and XML files. They will also learn how to navigate these data storage systems, learn how to find the information they need, and how to extract the data to produce sophisticated reports.

Students will also learn how to publish these reports via the Internet and intranets and how to integrate reports into custom applications. As a result, they will return to their organization with a detailed checklist to help them connect to data sources and begin creating useful reports.

60 Hours

CISCO Router

 

Prerequisites: Windows Server 2012 Network Infrastructure


This course will help students understand the working mechanism of CISCO routers in a network environment, configure different routing protocols, security of network, access to the network computers, and configure CISCO switches. At the end of the course, students will become confident and competent enough to work with routers in a network environment.
40 Hours

CISCO CCNA Security

 

Prerequisites: CCNA


This course will give students important knowledge and skills necessary to secure the CISCO network. Students will learn about security infrastructure which includes how to recognize threats and vulnerabilities to networks and how to mitigate security threats. Students will learn core security technologies, installation, and troubleshooting. Students will also learn about monitoring of network devices to maintain the integrity, confidentiality, availability of data and devices, and competency in the technologies that CISCO uses in its security structure.
36 Hours

Citrix Xen Server

 

Prerequisites: Knowledge and skills of Windows or Linux Operating System


In Citrix Xen Server, students will learn about the Citrix Xen server, its related components, and products. Students will learn how the Xen server helps build cloud through data center automation, improve high availability, business continuity, reduces power consumption and cooling costs, management costs and how to optimize the hardware.
40 Hours

Developing Microsoft SQL Server Databases

 

Prerequisites: Programming fundamentals


This course introduces SQL Server 2012 and describes logical table design, indexing, and query plans. This course also focuses on the creation of database objects including views, stored procedures, parameters, and functions. Other common aspects of procedure coding, such as transactions, concurrency, error handling, triggers, and SQL CLR, are also covered in this course.

All the labs for this course can be performed using the provided virtual machines. However, if you have a Microsoft Windows Azure account and the classroom virtual machines are connected to the internet, you may be able to connect to your Azure server and database from the classroom. Many of the labs in this course are enabled for you to perform the lab work while connected to your own Azure database in the cloud. Your instructor will provide a current list of Azure enabled labs.

Prerequisite: In addition to their professional experience, students who attend this training should already have the following technical knowledge: Knowledge of writing T-SQL queries and Knowledge of basic relational database concepts.

Students who attend this training can meet the prerequisites by attending the following courses, or obtaining equivalent knowledge and skills: Writing T-SQL Queries for Microsoft SQL Server 2012

48 Hours

LINUX Administration

 

Prerequisites: A+ Essentials, MS Windows 2012 Server Network Infrastructure


This course introduces the Linux Operating System on a GUI level and will help students understand how to use shell and command line utilities to manage network and local services that it provides.
40 Hours

VMware Server

 

Prerequisites: MS Windows 2012 Server


This course will help students understand how to install, configure, modify, and maintain virtual machines at their highest performance levels.