SAS and Information Technology Courses
SAS I: Fundamentals of SAS Programming
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.
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.
Statistical Modeling using SAS
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.
Data Analysis Project using SAS
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.
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.
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.
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.
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.
CISCO CCNA Security
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.
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.
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
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.
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.