Python for Beginners: Introduction to Databases and SQLite3


Although this course is primarily aimed at KS3, it is equally suitable for those in KS4, with no previous programming experience. Learn the rewarding and useful skill of coding in a fun and interactive way.

Created By

Dawn H

Beginner
Exercise

5 HOURS

5 LESSONS

Python for Beginners: Introduction to Databases and SQLite3

academic-development

Course Overview



This course is designed to introduce the concepts of coding in a fun and interactive way. Each lesson will be split between learning a new concept and trying out that concept with age-appropriate exercises to stretch and challenge. On this course, we will be looking at how we can create a database using SQLite3 and Python. This is primarily a Key Stage 3 course; however, it would be beneficial for those new to coding in Python Key Stage 4 with no prior exposure to 3GL programming languages. It is advised that during this course, you commit to at least two additional hours of coding between each lesson to ensure that you get the most out of the time in the lesson.

Course Content



5 LESSONS

5 HOURS Total Length

Lesson 1

Introduction to Databases and How Databases Work

60 minutes

Lesson 2

Introduction to SQLite3 Within the Python Environment

60 minutes

Lesson 3

Creating a Database

60 minutes

Lesson 4

Storing Data in a Database

60 minutes

Lesson 5

Reading Data from a Database

60 minutes

Key Skills


Critical Thinking

Defining Variables

Casting Variables

Mathematical Equations

Educator


Dawn H

Computing Expert

With 25 years of experience and a PGCE, Dawn teaches all Computer Science and ICT topics, including programming and coding.