Choosing Data Stores
Course description
One of the key tasks in creating a data platform and pipelines is choosing the appropriate data storage. This course is dedicated to this topic.
We will examine relational and NoSQL databases, as well as data warehouses and data lakes. You will learn when to use each type of storage and how to properly integrate it into your architecture.
After completing the course, you will understand how to store data and how to choose the appropriate storage for specific tasks. This will help you better navigate different types of storage and make informed decisions in your work as a data engineer. In subsequent courses, we will delve into specific technologies from each category.
Read more about the course
Basics of Data Warehouses
First, you will study the basic principles: the differences between OLTP (Operational Transactional Systems) and OLAP (Analytical Systems), and the scenarios in which they are used. You will also learn what ETL (Extract, Transform, Load) and ELT (Extract, Load, Transform) are and how these methods relate to the choice of data warehouses. At the end of the section, I will share a resource where you can further explore the types of data warehouses and compare them with each other.
Relational Databases
We will go through a step-by-step guide to selecting the appropriate data storage that you can use in your work. Then, we will take a closer look at relational databases: you will learn about the principles of CRUD and ACID, as well as get acquainted with examples of specific DBMS.
NoSQL Databases
Here you will learn what NoSQL is, what types of such databases exist (document-based, columnar, temporal, search), their characteristics, and the tasks for which they are suitable. We will also discuss the trade-offs between read and write speed and the importance of setting goals when choosing storage.
Data Warehouses and Data Lakes
At the end of the course, you will learn what data warehouses (Data Warehouses) and data lakes (Data Lakes) are, the differences between them, and the specific cases for using each solution.
Watch Online
All Course Lessons (16)
| # | Lesson Title | Duration | Access |
|---|---|---|---|
| 1 | Introduction Demo | 02:10 | |
| 2 | OLTP vs OLAP | 07:35 | |
| 3 | ETL vs ELT | 05:46 | |
| 4 | Data Stores Ranking | 04:06 | |
| 5 | How to Choose Data Stores | 08:12 | |
| 6 | Relational Databases | 06:35 | |
| 7 | NoSQL Basics | 10:40 | |
| 8 | Document Stores | 05:57 | |
| 9 | Time Series Databases | 05:01 | |
| 10 | Search Engines | 04:19 | |
| 11 | Wide Column Stores | 04:23 | |
| 12 | Key Value Stores | 05:00 | |
| 13 | Graph Databases | 01:06 | |
| 14 | Data Warehouses | 05:33 | |
| 15 | Data Lakes | 07:11 | |
| 16 | Conclusion | 01:57 |
Unlock unlimited learning
Get instant access to all 15 lessons in this course, plus thousands of other premium courses. One subscription, unlimited knowledge.
Learn more about subscription
Want to join the conversation?
Sign in to comment