Data Warehouse Essential: Architecture Frameworks & Implementation
Data Warehouse
| Beginner
- 11 videos | 1h 1m 27s
- Includes Assessment
- Earns a Badge
Examine architectures of data warehouse implementations, including logical and physical design. How to effectively implement and manage data warehousing projects is also covered.
WHAT YOU WILL LEARN
-
Recall essential architectural components of data warehouse along with the design considerations to successfully implement the right data warehousing solution
Specify essential data warehouse architectural styles and frameworks, and compare kimball and inmon
Identify the logical and physical data warehousing architectural models, with the emphasis on schema and objects
Illustrate implementation scenarios of the logical and physical data warehousing models
List dimensional modeling principles and the differences between it and the er model
Specify how data warehousing can be used to facilitate information realization -
Illustrate the processes of extracting, loading, and transforming data in a data warehousing environment
Recall data warehousing and etl tools and specify how they are implemented real-time
Recognize essential tools, components, features and how they are used to implement etl
Demonstrate how to use talend to implement etl
Extract data from various sources, and transform and load the data in the intended destination
IN THIS COURSE
-
8m 24sUpon completion of this video, you will be able to recall essential architectural components of data warehouses along with the design considerations to successfully implement the right data warehousing solution. FREE ACCESS
-
7m 42sUpon completion of this video, you will be able to specify essential data warehouse architectural styles and frameworks, and compare Kimball and Inmon. FREE ACCESS
-
3. Logical and Physical Data Warehouse Designs4m 27sLearn how to identify the logical and physical data warehousing architectural models, with an emphasis on schema and objects. FREE ACCESS
-
4. Use Cases of Logical and Physical Modeling2m 46sAfter completing this video, you will be able to illustrate implementation scenarios of the logical and physical data warehousing models. FREE ACCESS
-
5. Principles of Dimensional Modeling6m 23sAfter completing this video, you will be able to list the principles of dimensional modeling and the differences between it and the ER model. FREE ACCESS
-
6. Information Realization5m 7sUpon completion of this video, you will be able to specify how data warehousing can be used to facilitate information retrieval. FREE ACCESS
-
7. ETL in Data Warehouse5m 6sUpon completion of this video, you will be able to illustrate the processes of extracting, loading, and transforming data in a data warehousing environment. FREE ACCESS
-
8. Popular Data Warehouse and ETL Tools7m 28sUpon completion of this video, you will be able to recall data warehousing and ETL tools and specify how they are implemented in real-time. FREE ACCESS
-
9. Exploring Talend4m 48sUpon completion of this video, you will be able to recognize essential tools, components, features and how to use them to implement ETL. FREE ACCESS
-
10. Talend ETL Implementation5m 34sIn this video, you will learn how to use Talend to implement Extract, Transform, and Load (ETL). FREE ACCESS
-
11. Exercise: Transform Multi-data with Talend3m 43sFind out how to extract data from various sources, and how to transform and load the data in the intended destination. FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
