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
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 |
Comments
0 commentsSimilar courses
Apache Flink
Sources: rockthejvm.com
Apache Flink is a distributed system and computational engine for stateful big data streaming. That was a mouthful. In plain English, Flink is an library that allows you to proc...
8 hours 31 minutes 38 seconds
Web API From Start to Finish
Sources: iamtimcorey.com (Tim Corey)
Application Programming Interfaces (APIs) are software that send information back and forth between a program and a user. The entire web runs on APIs! They are required for mose...
17 hours 59 minutes 54 seconds
Build an app with ASPNET Core and Angular from scratch
Sources: udemy
Have you learnt the basics of ASP.NET Core and Angular? Not sure where to go next? This course should be able to help with that. In this course we start from nothing and incr...
29 hours 51 minutes 36 seconds
The Complete 2023 Web Development Bootcamp
Sources: udemy
Welcome to the Complete Web Development Bootcamp, the only course you need to learn to code and become a full-stack web developer. With over 12,000 ratings and a 4.8 average, my...
62 hours 32 minutes 23 seconds
Want to join the conversation?
Sign in to comment