Course PYT107
Python Database Programming - MySQL, PostgreSQL, SQLite
Python Database Programming - MySQL, PostgreSQL, SQLite
Duration: 3 Days
Synopsis
This course provides an intensive coverage of database programming with Python, including Python programming aspects of developing specialised database driven web sites.
Prerequisites
- Attendees are expected to be experienced Python programmers and to have some familiarity with relational databases and SQL, as well as a basic understanding of XML and HTML, and CGI.
Publicly scheduled dates, locations, and prices
A schedule of dates for this subject is not currently available. Please call Ajay Patel on 02086471939 to enquire about places and availability.
Contents
Overview of Relational Databases and SQL
Overview of lists, strings, tuples and dictionaries
Nested structures - lists of lists, lists of dictionaries, dictionaries of dictionaries
Creating and processing CSV files using Python
Pickling and unpickling
Overview of Object Oriented Python programming
Overview of the Python Database API
- Connection objects
- Cursor objects
- Database query patterns
Python database modules for MySQL, SQLite and PostgreSQL
Queries 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