StudiousStart free

17 units · 60 lessons

Database Systems

Database Systems from the first idea to exam level: every lesson builds on the one before, with a worked example, a step-through diagram where it helps, a quick check and practice that adapts to what you know. Follows Silberschatz, Korth & Sudarshan, Database System Concepts, 7th ed. (with Elmasri & Navathe).

Database Systems at a glance

What does Database Systems cover?

Database Concepts & Architecture, ER Modeling, Relational Model, Relational Algebra, SQL DDL & DML, SQL Queries & Joins, Aggregates & Subqueries, Views, Procedures & Triggers, Functional Dependencies, Normalization, Transactions & Schedules, Concurrency Control & Recovery and Indexing & Query Processing. It follows Silberschatz, Korth & Sudarshan, Database System Concepts, 7th ed. (with Elmasri & Navathe).

How many lessons does the Database Systems course on Studious have?

17 units and 60 lessons, from "From files to a database" to "Query processing and optimization". Each lesson has a worked example, a quick check and practice that adapts to what you know, and many have step-by-step diagrams.

Course outline

  1. Unit 1 · Week 1

    Databases and the DBMS

    1. From files to a database
    2. The DBMS, its users and its languages
    3. Three-schema architecture and data independence
    4. Data models, schemas and instances
  2. Unit 2 · Weeks 2–3

    Entity-relationship modeling

    1. Entities, entity sets and attributes
    2. Composite, multivalued and derived attributes
    3. Relationships, degree and roles
    4. Cardinality ratios and participation
    5. Weak entities
  3. Unit 3 · Week 4

    Extended ER and a full design

    1. Specialization and generalization
    2. Designing a complete ER diagram
  4. Unit 4 · Week 5

    The relational model

    1. Relations, tuples and attributes
    2. Keys: super, candidate, primary and foreign
    3. Integrity constraints
  5. Unit 5 · Week 6

    Mapping ER to relations

    1. Mapping strong and weak entities
    2. Mapping 1:1, 1:N and M:N relationships
    3. Mapping multivalued attributes and specialization
  6. Unit 6 · Weeks 6–7

    Relational algebra

    1. Selection and projection
    2. Union, intersection and difference
    3. Cartesian product and joins
    4. Rename, division and query trees
  7. Unit 7 · Week 8

    SQL: defining and changing data

    1. CREATE TABLE and data types
    2. Constraints in SQL
    3. ALTER, DROP and TRUNCATE
    4. INSERT, UPDATE and DELETE
  8. Unit 8 · Week 9

    SQL: retrieving data

    1. SELECT, FROM and WHERE
    2. Sorting and filtering with ORDER BY, DISTINCT, LIKE, BETWEEN and IN
    3. NULL and three-valued logic
  9. Unit 9 · Week 10

    SQL joins

    1. Inner joins
    2. Left, right and full outer joins
    3. Self joins and joining three tables
  10. Unit 10 · Week 11

    Aggregates and grouping

    1. Aggregate functions
    2. GROUP BY
    3. HAVING and the order of evaluation
  11. Unit 11 · Weeks 11–12

    Subqueries and set operations

    1. Subqueries in WHERE and FROM
    2. Correlated subqueries and EXISTS
    3. UNION, INTERSECT and EXCEPT
  12. Unit 12 · Week 12

    Views, procedures and triggers

    1. Views
    2. Stored procedures and functions
    3. Triggers
  13. Unit 13 · Week 13

    Functional dependencies

    1. Anomalies and functional dependencies
    2. Armstrong's axioms and attribute closure
    3. Finding candidate keys and a minimal cover
  14. Unit 14 · Weeks 13–14

    Normalization

    1. First normal form
    2. Second normal form
    3. Third normal form
    4. Boyce–Codd normal form
    5. Lossless and dependency-preserving decomposition
  15. Unit 15 · Weeks 14–15

    Transactions

    1. Transactions and ACID
    2. Transaction states and concurrency problems
    3. Schedules and conflict serializability
    4. Recoverable schedules and isolation levels
  16. Unit 16 · Week 15

    Concurrency control and recovery

    1. Shared and exclusive locks
    2. Two-phase locking
    3. Deadlocks
    4. Logs, checkpoints and recovery
  17. Unit 17 · Week 16

    Storage, indexing and query processing

    1. Files, blocks and indexes
    2. B+ tree indexes
    3. Hash indexes
    4. Query processing and optimization

Study every lesson with diagrams, practice and Buddy, your AI tutor.

Start studying free