pdf, 1.41 MB
pdf, 1.41 MB
png, 435.02 KB
png, 435.02 KB
zip, 5.07 MB
zip, 5.07 MB
pdf, 133.89 KB
pdf, 133.89 KB
pdf, 234.75 KB
pdf, 234.75 KB

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.

Click Here To See More Of My Great Python Lessons

Get this resource as part of a bundle and save up to 16%

A bundle is a package of resources grouped together to teach a particular topic, or a series of lessons, in one place.

Bundle

Python Programming Lesson Bundle

Take a giant step towards regaining control over your workload and teach Python programming with confidence. These ready to use Python lessons will save you hours of planning by providing you with comprehensive, engaging content you can use in your classes with next to no preparation. This bundle provides attractive dyslexia-friendly PowerPoint presentations, videos to teach key skills and plenty of opportunities for students to practise their Python programming skills. You will also get easy to follow teacher’s guides including ALL THE ANSWERS! These 20 lessons are suitable for teaching pupils about the joys of Python programming, from the very basics to confidently writing and using subprograms and writing to and reading from external files. It even includes a fun interactive computational thinking escape room game to introduce them to the problem-solving skills involved in Python programming. It uses a proven scaffolding technique that empowers pupils to make progress and gain confidence in their programming skills. Lessons: * Getting Started with Input and Output statements * If Statements * More Advanced If Statements * For and While Loops * Strings and Numbers * Random Values * Drawing with the Turtle * Creating Robust Programs * Good Programming Habits * Writing and Using Lists * Writing and Using 2D Lists * Using Subprograms * Recapping Programming Constructs * Recapping Subprograms * Recapping Lists and 2D lists * Recapping Good Programming Practice * Using External Text Files * Creating SQL Databases using DB Browser * Interrogating SQL database using Python * Using Structure Diagrams to Plan Larger Programs The lessons are suitable for newly qualified teachers, non-specialist teachers and experienced computer science teachers who are looking to add a sprinkle of zesty brilliance to their lessons.

£47.00

Reviews

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.