This was a short introduction on using python with SQL databases that I delivered to a group of visiting researchers.

Slides : python-databases.pdf

Code: https://github.com/vkvn/python-databases

Outline

• Python modules for working with databases
  • SQLite
  • pyodbc
• Client software
• Create and connect to a database
• Create a table
• Inserting a row
• Inserting multiple rows
• Retrieving data
• Updating data
• Example using pyodbc