Labs


Slides and other material for CS460 labs.


Lab 1

In our first lab we executed some basic SQL queries.

Readings

Tap to view queries
DDL


Lab 2

In our second lab we drew an ER model.

Readings

Tap to view slides
Tap to view exercise
Tap to view solution


Lab 3

In the third lab we discussed the first programming assignment.

Readings

Virtual Box instructions
DBeaver and Terminal guide


Lab 4

In the fourth lab we discussed the solutions for the first written assignment.

Readings

Written assignment 1 solutions


Lab 5

In the fifth lab we demonstrated how to connect MySQL with Java. We also solved an SQL exercise.

Readings

SQL and Java
Java code example
SQL exercise


Lab 6

In the sixth lab we solved exercises in B-trees, storage and external sorting.

Readings

Storage
B-trees
External sorting
WA2 Solutions


Revision Exercises

Exercises and solutions from External Sorting, Query Processing, Query Optimization, Transactions and Concurrency Control.

Readings

Exercises


Lab 9

In the ninth lab we solved one exercise on recovery based on the ARIES algorithm from IBM.

Readings

Exercise