Relational Databases

13h 15m 17s
English
Paid
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 Relational Databases

Join premium to watch
Go to premium
# Title Duration
1 001 Basic query executor 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

Similar courses to Relational Databases

Apache Flink

Apache Flinkrockthejvm.com

Category: Other (Backend)
Duration 8 hours 31 minutes 38 seconds
Building a Database Engine

Building a Database EngineMartin Joo

Category: Other (Backend)
Duration
Web API From Start to Finish

Web API From Start to Finishiamtimcorey.com (Tim Corey)

Category: Other (Backend)
Duration 17 hours 59 minutes 54 seconds
Introduction to Microsoft Orleans

Introduction to Microsoft Orleanspluralsight

Category: Other (Backend)
Duration 1 hour 45 minutes
Apache Kafka Series - Learn Apache Kafka for Beginners v3

Apache Kafka Series - Learn Apache Kafka for Beginners v3udemy

Category: Other (Backend)
Duration 8 hours 20 minutes 45 seconds
Full-Stack Fundamentals 2 - Backend

Full-Stack Fundamentals 2 - BackendMckay Wrigley (takeoff)

Category: Other (Backend), Other (Frontend)
Duration 1 hour 45 minutes 49 seconds
Fundamentals of Database Engineering

Fundamentals of Database Engineeringudemy

Category: Other (Backend)
Duration 26 hours 2 minutes 59 seconds
PostgreSQL Replication, High Availability HA and Scalability

PostgreSQL Replication, High Availability HA and Scalabilityudemy

Category: Other (Backend)
Duration 3 hours 9 minutes 35 seconds
PostgreSQL High Performance Tuning Guide

PostgreSQL High Performance Tuning Guideudemy

Category: Other (Backend)
Duration 2 hours 41 minutes 14 seconds
Fundamentals of Networking Engineering

Fundamentals of Networking Engineeringudemy

Category: Other (Backend)
Duration 13 hours 40 minutes 46 seconds