Try this simple SQL game to test your skills. Use SQL to solve the puzzles. The game is in German, so use the menu to change language to English. The option is shown in the pic to the above.
This is challenging SQL Murder Mystery game to really challenge your skills. Use SQL to solve the murder. Don't forget to check out the ERD (Entity Relationship Diagram) so you can work out the proper queries to solve the puzzle.
Beginner focused intro lesson for using SQL with Python.
Work through this to understand how to query your sqlite database file with Python and output the results of the queries.
In this tutorial you will:
Create a table in SQLite Studio with the correct data types
Enter data into the database with SQLite Studio
Write and test SQL Queries on your data
Write Python Code to interface with your database and output the data
Teachers:
You may want to get your kids to hand this in or check the progress at this stage. It's critical for moving on. Students who did Techquity Level 1 may have already completed this.
Try it out in your own project