IT 117: Intermediate Scripting
Class 16

Today's Topics

Review


New Material

Reading Assignment

In Chapter 10, Classes and Object-Oriented Programming, from our textbook, Starting Out with Python, you should read sections 10.1 and 10.2, Classes and Object-Oriented Programming and Procedural and Object-Oriented Programming, before next Tuesday's class.

Homework 7

I have posted homework 7 here.

It is due this Sunday, at 11:59 PM.

Quiz 4

I have posted the answers to Quiz 4 here.

Quiz Next Week

There will be a graded quiz next week.

It will cover material from today's class and Class 13.

Announcements

Today we will be discussing how to use Python to access SQLite database.

I am doing this to show you how Python can be used with other sources of information.

In order to do this, I need to discuss some basic use of Structured Query Language (SQL).

This is not a database course, so you will not be required to remember this on the Final Exam.

Review

Reusing Functions with Modules

Importing Modules

Dot Notation with Module Functions

New Material

Python as a Tool

Working with Data

Database Products

SQLite

The SQLite Command Line

Database Structure

Data Checking

Queries

Joins

Views

Changing Data in a Table

Adding a Record to a Table

Changing the Values in a Record

Deleting Records

Using SQLite in Python

Connecting to a SQLite Database

The SQLite Cursor Object

Running a SQLite Query in Python

Adding a Record Using SQLite

Committing Changes to a Table

Changing a Record Using SQLite

Deleting a Record Using SQLite

Writing Python Code to Work with SQLite

A Python Function to Add an Entry to the enrollment Table

Parameter Binding with sqlite3

Attendance

Class Quiz