Python and Database Programming (MySQL, SQLite, PostgreSQL)

Overview of Relational Databases and SQL Overview of lists, strings, tuples and dictionariesNested structures - lists of lists, lists of dictionaries, dictionaries of dictionariesCreating and processing CSV files using PythonPickling and unpicklingOverview of Object Oriented Python programmingOverview of the Python Database API

• Connection objects
• Cursor objects
• Database query patterns

Python database modules for MySQL, SQLite and PostgreSQLQueries in greater depth

• SQL query strings with placeholders
• Exception handling
• Fetching results a row at a time vs. fetching results all at once
• Transaction processing - commits and rollbacks
• Creating web forms for generating and processing database queries
• Working with stored procedures
• Handling images and text files

Formatting query result data

• Formatting query results as HTML tables
• Formatting query results as XML
• Object Relational Modeling and data persistence

Overview of Object Relational Modelling and data persistence