Implementing a Data Warehouse with Microsoft SQL Server 2012

Learn how to design and implement an enterprise data warehouse. Microsoft Certified Trainer Martin Guidry shows how to design fact and dimension tables using both the star and snowflake techniques, use data quality services to cleanse data, and implement an ETL process with SQL Server integration services.

Topics include:

  • Typical databases vs. vdata warehouses
  • Choosing between star and snowflake design schemas
  • Working with appliances and "big data"
  • Exploring source data
  • Implementing data flow
  • Debugging an SSIS package
  • Extracting and loading modified data
  • Enforcing data quality
  • Consuming data in a data warehouse

Course Timeline:

Implementing a Data Warehouse with Microsoft SQL Server 2012 Welcome

...

Implementing a Data Warehouse with Microsoft SQL Server 2012 What should you know

...

Implementing a Data Warehouse with Microsoft SQL Server 2012 Using the Exercise File

...

Finding and downloading SQL Server 2012 trial edition

...

Installing SQL Server 2012 trial edition

...

Finding and installing the sample data

...

Overview of Data Warehousing

...

Understanding the differences between typical databases and data warehouses

...

Implementing a data warehouse using a SQL database engine

...

Logical design for a data warehouse

...

Choosing between star and snowflake schema design techniques

...

Physical design for a data warehouse

...

Considerations for building a data warehouse

...

Data Warehouse Reference Architecture

...

Appliances and big data

...

Introduction to ETL with SSIS

...

Exploring source data

...

Introduction to control flow

...

Implementing data flow

...

Debugging an SSIS package

...

Logging SSIS package events

...

Handling errors in an SSIS package

...

Introduction To Incremental-ETL

...

Extracting modified data

...

Loading modified data

...

Working with slowly changing dimensions

...

Installing and maintaining SSIS components

...

Deploying SSIS solutions

...

Using SQL Server Agent to execute an ETL package

...

Configuring advanced SSIS settings

...

Installing Data Quality Services

...

Using Data Quality Services to cleanse data

...

Using Data Quality Services to find duplicate data

...

Utilizing Data Quality Services in an SSIS data flow

...

Introduction to Business Intelligence

...

Using Reporting Services with a data warehouse

...

Introduction to data analysis with SQL Server Analysis Services (SSAS)

...

Implementing a Data Warehouse with Microsoft SQL Server 2012 next step

...

Course Reviews:

Average Rating 0
0 Ratings
Details
5 Stars 0
4 Stars 0
3 Stars 0
2 Stars 0
1 Stars 0

No reviews yet.