Traditional Data Architectures: Data Warehousing and ETL Systems
Data Architecture 2021
| Beginner
- 12 Videos | 38m 56s
- Includes Assessment
- Earns a Badge
Data warehouses are actively used for business intelligence and, because they integrate data from multiple sources, are advantageous to simple databases in many instances. Considering modern companies often have ETL-based data warehousing systems, decision-makers need to comprehend how they operate and are appropriately managed. In this course, learn the necessary concepts and processes required to work with and manage projects related to data warehousing. Study data warehousing architectures and schemas and investigate some core data warehouse elements, such as dimension, fact tables, and keys. Furthermore, examine the extract, transform, and load (ETL) approach for working with data warehouses, specifying process flow, tools, and software as well as best practices. When you're done, you'll know how to adopt data warehousing and ETL systems for your business intelligence and data management needs.
WHAT YOU WILL LEARN
-
discover the key concepts covered in this coursedescribe how a data warehouse is different from a database and how data warehouses are used for business intelligencename and define three main tiers of a data warehousecompare and contrast various data warehousing schemas, such as Star, Snowflake, etc.name use cases of dimension tables and define different types of dimensions and their granularitydefine fact table measures, describe how measures are added and loaded, and outline the steps for implementing a fact table in a data warehouse
-
describe how data warehouse keys work, specifying the importance of surrogate keysdescribe extract, transform, and load (ETL) functionality and specify how the movement between transactional OLTP databases and a data warehouse is performed and how to organize and design your extraction, transformation, and loading capabilities to keep your data warehouse up-to-datedescribe the ETL framework and it's three main components - extraction, transformation, and loadingname and describe the most commonly used ETL tools and softwarespecify best practices to be followed when dealing with ETL to perform operations as efficiently as possiblesummarize the key concepts covered in this course
IN THIS COURSE
-
1.Course Overview1m 35sUP NEXT
-
2.Data Warehousing for Business Intelligence3m 54s
-
3.Data Warehouse Architecture3m 55s
-
4.Data Warehousing Schemas3m 55s
-
5.Dimension Table Use Cases3m 11s
-
6.Fact Tables in a Data Warehouse3m 15s
-
7.Keys in Data Warehouse Schemas3m 28s
-
8.What Is ETL?2m 56s
-
9.What Is ETL, ETL Framework, and Process Flow?5m 11s
-
10.Extract, Transform, and Load (ETL) Tools3m 11s
-
11.Extract, Transform, and Load (ETL) Best Practices3m 21s
-
12.Course Summary1m 3s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.