A database is an organised collection of interrelated data that models some aspect of the real world. A database management system(DBMS) is a collection of interrelated data and a set of programs to access those data.
Introduction
Relational languages
SQL
Introductory
- Overview of SQL
- SQL data definition
- Basic structure of SQL queries
- Additional basic SQL operations
- Set operations in SQL
- Null values in SQL
- Aggregate functions
- Nested subqueries
- Modification of the database
Intermediate
Advanced
- Accessing SQL from a programming language
- Triggers in SQL
- Recursive queries
- Advanced aggregation features
Database design
E-R model
- E-R model
- Constraint (E-R)
- Primary key (E-R)
- Extended E-R features
- E-R diagram
- Reduction to relational schema
- E-R design issues