1. 1. Databases and Python
2. 2. Database
3. 1. 2.1. Relational Databases (SQL)
   2. 2.2. NoSQL
   3. 2.3. Types of NoSQL databases
4. 3. SQLite Database Access
5. 1. 3.1. SQLite
   2. 3.2. Connecting to SQLite database
   3. 3.3. Connecting to in-memory SQLite database
   4. 3.4. Create TABLE in SQLite
   5. 3.5. INSERT data into SQLite database
   6. 3.6. SELECT data from SQLite database
   7. 3.7. SELECT aggregate data from SQLite database
   8. 3.8. SELECT data from SQLite database into dictionaries
   9. 3.9. UPDATE data in SQLite database
   10. 3.10. A counter
   11. 3.11. SQLite in-memory AUTOINCREMENT
   12. 3.12. SQLite in-memory field with DEFAULT value
   13. 3.13. SQLite transactions
6. 4. MySQL
7. 1. 4.1. Install MySQL support
   2. 4.2. Create database user (manually)
   3. 4.3. Create database (manually)
   4. 4.4. Create table (manually)
   5. 4.5. Connect to MySQL
   6. 4.6. Connect to MySQL and Handle exception
   7. 4.7. Select data
   8. 4.8. Select more data
   9. 4.9. Select all data fetchall
   10. 4.10. Select some data fetchmany
   11. 4.11. Select some data WHERE clause
   12. 4.12. Select into dictionaries
   13. 4.13. Insert data
   14. 4.14. Update data
   15. 4.15. Delete data
   16. 4.16. Exercise MySQL
   17. 4.17. Exercise: MySQL Connection
   18. 4.18. Solution: MySQL Connection
8. 5. PostgreSQL
9. 1. 5.1. PostgreSQL install
   2. 5.2. PostgreSQL with Docker compose
   3. 5.3. Python and Postgresql
   4. 5.4. PostgreSQL connect
   5. 5.5. PostgreSQL create table
   6. 5.6. INSERT
   7. 5.7. INSERT (from command line)
   8. 5.8. SELECT
   9. 5.9. DELETE