You can download the lectures here. We will try to upload lectures prior to their corresponding classes.

  • Introduction
    tl;dr: Class Overview, Database Architectures: Centralized, Client-Server, Distributed, and Parallel
    [slides]
  • Relational Model
    tl;dr: Structure of Relational Model and Different Types of Keys
    [slides]
  • Relational Algebra
    tl;dr: Introduction to Relational Algebra and its operations
    [slides]
  • Relations
    tl;dr: Introduction to Relational Calculus and queries using it
    [slides]
  • ER
    tl;dr: ER model basics, including Entity, Attributes, Relationship, and designing with them
    [slides]
  • EER
    tl;dr: Generalization and Specialization, Hierarchies and Lattices, Union, and Aggregation"
    [slides]
  • Reducing ER Diagrams to Relational Schemas
    tl;dr: Rules of translating ER diagrams to relational schemas, Examining different ways of reduction based on relation cardinality
    [slides]
  • Reducing EER Diagrams to Relational Schemas
    tl;dr: Rules of translating EER diagrams to relational schemas by examining 'IS A' Relationships, Aggregation Relationships, etc
    [slides]
  • Introduction to SQL
    tl;dr: Introduction to SQL commands; Database, Schemas, and Tables; Data types
    [slides]
  • DDL
    tl;dr: Introduction to Data Definition Language (DDL) commands: CREATE TABLE, ALTER TABLE, DROP TABLE, RENAME, TRUNCATE, and COMMENT; Data Integrity Enhancement feature
    [slides]
  • DML
    tl;dr: Introduction to SQL commands: Select, Join, Data Aggregation, Subqueries, Manipulating Data
    [slides] [video1] [video2] [video3] [video4] [video5]
  • DCL
    tl;dr: Creating Users and modifying their access
    [slides]
  • View
    tl;dr: Introduction to View and Materialized View, their implementation in DBMS, user commands and views, updating a view on multiple tables.
    [slides] [video]
  • Integrity, Assertion, Procedure, Function, and Trigger
    tl;dr: Integrity Constraints (ICs), CHECK, Assertions and limitations of DBMS, Trigger, Procedure, Functions, and examples
    [slides]
  • Modern SQL
    tl;dr: Output Control, Window Functions, Nested Queries, Lateral Join, and Common Table Expressions
    [slides] [practice]
  • Functional Dependencies
    tl;dr: Definition, Armstrong Axioms, Closure of Attribute Sets, Types of FDs, FDs in Relational Database
    [slides]
  • Normalization
    tl;dr: Introduction to Normalization, 1NF, 2NF, 3NF, BCNF
    [slides]
  • Optimizing Database Performance
    tl;dr: Introduction to Indexing, clustered and un-clustered index, hash based and B+ tree index, Introduction to partitioning, partitioning methods
    [slides]
  • Data Warehouse
    tl;dr: Data Warehouse Models, Multidimensional Modeling, Schema Design, Data Cubes, OLAP Operations
    [slides]
  • Advanced Tunning
    tl;dr: Query Optimization, B+ Tree, Hashing, Examples
    [slides]
  • TCL
    tl;dr: Database Transactions, ACID properties, COMMIT and ROLLBACK, and Locking
    [slides]
  • NoSQL
    tl;dr: Introduction, Why use NoSQL, Data Partitioning Algorithms, Consistant Hashing,
    [slides] [Dr. Amini Slides]