Modern Data Warehouses

Data Warehouse 2021    |    Intermediate
  • 12 videos | 1h 4m 56s
  • Includes Assessment
  • Earns a Badge
In today's world, data warehouses have become necessary for making informed business decisions. The wide availability of data comes at an increased cost of storing it efficiently - a necessity for any business working with large amounts of data. Learn more about the key concepts, architecture, stages, use cases, and available solutions for data warehouses using this course. You will examine data warehousing solutions, architecture, and techniques, discover Amazon Redshift and Google BigQuery, and explore the concepts, such as batch, stream, and real-time analytics. This course will also help highlight the considerations for implementing a data warehouse for a business and the implementation steps and best practices required. After completing this course, you will have a foundational knowledge of implementing a data warehousing solution for your business.


  • Discover the key concepts covered in this course
    Define a data warehouse and its characteristics
    Describe different key concepts and benefits related to modern data warehouses
    List the features and architecture amazon redshift data warehouse
    Describe the architecture, characteristics, features, and use cases of google bigquery data warehouse
    Outline the architecture and various processes involved in a modern data warehouse
  • Recognize various techniques that are commonly encountered in a modern data warehouse
    Describe batch processing in a data warehouse with an industry use case
    Discuss real-time data processing in a modern data warehouse with an industry use case
    Outline stream data analytics in a modern data warehouse with an industry use case
    Outline the features and functions of hybrid modern data warehouses
    Summarize the key concepts covered in this course


  • 2m 9s
  • 7m 48s
  • Locked
    3.  Modern Data Warehouses: Key Concepts and Stages
    7m 46s
  • Locked
    4.  Amazon Redshift
    6m 15s
    In this video, you'll learn more about Amazon Redshift, which is a data warehouse product that forms a division of Amazon Web Services. It has been named as to describe a shift from Oracle and Red because the corporate color of Oracle is red. It's built on massive parallel processing technology and can easily handle large scale data. FREE ACCESS
  • Locked
    5.  Google BigQuery
    5m 52s
    In this video, you'll describe the architecture, characteristics, features, and use cases of Google BigQuery data warehouse. You'll learn this is a Platform-as-a-Service software that supports queries in ANSI SQL. It contains built-in machine learning capabilities and external access to Google's Dremel technology, a scalable, interactive ad hoc query system for analysis of nested data. FREE ACCESS
  • Locked
    6.  Modern Data Warehouses: Architecture and Processes
    6m 15s
  • Locked
    7.  Modern Data Warehouses: Techniques
    4m 1s
  • Locked
    8.  Data Warehouse Solutions: Batch Processing
    5m 53s
  • Locked
    9.  Data Warehouse Solutions: Real-time Processing
    6m 50s
  • Locked
    10.  Data Warehouse Solutions: Streaming Analytics
    6m 26s
  • Locked
    11.  Hybrid Modern Data Warehouse
    4m 8s
  • Locked
    12.  Course Summary
    1m 32s


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.