Relational Databases

13h 15m 17s
English
Paid

Course description

Modern business processes depend on data, and most companies use complex database management systems (DBMS) for storing and processing it. The development of database technologies and competitive pressure have led to the creation of powerful and complex systems, the use of which requires deep understanding. Errors in working with such systems can be costly. This course provides fundamental knowledge about the operation of DBMS, allowing for informed decision-making in the design and use of relational databases.
Read more about the course
During the course exercises, you will create a simple relational database management system. The exercises are designed to allow you to solve tasks independently, referring to video guides and additional explanations only when necessary. Instead of a rigid definition of exercise completion, you are provided with flexibility: you can focus on core tasks and interesting additional goals. The course also includes seminars recorded with participants from CS Primer, which cover complex conceptual aspects that are difficult to understand in an exercise format. It is recommended to attend the seminars after studying the corresponding course module.

Watch Online

This is a demo lesson (10:00 remaining)

You can watch up to 10 minutes for free. Subscribe to unlock all 19 lessons in this course and access 10,000+ hours of premium content across all courses.

View Pricing
0:00
/
#1: 001 Basic query executor

All Course Lessons (19)

#Lesson TitleDurationAccess
1
001 Basic query executor Demo
58:27
2
002 A brief overview of query execution using EXPLAIN
42:43
3
003 Observing PostgreSQL client and server communication
12:27
4
004 A very brief history of early DBMSs
22:19
5
005 Column vs row stores
08:43
6
006 What is the core of a core dump or out of core sort
04:51
7
007 CSV FileScan
01:03:36
8
008 Heap File
02:06:34
9
009 Basic inserts
01:01:10
10
010 The layout of a PostgreSQL table
35:22
11
011 Nested loops join
01:00:55
12
012 Hash join
40:18
13
013 Sort-merge join
01:38:55
14
014 Aggregation
58:22
15
015 What is a join
20:50
16
016 The three basic join stratgies
18:54
17
017 Nested loop variants and practical considerations
15:25
18
018 Hash join variants and practical considerations
14:58
19
019 Transactions the big picture
30:28

Unlock unlimited learning

Get instant access to all 18 lessons in this course, plus thousands of other premium courses. One subscription, unlimited knowledge.

Learn more about subscription

Comments

0 comments

Want to join the conversation?

Sign in to comment

Similar courses

Building a Database Engine

Building a Database Engine

Sources: Martin Joo
The book "Building a Database Engine" is a practical guide to creating your own database engine from scratch. It is intended for developers...
Fundamentals of Backend Communications and Protocols

Fundamentals of Backend Communications and Protocols

Sources: udemy
Backend engineering is an art. During my 18 years career working with and building backend applications, I discovered that certain communication design patterns keep emerging. T...
15 hours 35 minutes 37 seconds
Full-Stack Fundamentals 4 - Payments

Full-Stack Fundamentals 4 - Payments

Sources: Mckay Wrigley (takeoff)
In the previous section, we successfully implemented user authentication using Clerk. Now, based on this project, we will add online payment processing with...
54 minutes 17 seconds
Streaming Databases

Streaming Databases

Sources: oreillymedia
Real-time applications are becoming the norm. However, for the model to function properly, it is necessary to obtain data in real time...
Database Mastery: SQL to Prisma

Database Mastery: SQL to Prisma

Sources: jsmastery.pro, Adrian Hajdin
Master key technologies with a practical approach! You will gain applied knowledge, clear explanations, and all the necessary tools to confidently master...
16 minutes 3 seconds