Experiential Learning in module order

This page collects together all of the “experiences” associated with individual modules.

In this site, experiences represent “active” learning opportunities, as opposed to readings, which represent “passive” learning opportunities. In many courses, readings and experiences together constitute the “assignments”.

Module: Introduction

Install DBMS Software

Install MySQL on your laptop

11 Jan 09:00 AM

Module: Worlds of Database Systems

Exercise 1

Reverse engineer an application

27 Aug 12:00 PM

HW1: Querying Large Files

Write a Java program to query large CSV files

Assignment 1 01 Jan 12:00 AM

Module: The relational model of data

Exercise 2

Write relational algebra expressions

08 Sep 12:00 AM

Exercise 3

Write schemas in SQL

01 Sep 12:00 PM

Module: Algebraic and logical query languages

Exercise 4

Relational algebra & bag semantics

10 Sep 12:00 PM

Exercise 5

Queries as datalog programs

15 Sep 12:00 PM

Module: SQL

Exercise 6

Write basic SQL queries

17 Sep 12:00 PM

Exercise 7

Write Nested SQL Queries

22 Sep 12:00 PM

Exercise 8

Write Aggregation Queries in SQL

24 Sep 12:00 PM

HW2: SQL

Write SQL Queries

Assignment 2

Module: SQL in a server environment

Exercise 9

Become familiar with SQL, ODBC, and JDBC function calls

JDBC example

Sample code to run JDBC

HW3: Web App

Program a simple web application

Assignment 3 01 Oct 12:00 AM

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

Practice Armstrong’s axioms, keys, superkeys.

Exercise 12

More practice with Armstrong’s axioms, keys, superkeys.

Exercise 13

Chase test, lossless queries

Module: Constraints, triggers, view, indexes

Exercise 14

Practice use of constraints, triggers, views, indexes

Module: Transaction processing

Exercise 15

Practice use of transactions

22 Nov 09:00 PM

Exercise 16

Practice use of locking

22 Nov 09:00 PM

Module: Storage and indexing

Exercise 17

Practice undesrstanding of disk and memory based storage

29 Nov 09:00 PM

Exercise 18

Practice use of B+ trees, hash indexes, clustering

29 Nov 09:00 PM

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