A Quick Glance

  • black-arrow

    For supporting Business Intelligence solutions learn to implement data warehouse

  • black-arrow

    Maintain quality and integrity of data using SQL Server Data Quality Services

  • black-arrow

    Understand about SSIS packages and how to load, extract and transform information from it

  • black-arrow

    Course is developed by well qualified, and Microsoft certified trainers

  • black-arrow

    Gain the certification and accomplish your career goals

  • black-arrow

    Pentagon Training offers this course at an affordable price

As the size of databases is growing day by day, we need to retrieve data as fast as possible and write it back at same speed. For this, companies need to make sure that databases are working smoothly. For managing different types of applications and databases, nowadays companies make use of SQL Server. Companies chose to use SQL Server over other popular database systems like Oracle or DB2 due to its excellent features. SQL Server provide features like high availability, better transactional throughput and excellent performance. Proper implementation of SQL Server is required for excellent performance. 

In this Pentagon Training’s Implementing a Data Warehouse with Microsoft SQL Server (M20463) course delegates will learn how to create data warehouse using Microsoft SQL Server and implementing it with SQL Server Integration services. Get the complete technical skills required to install data warehouse using SQL Server 2014.   

Who should take this course

The intended audience for this course is database professionals who want to become Business Intelligence developers.

Database developers are required to focus implementing a data warehouse, ETL and cleansing data.

Primary responsibilities of database administrator include:

  • Implementing data warehouse
  • Develop SSIS packages for data loading, transformation and extraction.
  • Enforce data integrity using Master Data Services.
  • Cleanse data using Data Quality Services.
More

Prerequisites

For attending this course, delegates must have at least three years of experience of working with relational database management system.

Knowledge of designing normalised databases, creating tables and their relationships, querying with Transact-SQL and basic programming constructs like branching and looping is required for attending this course.

More

What Will You Learn

  • Understand concepts and architecture of data warehouse.
  • For Data Warehouse, learn to select suitable hardware platform.
  • Effectively design and implement a data warehouse.
  • Understand to implement data flow and control flow in SSIS package.
  • Learn to debug and troubleshoot SSIS packages.
  • Implement SSIS solution that supports incremental data warehouse loads and data extraction.
  • Using Microsoft Data quality services cleanse the data.
  • Enforce data integrity using Master Data Services (MDS).
  • Learn to extend SSIS with custom components and scripts.
  • Understand to configure and deploy SSIS packages.
  • Learn how Business Intelligence solutions consume data in the data warehouse.
More

What's included

  Course Overview

In this Pentagon Training’s Implementing a Data Warehouse with Microsoft SQL Server (M20463), course get the knowledge and skills required to set up and implement data warehouse using SQL Server in an organisation. Also, learn basic principles of data warehousing, data extraction, using master data services and creating ETL solution. Find out how to cleanse and validate data using SQL Server master data and Quality Services.

More

  Course Content

Introduction to data warehousing

In this module, understand key components of data warehousing and other high-level considerations one must take into account when undertaking data warehousing project.

  • Introduction to data warehousing
  • Considerations for data warehousing solution

Planning data warehouse infrastructure

Learn what to consider for selecting hardware and distributing SQL Server facilities across servers.

  • Considerations for Data Warehousing Infrastructure
  • Planning Data Warehouse Hardware

Design and implement data warehouse

In this topic, understand about key factors for the logical design of data warehouse and then discuss best practices for physical implementation.

  • Overview of Data Warehouse design
  • Design dimension tables
  • Design fact tables
  • Physical design for data warehouse

Create an ETL solution with SSIS

In this topic, understand about considerations for implementing ETL process and then focus on Microsoft SQL Server Integration Services (SSIS) for building ETL solutions.

  • Introduction to ETL with SSIS
  • Explore data sources
  • Implement data flow

Implementing Control Flow in an SSIS package

In this module learn how to implement ETL solutions that merge multiple tasks and workflow logic.

  • Introduction to control flow
  • Create dynamic packages
  • Use containers
  • Manage consistency

Debugging and troubleshooting SSIS packages

In this module understand how you can debug packages to find the reason of errors occurrence during execution. Understand the logging functionality built into SSIS that can be used to log events for troubleshooting purpose. It also describes approaches for handling errors in control flow and data flow.

  • Debug an SSIS package
  • Logging SSIS package events
  • Handle errors in SSIS package

