1. Databases and Python
  2. Database
    1. Relational Databases (SQL)
    2. NoSQL
    3. Types of NoSQL databases
  3. SQLite Database Access
    1. SQLite
    2. Connecting to SQLite database
    3. Connecting to in-memory SQLite database
    4. Create TABLE in SQLite
    5. INSERT data into SQLite database
    6. SELECT data from SQLite database
    7. SELECT aggregate data from SQLite database
    8. SELECT data from SQLite database into dictionaries
    9. UPDATE data in SQLite database
    10. A counter
    11. SQLite in-memory AUTOINCREMENT
    12. SQLite in-memory field with DEFAULT value
    13. SQLite transactions
  4. MySQL
    1. Install MySQL support
    2. Create database user (manually)
    3. Create database (manually)
    4. Create table (manually)
    5. Connect to MySQL
    6. Connect to MySQL and Handle exception
    7. Select data
    8. Select more data
    9. Select all data fetchall
    10. Select some data fetchmany
    11. Select some data WHERE clause
    12. Select into dictionaries
    13. Insert data
    14. Update data
    15. Delete data
    16. Exercise MySQL
    17. Exercise: MySQL Connection
    18. Solution: MySQL Connection
  5. PostgreSQL
    1. PostgreSQL install
    2. PostgreSQL with Docker compose
    3. Python and Postgresql
    4. PostgreSQL connect
    5. PostgreSQL create table
    6. INSERT
    7. INSERT (from command line)
    8. SELECT
    9. DELETE
  6. MongoDB
    1. MongoDB CRUD
    2. Install MongoDB support
    3. MongoDB in Docker compose
    4. Python MongoDB drop database
    5. Python MongoDB insert
    6. MongoDB CLI
    7. Python MongoDB find
    8. Python MongoDB find refine
    9. Python MongoDB update
    10. Python MongoDB remove (delete)
    11. Python MongoDB replace
    12. Python MongoDB upsert
    13. Python Mongodb: TypeError: upsert must be True or False
    14. Python MongoDB Async with motor - connect
    15. Python MongoDB Async with motor - insert and find
  7. Redis
    1. Redis CLI
    2. Redis list keys
    3. Redis set get
    4. Redis incr
    5. Redis incrby
    6. Redis setex
  8. SQLAlchemy
    1. SQLAlchemy hierarchy
    2. SQLAlchemy engine
    3. SQLAlchemy autocommit
    4. SQLAlchemy engine CREATE TABLE
    5. SQLAlchemy engine INSERT
    6. SQLAlchemy engine SELECT
    7. SQLAlchemy engine SELECT all
    8. SQLAlchemy engine SELECT fetchall
    9. SQLAlchemy engine SELECT aggregate
    10. SQLAlchemy engine SELECT IN
    11. SQLAlchemy engine SELECT IN with placeholders
    12. SQLAlchemy engine connection
    13. SQLAlchemy engine transaction
    14. SQLAlchemy engine using context managers
    15. Exercise: Create table
    16. SQLAlchemy Metada
    17. SQLAlchemy types
    18. SQLAlchemy ORM - Object Relational Mapping
    19. SQLAlchemy ORM create
    20. SQLAlchemy ORM schema
    21. SQLAlchemy ORM reflection
    22. SQLAlchemy ORM INSERT after automap
    23. SQLAlchemy ORM INSERT
    24. SQLAlchemy ORM SELECT
    25. SQLAlchemy ORM SELECT cross tables
    26. SQLAlchemy ORM SELECT and INSERT
    27. SQLAlchemy ORM UPDATE
    28. SQLAlchemy ORM logging
    29. Solution: Create table
    30. Exercise: Inspector
    31. SQLAlchemy CREATE and DROP
    32. SQLAlchemy Notes
    33. SQLAlchemy Meta SQLite CREATE
    34. SQLAlchemy Meta Reflection
    35. SQLAlchemy Meta INSERT
    36. SQLAlchemy Meta SELECT