Fundamentals of Data Warehousing
- Offered byCoursera
Fundamentals of Data Warehousing at Coursera Overview
Duration | 14 hours |
Start from | Start Now |
Total fee | Free |
Mode of learning | Online |
Difficulty level | Beginner |
Official Website | Explore Free Course  |
Credential | Certificate |
Fundamentals of Data Warehousing at Coursera Highlights
- Shareable Certificate Earn a Certificate upon completion
- 100% online Start instantly and learn at your own schedule.
- Course 3 of 4 in the Key Technologies in Data Analytics Specialization
- Flexible deadlines Reset deadlines in accordance to your schedule.
- Beginner Level
- Approx. 14 hours to complete
- English Subtitles: English
Fundamentals of Data Warehousing at Coursera Course details
- Welcome to Fundamentals of Data Warehousing, the third course of the Key Technologies of Data Analytics specialization. By enrolling in this course, you are taking the next step in your career in data analytics. This course is the third of a series that aims to prepare you for a role working in data analytics. In this course, you will be introduced to many of the core concepts of data warehousing. You will learn about the primary components of data warehousing. We?ll go through the common data warehousing architectures. The hands-on material offers to add storage to your cloud environment and configure a database. This course covers a wide variety of topics that are critical for understanding data warehousing and are designed to give you an introduction and overview as you begin to build relevant knowledge and skills.
Fundamentals of Data Warehousing at Coursera Curriculum
Concepts
Course Introduction And Objectives
Module Introduction And Objectives
Introduction To Subject-Oriented
Subject-Oriented In Your Reading
Introduction To Integrated
Integrated In Your Reading
Introduction To Time-Variant
Time-Variant In Your Reading
Introduction To Nonvolatile
Nonvolatile In Your Reading
Module 1 Summary
Data Warehousing - Overview
Which Data Integration Approach Is Right For You?
Time-Variant System
Nonvolatile Data
Subject-Oriented
Integrated
Time-Variant
Nonvolatile
Module 1 Graded Quiz
Components
Module Introduction And Objectives
Introduction To Database Structures
Database Structures In Your Reading
Introduction To ETL and ELT
ETL and ELT In Your Reading
Introduction To Metadata
Metadata In Your Reading
Introduction To Tools
Tools In Your Reading
Hands-On Demonstration
Module 2 Summary
Database Structure And Design Tutorial
ETL vs ELT: 5 Critical Differences
What Is Metadata (With Examples)
Querying and Reporting Tools for Data Warehousing
Hands-On Exercise: Add Storage To Your AWS Environment
Database Structures
ETL and ELT
Metadata
Tools
Module 2 Graded Quiz
Design and Architecture
Module Introduction And Objectives
Introduction To Design Approach
Design Approach In Your Reading
Introduction To Single Tier Architecture
Single Tier Architecture In Your Reading
Introduction To Two Tier Architecture
Two Tier Architecture In Your Reading
Introduction To Three Tier Architecture
Three Tier Architecture In Your Reading
Module 3 Summary
Various Data Warehouse Design Approaches:Top-Down and Bottom-Up
Database Architecture in DBMS: 1-Tier, 2-Tier and 3-Tier
Two-Tier vs Three-Tier Architecture
3-Tier Architecture: A Complete Overview
Design Approach
Single Tier Architecture
Two-Tier Architecture
Three Tier Architecture
Module 3 Graded Quiz
Fundamentals of Data Warehousing at Coursera Admission Process
Important Dates
Other courses offered by Coursera
Student Forum
Anything you would want to ask experts?