Neso Academy DBMS: study plan and how long it takes
The Neso Academy playlist is 91 videos and 17.9 hours long. Here's how long it takes at different paces, a week-by-week schedule built from the real videos, and a planner that turns it into your own daily plan.
91 videos · 17.9 hours · Neso Academy
Neso Academy's DBMS course covers database basics and data models, keys, relational algebra with solved problems, database design and ER diagrams, SQL DDL, DML and TCL commands, SQL functions and solved SQL problems, ending with a rapid-fire SQL quiz.
It balances theory with SQL practice. The very last entry (MySQL practicals) is a short preview of a chapter that continues on nesoacademy.org.
Who it's for: Students learning databases for university exams who also want practical SQL skills.
How long does it take?
The full playlist is 17.9 hours across 91 videos. Here's roughly how many days that is at different daily watch times and speeds, counting video time only:
| Daily time | At 1x | At 1.5x | At 2x |
|---|---|---|---|
| 30 min a day | 36 days | 24 days | 18 days |
| 1 h a day | 18 days | 12 days | 9 days |
| 2 h a day | 9 days | 6 days | 5 days |
Make your own schedule
The playlist link is already filled in. Press Plan, set how much time you have each day and your speed, and you'll get a day-by-day schedule with a finish date and a calendar file. It reads the live playlist, so new videos are included.
Week-by-week schedule
A sample plan at 1 hour a day and normal speed, using whole videos so none is split across days. That's 3 weeks in total. For a different pace, start date or speed, use the planner above.
Week 1Videos 1–29 · 6h 4m
Day 1 · 49m
- 1Introduction to Database Management Systems (DBMS)10m
- 2DBMS - Definition9m
- 3Applications of DBMS7m
- 4File System vs. Database Management System23m
Day 2 · 47m
- 5Three Tier Architecture11m
- 6View of Data10m
- 7Instances and Schemas in DBMS10m
- 8Database Users8m
- 9Database Administrator (DBA)7m
Day 3 · 54m
- 10Introduction to Data Models16m
- 11Database System Architecture - Part 115m
- 12Database System Architecture - Part 216m
- 13History of DBMS7m
Day 4 · 58m
- 14Database Languages and Software12m
- 15Introduction to DBMS - Solved Questions9m
- 16Introduction to Relational Databases12m
- 17Codd’s 12 Rules (13 Rules)16m
- 18Database Schema9m
Day 5 · 54m
- 19Keys in RDBMS23m
- 20Keys in RDBMS (Solved Questions)10m
- 21Schema Diagrams13m
- 22Relational Query Languages8m
Day 6 · 53m
- 23Basics of Relational Algebra8m
- 24Relational Algebra (Select Operation)16m
- 25Relational Algebra (Project Operation)9m
- 26Relational Algebra (Union Operation)20m
Day 7 · 50m
- 27Relational Algebra (Set Difference Operation)15m
- 28Relational Algebra (Cartesian Product Operation)25m
- 29Relational Algebra (Rename Operation)10m
Week 2Videos 30–56 · 5h 48m
Day 8 · 36m
- 30Relational Algebra (Set Intersection Operation)21m
- 31Relational Algebra (Assignment Operation)8m
- 32NULL Values in RDBMS7m
Day 9 · 55m
- 33Relational Algebra (Natural Join Operation)26m
- 34Relational Algebra (Division Operation)9m
- 35Relational Algebra (Outer Join Operation)11m
- 36Relational Algebra (Solved Problem 1)9m
Day 10 · 55m
- 37Relational Algebra (Solved Problem 2)7m
- 38Relational Algebra (Solved Problem 3)6m
- 39Relational Algebra (Solved Problem 4)20m
- 40Relational Algebra (Solved Problem 5)10m
- 41Tuple Relational Calculus (Formal Definition)12m
Day 11 · 53m
- 42Tuple Relational Calculus (Example Queries)17m
- 43Domain Relational Calculus (Formal Definition)10m
- 44Domain Relational Calculus (Example Queries)16m
- 45Relational Algebra (Rapid Fire Quiz)9m
Day 12 · 52m
- 46Database Design11m
- 47Introduction to E-R Model (Part 1)20m
- 48Introduction to E-R Model (Part 2)10m
- 49Types of Attribute in DBMS11m
Day 13 · 45m
- 50Mapping Cardinalities11m
- 51Entity-Relationship (ER) Diagram17m
- 52Mapping Cardinality in ER Diagram8m
- 53Participation Constraints in DBMS10m
Day 14 · 53m
- 54ER Diagram for University Database22m
- 55ER Diagram for Banking Enterprise15m
- 56ER Diagram for Hospital Management System16m
Week 3Videos 57–91 · 5h 59m
Day 15 · 59m
- 57Extended ER Features25m
- 58ER Model (Solved Problem 1)8m
- 59ER Model (Solved Problem 2)8m
- 60ER Model (Solved Problem 3)7m
- 61ER Model (Rapid Fire Quiz)10m
Day 16 · 59m
- 62Introduction to Structured Query Language (SQL)9m
- 63Data Definition Language (DDL)6m
- 64DDL Commands - CREATE14m
- 65Constraints in SQL7m
- 66Constraints in SQL (Example Queries)10m
- 67Primary Key and Foreign Key Constraints in SQL13m
Day 17 · 59m
- 68DDL Commands - ALTER11m
- 69DDL Commands - TRUNCATE, DROP, and RENAME6m
- 70DML Commands - INSERT and UPDATE11m
- 71DML Commands - DELETE and SELECT11m
- 72Data Control Language (DCL)11m
- 73Transaction Control Language (TCL)9m
Day 18 · 57m
- 74Aggregate Functions in SQL12m
- 75GROUP BY and HAVING Clause in SQL8m
- 76ORDER BY in SQL6m
- 77LIKE in SQL9m
- 78IN in SQL6m
- 79BETWEEN in SQL6m
- 80Alias (AS) in SQL10m
Day 19 · 55m
- 81TOP, LIMIT, FETCH FIRST, and ROWNUM in SQL7m
- 82NULL Functions in SQL15m
- 83ANY and ALL Operators in SQL11m
- 84CASE Expression in SQL10m
- 85Comments in SQL12m
Day 20 · 47m
- 86Joins in SQL24m
- 87SQL - Solved Problem 19m
- 88SQL - Solved Problem 27m
- 89SQL - Solved Problem 36m
Day 21 · 24m
- 90SQL (Rapid Fire Quiz)22m
- 91MySQL Practicals | Chapter 5 | Database Management Systems (DBMS)2m
Tips for finishing
- Install MySQL and type every query from the SQL chapters yourself.
- Practise relational algebra with the solved problems; it's a common exam topic.