Objective: To practice the relational model and SQL DDL
- Working with PostgreSQL using DataGrip
Objective: To practice relational algebra.
Objectives: 1. To practice more relational algebra, especially aggregations, joins, and division.
2. To practice SQL queries.
Objective: To practice more SQL queries on Postgres.
Objective: To understand how triggers work in PostgreSQL and to practice writing triggers.
Objectives: 1. To get started with JDBC and demonstrate transaction concurrency control on PostgreSQL
2. To practice Views
Objective: To practice Evaluation Modes, Transactions, Procedures and Functions.
Objective: To practice ER diagrams and transforming them to relational schemas.
Objective: To practice normalization, canonical forms, decomposing relations into BCNF and checking for lossless decompositions.
Objective: To practice operations on static hashing, extendible hashing and B+-tree
Objective: Practice Concurrency Control, Recovery