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