DBMSFoundationOne To One
Database Management Systems and SQL
Design databases, write SQL with confidence and understand what happens inside a DBMS.
About this programme
Twelve sessions on databases for B.Tech courses, GATE and placements. You design schemas with ER diagrams and normalisation, write SQL on a real database from the first session, and learn how transactions and indexes work underneath.
What you will be able to do
- Design a database with ER diagrams and normal forms
- Write SQL queries with joins, grouping and subqueries
- Explain transactions, concurrency control and recovery
- Answer DBMS questions in exams and interviews
Curriculum
4 modules · 12 lessons
- Databases, DBMS and the relational model1h
- ER diagrams1h
- Keys and constraints1h
Before you start
- Basic programming; no database experience needed