Microsoft 70-463 Implementing a Data Warehouse with SQL...
- 4.5 hours on-demand video
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Get your team access to Udemy's top 3,000+ courses anytime, anywhere.Try Udemy for Business
- 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.
- Basic understanding of SQL server
- Interest in Business Intelligence (BI) solutions
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.
- IT Professionals who wish to gain Microsoft Certification
- ETL and data warehouse developers