Microsoft 70-463 Implementing a Data Warehouse with SQL...
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.
- 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.
Who this course is for:
- IT Professionals who wish to gain Microsoft Certification
- ETL and data warehouse developers
At Stone River eLearning, technology is all we teach. If you're interested in IT, programming, development or design - we have it covered.
Check out our huge catalog of courses and join the over 2.3M students currently taking Stone River eLearning courses. We currently offer 1000+ courses. We can provide all or part of this catalog to any business via API connection, or you can get your own branded LMS free with 10+ users.