Microsoft 70-463: Implementing a Data Warehouse with SQL Server 2012
Course
Online
Making the appropriate job role decisions around implementing a Data Warehouse with Microsoft SQL Server 2012.
-
Type
Course
-
Level
Intermediate
-
Methodology
Online
-
Duration
Flexible
-
Start date
Different dates available
-
Online campus
Yes
-
Delivery of study materials
Yes
-
Support service
Yes
-
Virtual classes
Yes
"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."
Facilities
Location
Start date
Start date
About this course
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
Reviews
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 6 years
Subjects
- Server
- SQL
- Quality
- Quality Training
- Javascript training
- HTML
- Javascript
- Web
- Writing
- Programming
- Networking
- Windows
- Office IT
- DNS
- Proxy
- Active Directory
- Rights Management
- Pilot
- Ms Office
- Install
Course programme
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
- 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
- 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
- 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
- Troubleshooting Packages
- Overview of Troubleshooting
- Debugging
- Breakpoints
- Error Handling
- SSIS Log Providers
- Custom Logging
- Troubleshooting and Logging
- Exam Scenarios
- Module Review
- Advanced Packages
- Maintaining a Data Warehouse
- Change Data Capture
- Slowly Changing Dimensions
- Script Components
- Incremental Updates
- Exam Scenarios
- Module Review
- Data Quality Services
- Introduction to Data Quality Services
- Data Quality Services Components
- Working with Data Quality Services
- Exam Scenarios
- Module Review
- Master Data Services
- Introduction to Master Data Services
- MDS vs. DQS
- How MDS Works
- Exam Scenarios
- Module Review
- Deployment and Security
- Deployment Options
- Package Deployment
- Securing Packages
- Deploying SSIS Packages and Projects
- Exam Scenarios
- Module Review
- Program Review
Microsoft 70-463: Implementing a Data Warehouse with SQL Server 2012