«- Back
Where to watch "Python for Everybody"
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.