Database Systems 2019/20

Note: Slides may be updated. If so, final versions will be uploaded few hours before each class. (back to course main page)

█ - Tutorial

Week	Date	Slides	Textbook	Notes
1	29/10/2019	Introduction to Database Systems	SQL For Web Nerds, Chapter 3
2	4/11/2019	Introduction to MySQL	TAU Connection Guide
	5/11/2019	SQL Basic SQL Basic (cont.)	Book, Section 6.1-6.2
3	11/11/2019	Introduction to MySQL (cont.)		HW#1 distributed
	12/11/2019	Canceled due to Home Front Command's instructions
4	18/11/2019	Database Programming
	19/11/2019	Advanced SQL	Book, Section 6.3-6.4
5	25/11/2019	Database Programming (cont.)		TAU MySQL Server - user creation guide
	26/11/2019	SQL Schema, Views Constraints and Triggers, Transactions	Book, Section 6.5-6.6 Book, Section 6.7 Book, Section 7 Book, Section 8
6	2/12/2019	Web Development Intoduction
	3/12/2019	Conceptual DB Design E/R Diagrams & Relational Model	Book, Section 2.1-2.4 Book, Section 3.1-33
7	9/12/2019	Web Development (cont.)
	10/12/2019	Functional Dependencies & Relational Decomposition	Book, Section 3.4-3.6	HW#1 due; Project distributed
8	16/12/2019	Final Project + Web services
	17/12/2019	Relational Algebra	Book, 5.1-5.2
9	23/12/2019	Canceled
	24/12/2019	DBMS Internals Storage and Indexing	Book, Section 11 Book, Section 13.1	HW#2 distributed
10	30/12/2019	Functional Dependencies
	31/12/2019	Projects Day (slides)		example server code
11	6/1/2020	SQL Queries - exam question
	7/1/2020	Query Execution	Book, Section 15	HW#2 due
12	13/1/2020	JavaScript (cont.)
	14/1/2020	Query Optimization	Book, Section 13.2-13.3
13	20/1/2020	MySQL Query Optimization
	21/1/2020	Query Optimization	Book, Section 13.2-13.3
	26/1/2020			Project due
	19/2/2020			Exam moed A
	6/4/2020			Exam moed B