تفاصيل الدورة
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:
تفاصيل الدورة
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.
تحديث بتاريخ 20 October, 2016 - أقل
