Dave Sullivan

Defining Methods

SQL: Removing Duplicates; Aggregate Functions

From Python to Java: Converting a Simple Program

Functions in Assembly Language

From Python to Java: Functions / Static Methods

Variable Scope (plus: the Python Tutor Visualizer)

Accessing a Database from Python

Variable Scope in Java

ASCII Codes and the Caesar Cipher

Fundamental Facts About Data

Using Objects; Splitting and Joining Strings

Keys, Candidate Keys, and Primary Keys

From Python to Java: Lists / Arrays, Part I

From Python to Java: for Loops

Writing Your Own Functions (Using Spyder)

Working with Strings and Lists

Python: Built-In Functions and User Input

Reading from a Text File

From Python to Java: Conditional Execution and User Input

Evaluating a Model Learned in Data Mining

Data Mining Fundamentals

2-D Lists

Making Decisions: Conditional Execution

for Loops in Python

The Relational Model

From Python to Java: Primitives, Objects, and References

Working with Text Files; File Writing

Constraints and Null Values

Getting Started with Python (Using Spyder)

Getting Started With Python (using Spyder)

Introduction to Functions (using Spyder)

SQL: Simple SELECT Commands

Classification Learning: Learning a Decision Tree

Python Building Blocks

Capturing Relationships Using Foreign Keys

Functions Calling Functions

From Python to Java: Lists / Arrays, Part II

Making Decisions: Conditional Execution

Program Building Blocks: Variables, Expressions, Statements

Python: A First Look at Lists; the range() Function

References and Mutable Data

Methods for Comparing and Printing Objects

Classification Learning Using 1R

Defining Methods

Using the Stack in Assembly Language

Getting Started with Python (using IDLE)

SQL: Cartesian Product; Joins

Classes: Defining New Types of Objects

Working with Text Files

Getting Started With Python (using IDLE)

Subqueries in SQL