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
Watch Online DBMS
0:00
/ #1: 1.1 Data, Information & Database (Introduction to DBMS)
All Course Lessons (94)
| # | Lesson Title | Duration | Access |
|---|---|---|---|
| 1 | 1.1 Data, Information & Database (Introduction to DBMS) Demo | 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 |
Unlock unlimited learning
Get instant access to all 93 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
Fundamentals of Backend Engineering
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
16 hours 53 minutes 4 seconds
Fundamentals of Database Engineering
Sources: udemy
Database Engineering is a very interesting sector in software engineering. If you are interested in learning about database engineering you have come to the rig
26 hours 2 minutes 59 seconds
Complete SQL + Databases Bootcamp: Zero to Mastery
Sources: zerotomastery.io
With so many online resources available, it can be paralyzing not only figuring out where to start but more importantly which courses will actually teach you the skills you need...
24 hours 6 minutes 52 seconds
Ludicrous Speed Postgres
Sources: Creston Jamison
This course is dedicated to optimizing PostgreSQL performance with a focus on proper schema design and efficient database usage. It is designed for those...
12 hours 27 minutes 44 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