DBMS
21h 30m 50s
English
Paid
Course description
This course is dedicated to the study of Database Management Systems (DBMS) - technologies that allow for efficient data storage, processing, and protection. You will start with the most fundamental concepts (data, information, databases and their characteristics), and then gradually move on to data models, SQL, NoSQL, and modern approaches to distributed and scalable systems.
The course is designed to provide listeners with a comprehensive understanding of how databases are structured internally, how to work with them in practice, and how to ensure their reliability, security, and performance.
Read more about the course
After the course, you will be able to:
- Distinguish data from information and understand why DBMS are needed;
- Work with relational and non-relational databases;
- Write SQL queries and optimize them;
- Configure security, backup, and scaling;
- Design databases for real applications.
Watch Online
Join premium to watch
Go to premium
| # | Title | Duration |
|---|---|---|
| 1 | 1.1 Data, Information & Database (Introduction to DBMS) | 11:47 |
| 2 | 1.2 Types of Databases | 10:25 |
| 3 | 1.3 Database Management System | 11:30 |
| 4 | 1.4 Need, Advantages and Disadvantages of DBMS | 09:48 |
| 5 | 1.5 Data Abstraction in DBMS | 09:52 |
| 6 | 1.6 DBMS Architecture | 09:39 |
| 7 | 1.7 Database Users and Interactions | 14:33 |
| 8 | 2.1 DBMS Interfaces (Data Models and ER Models) | 19:25 |
| 9 | 2.2 Data Models and Their Types | 12:33 |
| 10 | 2.3 ER Model and its Components | 13:09 |
| 11 | 2.4 Types of Relationships in DBMS | 11:29 |
| 12 | 2.5 Extended ER Features | 12:43 |
| 13 | 2.6 Types of Inheritance | 10:55 |
| 14 | 2.7 Entity-Relationship Diagram | 12:20 |
| 15 | 2.8 Create ER Diagram | 11:28 |
| 16 | 2.9 Relationships in ER Diagram | 10:46 |
| 17 | 2.10 Relational Models | 15:26 |
| 18 | 3.1 Intension and Extension (Relational Model and Normalization) | 11:28 |
| 19 | 3.2 Keys in DBMS | 11:05 |
| 20 | 3.3 Data Normalization | 18:27 |
| 21 | 3.4 Functional Dependency | 12:49 |
| 22 | 3.5 Armstrong's Axioms | 10:47 |
| 23 | 3.6 Inference Rules | 11:45 |
| 24 | 3.7 Closure in Functional Dependencies | 09:54 |
| 25 | 3.8 Denormalisation | 17:52 |
| 26 | 4.1 Database Languages (SQL and Query Optimization) | 15:28 |
| 27 | 4.2 SQL Operators | 12:44 |
| 28 | 4.3 Aggregates in SQL | 10:48 |
| 29 | 4.4 SQL Clauses | 10:45 |
| 30 | 4.5 SQL Joins | 15:17 |
| 31 | 4.6 SQL Joins (Advanced) | 14:23 |
| 32 | 4.7 SQL Joins (Advanced) | 16:36 |
| 33 | 4.8 Views in SQL | 17:26 |
| 34 | 4.9 Advanced Views in SQL | 14:18 |
| 35 | 4.10 Indexed Views (Materialised Views) | 17:06 |
| 36 | 4.11 SQL Subqueries | 15:05 |
| 37 | 4.12 Types of SQL Subqueries | 18:09 |
| 38 | 4.13 Query Processing | 12:49 |
| 39 | 4.14 Query Optimization | 18:24 |
| 40 | 4.15 Advanced Query Optimization | 19:08 |
| 41 | 5.1 NoSQL Databases (NoSQL Databases) | 24:55 |
| 42 | 5.2 BASE Properties | 15:22 |
| 43 | 5.3 NoSQL Languages | 24:15 |
| 44 | 5.4 Graph Databases | 13:01 |
| 45 | 5.5 In-Memory Databases | 07:35 |
| 46 | 5.6 Partitioning in Databases | 20:07 |
| 47 | 5.7 Types of Partitioning | 22:24 |
| 48 | 5.8 Sharding in DBMS | 22:57 |
| 49 | 6.1 Sharding in DBMS (Distributed Database Systems) | 16:04 |
| 50 | 6.2 Distributed Database Systems | 14:13 |
| 51 | 6.3 Architecture of Distributed Database Systems | 11:46 |
| 52 | 6.4 Data Distribution Methods | 16:37 |
| 53 | 6.5 Fault Tolerance in Distributed Databases | 18:03 |
| 54 | 6.6 Load Balancing in Distributed Databases | 13:14 |
| 55 | 6.7 Data Replication Techniques | 14:17 |
| 56 | 7.1 Thomas' Rules (Transactions and Concurrency) | 08:19 |
| 57 | 7.2 ACID Properties | 13:55 |
| 58 | 7.3 CAP Theorem | 16:33 |
| 59 | 7.4 Database Transactions | 13:27 |
| 60 | 7.5 Concurrency Control in Databases | 18:31 |
| 61 | 7.6 Locking Protocol (Shared Locks, Exclusive Locks) | 16:19 |
| 62 | 7.7 Timestamp Ordering Protocols in DBMS | 17:23 |
| 63 | 7.8 Starvation in DBMS | 10:07 |
| 64 | 7.9 Deadlock in DBMS | 12:53 |
| 65 | 7.10 Concurrency Control in Distributed Databases | 18:44 |
| 66 | 7.11 Serialization in Databases | 19:12 |
| 67 | 7.12 Scheduling in Databases | 12:04 |
| 68 | 7.13 Serialization Graphs in Databases | 12:12 |
| 69 | 7.14 Isolation Levels | 10:22 |
| 70 | 7.15 Managing Transaction Consistency and Concurrency | 11:55 |
| 71 | 8.1 Triggers in Databases (Triggers and Procedural Features) | 13:42 |
| 72 | 8.2 Stored Procedures in Databases | 13:03 |
| 73 | 9.1 Database Recovery Management (Recovery and Backup) | 12:48 |
| 74 | 9.2 Database Backups | 13:00 |
| 75 | 10.1 Database Indexing (Indexing and Performance Tuning) | 15:31 |
| 76 | 10.2 Types of Database Indexing | 12:18 |
| 77 | 10.3 Indexing Techniques | 11:53 |
| 78 | 10.4 B- and B+ Trees | 12:24 |
| 79 | 11.1 Database Monitoring (Database Monitoring and Caching) | 12:29 |
| 80 | 11.2 Performance Tuning | 11:19 |
| 81 | 11.3 Database Caching | 10:23 |
| 82 | 11.4 Database Caching Strategies | 09:45 |
| 83 | 12.1 Data Encryption in DBMS (Security and Access Control) | 08:53 |
| 84 | 12.2 Database Security | 13:11 |
| 85 | 12.3 Encryption Techniques in DBMS | 07:17 |
| 86 | 12.4 Data Masking Techniques | 10:10 |
| 87 | 12.5 RBAC (Role-Based Access Control) | 12:20 |
| 88 | 12.6 RBAC Models | 11:30 |
| 89 | 13.1 Database Scaling (Scalability and Big Data) | 13:52 |
| 90 | 13.2 Big Data and DBMS | 14:18 |
| 91 | 13.3 DBaas (Database as a Service) | 08:16 |
| 92 | 14.1 Database Migration (Data Warehousing and Migration) | 11:06 |
| 93 | 14.2 Data Warehousing | 10:29 |
| 94 | 14.3 Event-Driven Architecture | 13:46 |
Similar courses
Neo4j: GraphDB Foundations with Cypher
Sources: udemy
Learn what a graph database is, gain the fundamental skills to use Neo4j on your next project. Learn how some of the worlds top tech companies structure and que
4 hours 44 minutes
Fundamentals of Networking Engineering
Sources: udemy
We are entering an era in software engineering where we rely on libraries and frameworks to do most of our work. While this is useful and save tremendous dev ho
18 hours 6 minutes 23 seconds
Apache Kafka Series - Learn Apache Kafka for Beginners v3
Sources: udemy
Welcome to the Apache Kafka Series! Join a community of 20,000+ students learning Kafka. Apache Kafka has become the leading distributed data streaming enterprise big data tech...
8 hours 20 minutes 45 seconds
Full-Stack Fundamentals 2 - Backend
Sources: Mckay Wrigley (takeoff)
In the first project, we focused on the frontend, creating a personal portfolio website. Now we will take the next step towards full-stack development...
1 hour 45 minutes 49 seconds
PostgreSQL Fundamentals
Sources: bigmachine.io
You will learn the basics of SQL and work with databases using PostgreSQL as an example - and you will truly enjoy it! We will work with a real dataset...
2 hours 5 minutes 18 seconds