Latest Courses
ISTQB Artificial Intelligence Tester Sample ExamsCheck course
JAVA Programming Online Practice ExamCheck course
Programming for Kids and Beginners: Learn to Code in PythonCheck course
Practice Exams | Codeigniter 4 developer certificationCheck course
WordPress Practice Tests & Interview Questions (Basic/Adv)Check course
Git &Github Practice Tests & Interview Questions (Basic/Adv)Check course
Machine Learning and Deep Learning for Interviews & ResearchCheck course
Laravel | Build Pizza E-commerce WebsiteCheck course
101 - F5 CERTIFICATION EXAMCheck course
Master Python by Practicing 100 QuestionCheck course
ISTQB Artificial Intelligence Tester Sample ExamsCheck course
JAVA Programming Online Practice ExamCheck course
Programming for Kids and Beginners: Learn to Code in PythonCheck course
Practice Exams | Codeigniter 4 developer certificationCheck course
WordPress Practice Tests & Interview Questions (Basic/Adv)Check course
- 25% Introduction to Data Warehousing

Introduction to Data Warehousing

$14.99Track price

Add your review
Add to wishlistAdded to wishlistRemoved from wishlist 0
Add to compare

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

Specification: Introduction to Data Warehousing

Duration

2 hours

Year

2021

Level

All

Certificate

Yes

Quizzes

No

User Reviews

0.0 out of 5
0
0
0
0
0
Write a review

There are no reviews yet.

Be the first to review “Introduction to Data Warehousing”

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Introduction to Data Warehousing
Introduction to Data Warehousing

$14.99

Price tracking

Java Code Geeks
Logo
Register New Account
Compare items
  • Total (0)
Compare