SQL週刊

This class will cover the basics of SQL. SQL is a widely-used programming language. Large websites like Instagram, Facebook, X (Twitter), Instagram, etc. all use SQL to store data. Most business use databases and SQL to store organizational data as well.

We'll first make sure everyone can download the SQL client we' re using. Then students will follow along as they learn how to query data. The course is very open and questions are encouraged.

Each week we'll cover some basic commands: build tables, insert data into those tables and how to query data from the tables. We'll cover some of the most common commands first and possibly dive into more complex queries if time permits. We'll use a test database, so users will be able to (and in fact encouraged to) delete the entire database and rebuild it from scratch if they want to.

I'll demonstrate each query one at a time, then allow students to replicate the query. And of course, answering any questions along the way.

After this course, students should have a good feel for how to create a database, edit it and build simple queries in a SQL database.