Implementing a Data Warehouse with Microsoft SQL Server (M20463)

  • Support Business Intelligence solutions and Implement data warehouse

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

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

Key Points About Implementing a Data Warehouse with Microsoft SQL Server (M20463)

237 Learners Recommended

Duration: 5 Days*

Accredited: Yes

Book Now

Implementing a Data Warehouse with Microsoft SQL Server (M20463)

Course Overview

The Pearce Mayfield’s Implementing a Data Warehouse with Microsoft SQL Server (M20463) course provides essential knowledge required to set up warehousing facilities using SQL Server in the organisation. The course introduces delegates to the basic principles of data warehousing, data extraction, using master data services and creating ETL (Extract, Transform and Load) solution. During the course, the delegates will also learn how to cleanse and validate data using SQL Server master data and Quality Services.

Course Outline

  • Introduction to Data Warehousing
    • Data warehousing overview
    • Considerations for data warehousing solution
  • Planning Data Warehouse Infrastructure
    • Considerations for Data Warehousing Infrastructure
    • Planning Data Warehouse Hardware
  • Design and Implement Data Warehouse
    • Overview of Data Warehouse design
    • Design dimension tables
    • Design fact tables
    • Physical design for data warehouse
  • Create an ETL solution with SSIS
    • Introduction to ETL with SSIS
    • Explore data sources
    • Implement data flow
  • Implementing Control Flow in an SSIS Package
    • Introduction to control flow
    • Create dynamic packages
    • Use containers
    • Manage consistency
  • Debugging and Troubleshooting SSIS packages
    • Debug an SSIS package
    • Logging SSIS package events
    • Handle errors in SSIS package
  • Implementing a Data Extraction Solution
    • Plan data extraction
    • Extract modified data
  • Loading Data into Data Warehouse
    • Plan data loads
    • Use SSIS for incremental loads
    • Use Transact-SQL loading techniques
  • Enforce Data Quality
    • Overview of Microsoft SQL Server Data Quality Services (DQS)
    • Cleanse and validate data  
  • Master Data Services
    • Introduction to Master Data Services
    • Implement Master Data Services model
    • Manage Master data
    • Create Master data hub
  • Extending SQL Server Integration Services
    • Use scripts in SSIS
    • Use custom components in SSIS
  • Deploy and Configure SSIS Packages
    • Overview of SSIS deployment
    • Deploy SSIS projects
    • Plan SSIS package execution
  • Consuming Data in Data Warehouse
    • Introduction to business intelligence
    • Enterprise Business Intelligence
    • Big data and Self Service BI

The delegates must possess minimum three years working experience with some relational database management system. They must be familiar with the concepts of normalization and able to create tables and databases using the said concept. The knowledge of establishing relationships, executing SQL queries and writing scripts using T-SQL supported functions and procedures would also be beneficial.

The course is intended for Database professionals who are responsible for developing their Business Intelligence skills and Database developers who are involved in the implementation of 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
  • Implement data reliability using Master Data Services
  • Purify data using Data Quality Services

The Implementing a Data Warehouse with Microsoft SQL Server (M20463) Cost in United Kingdom Starts from £3735.00

Please see our Microsoft SQL Server Training courses available in United Kingdom

  • Key Learning Points
  • Certification
  • Tutor Support
  • Exam(s) included
telephone

Get More Information

Still have questions? We’re happy to help.

calendar

Dates & Prices

Choose a Location

Choose a Month

Learn from the comfort of your home or office

Join discussions via computer or mobile device

Interact with subject matter experts

40 Hours (on average)

90 Days Access

Certificate upon completion

Schedule and location of your choice

Save on travel costs

Monitor employee development

Key points about this course

237 Learners Recommended

Duration: 5 Days*

Accredited: Yes

Add additional features

Official Exam - £ 329.00

Personal career coach and career services

Your online (Implementing a Data Warehouse with Microsoft SQL Server (M20463)) package

Upon purchase you will receive a password via the email you used to purchase the course.

You will then be able to login to our online learning platform with your email and password.

You will have access to the platform for 90 days to complete your course.

Course Onsite Enquiry

Implementing a Data Warehouse with Microsoft SQL Server (M20463)

Complete the steps below to receive a quote or more information

Your details

How many employees need training test?

When would you like to take the course test?

How many employees need training?

Prev

Discover how we are doing

Our goal is to always provide training of the highest quality for your organisation.

We aim for customer satisfaction across all areas, including price, quality, and learning support. We always use the feedback from clients to continually improve and ensure we surpass expectation. Have a look at our customer reviews that showcase the standard we offer.

97% price

Response Rate

99% price

Positive Rating

Steps For Success

Leading Path To Success

works