Data Warehouse Essential: Concepts

Data Warehouse
  • 18 Videos | 1h 51m 33s
  • Includes Assessment
  • Earns a Badge
Likes 85 Likes 85
Discover the fundamentals of data warehousing and the approaches of implementing it. Explore Data Warehouse planning, processes, schemes, and terms. You will also examine global and local Data Warehouses as well as comparing Data Warehouses with RDBMS and Data Lake.

WHAT YOU WILL LEARN

  • identify the characteristics of strategic information and the need for data warehousing to manage strategic information
    list the essential differences between OLAP and data warehousing capabilities
    specify the essential guidelines that should be followed in order to implement a successful data warehouse project on the cloud and on-premise
    compare essential on-premise and on-cloud data warehousing products and components
    identify the essential characteristics of data warehouse projects
    compare normalization and denormalization processes in data warehouse projects
    compare the contrasting features of OLTP and data warehouse from the perspective of indexes, joins, data duplication, and data aggregation
    differentiate global data warehouse from local data warehouse, and recognize critical features, capabilities, and implementation
    recall essential data warehouse terms that are frequently used when implementing data warehouse projects
  • recall important data warehouse processes that are generally applied to facilitate business intelligence, including the essential ETL processes
    recall how the ER schemas are implemented in data warehouse projects
    specify how the star schemas are implemented in data warehouse projects
    describe how the snowflake schemas are implemented in data warehouse projects
    identify the critical capabilities of multi-valued dimensions and the essential comparison between weighted and impact reports
    illustrate the architectural concept of reporting and classify the various essential types of reports
    compare data warehouse, RDBM, data lake and their implementation scenarios
    compare the critical features, capabilities, and the implementation scenarios of Azure and AWS data lakes
    identify how to implement and facilitate data warehouse given a scenario

IN THIS COURSE

  • Playable
    1. 
    Role of Data Warehouse in Strategic Information
    8m 28s
    UP NEXT
  • Playable
    2. 
    OLAP and Data Warehouse
    7m 2s
  • Locked
    3. 
    Planning Data Warehouse Implementation Part 1
    9m 8s
  • Locked
    4. 
    Planning Data Warehouse Implementation Part 2
    4m 5s
  • Locked
    5. 
    Characteristics of Data Warehouse Projects Part 1
    6m 45s
  • Locked
    6. 
    Characteristics of Data Warehouse Projects Part 2
    6m 14s
  • Locked
    7. 
    Technical Comparison of OLTP and Data Warehouse
    6m 16s
  • Locked
    8. 
    Global and Local Data Warehouses
    3m 37s
  • Locked
    9. 
    Data Warehouse Terms
    4m 45s
  • Locked
    10. 
    Data Warehouse Processes
    9m 19s
  • Locked
    11. 
    Data Warehouse Schemas - ER
    4m 3s
  • Locked
    12. 
    Data Warehouse Schemas - Star
    4m 32s
  • Locked
    13. 
    Data Warehouse Schemas - Snowflake
    3m 38s
  • Locked
    14. 
    Multi-Valued Dimension and Report Types
    4m 42s
  • Locked
    15. 
    Analytical Reports
    5m 3s
  • Locked
    16. 
    Comparing Data Warehouse with RDBMS and Data Lake
    6m 59s
  • Locked
    17. 
    Comparing Azure and AWS Data Lakes
    4m 58s
  • Locked
    18. 
    Exercise: Implementing Data Warehouse
    3m 31s

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.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 57 Likes 57  
COURSE SQL Developer
Likes 152 Likes 152