There are currently no items in your shopping cart.

User Panel

Forgot your password?.

The Complete Python & PostgreSQL Developer Course

Installing Python :
Installing Python on Windows
Installing Python on Mac

Python 101 :
My private letter to you as you start learning programming
The Live Chat for Q&A
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
6 questions

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
8 questions

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
3 questions

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 dictionary's keys and values
Creating the application menu
Student Registration System Code
Section 5 Final Quiz
5 questions

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
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
5 questions

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: 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
5 questions

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
The PostgreSQL SERIAL type
Section 8 Final Quiz
5 questions

Python and PostgreSQL :
Installing psycopg2 on Windows (2018 update)
Installing psycopg2 on Windows (older versions)
Installing psycopg2 on Mac
Verifying everything works—don't proceed if it doesn't!
Mac OS X: Fixing psycopg2 'library not loaded' error
What is a virtual environment?
psycopg2 on a virtualenv on Windows (2018 update)
Psycopg2 on a virtualenv on Windows (older versions)
Setting up the app structure, pip, and requirements.txt
Recap on classes and object-oriented programming
Saving to database from Python
Loading from the database from Python
Removing some duplicate code from our app
Connection pooling and why it is important
Creating the ConnectionPool class
Creating the ConnectionFromPool class
Obtaining a cursor from the ConnectionFromPool class
The Database class and selective initialisation
Cleaning up the Database class
End of section review
Section 9 Final Quiz
3 questions
Keep thinking: Section 9
Download the code for this section here

Python Web and APIs :
What is an API?
Making requests in Python
What is OAuth?
Creating a Twitter app
Setting up Twitter login
Getting the OAuth request token
More on the Python debugger—an essential tool
Getting authorization by the user
Getting the OAuth access token
Performing Twitter requests: getting images
Reusing code from the last section to save users
Creating users in our app
Retrieving users in our app
Cleaning up the code—extremely important!
Introduction to Flask and Python Web Development
Adding a Twitter login endpoint
Adding Twitter authorization
Creating the user profile
The Flask before_request decorator
Checking if a user is already logged in
Searching tweets and displaying them
Searching for different things
What is Bootstrap?
Writing our own CSS
Allowing users to perform custom searches
Adding sentiment analysis with another API
Section 10 Final Quiz
6 questions
Section 10: Twitter Login code

Introduction to Git and GitHub :
What is Git?
Installing Git on Mac and Windows
Introduction to the UNIX terminal
The VIM text editor, a powerful terminal editor
Dealing with files in the UNIX terminal
What is a Git repository?
git init — create a Git repository
git add and git commit — staging and committing
git log — viewing past commits
Creating a repository on GitHub
git remote — managing remote repositories
Adding your SSH key to GitHub
What is a README file? Introduction to Markdown
git pull — pulling other's changes
Section 11 Final Quiz
5 questions
Keep thinking: Section 11

Advanced Python :
OOP: Inheritance
OOP: Multiple Inheritance in Python
OOP: What is composition?
OOP: What is encapsulation?
Introduction to Exceptions in Python
Creating our own Exceptions
Some of the available built-in Exceptions
Python built-in methods
Assertions in Python
Lambda expressions in Python
More uses of lambda expressions
Lambda expressions in the wild
Introduction to unit testing with unittest
Section 12 Final Quiz
4 questions
Section 12: Advanced Python code
Keep thinking: Section 12

Data Structures and Algorithms :
What are data structures?
What is a Linked List?
Introduction to Linked List Assignment
Assignment: Linked List
Programming our own Linked List in Python
Creating a Queue
Introduction to Queue Assignment
Assignment: Queue
Programming our own Queue in Python
Creating a Stack
Introduction to Stack Assignment
Assignment: Stack
Programming our own Stack in Python
Creating a Binary Tree
Introduction to Binary Tree Assignment
Assignment: Binary Tree
Programming our own Binary Tree in Python
Section 13 Final Quiz
2 questions

Conclusion :
Next steps
Bonus lecture: web development with Python