Installing Python
- IMPORTANT: New Version of This Course Available!
- Introduction
- Installing Python on Windows
- Installing Python on Mac
Python 101
- My private letter to you as you start learning programming
- Two tools to take the most from this course
- The Python interactive shell (IDLE)
- Numbers and Strings in Python
- Variables in Python
- The str() method to convert to Strings
- Running a Python file from the IDLE
- Getting user input in Python
- The int() method to convert to Integers
- The format() method to simplify String formatting
- Age Program Code
- Section 2 Final Quiz
Magic Numbers in Python
- Lists in Python
- The for loop in Python
- Boolean expressions, True and False
- If statements in Python
- The 'in' keyword to check whether a list contains an element
- Giving the user multiple chances in our program
- Generating random integers in Python
- Defining our own methods in Python
- Returning values from our methods in Python
- Magic Numbers Code
- Section 3 Final Quiz
A Lottery app
- The String split() method
- List comprehension in Python
- Python Sets — what is a Set?
- Set comprehension in Python
- Creating our lottery numbers
- Calculating the lottery winnings
- Lottery App Code
- Section 4 Final Quiz
More complex applications: a student registration system
- Installing PyCharm, a professional Python tool
- Setting up PyCharm on Mac
- Setting up PyCharm on Windows
- Dictionaries in Python
- Advanced Dictionary usage in Python
- Methods returning dictionaries
- Appending to a list in Python
- Adding marks to our student data structure
- The sum() method in Python
- Iterating over a list and using the dictionaries inside it
- Creating the application menu
- Student Registration System Code
- Section 5 Final Quiz
Object-Oriented Programming: a movie rental system
- What are classes? Classes in Python
- The Movie Class
- The User Class (and the __repr__ method)
- The filter() method in Python
- More Movie operations and methods
- Writing to a file in Python
- Saving CSV files with our data
- Loading our data from CSV files
- How to use the csv module to read and write CSV files more easily
- Saving JSON files with our data
- Loading our data from JSON files
- Argument unpacking in Python (the two asterisks)
- Creating the menu for our application
- Movie Rental System Code
- Section 6 Final Quiz
Introduction to PostgreSQL
- Introduction to databases
- Installing PostgreSQL on Windows
- Using PostgreSQL on Windows
- Executing SQL queries on Windows
- Installing PostgreSQL on Mac
- Using PostgreSQL on Mac
- Executing SQL commands on Mac
- Using the sample data provided
- SQL: The SELECT command
- SQL: filtering with WHERE
- SQL: LIMIT for limiting the number of results
- SQL: UPDATE data in a table
- SQL: DELETE data from a table
- SQL Wildcards for filtering unknowns
- What is a JOIN?
- SQL: JOINs and JOIN examples
- SQL: GROUP BY for aggregation of data
- SQL: ORDER BY for sorting data
- SQL: CREATE TABLE
- SQL: INSERT INTO for adding data to a table
- SQL: SEQUENCE for auto-incrementing fields
- SQL: CREATE INDEX and advanced information about indexes
- SQL: DROP TABLE for deleting tables and data
- Section 7 Final Quiz
Advanced PostgreSQL
- SQL: VIEWs and what they are used for
- SQL: built-in functions and the HAVING construct
- Dates in SQL: an old problem
- Other data types in SQL (including JSON in PostgreSQL)
- Nested SELECT statements for complex queries
