On-Demand learning...
be In-Demand and earning.

Microsoft 70-463: Implementing a Data Warehouse with SQL Server 2012

Course 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

Language:

English

Type of Course:

Self Paced

---

eCertIT is committed to ensuring that your investment in IT learning is well rewarded with:

• Expert instructor led training
• Virtual Labs – practice 24 X 7 in your own, live, test environment
• Practice exams, test your knowledge with certification type exam questions
• Community Forum to share experiences and knowledge
• Australian support
• Multiple certification offerings at reduced cost