Smart Cities (2023) - SQLite3 database
A series of tools for Schools to deliver the Smart Cities, Tiny House Course, which includes Teacher Training, Lesson Plans. This course was originally conceived by Dr Edmond Lascaris
Lesson 1: Introduction
Lesson 2: Authors
Lesson 3: Installation of SQLite3 on Raspberry Pi
Lesson 4: Installing Database Browser software
Lesson 5: Creating a database and table in SQLite3 using DB Browser for SQLite
Lesson 6: Interacting with SQLite Databases using Python
6.1 Python instructions for SQLite
6.2 Creating a SQLite Database using Python
6.2.1 Creating a Table and single Data entry in a SQLite Database using Python
6.2.2 Inserting data into Table using Python