Udemy – Data Warehouse – The Ultimate Guide 2023-6

Data Warehouse – The Ultimate Guide is a comprehensive training course on analytical database (Data warehouse) published by Udemy Academy. During the process of this training course, in addition to the analytical database, other relevant and important topics such as dimensional modeling (Dimensional Modeling) and the ETL process in the data warehouse (Extract, Transformation, Load) will also be discussed. The implementation and architecture of large databases and analytical databases are among the most important skills that activists and engineers in the field of data mining and data analysis can master. These two skills are very useful and important in the fields of business intelligence and data engineering and can bring you many job opportunities.

What you will learn in Data Warehouse – The Ultimate Guide

• Basic principles of analytical database (Data warehouse)
• Different analytic database architectures
• Analytical database infrastructure and advanced technology
• Information modeling
• Installation of ETL processes
• Dimensional modeling
• Easy and smooth change of information dimensions
• Familiarity with various ETL tools
• Differences between ELT and ETL
• Columnar data storage
• Online Analytical Processing or OLAP
• In-memory database
• Parallel computing
• Cloud analytical database (cloud data warehouses)
• Optimizing analytical databases using B-tree and Bitmap indexes
• And …

Course specifications

• Publisher: Udemy
• Instructors: Nikolai Schuler
• Language: English
• Level: Introductory to Advanced
• Number of Lessons: 101
• Duration: 8 hours and 48 minutes

Course topics

Data Warehouse – The Ultimate Guide Prerequisites

Basic SQL is helpful but absolutely not necessary
Laptop or PC

Pictures

Data Warehouse – The Ultimate Guide introduction video

Installation guide

After Extract, watch with your favorite Player.

Subtitle: English

Quality: 720p

Changes:

Version 2023/6 compared to 2022/5 has increased the number of 1 lessons and the duration of 3 minutes.

Download link

Download Part 1 – 1 GB

Download Part 2 – 1 GB

Download Part 3 – 1 GB

Download Part 4 – 472 MB

Size

3.47 GB