Many of the apps you will contribute to this year will involve managing data.
A key skill is understanding how to query a relational database, and that means using structured query language, or SQL.
In the spirit of learning by doing, we will use the SQL Bolt website to review SQL concepts:
Each lesson will introduce a different concept and end with an interactive exercise. Go at your pace and don’t be afraid to spend time experimenting with the exercises before continuing! If you happen to be familiar with SQL already, you can skip ahead using the links in the top-right, but we would recommend you work through the lessons anyways!
Please take full screen screenshots using the Command-Control-Shift-3 keyboard shortcut showing that you completed each set of exercises – add these into your portfolio post for today’s class. For example:
.png)
Exercises
TIP
Solutions are provided on the SQL Bolt website. Use this as an assessment as learning, where you reflect on your results and identify next steps for improvement.
The goal is to learn – Mr. Gordon is here to help – please take full-screen screenshots and add these to your portfolio simply to demonstrate your engagement with the exercise.
Day 1
Aim to complete exercises up to, at least, the SQL Review on Simple SELECT Queries:
Day 2
Aim to complete exercises 6, 7, and 8, focusing on joining tables:
Day 3
Aim to complete exercises 9, 10, and 11, focusing on using aggregate functions:
