
Microsoft 70-463: Implementing a Data Warehouse with SQL Server 2012
£495.00
Description
Description
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
Syllabus:
Module 1
- Introduction to Data Warehousing
- OLTP vs. OLAP
- Data Warehouse
- Data Warehouse Architecture
- Creating a Data Warehouse
- Presenting OLAP Data
- OLTP and OLAP Comparison Demonstration
- Exam Scenarios
- Module Review
Module 2
- Designing a Data Warehouse
- Data Modeling
- Data Warehouse Schemas
- Time Dimensions
- Data Modeling Considerations
- Implementing a Data Model
- Logical Model
- Physical Model
- Dimensions and Facts
- Exam Scenarios
- Module Review
Module 3
- ETL with SSIS
- Introduction to SSIS
- Upgrading SSIS Packages
- SSIS Tools
- Data Flow Tasks
- Data Sources
- Transformations
- Utilizing SQL Server Data Tools
- Data Flow Task
- Exam Scenarios
- Module Review
Module 4
- SSIS Control Flow
- Control Flow Tasks
- Integration Services Variables
- Expressions
- Precedence
- Containers and Annotation
- Transactions
- Checkpoints
- Control Flow Tasks and Precedence
- Exam Scenarios
- Module Review
Module 5
- Troubleshooting Packages
- Overview of Troubleshooting
- Debugging
- Breakpoints
- Error Handling
- SSIS Log Providers
- Custom Logging
- Troubleshooting and Logging
- Exam Scenarios
- Module Review
Module 6
- Advanced Packages
- Maintaining a Data Warehouse
- Change Data Capture
- Slowly Changing Dimensions
- Script Components
- Incremental Updates
- Exam Scenarios
- Module Review
Module 7
- Data Quality Services
- Introduction to Data Quality Services
- Data Quality Services Components
- Working with Data Quality Services
- Exam Scenarios
- Module Review
Module 8
- Master Data Services
- Introduction to Master Data Services
- MDS vs. DQS
- How MDS Works
- Exam Scenarios
- Module Review
Module 9
- Deployment and Security
- Deployment Options
- Package Deployment
- Securing Packages
- Deploying SSIS Packages and Projects
- Exam Scenarios
- Module Review
- Program Review
Course Delivery: Online