SQL Workshop

SQL is a data query and management language for relational databases. A solid knowledge of SQL is a must for big data analytics at the enterprise level. In this workshop, you will learn the basics of SQL and relational databases. You will also get hands-on exercises to write simple SQL queries against a mini-SQLite database.

---

Slides

• Intro to SQL (sql_bta.pdf)

Notebook

• SQL Intro Notebook

---

Free Learning Resources

• SQL Intro Notebook (Full Version)

• Learning SQL Programming by Scott Simpson on LinkedIn Learning (1h 27m).

  Note that LinkedIn Learning is not free for UofT students. However, one of the following options can get you free access to this course.

  • Apply for a free Toronto Public Library card, and login LinkedIn Learning via the library site. (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 from 8/20/2021 to 12/15/2021.

• SQL for Data Analysis at Udacity

• SQLite Tutorial

• SQL Tutorial

---

Back to TDMDAL Computing Page