SQL Workshop

Prerequisite

Please take the following online course before the SQL workshop. (You will need to install DB Browser for SQLite for this online course.)
- Learning SQL Programming by Scott Simpson (1h 27m) (login from here using UTORid for free access).
During the workshop, we will practise SQL together using Google Colab, so please make sure you have a Google account.

Slides

Intro to SQL (sql_bootcamp.pdf); Please print out page 8 of the slides (the “Northwind DB” page) so you can refer to it easily when we start hands-on exercises.

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.

Install DB Browser for SQLite. You should already have it installed if you took the online course by Scott Simpson (see Prerequisite above).
Download the dataset (northwind.sqlite3).
Load the dataset in DB Browser for SQLite, and follow along using the html version of the notebook.

SQL Setup for RSM8411 (MMA, Fall 2020)

You will learn more SQL in RSM8411 this fall. Instead of SQLite as we use in this workshop, RSM8411 will use Microsoft SQL Server Express. 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 Microsoft SQL Server Express, a mini-versin of MS SQL Server (important: download the Express version).
Download and install SQL Server Management Studio (SSMS), A GUI management client for MS SQL Server.
Test the installation (I will walk you through this step in the workshop).
- Download and restore the Northwind Database. You can find the instruction on how to restore a database from a back file here (either answer 1 or 2).
- Execute a few SQL statements.
Getting-stated resources: Querying Microsoft SQL Server 2019 (login from here using UTORid for free access).

In addition, to be well prepared for RSM8411, please go through this SQL tutorial at w3schools. The tutorial provides a good review of SQL syntax.

Back to TDMDAL Computing Page