Gettin' CRUD-y With It

Using Databases in Python

Our Diary App

Using Databases in Python

Meet Peewee

Using Databases in Python

Covering Your Bases

Python Testing

Be Assertive!

Python Testing

What Is Testing?

Python Testing

Python Regular Expressions

Regular Expressions in Python

Timezones

Dates and Times in Python (2014)

Dates and Times

Dates and Times in Python (2014)

Python: Inheritance

Object-Oriented Python

Python: Instant Objects

Object-Oriented Python

Python Tuples

Python Collections (2016, retired 2019)

Python Slices

Python Collections (2016, retired 2019)

Build an Application

Introducing Lists

Using Lists

Introducing Lists

Meet Lists

Introducing Lists

Meet Python

Python Basics

All Together Now

Python Basics

Functions and Looping

Python Basics

Types and Branching

Python Basics

Orientation: Selecting Data

SQL Reporting by Example

Subqueries

Querying Relational Databases

Set Operations

Querying Relational Databases

Joining Table Data with SQL

Querying Relational Databases

Table Relationships

Querying Relational Databases

Database Keys

Querying Relational Databases

Database Normalization

Querying Relational Databases

Date and Time Functions

Reporting with SQL

Aggregate and Numeric Functions

Reporting with SQL

Working with Text

Reporting with SQL

Ordering, Limiting and Paging Results

Reporting with SQL

Handling Errors When Manipulating Data

Modifying Data with SQL

Deleting Data from a Database

Modifying Data with SQL

Updating Data in a Database

Modifying Data with SQL

Adding Data to a Database

Modifying Data with SQL

Finding the Data You Want

SQL Basics

Getting Data from a Database

SQL Basics

Data, Databases and SQL

SQL Basics

Python Lists

Python Collections (2016, retired 2019)

Letter Game App

Python Basics (2015)

Number Game App

Python Basics (2015)

Shopping List App

Python Basics (2015)

Logic in Python

Python Basics (2015)

Python For Beginners

Python Basics (2015)

Python Data Types

Python Basics (2015)

Newbie