System Design-Data modeling for datawarehouses/OLAP DBs

System Design-Data modeling for datawarehouses/OLAP DBs, available at $69.99, has an average rating of 4.35, with 12 lectures, based on 21 reviews, and has 130 subscribers.

You will learn about Understand the internal architecture of an OLAP store Designing the data model to support rich analytical queries Understand distribution and sort keys and how to leverage them Designing your aggregation queries in a column-oriented OLAP store Optimize Redshift Query Performance This course is ideal for individuals who are Data engineer and/or data architects It is particularly useful for Data engineer and/or data architects.

Enroll now: System Design-Data modeling for datawarehouses/OLAP DBs

Summary

Title: System Design-Data modeling for datawarehouses/OLAP DBs

Price: $69.99

Average Rating: 4.35

Number of Lectures: 12

Number of Published Lectures: 12

Number of Curriculum Items: 13

Number of Published Curriculum Objects: 13

Original Price: $29.99

Quality Status: approved

Status: Live

What You Will Learn

Understand the internal architecture of an OLAP store
Designing the data model to support rich analytical queries
Understand distribution and sort keys and how to leverage them
Designing your aggregation queries in a column-oriented OLAP store
Optimize Redshift Query Performance

Who Should Attend

Data engineer and/or data architects

Target Audiences

Data engineer and/or data architects

Designing a data model for a data warehouse is fundamentally different from designing the schema for your primary database. A data warehouse is meant for supporting aggregation queries that touch a huge number of records and are very expensive. The scale in terms of number of queries is at least an order of magnitude less than the number of queries seen by a consumer-facing primary database. This distinction leads to a fundamental different data layout and indexing model in the database used in a data warehouse. Such databases are called OLAP databases.

This course will take you into the internal architecture of an OLAP database with specific focus on areas that help you how a query runs on an OLAP database. We will walk though the levers that an OLAP database provides to optimize your queries. We will then cover various scenarios that will help you design the data model for an OLAP database used in a data warehouse.

Throughout this course, we will use AWS Redshift as the OLAP database. However, the principles covered in this course are general and can be applied in any data warehouse including Snowflake or Hive. Some of these principles are also applicable in real-time column stores like HBase.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: OLTP Versus OLAP – part I

Lecture 3: OLTP versus OLAP – part II

Chapter 2: OLAP Architecture

Lecture 1: Data Layout and Distribution

Lecture 2: Query execution – I

Lecture 3: Query execution – II

Chapter 3: Data Modeling

Lecture 1: Avoiding Full Scans (Sort Keys) – 1

Lecture 2: Avoiding Full Scans (Sort Keys) – 2

Lecture 3: Distribution Keys

Lecture 4: Handling Joins – Part I

Lecture 5: Handling Joins – Part 2

Chapter 4: Beyond data modeling

Lecture 1: Beyond schema design

Instructors

Akshat Verma
CTO and Principal Architect

Rating Distribution

1 stars: 1 votes
2 stars: 0 votes
3 stars: 1 votes
4 stars: 2 votes
5 stars: 17 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu