Summary and Setup

This is a lesson about accessing relational databases with the Python programming language.

Learning Objectives

By the end of this lesson, learners will be able to…

  • Explain the basic concepts of relational databases
  • Establish a connection between a Python script and a relational database
  • Perform basic CRUD (Create, Read, Update, Delete) operations using SQL queries
  • Use parameterised SQL queries to separate SQL logic/commands from user-supplied data
  • Retrieve and process query results using Python data structures
  • Handle database errors and exceptions
Prerequisite

To follow this lesson, learners should already be able to…

  • Write and execute short scripts in Python.
  • Define and document functions.
  • Execute commands in the shell.

FIXME: Setup instructions live in this document. Please specify the tools and the data sets the Learner needs to have installed.

Data Sets

Download the data zip file and unzip it to your Desktop

Software Setup

Discussion

Details

Setup for different systems can be presented in dropdown menus via a spoiler tag. They will join to this discussion block, so you can give a general overview of the software used in this lesson here and fill out the individual operating systems (and potentially add more, e.g. online setup) in the solutions blocks.

Use PuTTY

Use Terminal.app

Use Terminal