SQL

WHAT IS DATABASE DEVELOPMENT?

What is Database Development?

What is SQL and why should I care about learning it?

Like it or not, Data is everywhere. From your Instagram feed to the supermarket shelves, without data and data management software, it would all fall apart. Databases hold all this data and, in order to manipulate it, we need a language to help us to "talk" to the database. That language is called SQL and it still sits in the top 10 programming languages in the world despite being invented in 1970!

In this course, you'll learn to create and manipulate databases with a mix of SQL and Python.

UNDERSTAND SQL

Grok Academy SQL Tutorial

Another great step by step written tutorial from Grok.

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

Follow the teacher instructions on how to join the class and sign in to track your progress.

Extension learning

SQL- W3 Schools Tutorial

This is a great place to go to learn SQL and doubles as an amazing reference resource when you get stuck. The exercises can be done in the browser and they are really well explained, covering everything you will need in SQL to work with databases.

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.

Task 2 | Test your Knowledge of SQL

SQL- W3 SChools Quiz

What can you get out of 25?

Remember that w3 schools is also a great place to find help if you don't know the answer to a question.

Go through all you can and see how many you can get right.

Extension exercises for fun!

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 left.

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.

HackerRank

HackerRank is a popular platform for competitive programming, coding challenges, and technical interview preparation. It offers a variety of programming challenges across different domains such as algorithms, data structures, artificial intelligence, and more. Users can solve these challenges in various programming languages like Python, Java, C++, SQL, etc. HackerRank also provides a platform for companies to screen and assess technical talent through coding assessments and interviews. It's widely used by developers and companies alike to improve coding skills, prepare for coding interviews, and identify talented individuals.

UNDERSTAND DATABASE DESIGN

Database Design

Entity Relationship Diagrams (ERD for short) is the way you design and refine your database structure. A database can be a lot more than one just one table and we need a way to make sure the data is structured correctly with Primary Keys, Foreign Keys, Relationships, Cardinality and Data Types.

This Video give you a high level overview of these topics and uses Lucid Charts to make the job easier. And a bonus video that helps explain "relationships" in data and between tables in your database if you need a bit more help.

Part 1 of the Lucid Charts Videos

Part 2- Using proper Design

Database Relationships Explained

APPLY YOUR KNOWLEDGE

Task 4 | Database Design Practice- Go to Schoology and open your document there.

Database Design Practice

Connect Python to SQLite

Open your document in Schoology

Task 5 | Intro to SQLite

Complete the Python Database Tutorial

Beginner focussed 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

Add a screenshot to your document on Schoology

Task 6 | Make a Github Repository from VSCode

Learn how to use Git and Github in VSCode

This is an essential software engineering skill. Trusted by more than 4 million developers, github is the best place to keep your code safe. It can be really confusing and some tutorials tell you about branching and merging and forking and pull requests and it just puts the beginners off.

In this tutorial we'll use a simple process called "Master-Commit" where you'll stage, commit and sync changes straight to your main repository. If all goes well, thats all you'll need to do!

Welcome to the world of github!

Add a screenshot to your document on Schoology

Task 7 | Putting it Together

This video explains the task and quickly shows you how to put together all the knowledge that you should already have to complete a simple Python Database application.

This include setting up folders, designing and creating a database, creating a useful main menu and breaking your program up into functions.

Make sure you have working simple example similar to the the one in the tutorial before you attempt the assessment.

Add a link to your github repo to the document on Schoology

Assessment!

Assessment

Now you have to take what you have learned and make simple database application from start to finish on your own.

Make sure you read all the instructions carefully and know exactly what you intend to make before starting this assessment. Your teacher is only allowed to give you very basic feedback now and is not allowed to help you.

This is a test to see if you can work independently and put all your knowledge into practice to make a functional database application using Python and SQL.

Make a copy of the following Document and keep it somewhere safe. This document and your web application will need to handed in for assessment.

You will have several lesson to complete this. Check on the dues date with your teacher and get started.

Task 8 | Develop a Database Assessment- Open your doc on Schoology and get started

L1 Develop a Database Assessment 2025

Extension and Extras

Intro to Flask

Beginner focussed introductory lesson to the Flask Web Framework.

Work through this and make sure you are able to make a basic Flask App using VSCode, Python, Flask and HTML/CSS

By the end of the tutorial you will have made a working Web Application with Python code that serves HTML to your web browser and sends it simple data.

This is a critical first step to understanding how it all goes together to make a data focussed web applications.

Follow along and PLEASE USE HEADPHONES! Google captions don't work very well with Scottish accents...

Page updated

Report abuse