56. 16.3 Processing Mail Data

No release date yet

We end where we started, processing email data. Except that this time it is a lot (nearly 1GB) of email data.

55. 16.2 Building a Web Search Engine

No release date yet

We build a web crawler that retrieves web pages and links from those pages an copies the pages into the database. Once we have retrieved our web data we run a simple Page Rank algorithm on the data and visualize the results.

54. 16.1 Visualizing Map Data

No release date yet

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

53. 15.7 Many-to-Many Relationships

No release date yet

We look at how to build a connector table to represent many-to-many relationships such as students and courses in database tables. We also learn about composite primary keys.

52. 15.6 Multi-Table Retrieval using JOIN

No release date yet

We look at how to reconstruct complete views of the data when data is properly distributed across multiple tables and connected via foreign keys. We learn the JOIN operation and ON clause in SQL.

51. 15.5 Representing Relationships in Database Tables

No release date yet

We look at how we map a logical database model to a physical database model by adding columns and constraints to model the table-to-table relationships.

50. 15.4 Database Key Types

No release date yet

We look at primary keys, logical keys and foreign keys. We look at how foreign keys are represented in the database.

49. 15.3 Building a Relational Model

No release date yet

We look at how we can take the various data elements that will be modeled in an application and distribute them across several tables efficiently. We learn about the basic rules of database design.

48. 15.2 Single Table SQL

No release date yet

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

47. 15.1 Relational Databases

No release date yet

We look at the history of database systems, learn the terminology of database systems, and review some of the common database systems that are in use.

46. 14.4 Object Inheritance

No release date yet

We look at how we can make a new class by inheriting all of the attributes and methods of a parent class and then extend the new class with additional attributes and methods.

45. 14.3 Object Life Cycle

No release date yet

We look at how we as the developers of a Python class can interact with the moment of construction and destruction of various objects created using the class.

44. 14.2 Our First Class and Object

No release date yet

We look at how use create a new class in Python and then construct a new object from that class. We also look at some of the Python objects (like strings) that we have been using all along.

43. 14.1 Object Oriented Definitions and Terminology

No release date yet

We look at how Python mentions objects in its documentation as well as talk about why philosophy of object-oriented programming. We explore some OOP terms like class, object, instance, method, and attribute.

42. 13.7 Securing API Requests

No release date yet

We explore the use of OAuth to communicate sign requests to establish identity when using the Twitter API.

41. 13.6 Using Application Programming Interfaces

No release date yet

We explore using a Google API that can be used to query location data and parse the JSON that is returned.

40. 13.5 Service Oriented Approach (SOA)

No release date yet

We talk briefly about how applications can be built over time to depend on services provide other applications.

39. 13.4 JavaScript Object Notation

No release date yet

We learn about the popular JSON data format and how to handle the JSON data in Python.

38. 13.3 XML Schema

No release date yet

We look at how we can use XML Schema to determine whether or not a particular bit of XML is valid.

37. 13.2 eXtensible Markup Language (XML)

No release date yet

We look at how data is represented using the XML format.

36. 13.1 Data on the Web

No release date yet

We look at two different ways to format data for transmission across the network including JavaScript Object Notation (JSON) and eXtended Markup Language (XML).

35. 12.6 Parsing Web Pages

No release date yet

Now we will look at the HypertextMarkup Language (HTML) that we retrieved using Python and extract links from that HTML. We are slowly building a very simple web search engine.

34. 12.5 Retrieving Web Pages

No release date yet

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

33. 12.4 Unicode Characters and Strings

No release date yet

We explore how characters are encoded when they are transported across the network.

32. 12.3 Building a Web Browser in Python

No release date yet

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

31. 12.2 Hypertext Transport Protocol (HTTP)

No release date yet

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

30. 12.1 Network Technology (TCP/IP)

No release date yet

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

29. 11.3 String Parsing with Regular Expressions

No release date yet

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

28. 11.2 Matching and Extracting Data

No release date yet

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

