Database Programming with Python

Course Curriculum

Chapter 1: Introduction to Python, Databases, and Tools

Lecture 1: Introduction

Lecture 2: The Importance of Data

Lecture 3: Introduction to Python

Lecture 4: What can I do with Python?

Lecture 5: Introduction to Databases

Lecture 6: Database and RDBMS Options

Lecture 7: SQLite and SQLite Studio

Lecture 8: MySQL and PhpMyAdmin

Lecture 9: SQL Server and Management Studio

Lecture 10: ODBC, DB API, and pyodbc

Lecture 11: Installing the Tools for this Course

Lecture 12: Installing Python

Lecture 13: Installing Eclipse

Lecture 14: Installing PyDev

Lecture 15: Installing the pyodbc Module

Lecture 16: Installing the MySQL Driver

Lecture 17: Installing the Microsoft ODBC Driver

Chapter 2: Creating Databases and Tables

Lecture 1: Introduction

Lecture 2: Introduction to Relational Data

Lecture 3: Planning and Designing a Database

Lecture 4: Tables, Records, and Columns

Lecture 5: Assigning Data Types

Lecture 6: Normalization

Lecture 7: Keys and Relationships

Lecture 8: An Overview of the Vecta Corp. Help Desk Database Structure

Lecture 9: The Employees Table

Lecture 10: The Roles Table

Lecture 11: The Tickets Table

Lecture 12: The Solutions Table

Lecture 13: The Status Table

Lecture 14: Lab 1a: Creating the Database and Tables in SQLite

Lecture 15: Lab 1b: Creating the Database and Tables in SQL Server

Lecture 16: Lab 1c: Creating the Database and Tables in MySQL

Lecture 17: Lab 2a: Establishing the Relationships in SQLite

Lecture 18: Lab 2b: Establishing the Relationships in SQL Server

Lecture 19: Lab 2c: Establishing the Relationships in MySQL

Lecture 20: Lab 3a: Manually Adding Data to the Tables in SQLite

Lecture 21: Lab 3b: Manually Adding Data to the Tables in SQL Server

Lecture 22: Lab 3c: Manually Adding Data to the Tables in MySQL

Chapter 3: Introduction to SQL

Lecture 1: Introduction

Lecture 2: Introduction to the Structured Query Language (SQL)

Lecture 3: The SELECT Command

Lecture 4: Filtering and Ordering Data with Clauses

Lecture 5: Operators for Advanced Querying

Lecture 6: The INSERT INTO Command

Lecture 7: The UPDATE Command

Lecture 8: The DELETE Command

Lecture 9: SQL Expressions and Aliases

Lecture 10: Common SQL Functions

Lecture 11: Joining Related Tables

Chapter 4: Python and Relational Databases

Lecture 1: Lecture Introduction

Lecture 2: Setting Up and Importing the Required Modules

Lecture 3: Connecting to a SQLite Database

Lecture 4: Connecting to a MySQL Database

Lecture 5: Connecting to a SQL Server Database

Lecture 6: How to Execute SELECT Statements

Lecture 7: How to Get the Rows in a Result Set

Lecture 8: How to Get Data from a Database View

Lecture 9: How to Insert Data into a Database

Lecture 10: How to Update Data in a Database

Lecture 11: How to Delete Data from a Database

Lecture 12: How to Handle Database Exceptions

Chapter 5: Project

Lecture 1: Lecture Introduction

Lecture 2: Setting Up the Administrative Dashboard

Lecture 3: Creating the Database Layer

Lecture 4: Creating the Object Layer

Lecture 5: Creating the User Interface (UI) Layer

Lecture 6: Lab 1: On Your Own! Displaying the User Role

Lecture 7: Lab 2: On Your Own! Logging In the Admin

Lecture 8: Setting Up the Help Desk Dashboard

Lecture 9: Creating the Object Layer

Lecture 10: Creating the Database Layer

Lecture 11: Creating the User Interface (UI) Layer

Lecture 12: Lab 3: On Your Own! Getting Employees When Adding Tickets