Databases and SQL with Python

Course content

1. 1Why databasesComing
2. 2The relational modelComing
3. 3Writing SELECT queriesComing
4. 4Filtering, sorting and groupingComing
5. 5JoinsComing
6. 6Designing tables and keysComing
7. 7NormalizationComing
8. 8Changing data safely and transactionsComing
9. 9Using SQLite and PostgreSQL from PythonComing
10. 10Object-relational mappingComing
11. 11Indexes and query performanceComing
12. 12Capstone: a database-backed applicationComing

Requirements

• PYTH-102 Python Programming II: Functions, Modules and Objects

Recommended background. You can start any course at any time.

Description

Designing relational databases, writing SQL and using databases from Python with drivers and an ORM.

Part of the Information Technology stream, typically taken in year 2.