Experiential Learning in module order

Module: Introduction

Install DBMS Software

Install Oracle DBMS on your laptop

Module: Virtualization

Docker Containers

Learn how to use Docker

Docker Hands-on

Module: Worlds of Database Systems

Exercise 1

Reverse engineer an application

HW1: Querying Large Files

Write a Java program to query large CSV files

Assignment 1

Module: The relational model of data

Exercise 2

Write relational algebra expressions

Exercise 3

Write schemas in SQL

Module: Algebraic and logical query languages

Exercise 4

Relational algebra & bag semantics

Exercise 5

Queries as datalog programs

Module: SQL

Exercise 6

Write basic SQL queries

Exercise 7

Write Nested SQL Queries

Exercise 8

Write Aggregation Queries in SQL

HW2: SQL

Write SQL Queries

Assignment 2

Module: SQL in a server environment

Exercise 9

How does an app talk to a DB?

JDBC example

Sample code to run JDBC

HW3: Web App

Program a simple web application

Assignment 3

Module: Midterm

Mock Midterm

Practice for the real midterm

Module: High-level database models

Exercise 10

Practice the design of a database model

HW4: ERD

Design a database

Assignment 4

Module: Design theory for relational databases

Exercise 11

Finding Keys using Armstrong’s axioms.

Exercise 12

Identifying Normal Forms.

Exercise 13

Identifying Lossless-join & Dependency-preserving Decomposition

Module: Constraints, triggers, view, indexes

Exercise 14

Choosing indexes

Module: Transaction processing

Exercise 15

Reasoning with Transactions

Exercise 16

Practice use of locking, logging, and recovery

Module: Storage and indexing

Exercise 17

Estimate data access times

Exercise 18

Analyze the use of indexes

Module: Query processing

Exercise 19

Practice query planning and optimization

Module: Semi-structured data and XML

Exercise 20

Practice querying XML data

Module: Project

Project

Create a DBMS-backed Web Application

Module: Final Exam

Mock Final

Practice for the real final