From the course: Learning SQL Programming

Exercise files - SQL Tutorial

From the course: Learning SQL Programming

Start my 1-month free trial

Exercise files

“

- [Instructor] The exercise files for this course, the sample data that we'll be working with as we learn SQL, are available through GitHub to anyone watching the course. The files are divided into a few folders and I want to take a moment to explain those before we explore the data and the software I'll be using in this course. Here I've downloaded and unzipped the exercise files. You could also download individual files from GitHub, if you don't need all of them. As I mentioned, the exercise files are divided into three folders, one called SQLite, one called other DPMS, and one called Notes. The SQLite folder contains the file that I'll be working with in the course, and it's the one that I recommend you use as well. The other DBMS folder contains the same data, but in a format that can be imported into software like Microsoft SQL Server or into other database management systems. You could use those if you're not able to use the software that I'll be demonstrating with in the course. And the Notes folder contains a text document with all the commands I use in the course for your reference. You'll be able to open this file in any plain text editor or you can view it on GitHub. It can also be helpful to keep notes as you go along. If you plan to do so, I recommend Visual Studio Code for Mac, Windows, or Linux, or you can use the plain text mode of your system's text editor. The database that the course uses, which is called Quiz Data, includes two tables, one called People and one called States. The People table contain some information about a thousand people in the US who participated in a fictional quiz competition. We have their scores, what team they signed up to be part of, an ID number, whether they chose to get a shirt or a hat for participating in the competition, and some other information. The States table includes abbreviations and full names of states in the US, and information about what census region and division each state is part of. Throughout the course, we'll use this information in different ways to explore how SQL works.

Contents