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:

  1. Distinguish data from information and understand why DBMS are needed;
  2. Work with relational and non-relational databases;
  3. Write SQL queries and optimize them;
  4. Configure security, backup, and scaling;
  5. Design databases for real applications.

Watch Online

This is a demo lesson (10:00 remaining)

You can watch up to 10 minutes for free. Subscribe to unlock all 94 lessons in this course and access 10,000+ hours of premium content across all courses.

View Pricing

Watch Online DBMS

0:00
/
#1: 1.1 Data, Information & Database (Introduction to DBMS)

All Course Lessons (94)

#Lesson TitleDurationAccess
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 subscription

Comments

0 comments

Want to join the conversation?

Sign in to comment

Similar courses

Master SQL Queries From Basic to Advanced

Master SQL Queries From Basic to Advanced

Sources: Kamran Ahmed
The course is designed for developers, data analysts, and anyone working with databases. It covers the entire range of SQL queries - from basics to advanced...
Database Design & Implementation

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
The Complete SQL Bootcamp: Go from Zero to Hero

The Complete SQL Bootcamp: Go from Zero to Hero

Sources: udemy
You'll learn how to read and write complex queries to a database using one of the most in demand skills - PostgreSQL. These skills are also applicable to any ot
8 hours 45 minutes 49 seconds
Fundamentals of Networking Engineering

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