Course Brief
The primary audience for this course is ETL and Data Warehouse Developers. They are most likely to focus on hands-on work creating business intelligence (BI) solutions including data cleansing, Extract Transform Load (ETL), and Data Warehouse implementation. Their primary responsibilities may include:
- Mastering data using Master Data Services
- Cleansing data using Data Quality Services
- ETL Package development for data loading/transfer/transformation
- Data Synchronization
- One-time data or application migration
- Ad-hoc data manipulations, transformations
- Scheduling ETL jobs
- Managing, configuring and deploying SQL Server Integration Services (SSIS) packages
This course is available for Corporate Training only. Please contact us for a quotation.
- This course is offered in 30 hours
The primary audience for this course is ETL and Data Warehouse Developers. They are most likely to focus on hands-on work creating business intelligence (BI) solutions including data cleansing, Extract Transform Load (ETL), and Data Warehouse implementation. Their primary responsibilities may include:
- Mastering data using Master Data Services
- Cleansing data using Data Quality Services
- ETL Package development for data loading/transfer/transformation
- Data Synchronization
- One-time data or application migration
- Ad-hoc data manipulations, transformations
- Scheduling ETL jobs
- Managing, configuring and deploying SQL Server Integration Services (SSIS) packages
Champs Fleurs
There are no classes scheduled in Champs Fleurs at this time.
- Microsoft Certified Solutions Associate (MCSA): SQL Server 2012
The Microsoft Certified Solutions Associate (MCSA): SQL Server 2012 certification demonstrates your essential skills and breakthrough insights in developing and maintaining the next wave of mission critical environments.
This certification qualifies you for a position as a software or database developer or database analyst.It consists of the following modules and each module is covered in 30 contact hours.
- Querying Microsoft SQL Server 2012 (70-461):Create database objects; work with data; modify data, troubleshoot and optimize
- Administering Microsoft SQL Server 2012 Databases (70-462): Install and configure; maintain instances and databases; optimize and troubleshoot; manage data; implement security; implement high availability
- Implementing a Data Warehouse with Microsoft SQL Server 2012 (70-463): Design and implement a data warehouse; extract and transform data; load data; configure and deploy SSIS; build data quality solutions
Why Study MCSA:SQL Server with SBCS?
- Instructors are certified, highly skilled and experienced practitioners who bring their knowledge and work experience to the classroom.
- Course is career oriented. The curriculum was developed to meet the needs of the current marketplace.
- The course is practical. All sessions are held in a lab and each participant has access to a computer.
- Modern, fully equipped labs. You learn using the same hardware and software that you will encounter in the field.
- Convenient class schedules. Classes are offered part-time at one location. This allows working individuals to balance their work and educational needs.
- Sufficient contact hours to cover the full syllabus and prepare participants for the Microsoft exams.
- Microsoft exams can be written at your convenience at our Champs Fleurs campus through our testing center.
SCHEDULE & FEES
This programme is available for Corporate Training. Please contact us for a quotation.