Course Outline
Topics
Basic Database Concepts
File System vs DBMS
Database Architecture
Three Level Schema Architecture
Data Independence
Relational Data Model
Attributes
Schemas
tuples
domains
relation instances
Keys of relations
Integrity Constraints
relational algebra
selection projection
cartesian product
types of joins
functional Dependencies
normal forms
entity-relationship model and diagrams
Structured Query Language
Joins and Sub Queries in SQL
Concurrency Control
database backup and recovery
Indexes
NoSQL Systems
Back to Subject Selection