Skip to content
🔑 Data Modelling, Querying SQL, Relational Algebra, Postgresql, Jupyter Notebooks 📰
Jupyter Notebook
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
AggregatePractice.ipynb
CountryQuestions-SQL.ipynb
GroupbyPractice.ipynb
MovieQueries.ipynb
NestedSets.ipynb
README.md
RegistrationDDL.ipynb
joins1.ipynb
moremovies.ipynb

README.md

🔑 Data Modelling and Querying - CS140 📰

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..

You can’t perform that action at this time.