Data Warehouse Essential: Concepts

Data Warehouse    |    Beginner
  • 18 videos | 1h 43m 3s
  • Includes Assessment
  • Earns a Badge
Rating 4.4 of 292 users Rating 4.4 of 292 users (292)
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

  • 8m 28s
    During this video, you will learn how to identify the characteristics of strategic information and the need for data warehousing to manage strategic information. FREE ACCESS
  • 7m 2s
    After completing this video, you will be able to list the essential differences between OLAP and data warehousing. FREE ACCESS
  • Locked
    3.  Planning Data Warehouse Implementation Part 1
    9m 8s
    After completing this video, you will be able to specify the essential guidelines that should be followed in order to implement a successful data warehouse project on the cloud or on-premise. FREE ACCESS
  • Locked
    4.  Planning Data Warehouse Implementation Part 2
    4m 5s
    In this video, you will learn how to compare essential on-premises and on-cloud data warehousing products and components. FREE ACCESS
  • Locked
    5.  Characteristics of Data Warehouse Projects Part 1
    6m 45s
    In this video, you will identify the essential characteristics of data warehouses. FREE ACCESS
  • Locked
    6.  Characteristics of Data Warehouse Projects Part 2
    6m 14s
    In this video, find out how to compare normalization and denormalization processes in data warehouse projects. FREE ACCESS
  • Locked
    7.  Technical Comparison of OLTP and Data Warehouse
    6m 16s
    Find out how to compare the contrasting features of OLTP and data warehouse from the perspective of indexes, joins, data duplication, and data aggregation. FREE ACCESS
  • Locked
    8.  Global and Local Data Warehouses
    3m 37s
    In this video, find out how to differentiate between a global data warehouse and a local data warehouse, and recognize critical features, capabilities, and implementation. FREE ACCESS
  • Locked
    9.  Data Warehouse Terms
    4m 45s
    Upon completion of this video, you will be able to recall essential data warehouse terms that are frequently used when implementing data warehouse projects. FREE ACCESS
  • Locked
    10.  Data Warehouse Processes
    9m 19s
    Upon completion of this video, you will be able to recall important data warehouse processes that are generally applied to facilitate business intelligence, including the essential ETL processes. FREE ACCESS
  • Locked
    11.  Data Warehouse Schemas - ER
    4m 3s
    Upon completion of this video, you will be able to recall how ER schemas are implemented in data warehouse projects. FREE ACCESS
  • Locked
    12.  Data Warehouse Schemas - Star
    4m 32s
    Upon completion of this video, you will be able to specify how star schemas are implemented in data warehouse projects. FREE ACCESS
  • Locked
    13.  Data Warehouse Schemas - Snowflake
    3m 38s
    After completing this video, you will be able to describe how snowflake schemas are implemented in data warehouse projects. FREE ACCESS
  • Locked
    14.  Multi-Valued Dimension and Report Types
    4m 42s
    In this video, you will learn how to identify the critical capabilities of multi-valued dimensions and the essential comparison between weighted and impact reports. FREE ACCESS
  • Locked
    15.  Analytical Reports
    5m 3s
    After completing this video, you will be able to illustrate the architectural concept of reporting and classify the various essential types of reports. FREE ACCESS
  • Locked
    16.  Comparing Data Warehouse with RDBMS and Data Lake
    6m 59s
    Learn how to compare data warehouses, RDBMs, data lakes, and their implementation scenarios. FREE ACCESS
  • Locked
    17.  Comparing Azure and AWS Data Lakes
    4m 58s
    In this video, you will compare the critical features, capabilities, and implementation scenarios of Azure and AWS data lakes. FREE ACCESS
  • Locked
    18.  Exercise: Implementing Data Warehouse
    3m 31s
    In this video, you will learn how to implement and facilitate a data warehouse in given scenarios. 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.

YOU MIGHT ALSO LIKE

Book Architecting a Modern Data Warehouse for Large Enterprises: Build Multi-cloud Modern Distributed Data Warehouses with Azure and AWS
Book Beginning Database Design Solutions: Understanding and Implementing Database Design Concepts for the Cloud and Beyond, Second Edition
Course CompTIA IT Fundamentals: Database Concepts
Rating 4.7 of 29 users Rating 4.7 of 29 users (29)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Data Nuts & Bolts: Fundamentals of Data
Rating 4.4 of 524 users Rating 4.4 of 524 users (524)
Course Generative AI and Its Impact to Everyday Business
Rating 4.6 of 893 users Rating 4.6 of 893 users (893)
Course Data Mining and Decision Making: Data Mining for Answering Business Questions
Rating 4.5 of 72 users Rating 4.5 of 72 users (72)