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

Call us on: 1800 422 393

Enquire online

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

Not sure which course?

Let us help you with your IT learning and advise you on your career goals.

Email, Free call 1800 422 393 or online chat

Certification by vendor

Cisco
Microsoft
ITIL
CompTIA
EC-Council
Oracle
(ISC)²
PMI
Linux Professional Institute
Exin
Cloud Security Alliance
PRINCE2®
Website design and development by Almatech Ltd - ©2019.