Databases Build step three: the data. Where does your app keep its users and orders? Five lessons on one coffee shop: SQL commands, joining tables, designing the database, connecting Python to it, then NoSQL. Every query runs inside the lesson.
Lessons 0 Overview Four lessons on one coffee shop: the four SQL commands, joining tables, designing the database and normalising it, then connecting Python to it safely. Every query runs on a real SQLite inside the lesson. 1 SQL, CRUD Operations From creating your first table, to inserting, reading, updating, deleting and summarizing data with aggregate functions, on a single table, before relationships between tables enter the picture. 2 SQL, Joins & Relationships How data is split across several tables linked by keys, and how JOIN and subqueries stitch it back together to answer questions no single table can. 3 SQL: Database Design & Normalization How to turn a description of a real domain into sound tables: identify entities and relationships, spot redundancy and anomalies, remove them by normalizing up to the third normal form, and protect the result with constr 4 Python & Databases How a Python program talks to a database: first the direct way (a driver sends SQL and receives rows), then the object way, where a table becomes a class, a row becomes an object, and the library writes the SQL for you. 5 NoSQL: documents and key-value The four NoSQL families and when to pick each, designing documents around how you read, MongoDB by example, Redis for caching, and an honest comparison with SQL. 6 Wrap-up and resources The best outside resources for these lessons, classified by kind and level. All are open to everyone and need no account on any platform. Use the filters to narrow the list.