|
Setup |
Download files required for the lesson |
00:00 |
1. Introduction to SQL
|
What is SQL?
Why is it significant?
What is the relationship between a relational database and SQL?
|
00:15 |
2. Selecting and sorting data
|
What is a query?
How do you query databases using SQL?
How do you retrieve unique values in SQL?
How do you sort results in SQL?
|
00:35 |
3. Filtering
|
How can I filter data?
|
01:05 |
4. Ordering and commenting
|
What is the order of execution in SQL queries?
How can you organize and comment more complex SQL queries?
|
01:20 |
5. Aggregating & calculating values
|
How can we aggregate values in SQL for reports?
Can SQL be used to make calculations?
|
01:40 |
6. Joins and aliases
|
How do I join two tables if they share a common point of information?
How can I use aliases to improve my queries?
|
02:25 |
7. Saving queries
|
How can I save a query for future use?
How can I remove a saved query?
|
02:55 |
8. Database design
|
What is database design?
|
03:40 |
9. Creating tables and modifying data
|
How can I create, modify, and delete tables and data?
|
04:05 |
10. Other database tools
|
Are there other database tools that I can use besides DB Browser and SqliteOnline?
|
04:10 |
11. Extra challenges (optional)
|
Are there extra challenges to practice translating plain English queries to SQL queries?
|
04:45 |
12. Good Style
|
What is good SQL Style, and how can I abide by SQL conventions?
|
04:55 |
Finish |
|
The actual schedule may vary slightly depending on the topics and exercises chosen by the instructor.