The following exercises are based on some real project data and are designed to give more practice with SQL statements, especially SELECT queries, following on from the SQL Introduction tutorial.
Prerequisites
Input data may be downloaded here
The following exercises are based on some real project data and are designed to give more practice with SQL statements, especially SELECT queries, following on from the SQL Introduction tutorial.
Prerequisites
Input data may be downloaded here
| Setup | Download files required for the lesson | |
| 00:00 | 1. Introduction | |
| 00:10 | 2. Exercise 1 - Database initialisation | |
| 01:10 | 3. Exercise 2 - Data queries | |
| 03:10 | 4. Exercise 3 - R or Python interaction | |
| 05:10 | Finish |
The actual schedule may vary slightly depending on the topics and exercises chosen by the instructor.