SQL Workshop

Prerequisite

  1. Please complete the following LinkedIn Learning online course before the SQL workshop. (Note that you will need to install DB Browser for SQLite for this online course.)

    Use one of the following options to get free access to LinkedIn Learning.

    • Register a free 1-month trial account and take the course.
    • Apply for a free Toronto Public Library card, and login LinkedIn Learning via the library site. (Note that you can get Toronto Public Library’s Digital Access Card without visiting a library branch.)
    • If you are a UofT graduate, you could register here at UofT alumni site to get free access to LinkedIn Learning until 8/16/2023.

  2. During the workshop, we will practise SQL together using Google Colab, so please make sure you have a Google account. If you don’t have access to Google service, see section Backup Setup below.

Slides

Notebook

  • SQL Intro Notebook

  • The full Notebook (all questions solved) in HTML format has been posted on Quercus. It’s not in notebook format so you cannot simply load it to Google Colab and hit run all. Use it as a reference and build your SQL Bootcamp Notebook on your own.

Backup Setup

If you don’t have access to Google service, below is a backup setup for the workshop.

  1. Install DB Browser for SQLite. You should already have it installed if you took the online course by Scott Simpson (see Prerequisite above).

  2. Download the dataset (northwind.sqlite3).

  3. Load the dataset in DB Browser for SQLite, and follow along using the html version of the notebook.

SQL Setup for RSM8411 (MMA, Fall 2023)

You will learn more SQL in RSM8411 this fall. Instead of SQLite as we use in this workshop, RSM8411 will use PostgreSQL, a powerful open-source DBMS. Please make sure you have it installed and tested before the end of this workshop. If you encounter any problem setting it up, please let me know.

  • Download and install the latest version of PostgreSQL. You can follow the installation guide from this PostgreSQL Tutorial site: Windows installation or MacOS installation. Note that

    • The guide is for an earlier version of PostgreSQL, but the procedures are similar for the latest version.
    • PostgreSQL management client pgAdmin is included in the installation.
    • You do NOT need to install the component “Stack Builder”.
    • After the installation, you should verify that everything is installed correctly. Follow the “Verify the Installation” step in the Windows installation guide or the “Load the sample database” step in the MacOS installation guide.

  • Getting-started resources: PostgreSQL Essential Training. (To access this LinkedIn course for free, refer to information in the Prerequisite section.)

Back to TDMDAL Computing Page