Introduction to Data Warehousing

Laser 17 Oct 2021 03:04 LEARNING » e-learning - Tutorial

Introduction to Data Warehousing
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 27 lectures (1h 48m) | Size: 529 MB

An introduction to data warehouses, using SQL Server 2019, SSMS, Visual Studio & SSIS.

Covers topics in the 70-463 exam

Define and describe common data warehousing concepts

Install SQL Server, SSMS and Visual Studio with the SSIS package

Create an ETL package in SSIS

Integrate data from text files and databases

A Windows computer or virtual machine with at least 2GB of RAM and about 10GB of hard drive space.

This course is an overview of basic data warehousing concepts, a guide for installing software and a step-by-step tutorial on using the software. This course is divided into three main sections:

Data Warehousing Basics

We b with a conversation about data warehousing concepts, including the following:

What is a data warehouse

Why do we need a data warehouse

What is Extract, Transform and Load (ETL)

The difference between OLAP and OLTP databases

The Star and Snowflake schemas

Fact and Dimension tables

These concepts can be difficult to understand, so I explain them using real conversation and examples. We have this conversation first so that you are familiar with the ideas as they are discussed in the later sections of the course.

Data Warehousing Software Installation

If you want to become good at data warehousing, you need to use the software. In this section I start by talking with you about the software and explain how the different pieces work together. Next is a step-by-step walkthrough of installing SQL Server Developer, SQL Server Management Studio (SSMS) and Visual Studio Community with the SQL Server Integration Services (SSIS) package. The versions of software we are all free for you to use.

SSIS Tutorial: Create a Project and Basic Package with SSIS

The last section of the course is a step-by-step tutorial on using the ETL tool SSIS. The tutorial is broken down into nine steps:

Step 1: Create a new integration services project

Step 2: Add and configure a flat file connection manager

Step 3: Add and configure an OLE DB connection manager

Step 4: Add a data flow task to the package

Step 5: Add and configure the flat file source

Step 6: Add and configure the lookup transformations

Step 7: Add and configure the OLE DB destination

Step 8: Make the Lesson 1 package easier to understand

Step 9: Test the Lesson 1 package

Before we being the tutorial, I discuss the steps in detail. I explain the source data, how the data will be transformed and how we will get the data to it's destination database.

People taking a college course in data warehousing or data integration

People who need to understand data warehousing, SQL Server or SSIS for their job





Add Comment

  • People and smileys emojis
    Animals and nature emojis
    Food and drinks emojis
    Activities emojis
    Travelling and places emojis
    Objects emojis
    Symbols emojis
    Flags emojis