Class Outline: Using the DB API

  1. A Super-Fast Introduction to the Relational Model
       * Everything is in tables
       * The role of the primary key
       * SQL in a Nutshell
  2. The DB API
       * Connections
       * Cursors
       * Exceptions
       * Some API-compliant modules
  3. Connecting to the Database
       * Creating connections
       * Transactions
       * Connection pooling
       * Thread safety
  4. Executing Queries
       * Some representations of queries
       * Building the query string
       * Processing the results
       * Representing results for convenient processing
  5. Handling Updates
       * Inserting new data
       * Deleting old data
       * Updating existing data
  6. Aiming for Portability
       * Different connection arguments
       * Differing paramstyles
       * SQL differences
  7. Putting it All Together
       * Real applications code


6 Member(s) Online Overview Registration Event Calendar Mailing Lists City Map Department Heads Conference Weblog Kiosk Presentations Keynotes Accepted Talks Schedule of Talks Lightning Talks Open Space Talks A/V Recordings Con Activities Tutorial Day Sprinting Days Python Lab Special Meetings Help for Speakers Vendors Travel/Lodging/Food Air Travel Hotel Reservations Ground Transit Food Restaurants Other Stores Points of Interest Help Out Volunteer Sponsor PyCon Spread the Word Items Needed Write Software Past Cons Past Conferences Recordings of Talks 2006 Presentations 2005 Presentations 2004 Presentations PyCon is a 100% Volunteer-run Conference Organized by Members of the Python Community. Site/Questions etc ?	Top / TX2007 / TutorialsAM3outline Edit Page Printable View Page History	About Search Recent Changes to Site PyCon 2007 is sponsored in part by Platinum Gold Silver Media
	Class Outline: Using the DB API 1. A Super-Fast Introduction to the Relational Model * Everything is in tables * The role of the primary key * SQL in a Nutshell 2. The DB API * Connections * Cursors * Exceptions * Some API-compliant modules 3. Connecting to the Database * Creating connections * Transactions * Connection pooling * Thread safety 4. Executing Queries * Some representations of queries * Building the query string * Processing the results * Representing results for convenient processing 5. Handling Updates * Inserting new data * Deleting old data * Updating existing data 6. Aiming for Portability * Different connection arguments * Differing paramstyles * SQL differences 7. Putting it All Together * Real applications code
	Content Last Modified: December 01, 2006, at 07:53 AM Edit Page Printable View Page History