Introduction to Data Warehousing

Introduction to Data Warehousing, available at $34.99, has an average rating of 4.15, with 27 lectures, based on 36 reviews, and has 111 subscribers.

You will learn about 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 This course is ideal for individuals who are People taking a college course in data warehousing or data integration or People who need to understand data warehousing, SQL Server or SSIS for their job It is particularly useful for People taking a college course in data warehousing or data integration or People who need to understand data warehousing, SQL Server or SSIS for their job.

Enroll now: Introduction to Data Warehousing

Summary

Title: Introduction to Data Warehousing

Price: $34.99

Average Rating: 4.15

Number of Lectures: 27

Number of Published Lectures: 27

Number of Curriculum Items: 27

Number of Published Curriculum Objects: 27

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

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

Who Should Attend

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

Target Audiences

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

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 begin 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 download 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.

Course Curriculum

Chapter 1: Data Warehousing Basics

Lecture 1: Introduction

Lecture 2: What is a Data Warehouse?

Lecture 3: Why do we need a Data Warehouse?

Lecture 4: What does a Data Warehouse look like?

Lecture 5: The Ideal Data Warehouse

Lecture 6: The Difference Between OLTP and OLAP

Lecture 7: What is Extract, Transform and Load (ETL)?

Lecture 8: What is Dimensional Modeling?

Lecture 9: What are Fact Tables?

Lecture 10: What are Dimension Tables?

Lecture 11: The Star and Snowflake Schema

Chapter 2: Installing SQL Server, SSMS and Visual Studio with the SSIS package

Lecture 1: What is SQL Server, SSMS and Visual Studio and how are they used?

Lecture 2: Install SQL Server and SQL Server Management Studio (SSMS)

Lecture 3: Download and Restore AdventureWorks Database

Lecture 4: Download Visual Studio Community

Lecture 5: Install the SQL Server Integration Services Extension

Lecture 6: Visual Studio Navigation Overview

Chapter 3: Create a Project and Basic Package with SSIS

Lecture 1: Lesson Overview – The Source Data, the Transformation and Destination Table

Lecture 2: Step 1: Create a New Integration Services Project

Lecture 3: Step 2: Add and Configure a Flat File Connection Manager

Lecture 4: Step 3: Add and Configure an OLE DB Connection Manager

Lecture 5: Step 4: Add a Data Flow Task to the Package

Lecture 6: Step 5: Add and Configure the Flat File Source

Lecture 7: Step 6: Add and Configure the Lookup Transformations

Lecture 8: Step 7: Add and Configure the OLE DB Destination

Lecture 9: Step 8: Make the Lesson 1 Package Easier to Understand

Lecture 10: Step 9: Test the Lesson 1 Package

Instructors

Maria Hamilton
Computing Professor

Rating Distribution

1 stars: 1 votes
2 stars: 1 votes
3 stars: 4 votes
4 stars: 11 votes
5 stars: 19 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu