Microsoft MCSA: SQL Server 2012/2014 (70-463): Implementing a Data Warehouse with Microsoft SQL Server 2012/2014

About this course:

This course is specifically for individuals who want to measure their knowledge and skills on and around implementing a Data Warehouse with Microsoft SQL Server 2012. This course is ideal for ETL and Data Warehouse Developers who want to focus on hands-on work creating business intelligence (BI) solutions, including data cleansing, Extract Transform Load (ETL), and Data Warehouse implementation.

Things you learn:

 

  • 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
Study Mode:

Online Only. Instructor Led E- Learning

Course Fees:

To Enrol for this course or to find out more on pricing or payment methods, please contact our Learning Consultants. Click here –  Contact Us 

If you are looking at completing more than one Certification in the next 12 months, it might be worthwhile looking at our Course Subscription option. To find out more Click here – Subscription option. 

Provider:

Administration provider and located in Australia. Powered by Skillsoft content

Career Opportunities:
  • Business Intelligence (BI)
  • Software Developers
  • Coders
  • Web Developers
  • IT Programmers
  • Systems Engineers
  • Systems Administrators
  • App Developers
  • SQL Server database administrators
  • System engineers
  • SQL developers
Recognition:

Global Recognition. Requires sitting for the Microsoft Certification Exam: 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012/2014.

You are able to sit for this exam Online or physically at an exam centre. For further information please contact our Learning Consultants today.

Pre Requisites:

None for the course.

Course location:

Online – 100% Flexible Self Study – You study at your own pace, at your own time. You have 24 hours access via your own private study portal.

Course Length:

30 hours – (depends on the learner, how quickly they pick the skills is up to the student) you have 6 months (180 days) months access to your course material. You have more than enough time to complete this short course.

** Part – time students dedicate on average 5 hours study time per week. This course would approximately take 6-8 weeks to complete at that pace of study.

Start date:

Within 3 working days payment confirmation and enrolment form completed or you can pick your own start date!

What will I Learn/ Extra Information:
Modules
  • Designing & Implementing Dimensions
  • Designing a Fact Table
  • Connection Managers & Data Sources
  • Data Transformation & Flow
  • Data Flow Implementation & ETL
  • SSIS Package Execution & Script Tasks
  • Designing Control Flow
  • Implementing Control Flow
  • SSIS Variables
  • SSIS Packages
  • Data Loading
  • Script Components
  • SSIS Components
  • Auditing, Logging, & Event Handling
  • Troubleshooting Data Integration
  • SSIS Solutions
  • SSIS Security
  • Data Quality Services (DQS) & Master Data Services (MDS)
  • Data Quality Projects
E Books  Included
Labs: Included
Certification Exam focus:
  • Design and implement a data warehouse (10–15%)
  • Extract and transform data (20–25%)
  • Load data (25–30%)
  • Configure and deploy SSIS solutions (20–25%)
  • Build data quality solutions (15–20%)
How to Enrol for this Course

For the Subscription option please click below on the Subscribe Here button.

For the Individual course, please contact us via live chat or click below on the Contact CertHub button.