MyPhatshala

DBMS Concepts

The theory behind every database: models, normalisation and transactions.

Intermediate7 modules23 lessonsFree · no sign-up
0 of 23 lessons published
View syllabus

Syllabus

01 IntroductionWhy databases exist. 4 lessons
  1. 1.1What is a DBMS?Coming soon
  2. 1.2File system vs DBMSComing soon
  3. 1.3Three-schema architectureComing soon
  4. 1.4Data independenceComing soon
02 Data ModelsDesigning a database. 3 lessons
  1. 2.1ER modelComing soon
  2. 2.2Converting ER diagrams to tablesComing soon
  3. 2.3Relational model and keysComing soon
03 Relational AlgebraThe maths behind SQL. 2 lessons
  1. 3.1Relational algebra operationsComing soon
  2. 3.2Joins in relational algebraComing soon
04 NormalisationRemoving redundancy. 4 lessons
  1. 4.1Functional dependenciesComing soon
  2. 4.21NF, 2NF and 3NFComing soon
  3. 4.3BCNFComing soon
  4. 4.4DenormalisationComing soon
05 TransactionsKeeping data consistent. 5 lessons
  1. 5.1ACID propertiesComing soon
  2. 5.2Transaction statesComing soon
  3. 5.3Concurrency controlComing soon
  4. 5.4Locking protocolsComing soon
  5. 5.5Deadlocks in databasesComing soon
06 Storage and IndexingMaking queries fast. 3 lessons
  1. 6.1File organisationComing soon
  2. 6.2IndexingComing soon
  3. 6.3B-trees and B+ treesComing soon
07 RecoverySurviving crashes. 2 lessons
  1. 7.1Log-based recoveryComing soon
  2. 7.2CheckpointsComing soon