27. 11.1 Introduction to Regular Expressions

No release date yet

We look at the syntax of regular expressions and how to use them to search through text data.

26. 10.2 Sorting Data

No release date yet

We look at how we sort lists, dictionaries, and lists of tuples in Python.

25. 10.1 Understanding Tuples

No release date yet

We look at the basic syntax and capabilities of Python tuples. We explore the concept of immutability, and we compare tuples to lists and strings.

24. 9.3 Counting Words in Text

No release date yet

In this segment we bring everything together, reading a file, parsing the lines, and computing the frequencies of the words in the file. This is an important moment that pulls from everything we have learned so far.

23. 9.2 Building Histograms

No release date yet

We look at how we can use dictionaries to count the frequencies of many things at the same time. We learn how the key and value are related in a dictionary and example the get method to retrieve values from a Python dictionary.

22. 9.1 Python Dictionaries

No release date yet

We compare and contrast how Python lists and dictionaries are structured internally. How we use position to index lists and use keys to index dictionaries.

21. 8.3 Strings and Lists

No release date yet

We learn how to parse strings pull sub-strings out of a string using the split() function.

20. 8.2 Manipulating Lists

No release date yet

We learn about list slicing, list searching, and using pre-defined functions with lists.

19. 8.1 Creating and Using Lists

No release date yet

We learn how to put data into lists, take data out of the list and write simple loops to examine the elements of a list.

18. 7.2 Processing Data in Files

No release date yet

We look at patterns for reading and processing the data in files. We learn how to check for nonexistent files, and how we process each line within the file.

17. 7.1 Reading Files

No release date yet

We look at how text and lines are represented in files, how we open a file and write a loop to read through all the lines in the file.

16. 6.2 String Operations

No release date yet

We learn how to extract substrings using slicing, and use the string library to perform common data extraction operations with strings.

15. 6.1 Storing Text Data in Strings

No release date yet

We learn how to create string variables and extract portions of the data as well as write simple loops to read through the characters in a string.

14. 5.4 Loop Techniques

No release date yet

We continue to look at how to construct loops including how to do something special the first time through the loop. We introduce the idea of 'None' which is a way to indicate that a variable is currently empty.

13. 5.3 Patterns for Making Loops

2016 - Season 1

Loops have a beginning, middle, and end. We look ant how we construct a loop to look at a list of items one at a time so we can compute an overall maximum, minimum or average.

12. 5.2 Definite Loops

No release date yet

We learn how to use the 'for' statement in Python to loop through a set of data.

11. 5.1 The Basics of Loops

2016 - Season 1

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 exiting loops with the 'break' and 'continue' statements.

10. 4.2 Building our Own Functions

No release date yet

We look at how to build our own functions using parameters and arguments as well as how we return results to the code that is calling our functions.

9. 4.1 Using Pre-Defined Functions

No release date yet

We look at how code flows into and out of functions as well has how we pass information into functions and get results returned to us.

8. 3.2 More Conditional Statements

No release date yet

In this lecture we look at multi-branch if statements and the try-except concept where we can indicate a group of statements to be executed if something goes wrong with a block of statements.

7. 3.1 If-Then-Else

No release date yet

The most basic conditional structure is the if statement where we either execute or skip a segment of code based on the results of a logical expression (i.e. asking a question).

6. 2.2 Expressions

No release date yet

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

5. 2.1 Building Blocks of Python

No release date yet

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

4. 1.4 What do we Say to Python?

No release date yet

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

3. 1.3 Python as a Language

No release date yet

We look at how writing programs is just another form of communication. Instead of communicating with another person, we are communicating our ideas to a computer.

2. 1.2 Hardware Architecture

No release date yet

In this lecture we learn abut how the computer processes and stores programs. We learn about the CPU, Memory, Storage and Input / Output devices are brought together to write a program.

1. 1.1 Why Program

No release date yet

Explore the nature of programming and how programming a computer is different than using a computer.

An error has occurred. This application may no longer respond until reloaded. Reload 🗙