DBMSFoundationOne To One

Database Management Systems and SQL

Design databases, write SQL with confidence and understand what happens inside a DBMS.

Dhananjay K.Dhananjay K.0 enrolled12 lessons · 12h

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

    1. Databases, DBMS and the relational model1h
    2. ER diagrams1h
    3. Keys and constraints1h

Before you start

  • Basic programming; no database experience needed
Database Management Systems and SQL · Entueri