Skip to content
Sabaqاردو

Database Management Systems (Neso Academy)

By Neso Academy

Course audio
Course audio: English
Level
Intermediate
Length
91 lessons · 17.9 hours

What you'll be able to do

  • Explain schemas, data models and keys in relational databases
  • Write relational algebra and relational calculus queries
  • Design databases with ER diagrams
  • Use SQL DDL, DML and transaction commands in MySQL

About this course

Neso Academy's DBMS course, 91 lectures and about 18 hours, covering the theory and SQL parts of a university database subject. It compares file systems with DBMS, explains instances and schemas, data models, the history of DBMS, relational databases and keys. A long section on relational algebra (project, select, Cartesian product, assignment, division) comes with solved problems, followed by tuple and domain relational calculus. Database design is taught with attribute types, mapping cardinalities and ER diagrams, including a banking example and quizzes. The SQL part covers DDL commands, primary and foreign key constraints, DML insert and update, transaction control, ORDER BY, BETWEEN, NULL functions and MySQL practicals. Suits BS students studying databases.

Before you start: Basic computer knowledge; set theory helps.

Syllabus

91 lessons · 17:51:13 in total

  1. 1Introduction to Database Management Systems (DBMS)9:38
  2. 2DBMS - Definition9:01
  3. 3Applications of DBMS7:18
  4. 4File System vs. Database Management System23:13
  5. 5Three Tier Architecture11:00
  6. 6View of Data10:23
  7. 7Instances and Schemas in DBMS9:33
  8. 8Database Users8:24
  9. 9Database Administrator (DBA)7:29
  10. 10Introduction to Data Models16:24
  11. 11Database System Architecture - Part 114:33
  12. 12Database System Architecture - Part 215:46
  13. 13History of DBMS6:52
  14. 14Database Languages and Software12:14
  15. 15Introduction to DBMS - Solved Questions9:20
  16. 16Introduction to Relational Databases12:08
  17. 17Codd’s 12 Rules (13 Rules)15:51
  18. 18Database Schema8:39
  19. 19Keys in RDBMS22:49
  20. 20Keys in RDBMS (Solved Questions)10:20
  21. 21Schema Diagrams12:54
  22. 22Relational Query Languages7:48
  23. 23Basics of Relational Algebra7:53
  24. 24Relational Algebra (Select Operation)16:07
  25. 25Relational Algebra (Project Operation)8:32
  26. 26Relational Algebra (Union Operation)20:15
  27. 27Relational Algebra (Set Difference Operation)15:24
  28. 28Relational Algebra (Cartesian Product Operation)24:41
  29. 29Relational Algebra (Rename Operation)9:37
  30. 30Relational Algebra (Set Intersection Operation)20:35
Show all 91 lessons
  1. 31Relational Algebra (Assignment Operation)8:03
  2. 32NULL Values in RDBMS7:17
  3. 33Relational Algebra (Natural Join Operation)26:11
  4. 34Relational Algebra (Division Operation)8:42
  5. 35Relational Algebra (Outer Join Operation)10:52
  6. 36Relational Algebra (Solved Problem 1)9:04
  7. 37Relational Algebra (Solved Problem 2)6:38
  8. 38Relational Algebra (Solved Problem 3)5:37
  9. 39Relational Algebra (Solved Problem 4)19:49
  10. 40Relational Algebra (Solved Problem 5)10:20
  11. 41Tuple Relational Calculus (Formal Definition)12:18
  12. 42Tuple Relational Calculus (Example Queries)17:24
  13. 43Domain Relational Calculus (Formal Definition)10:10
  14. 44Domain Relational Calculus (Example Queries)16:15
  15. 45Relational Algebra (Rapid Fire Quiz)9:13
  16. 46Database Design10:49
  17. 47Introduction to E-R Model (Part 1)20:12
  18. 48Introduction to E-R Model (Part 2)10:27
  19. 49Types of Attribute in DBMS10:32
  20. 50Mapping Cardinalities10:32
  21. 51Entity-Relationship (ER) Diagram17:17
  22. 52Mapping Cardinality in ER Diagram7:39
  23. 53Participation Constraints in DBMS9:31
  24. 54ER Diagram for University Database21:30
  25. 55ER Diagram for Banking Enterprise15:08
  26. 56ER Diagram for Hospital Management System16:21
  27. 57Extended ER Features25:27
  28. 58ER Model (Solved Problem 1)7:50
  29. 59ER Model (Solved Problem 2)8:13
  30. 60ER Model (Solved Problem 3)7:18
  31. 61ER Model (Rapid Fire Quiz)10:00
  32. 62Introduction to Structured Query Language (SQL)8:41
  33. 63Data Definition Language (DDL)6:00
  34. 64DDL Commands - CREATE13:56
  35. 65Constraints in SQL7:24
  36. 66Constraints in SQL (Example Queries)9:50
  37. 67Primary Key and Foreign Key Constraints in SQL12:41
  38. 68DDL Commands - ALTER11:15
  39. 69DDL Commands - TRUNCATE, DROP, and RENAME6:05
  40. 70DML Commands - INSERT and UPDATE11:25
  41. 71DML Commands - DELETE and SELECT10:55
  42. 72Data Control Language (DCL)10:31
  43. 73Transaction Control Language (TCL)8:44
  44. 74Aggregate Functions in SQL11:41
  45. 75GROUP BY and HAVING Clause in SQL7:57
  46. 76ORDER BY in SQL5:37
  47. 77LIKE in SQL8:56
  48. 78IN in SQL6:13
  49. 79BETWEEN in SQL6:26
  50. 80Alias (AS) in SQL10:06
  51. 81TOP, LIMIT, FETCH FIRST, and ROWNUM in SQL7:03
  52. 82NULL Functions in SQL15:03
  53. 83ANY and ALL Operators in SQL11:07
  54. 84CASE Expression in SQL9:42
  55. 85Comments in SQL11:36
  56. 86Joins in SQL24:08
  57. 87SQL - Solved Problem 18:55
  58. 88SQL - Solved Problem 27:29
  59. 89SQL - Solved Problem 36:22
  60. 90SQL (Rapid Fire Quiz)22:26
  61. 91MySQL Practicals | Chapter 5 | Database Management Systems (DBMS)1:39

What to take next

Related courses

Videos by Neso Academy, played from their official YouTube channel. Subscribe on YouTube

Official upload by the teacher or institution on their own channel, shown with YouTube's embedded player.

Lessons listed from the official YouTube playlist. Full playlist on YouTube

Lessons last checked Oct 2026. Course summary and lesson structure by Sabaq.

Report a problem or a rights request