Title here
Summary here
Databases and MySQL
What a database is, MySQL in a Docker container with an interface in VS Code, creating tables and queries, and full CRUD operations from Python.
- A Database and Setting Up MySQL: Tables, Keys, Docker and a Driver
- Connecting, a Table and Inserting Data: Connection, CREATE TABLE and INSERT
- Basic SQL: SELECT, WHERE by id and Simple Filtering
- Running a Query from Python: execute, Parameters, commit and fetch
- Updating and Deleting: UPDATE and DELETE by id — from SQL and from Python
- Full CRUD from Python: a Complete db.py Module and Testing All Four Actions