This lesson is perfect to for students learning about using SQL databases. In this lesson the pupils create an SQL database using DB Browser (free software) which helps them understand what tables are, the importance of field names and the data types used in an SQL database. It also introduces them to the concept of primary keys.
Although pupils are not using Python at all in this lesson and are instead using DB Browser it sets them up for the next lesson in the series which does allow them to start interrogating an SQL database using Python. Please note this lesson will NOT teach them how to interrogate an SQL database using Python and it instead teaches them how to set up an external database using DB Browser.
It includes an attractive dyslexia friendly PowerPoint presentation and the teachers lesson plan that includes the answers.
Please note: In order to use this lesson you MUST download and install DB Browser on every computer prior to the lesson. You can download the latest version of DB Browser for free from https://sqlitebrowser.org/
Duration: 1 lesson.
This lesson helps pupils understand the following key skills:
- What is a database
- Fields and records
- Primary key
- Setting up a database using DB Bowser
- SQL data types
- Adding data to a table in DB Browser
- Filtering data in a table in DB Browser
Creating an SQL Database using DB Browser
Digital resources purchased from Nichola Wilkin Ltd. are to be used in the original individual school which purchases the resources only.
Resources may not be shared, distributed or displayed digitally for public view, uploaded to school or borough websites, distributed via email, submitted to file sharing sites or shared with another school or institution, even those within the same academy chain.
For full terms and conditions visit https://www.nicholawilkin.com/terms