12DTP- Database Refresher

Database Refresher: Do you know Databases?

Task #1: Do you know SQL?

W3Schools Quiz

Take the quiz and see how you go.

SQL Island

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.

SQL Murder Mystery

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.

Need a refresher?

Pick one of these tutorials and complete it.

Grok Academy: SQL

Another great step by step written tutorial from Grok.

This contains expanations, in-browser code practice, quizzes and challenges.

This is free for all students in NZ and, better still, teachers can create classess and track their students progress through their own dashboard.

Or

Khan Academy SQL Tutorial

This is a great free course teaching you all you need to know about SQL in a real practical way. You get short videos and exercises and several challenges to help you nail down the concepts. Well worth running through the SQL Basics section.

Database Design: Need a refresher on ERD's?

Watch these videos

Data design and "common sense" data normalization is a huge topic. These two videos explain it fairly well and show you how to design an "Entity Relationship Diagram" easily in Lucid Charts (part of google docs). This will be important to ensure 'data integrity'.

Some of this stuff is a bit hard to get your head around right now. But watch it all the same. You will have the chance to put it in practice in task 4.

Using proper Design

Database Relationships Explained

A Complete the Python Database Tutorial

Intro to SQLite

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.

Extension and Extras

W3 Schools

This is an indespensible reference for everything you'll need. It includes reference and tutorials for Python, SQL, HTML and CSS.

Using an IDE

VSCode is a lightweight cross platform tool to write HTML and CSS. Take a look at how it can help you be more productive at this link.

Using Github with VSCode

This takes practics and you will probably mess up a few times but it's worth it. Become a real developer and join the other 100 Million developer who rely on this to keep their code safe.

Grid Layout Explanation

Try it out in your own project

Page updated

Report abuse