This lesson is perfect to for students learning about using SQL databases. In this lesson the pupils interrogate an SQL database using Python. They use the SELECT statements to fetch specific data from a flat file DB Browser SQL database.
It is important that pupils are familiar with using and creating databases in DB Browser and we STRONGLY RECOMMEND that this lesson is used in conjunction with the previous lesson in this series (Creating an SQL Database - https://www.nicholawilkin.com/product-page/creating-an-sql-database-using-db-browser) . It is also imperative that pupils have DB Browser installed on every computer prior to the lesson starting which can be downloaded for free from https://sqlitebrowser.org/.
This lesson includes an attractive dyslexia friendly PowerPoint presentation and the teachers lesson plan that includes the answers. It also includes 2 databases that are already populated with data for the pupils to interrogate and it includes a mini project which involves the pupils creating a single table database and interrogating it using Python.
Duration: 1 lesson.
This lesson helps pupils understand the following key skills:
- Filtering a database in DB Browser
- Identifying fields and file properties in a database
- Using Python to link to an SQL database
- SELECT …
- FROM …
- WHERE …
Interrogating an SQL Database using Python
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