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.
Download this ready to use lesson now and take control of your workload.
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). It is also essential 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 …
.
What are you waiting for? Take action straight away and grab your copy of this wonderful lesson today that will keep your pupils engaged and making real progress. Everything is done for you which will save you hours of preparation time.
FREE BONUS PRODUCT INCLUDED
As a special thank you for purchasing this product I am pleased to be able to also include a surprise FREE bonus gift. This gift is one of our complete resources which we will usually charge full price for but is yours absolutely free when you purchase this product. Just our little way of saying thank you to our valued customers. I hope you enjoy it and get use out of it, with my compliments.
Something went wrong, please try again later.
This resource hasn't been reviewed yet
To ensure quality for our reviews, only customers who have purchased this resource can review it
Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.