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
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

Full-Stack Fundamentals 4 - Payments

Full-Stack Fundamentals 4 - Payments

Sources: Mckay Wrigley (takeoff)
In the previous section, we successfully implemented user authentication using Clerk. Now, based on this project, we will add online payment processing with...
54 minutes 17 seconds
Apache Kafka Series - Learn Apache Kafka for Beginners v3

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
High Performance SQLite

High Performance SQLite

Sources: Aaron Francis
This course is designed to take you from beginner to expert in SQLite. You'll learn how to use SQLite in production, how to optimize it, and how to use...
15 hours 27 minutes 55 seconds
Zero To Shipped

Zero To Shipped

Sources: Kitze
Feeling intimidated by fullstack development? Wondering how can some developers ship a functional app in one day? This engaging video course demystifies and simplifies the proce...
24 hours 38 minutes 44 seconds
Introduction to Microsoft Orleans

Introduction to Microsoft Orleans

Sources: pluralsight
Microsoft Orleans, the Virtual Actor Framework developed by Microsoft Research is ideal for building distributed high scale systems with C#.
1 hour 45 minutes