Python for Everybody (Video/PY4E)

We look at Python's reserved words, how we name and use variables, why we choose meaningful (mnemonic) variable names an... Read more

We learn about how we can use Structured Query Language (SQL) to insert (create), read, update, and delete data in a sin... Read more

We learn how to create string variables and extract portions of the data as well as write simple loops to read through t... Read more

In this assignment we make use of the Google GeoCoding API to look up addresses, store the data in a database and then u... Read more

We look at how we construct a loop so that it runs as long as we want it to run. We learn about iteration variables and... Read more

We look at patterns for reading and processing the data in files. We learn how to check for nonexistent files, and how... Read more

Code Walkthrough: Hello World

We take a very brief look at how software communicates across the Internet using TCP/IP.

We look at how to build a connector table to represent many-to-many relationships such as students and courses in databa... Read more

We look at how code flows into and out of functions as well has how we pass information into functions and get results r... Read more

We look at how some of the string parsing we have done in earlier chapters can be easily done with regular expressions.

We write a simple Python program that connects to a web server and retrieves a web document. It is a very simple web b... Read more

The most basic conditional structure is the if statement where we either execute or skip a segment of code based on the ... Read more

We look at how we use various numerical and string operations to compute new information and store the new values in var... Read more

In this section we look at the HTTP protocol that is used to move documents between web servers and web browsers.

We look at how we map a logical database model to a physical database model by adding columns and constraints to model t... Read more

We look at how to reconstruct complete views of the data when data is properly distributed across multiple tables and co... Read more

We write an even simpler Python program to retrieve a web page using the urllib library in Python.

Code Walkthrough: Exercise 2.2

In this segment we learn to pull out data from strings after a regular expression has found a match.