Data Modelling, Querying SQL, Relational Algebra, Postgresql, Jupyter Notebooks.
I took this class in Fall 2016. Each notebook is an exercise, either on SQL, Relational Algebra, or both. New concepts are presented in each exercise. Concepts include:
-
Querying
-
Data Definition Language
-
Group By and Aggregate Functions
-
Cartesian Product
-
Joins
-
Sets operations
-
Nested statements
Feel free to clone this repository and to explore the notebooks..