Microsoft SQL 2012 – Data Warehouse Implementation (Exam 70-463)

Simply Cert

Course

Online

£ 195 VAT inc.

The best SQL Server courses

See all

See all

Description

  • Type

    Course

  • Level

    Intermediate

  • Methodology

    Online

  • Duration

    12 Months

  • Start date

    Different dates available

  • Online campus

    Yes

  • Delivery of study materials

    Yes

  • Support service

    Yes

  • Virtual classes

    Yes

Microsoft SQL 2012 – Data Warehouse Implementation (Exam 70-463)

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

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

This package is designed for any individual wishing to pursue or enhance their career as a Microsoft Engineer.

Our Online Courses is a cost-effective and successful approach for many individuals. It provides a flexible learning method, allowing candidates to schedule learning at a time that suits them and fits in with other commitments; ideal for those who find it difficult to take time away from their workplace. It also allows candidates to work at their own pace, and revisit sections of the course as often as needed, leading to a fuller understanding of all the topics covered.

In addition, there are none of the high costs of travel and accommodation associated with courses at an external venue.

A list of Career Paths you can pursue:

1st Line Support
2nd Line Support
3rd Line Support
Computer Support Specialist
Database Administrator
Database Analyst
Database Engineer
Database Consultant
Network Administrator
Exchange Server Administrator
Computer Systems Administrator
Exchange Recipient Administrator
Network Engineer
IT Technician
IT Engineer
IT Support Engineer
Desktop Support Technician
IT Support Analyst
Service Desk Administrator
Computer Support Administrator

Our training works on all devices including Mobile phones, IPad’s, Android tablets, Macs and PC’s.

Microsoft

Exam Information
You'll sit an exam at a local test centre. We provide interactive quizzes after each module and a mock exam at the end of your course to ensure you're fully prepared for the real thing. Once you've passed with at least 80%, you'll be able to book your exam as a private candidate.

Please NOTE: Exams are not included.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Server
  • SQL
  • Quality
  • Project
  • Quality Training
  • Warehousing
  • Concepts
  • Examine
  • Tables
  • Column

Course programme

Course Outline

Lesson 1: Introduction to Data Warehouses
  • Topic A: Overview of Data Warehouses
  • Topic B: Examine Data Warehousing Concepts
  • Topic C: Introduction to Data Analysis and Reporting Concepts
Lesson 2: Creating Dimensions and Changing Granularity of Dimensions
  • Topic A: Create Dimensions
  • Topic B: Change Granularity
Lesson 3: Creating Fact Tables and Column store Indexes
  • Topic A: Create Fact Tables
  • Topic B: Create Column store Indexes
Lesson 4: Implementing Data Warehouses in SQL Server 2012
  • Topic A: Overview of Data Warehouse Components
  • Topic B: Install Integration Services
Lesson 5: Working with Integration Services
  • Topic A: Create an SSIS Project
  • Topic B: Add Packages to an SSIS Project
Lesson 6: Managing Control Flow
  • Topic A: Deploy a Control Flow
  • Topic B: Execute Packages from Different Control Flow
Lesson 7: Working with Dynamic Variables
  • Topic A: Create Expressions with Variables
  • Topic B: Create Package Templates
Lesson 8: Implementing Data Flow
  • Topic A: Add Data Flow Components to a Data Flow Task
  • Topic B: Perform Transformation Tasks
  • Topic C: Track Changed Data
Lesson 9: Managing Data Flow
  • Topic A: Add Script Tasks and Script Components to an SSIS Package
  • Topic B: Profile OLTP Data
  • Topic C: Cleanse Data Using DQS
Lesson 10: Managing SSIS Package Execution
  • Topic A: Execute SSIS Packages on the Server
  • Topic B: Configure the Package Execution Strategy
Lesson 11: Debugging and Troubleshooting Packages
  • Topic A: Debug Package Execution Components
  • Topic B: Troubleshoot Package Failures
Lesson 12: Deploying Packages
  • Topic A: Deploy SSIS Packages
  • Topic B: Examine MSI Packages
Lesson 13: Securing Packages and Databases
  • Topic A: Secure Packages
  • Topic B: Secure Databases
Lesson 14: Working with MDS and Windows Azure
  • Topic A: Configure MDS
  • Topic B: Work with MDS Databases
  • Topic C: Work with Windows Azure

See related categories

Microsoft SQL 2012 – Data Warehouse Implementation (Exam 70-463)

£ 195 VAT inc.

The best SQL Server courses

See all

See all