Textbook and course material, for the Introduction to SQL course, taught by Daniel Fryer.
This repository includes slides for the full 4-day course.
There is also a 2-day course. If you are attending the 2-day course, we won't cover all of the 4-day material, but you still get access to all of it.
For this course, you'll need a way to write and run SQL commands. The best option is to install Visual Studio Code (VS Code) — a free, beginner-friendly code editor that's widely used across the industry. It supports SQL (and many other languages) and makes writing code enjoyable and efficient. 👉 Download Visual Studio Code
To actually run your SQL commands, you'll also need a database server installed on your computer. If you're using a work computer, you might not have permission to install software. In that case, I'll provide access to a remote database during the course — but the experience will not be as smooth.
If possible, install your own DBMS following one of the guides below.
There are two SQL variants we'll use in this course — T-SQL and MySQL. They're nearly identical for our purposes, so you can choose whichever is easier to set up:
- 💻 Windows users: Set up T-SQL (Microsoft SQL Server) This is usually the easiest option on Windows.
- 🍎 macOS users: Set up MySQL This is usually the easiest option on Mac.
Please don't leave setup until the last minute — installation and configuration can take time, especially if you run into permission issues. If you hit any snags, reach out for help early — I'm happy to assist!
- You'll have the best experience using a personal computer (with administrator access). Some students have had difficulties getting everything working on locked-down work devices.
- The setup guides linked above will walk you through everything step by step.
The textbook and slides are linked below.