Silicon Dojo - Free Technology Education

Classes are for all skill levels. We do a seminar, and then allow students to write their own scripts. There are no grades, so you can do only the work that you want. If you plan to write code please install Python3, VSCode and the Python VSCode extension on your computer.

Programming is about data, the question is how to manage the data. Databases store text data and makes it easy to add, update and find data that you have stored.

SQL (Structured Query Language) is the language used to interact with Relational Databases. It is used by systems such as MySQL, MariaDB, Postgres and SQLite.

SQLIte is a dirt simple Relational Database that gives you the power of SQL with the administrative overhead of a text file. It is fast, easy to use, AND has near no security built in.

We will learn how to add SQLite to our Python projects so that we can add the capability to store and request data easily.

The class will go over:
- Relational Database Basics
- Basic SQLite Management
- SQL Schemas
- Creating Databases and Tables in SQLite
- Select Statements
- Insert Statements
- Update Statements
- Table Joins
- Connecting Python Scripts to SQLite

Practical Work Will Include (Spaghetti Monster help us ;) )
- We will use SQLite to create a few apps that use a database for the backend.

I will do my best to support all students with the practical work. We can do screen share so I can see what you have done and offer advice. This code should be very simple as long as Python3 is working properly on your system.

The meat of the class should be an hour or less. With support/ troubleshooting I'll help until 4:30.