Resources Education Jobs Schools directory News Magazine Courses Log out Help
Home feed
My list
Courses My Jobs Job alerts My CV Career preferences Resources Author dashboard
Settings
Edit account Log out
Home Resources Jobs Schools directory News Magazine Courses Register for free Log in Help

Home feed Edit account About us My products Tes for schools Work for Tes Log out
Creating an SQL Database using DB Browser

Creating an SQL Database using DB Browser

Subject: Computing

Age range: 14-16

Resource type: Lesson (complete)

Last updated

27 February 2024

pdf, 1.69 MB
pdf, 1.69 MB
zip, 3.93 MB
zip, 3.93 MB
png, 487.83 KB
png, 487.83 KB
png, 601.48 KB
png, 601.48 KB

This lesson is perfect to for students learning how to create their own SQL databases using DB Browser and SQLite.

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 (available from here) 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 create an external database using DB Browser.

Download this no-prep lesson now to help you take control of your workload.
This teaching resource includes an attractive dyslexia friendly PowerPoint presentation and the teachers lesson plan that includes the answers.

This ready-to-use lesson is perfect for non-specialist teachers, newly qualified teachers and teachers who are teaching Python for the first time.

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 teaches pupils about:
What is a database

  • Tables
  • 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
    .

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.

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 progress and save you preparation time.

** [Click Here To See More Of My Great Python Lessons] (https://www.tes.com/resources/search/?authorId=835903&q=Python Lessons&shop=nwilkin)**

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.

£3.50
(no rating)0 reviews

Not quite what you were looking for?Search by keyword to find the right resource: