Database Management System

What you'll learn

The key areas this subject covers, mapped to the official curriculum.

• Relational model and SQL
• Entity-relationship design
• Normalization
• Transactions and concurrency
• Storage and indexing

Course units

The structured path through this subject.

1. 1

   Database and Database Users

   What databases are, how a DBMS differs from file systems, and who interacts with the system.

   5 topics · 5 lessons available

2. 2

   Database System - Concepts and Architecture

   Data models, the three-schema architecture, data independence and DBMS system architectures.

   5 topics · 5 lessons available

3. 3

   Data Modeling Using the Entity-Relational Model

   Entity types, attributes, relationship types, ER diagrams and mapping an ER design to tables.

   5 topics · 5 lessons available

4. 4

   The Relational Data Model and Relational Database Constraints

   Tables, keys and integrity constraints that keep relational data consistent.

   5 topics · 5 lessons available

5. 5

   The Relational Algebra and Relational Calculus

   Formal query languages: relational algebra operators and tuple/domain calculus.

   5 topics · 5 lessons available

6. 6

   SQL

   The practical query language: DDL, queries, joins, aggregates, DML, views and indexes.

   6 topics · 6 lessons available

7. 7

   Relational Database Design

   Functional dependencies, normal forms and lossless decomposition for clean schemas.

   5 topics · 5 lessons available

8. 8

   Introduction to Transaction Processing Concepts and Theory

   Transactions, the ACID properties, schedules, serializability and the system log.

   5 topics · 5 lessons available

9. 9

   Concurrency Control Techniques

   Locks, two-phase locking, deadlock handling, timestamp ordering and optimistic methods.

   5 topics · 5 lessons available

10. 10

    Database Recovery Techniques

    Recovery concepts, the log, deferred and immediate update, checkpoints and shadow paging.

    5 topics · 5 lessons available