Training Overview

The ever-changing ICT sector requires a training solutions provider that sets the pace by offering the most recent and technologically advanced courses available. As leaders in IT education Sochin is well placed to facilitate the development of core skills and expertise, as required by the ICT sector both locally and abroad.

We provide training, team-building, speaking and business consulting services.  Developed with international expertise and used by major corporations and universities worldwide, we have over 200 courses designed to take you to your next page of success.

 

 

Microsoft® SQL Server® 2012: Data Warehouse Implementation

Course Specifications

Course Length:

5 days

Course Description

Overview: You have created databases and performed database administration tasks. As business expands, organizations build data warehouses to manage the huge volumes of data and obtain strategic information from it. To meet these requirements, you will create dimension tables and fact tables and implement them in a data warehouse in SQL Server 2012.

You will also perform ETL operations by creating SSIS packages, managing a control flow and data flow, executing packages, and troubleshooting errors. To ensure the smooth functioning of the ETL operations, you will manage SSIS packages and secure them. In addition to these tasks, you will work with master data and access databases in the Windows Azure cloud platform. By familiarizing yourself with these tasks, you can implement a data warehouse in your organization that suits the requirements of your business. In this course, you will implement a data warehouse

Course Objectives: Upon successful completion of this course, students will be able to implement data warehouse in Microsoft SQL Server 2012. You will:

  • Identify the Basic Features of Data Warehouses and Data Warehousing Concepts
  • Create Dimensions and Change Granularity of Dimensions
  • Create Fact Tables and ColumnStore Indexes
  • Implement Data Warehouses in SQL Server 2012
  • Work with Integration Services
  • Manage Control Flow
  • Work with Dynamic Variables
  • Implement Data Flow
  • Manage Data Flow Capabilities
  • Manage SSIS Packages Execution
  • Debug and Troubleshoot Packages
  • Deploy Packages
  • Secure Packages and Databases
  • Work with MDS and Windows Azure  

Target Student: This course is designed for Extract Transform Load (ETL) and Data Warehouse developers who are already handling the creation and implementation of Business Intelligence (BI) solutions such as data cleansing, ETL, and implementing Data Warehouse. This course is also intended for database professionals who aspire to become a BI developer and want to gain hands on experience on creating BI solutions.

The primary responsibilities of the students may include the following:

    • Implement a data warehouse
    • Develop SQL Server Integration Services (SSIS) packages for data extraction, transformation, and loading (ETL)  
    • Synchronize data, migrate data, and manipulate and transform ad hoc data
    • Enforce data integrity using Master Data Services
    • Cleanse data using Data Quality Services
    • Migrate application or one-time data
    • Schedule ETL jobs
    • Manage, configure, and deploy SQL Server Integration Services (SSIS) packages  

This course is also for students who are seeking the Microsoft Certified Solutions Associate (MCSA) certification and who want to take the exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012 as a stand-alone, or as part of the requirement for the MCSA: SQL Server 2012; MCSE: Data Platform; MCSE: Business Intelligence certifications.  

Prerequisites: To ensure your success in this course, you should have: 

    • A minimum of two years of experience in administering relational databases
    • Designed a normalized database
    • Created tables and relationships
    • Used query with Transact-SQL
    • Basic knowledge on key business priorities such as revenue, profitability, and financial accounting
    • Basic Knowledge in programming constructs such as looping and branching
    • Relational Database Design Courses
    • Microsoft SQL Server 2012: Database Querying (Exam 70-461)
    • Microsoft SQL Server 2012: Database Administration (Exam 70-462) 

 

 

 

Event Properties

Event Date 16/10/2017
Individual Price R10,250.00
Location
Sochin Technologies
Unit E18, Lifestyle Riverfront Office Park, Bosbok Rd, Randpark Ridge, Randburg, 2169, South Africa
Sochin Technologies
We are no longer accepting registration for this event
R10,250.00 12
Share this event:

Mini Calendar

November   2017
M T W T F S S
    1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30      

Site Map:

Home Solutions Technology Clients

 ➮ Consulting

 ➮ Microsoft

 ➮ Agile Transformation

 ➮ Java

 ➮ Business Analysis

 ➮ Open Source

 ➮ Business Intelligence

 ➮ RDBMS

 ➮ Data Analytics

 ➮ Adobe – Flash, Flex, AIR

 ➮ Custom Development

 ➮ Mainframe & Midrange

 ➮ Resourcing

 ➮ WebSphere

 ➮ Training

       
Resourcing Learning Shop Online Contact Us
 ➮ Employer Control Panel      
 ➮ Job Seeker Control Panel