Introduction to Database Management Systems DBMS Characteristics Database Users Advantages & Disadvantages of DBMS History of Database Applications Fundamentals of Database Systems Three-Schema Architecture & Data Independence DBMS Languages, Interfaces, and Classification Database System Environment DBMS Architecture Basic Concepts of Entity-Relationship Model Database Design Process Concept of Relationships in ER Diagram Exercises based on ER Model Concepts (Part 1) Exercises based on ER Model Concepts (Part 2) Introduction to Relational Data Model Characteristics of Relations Relational Model Constraints Update Operations/Dealing with Constraint Violations Exercises based on Relational Model (Part 1) Exercises based on Relational Model (Part 2) Relational Algebra Operations - Unary Relational Algebra Operations - Set Theory Relational Algebra Operations - Binary Additional Relational Algebra Operations Relational Algebra Queries (Part 1) Relational Algebra Queries (Part 2) Introduction to Structured Query Language (SQL) Data Definition Language (DDL) DDL Commands - CREATE Constraints in SQL Constraints in SQL (Example Queries) Primary Key and Foreign Key Constraints in SQL DDL Commands - ALTER DDL Commands - TRUNCATE, DROP, and RENAME DML Commands - INSERT and UPDATE DML Commands - DELETE and SELECT Data Control Language (DCL) Transaction Control Language (TCL) Aggregate Functions in SQL GROUP BY and HAVING Clause in SQL ORDER BY in SQL LIKE in SQL IN in SQL BETWEEN in SQL Alias (AS) in SQL TOP, LIMIT, FETCH FIRST, and ROWNUM in SQL NULL Functions in SQL ANY and ALL Operators in SQL CASE Expression in SQL Introduction to Database Management Systems DBMS Characteristics Database Users Advantages & Disadvantages of DBMS History of Database Applications Fundamentals of Database Systems