Optimizing a Data Warehouse on the Microsoft SQL Server Platform

Focused View

Thomas LeBlanc

3:03:22

62 View

0. Course Overview

0. Course Overview.mp4

02:05

1. Managing Data Warehouse with Best Practices

0. Introduction.mp4

02:50

1. Demo- Course Resource ZIP File and Restoring a Database.mp4

01:19

2. Partitioning Data Warehouse Fact Tables

0. Table Partitioning in SQL Server.mp4

05:10

1. Demo- Table Partitioning in SQL Server.mp4

03:17

2. Implementing Partitioning on a Fact Table for Faster Querying.mp4

05:12

3. Demo- Implementing Partitioning on a Fact Table for Faster Querying.mp4

02:58

4. Implementing Partition Switching on a Fact Table for Faster Loading.mp4

02:25

5. Demo- Implementing Partition Switching on a Fact Table for Faster Loading.mp4

03:37

6. Using Integration Services for Loading a Fact Table.mp4

02:32

7. Demo- Using Integration Services for Loading a Fact Table.mp4

05:31

8. Preparing Data and Tables for Bulk Insert.mp4

04:19

9. Demo- Database Recovery Modes.mp4

02:51

10. Summary.mp4

00:38

3. Indexing Data Warehouse Tables

0. Indexing in a Data Warehouse.mp4

09:01

1. Demo- Indexing in a Data Warehouse.mp4

08:00

2. Building a Clustered Index on the Date Key of a Fact Table.mp4

03:45

3. Demo- Building a Clustered Index on the Date Key of a Fact Table.mp4

02:40

4. Creating and Working with Columnstore Indexes.mp4

02:53

5. Demo- Creating and Working with Columnstore Indexes.mp4

02:26

6. Maintenance Plans for Indexes.mp4

02:41

7. Demo- Maintenance Plans for Indexes.mp4

02:29

8. Summary.mp4

01:13

4. Extracting, Transforming, and Loading (ETL) a Data Warehouse

0. Creating an SSIS Package Template for Reuse.mp4

02:27

1. Demo- Creating an SSIS Package Template for Reuse.mp4

04:35

2. Creating a SSIS Solution and Project Template for Reuse.mp4

02:11

3. Demo- Creating a SSIS Solution and Project Template for Reuse.mp4

05:39

4. Creating Reusable Units of SSIS Package Workflow.mp4

01:10

5. Demo- Creating Reusable Units of SSIS Package Workflow.mp4

03:06

6. Implementing Parallelism for Faster Loading in SSIS.mp4

02:40

7. Demo- Implementing Parallelism for Faster Loading in SSIS.mp4

03:52

8. Summary.mp4

00:53

5. Cleansing Data in a Data Warehouse

0. Data Quality Domains.mp4

02:38

1. Demo- Data Quality Domains.mp4

04:07

2. Creating a Project in Data Quality Services (DQS).mp4

01:43

3. Demo- Creating a Project in Data Quality Services (DQS).mp4

02:27

4. Cleaning Data in SSIS with a DQS Component.mp4

02:42

5. Demo- Cleaning Data in SSIS with a DQS Component.mp4

05:46

6. Summary.mp4

00:45

6. Centralizing Data with Master Data Management Processes

0. Introduction to Master Data Services.mp4

00:52

1. Creating Projects with Master Data Services.mp4

03:04

2. Demo- Creating Projects with Master Data Services.mp4

05:04

3. Using Master Data Services for Common Data.mp4

03:13

4. Demo- Using Master Data Services for Common Data.mp4

04:47

5. Implementing a Master Data Services Model.mp4

02:00

6. Demo- Implementing a Master Data Services Model.mp4

05:24

7. Using Excel, SSMS, and SSDT for Managing MDM Data.mp4

01:54

8. Demo- Using Views in SSIS and Staging Data with SSMS.mp4

04:47

9. Security and Sharing.mp4

04:57

7. Documenting a Data Warehouse

0. Documenting a Data Warehouse.mp4

01:00

1. Building a Data Dictionary through Data Profiling.mp4

02:13

2. Demo- Building a Data Dictionary through Data Profiling.mp4

04:35

3. Automating DDL SQL Production.mp4

01:14

4. Demo- Automating DDL for a New Database.mp4

02:52

5. Demo- Automating DDL for a Change.mp4

04:39

6. Document Data Flows.mp4

01:29

7. Demo- Document Data Flows.mp4

01:56

8. Summary.mp4

00:49

Description

Once a data warehouse is initially created, performance and maintainability come into question. In this course, you'll explore SQL Server and the tools and resources needed to efficiently optimize a data warehouse.

What You'll Learn?

The resources offered by Microsoft SQL Server are geared towards architects, developers, and administrators in the database realm. In this course, Optimizing a Data Warehouse on the Microsoft SQL Server Platform, you'll delve into the tools and resources available in SQL Server for optimizing a data warehouse. First, you'll explore the options for indexing in a data warehouse. Next, you'll learn how to use Integration Services (SSIS) to import source data into your destination. Then, you'll discover what the database engine includes, such as, table partitioning, various indexes like clustered and columnstore, and bulk insert. Finally, you'll explore documentation options that includes data flows complementing a data dictionary. By the end of this course, you'll have the necessary knowledge needed to effectively optimize your data warehouse on the Microsoft SQL Server platform.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

SQL Server

Microsoft SQL

Data Warehouse

Thomas LeBlanc

Instructor's Courses

Thomas LeBlanc (Microsoft Data Platform MVP) is a Data Enthusiast in Baton Rouge, La. He started his IT career as a COBOL programmer in 1989 while at LSU. Since then he has spent years as a developer, DBA and Data Warehousing/Business Intelligence Architect. Community involve includes the local SQL Server and Analytics User Groups as well as SQLSaturday. Speaking engagements have been a blessing at SQL Pass Summit, Live 360, VSLive and IT Dev Connections.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.