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
0:00
/ #1: 001 Basic query executor
All Course Lessons (19)
| # | Lesson Title | Duration | Access |
|---|---|---|---|
| 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 subscriptionComments
0 commentsWant to join the conversation?
Sign in to commentSimilar courses
Node, SQL, & PostgreSQL - Mastering Backend Web Development
Sources: udemy
Become an in demand software engineer by taking this course on Node, SQL, PostgreSQL, and backend web development. As one of the most popular web development st
4 hours 59 minutes 41 seconds
Scaling Web App Configuration with Environment Variables
Sources: fullstack.io
This course examines in detail the use of the dotenv module for working with environment variables in JavaScript. You will learn to create nine different...
1 hour 53 minutes 25 seconds
Apache Kafka Series - Kafka Streams for Data Processing
Sources: udemy
Learn the Kafka Streams API with Hands-On Examples, Learn Exactly Once, Build and Deploy Apps with Java 8. Learn the Kafka Streams data processing library, for
4 hours 50 minutes 7 seconds
Database Design & Implementation
Sources: Amigoscode (Nelson Djalo)
Backend starts from Your Database. When you have a solid database design coding is easy. In this course you will learn how to design databases for your backend applications. You...
2 hours 7 minutes 49 seconds
Building Full-Stack Apps with AI
Sources: Mckay Wrigley (takeoff)
The course "Building Full-Stack Apps with AI" teaches how to create comprehensive applications using artificial intelligence, suitable for both beginners and...
8 hours 3 minutes 16 seconds