Implementing a Data Extraction Solution

In this module, understand the techniques that can be used to perform an incremental data warehouse refresh.

  • Plan data extraction
  • Extract modified data

Loading data into Data Warehouse

In this module understand the techniques used to implement data warehouse load process.

  • Plan data loads
  • Use SSIS for incremental loads
  • Use Transact-SQL loading techniques

Enforce Data Quality

Understand about Microsoft SQL Server Data Quality Services (DQS) and describe how it can be used to cleanse and de-duplicate data.

  • Overview of Microsoft SQL Server Data Quality Services (DQS)
  • Cleanse and validate data  

Master data Services

In this topic, Master Data Services provide a way for organisations to standardise data and improve its quality, consistency and reliability that helps in key business decisions. It also introduces Master Data Services and its benefits of using it.

  • Introduction to Master Data Services
  • Implement Master Data Services model
  • Manage Master data
  • Create Master data hub

Extending SQL Server Integration services

In this module understand the techniques to extend SSIS and get awareness of major steps required to use scripts in an ETL process and custom components based on SSIS.

  • Use scripts in SSIS
  • Use custom components in SSIS

Deploy and configure SSIS packages

In this module learn how to implement packages and their dependencies to the server. Learn how to manage and monitor the execution of deployed packages effectively.

  • Overview of SSIS deployment
  • Deploy SSIS projects
  • Plan SSIS package execution

Consuming Data in Data Warehouse

This module introduces Business Intelligence solutions that data warehouse can use as a basis for enterprise and self-service BI lessons.

  • Introduction to business intelligence
  • Enterprise Business Intelligence
  • Big data and Self Service BI
More


Implementing a Data Warehouse with Microsoft SQL Server (M20463) Enquiry

 

Enquire Now


----- OR -------

Reach us at +44 1344 961530 or info@pentagonit.co.uk for more information.

About Southampton

Southampton lies on the south coast of England and is the largest city in the county of Hampshire. It is a major port and the closest city to the New Forest. It lies at the northernmost point of Southampton Water at the confluence of the Rivers Test and Itchen.  The population of the city is estimated to be  253,651. A resident of Southampton is called a Sotonian.

 History

Southampton has been inhabited since the stone age. Following the  the conquering of the local Britons in 70 AD by the Romans, the fortress settlement of Clausentum was established. It was an important trading port and a defensive outpost of Winchester, at the site of modern Bitterne Man. After the Norman Conquest in 1066, Southampton became the major port of transit between Winchester and Normandy. Southampton Castle was built in the 12th century. Southampton became a leading port in the 13th Century.French wine was exchanged for English cloth and wool. Southampton was also instrumental in bringing Black Death to England via merchant's vessels.

Southampton expanded during the Victorian age. The Southampton Docks company was formed in 1842. Southampton subsequently became known as The Gateway to the Empire. Shipbuilding was one of the major businesses in the 20th century. Ships that fought during the two world wars were made in Southampton. The Titanic sailed on its first and last voyage from Southampton.

The longest surviving stretch of medieval walls in England is located in Southampton. Also, Southampton is home to many museums.

The SeaCity Museum    was initially occupied by Hampshire Constabulary and the Magistrates' Court. It focuses on Southampton's trading history and on the RMS Titanic. The museum receives half a million pounds from the National Lottery. It also recieves  interest from many private investors .

 Education

The University of Southampton and Southampton Solent University together have over 40,000 students.

The University of Southampton which received its Royal Charter as a university in 1952, has over 22,000 students. It is ranked in top 100 research universities in the world by Academic Ranking of World Universities 2010 and 80th according to the THES. It considers itself one of the top 5 research universities in the UK. The university has a global reputation for research into various sciences. It is also home to the National Oceanography Centre, Southampton (NOCS).

 Southampton lies on the south coast of England and is the largest city in the county of Hampshire. It is a major port and the closest city to the New Forest. It lies at the northernmost point of Southampton Water at the confluence of the Rivers Test and Itchen. The population of the city is estimated to be  253,651. A resident of Southampton is called a Sotonian.

 

 

More