Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
4 Hour(s) 40 Minute(s)
Language
English
Taught by
Stone River eLearning
Rating
Course Overview
Implementing Data Warehouse with SQL Server 2012
This course is specifically for participants to measure their knowledge and skills on making the appropriate job role decisions around implementing a Data Warehouse with Microsoft SQL Server 2012.
This course is designed for ETL and Data Warehouse Developers who most likely focus on hands-on work creating business intelligence (BI) solutions, including data cleansing, Extract Transform Load (ETL), and Data Warehouse implementation. 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 training course on implementing a Data Warehouse with Microsoft SQL Server 2012 prepares participants for the Microsoft Exam 70-463.
This course will provide all the skills and knowledge for the following areas:
- Designing and implementing dimensions
- Designing and implementing fact tables
- Defining connection managers
- Designing and implementing data flow
- Managing SSIS package execution
- Implementing script tasks in SSIS
- Designing and implementing control flow
- Implementing package logic using SSIS variables and parameters
- Implementing data load options
- Implementing script components in SSIS
- Troubleshooting data integration issues
- Installing and maintaining SSIS components
- Implementing auditing, logging, and event handling
- Deploying SSIS solutions
- Configuring SSIS security settings
- Installing and maintaining Data Quality Services
- Implementing master data management solutions
- Creating a data quality project to clean data
We create the highest quality course curriculum possible, ensuring you receive the training and knowledge needed to succeed.
Course Content
- 10 section(s)
- 100 lecture(s)
- Section 1 Implementing a Data Warehouse with Microsoft SQL Server 2012
- Section 2 Module 1
- Section 3 Module 2
- Section 4 Module 3
- Section 5 Module 4
- Section 6 Module 5
- Section 7 Module 6
- Section 8 Module 7
- Section 9 Module 8
- Section 10 Module 9
What You’ll Learn
- This course will prepare you to pass the exam Microsoft 70-463: Implementing Data Warehouse with SQL Server 2012.
- This course is designed for ETL and Data Warehouse developers who most likely focus on hands-on work creating business intelligence (BI) solutions, including data cleansing, Extract Transform Load (ETL), and Data Warehouse implementation.
Skills covered in this course
Reviews
-
CConnor Johnson
This course is very thorough, but at times hard to follow because of how dense the information is. I found the demonstration lessons within SSMS to be really helpful and hoped there would be more of them. Someone with more experience than me could probably follow all of this with no problem.
-
CConny van der Aalst
Veel theorie die snel wordt doorlopen. De praktische uitleg is wat minder
-
RRyan Clark
This is still an excellent course, however there are several time during the course where essential steps are skipped, such as setting up Report Services Configuration Manager for the first time that took a while to figure out. Would still highly recommend for anyone looking to pass the exam!
-
OOseiwe Umobuarie
Not enough practical demonstration.
