The Complete Python PostgreSQL Developer Course

Build 9 projects—master two essential and modern technologies in Python and PostgreSQL
The Complete Python PostgreSQL Developer Course
File Size :
10.60 GB
Total length :
21h 52m



Rob Percival


Last update

Last updated 1/2021



The Complete Python PostgreSQL Developer Course

What you’ll learn

Understand software and programming with Python from beginning to end
Create Python applications ranging from beginner, basic applications to advanced, useful and engaging applications
Learn how to extend Python applications by using a professional data storage which is PostgreSQL
Understand advanced concepts extremely useful in jobs and interviews, such as data structures and algorithms

The Complete Python PostgreSQL Developer Course


No pre-knowledge is required: I’ll teach you absolutely everything you need to know!
A computer is required, but any will do. A desktop or a laptop running Mac, Windows, or Linux
All the software used in the course is free, and I’ll personally walk you through setting it all up


Ever wanted to learn one of the most popular programming languages on the planet? Why not learn two of the most popular at the same time?
Python and SQL are used by many technology companies, small and large. That’s because they are powerful, yet extremely flexible.
Python is used in the industry for things like embedded software, web development, desktop applications, and even mobile apps!
PostgreSQL allows your applications to become even more powerful by storing, retrieving, and filtering through large data sets easily.
This course is your one-stop shop for everything Python and PostgreSQL, and the instructor is constantly available to support your learning and answer questions.
Gallop through — or go at your own speed
You’ll gain immediate access over 160 lectures and more than 20 hours of content, each developed with ease of learning in mind.
Using my previous teaching experience I’ve created crystal-clear and original content which you’ll find easy to understand – and more importantly – to absorb.
You’ll find learning both quick and fun. And, I’ve used techniques proven to effortlessly lock that knowledge in, as you breeze through each comprehensive chapter.
Fun, fast, and effective
This course will get you from being an absolute Python and PostgreSQL beginner to an experienced software developer.
Don’t believe me? I offer a full money back guarantee, so long as you request it within 30 days of your purchase of the course.
Are you ready to transform your world and become an uber-confident app developer?
I’ll see you on the inside!


Section 1: Installing Python

Lecture 1 IMPORTANT: New Version of This Course Available!

Lecture 2 Introduction

Lecture 3 Installing Python on Windows

Lecture 4 Installing Python on Mac

Section 2: Python 101

Lecture 5 My private letter to you as you start learning programming

Lecture 6 Two tools to take the most from this course

Lecture 7 The Python interactive shell (IDLE)

Lecture 8 Numbers and Strings in Python

Lecture 9 Variables in Python

Lecture 10 The str() method to convert to Strings

Lecture 11 Running a Python file from the IDLE

Lecture 12 Getting user input in Python

Lecture 13 The int() method to convert to Integers

Lecture 14 The format() method to simplify String formatting

Lecture 15 Age Program Code

Section 3: Magic Numbers in Python

Lecture 16 Lists in Python

Lecture 17 The for loop in Python

Lecture 18 Boolean expressions, True and False

Lecture 19 If statements in Python

Lecture 20 The ‘in’ keyword to check whether a list contains an element

Lecture 21 Giving the user multiple chances in our program

Lecture 22 Generating random integers in Python

Lecture 23 Defining our own methods in Python

Lecture 24 Returning values from our methods in Python

Lecture 25 Magic Numbers Code

Section 4: A Lottery app

Lecture 26 The String split() method

Lecture 27 List comprehension in Python

Lecture 28 Python Sets — what is a Set?

Lecture 29 Set comprehension in Python

Lecture 30 Creating our lottery numbers

Lecture 31 Calculating the lottery winnings

Lecture 32 Lottery App Code

Section 5: More complex applications: a student registration system

Lecture 33 Installing PyCharm, a professional Python tool

Lecture 34 Setting up PyCharm on Mac

Lecture 35 Setting up PyCharm on Windows

Lecture 36 Dictionaries in Python

Lecture 37 Advanced Dictionary usage in Python

Lecture 38 Methods returning dictionaries

Lecture 39 Appending to a list in Python

Lecture 40 Adding marks to our student data structure

Lecture 41 The sum() method in Python

Lecture 42 Iterating over a list and using the dictionaries inside it

Lecture 43 Creating the application menu

Lecture 44 Student Registration System Code

Section 6: Object-Oriented Programming: a movie rental system

Lecture 45 What are classes? Classes in Python

Lecture 46 The Movie Class

Lecture 47 The User Class (and the __repr__ method)

Lecture 48 The filter() method in Python

Lecture 49 More Movie operations and methods

Lecture 50 Writing to a file in Python

Lecture 51 Saving CSV files with our data

Lecture 52 Loading our data from CSV files

Lecture 53 How to use the csv module to read and write CSV files more easily

Lecture 54 Saving JSON files with our data

Lecture 55 Loading our data from JSON files

Lecture 56 Argument unpacking in Python (the two asterisks)

Lecture 57 Creating the menu for our application

Lecture 58 Movie Rental System Code

Section 7: Introduction to PostgreSQL

Lecture 59 Introduction to databases

Lecture 60 Installing PostgreSQL on Windows

Lecture 61 Using PostgreSQL on Windows

Lecture 62 Executing SQL queries on Windows

Lecture 63 Installing PostgreSQL on Mac

Lecture 64 Using PostgreSQL on Mac

Lecture 65 Executing SQL commands on Mac

Lecture 66 Using the sample data provided

Lecture 67 SQL: The SELECT command

Lecture 68 SQL: filtering with WHERE

Lecture 69 SQL: LIMIT for limiting the number of results

Lecture 70 SQL: UPDATE data in a table

Lecture 71 SQL: DELETE data from a table

Lecture 72 SQL Wildcards for filtering unknowns

Lecture 73 What is a JOIN?

Lecture 74 SQL: JOINs and JOIN examples

Lecture 75 SQL: GROUP BY for aggregation of data

Lecture 76 SQL: ORDER BY for sorting data


Lecture 78 SQL: INSERT INTO for adding data to a table

Lecture 79 SQL: SEQUENCE for auto-incrementing fields

Lecture 80 SQL: CREATE INDEX and advanced information about indexes

Lecture 81 SQL: DROP TABLE for deleting tables and data

Section 8: Advanced PostgreSQL

Lecture 82 SQL: VIEWs and what they are used for

Lecture 83 SQL: built-in functions and the HAVING construct

Lecture 84 Dates in SQL: an old problem

Lecture 85 Other data types in SQL (including JSON in PostgreSQL)

Lecture 86 Nested SELECT statements for complex queries

Lecture 87 The PostgreSQL SERIAL type

Section 9: Python and PostgreSQL

Lecture 88 Installing Microsoft Visual C++ on Windows

Lecture 89 Installing psycopg2 on Windows (2018 update)

Lecture 90 Installing psycopg2 on Windows (older versions)

Lecture 91 Installing psycopg2 on Mac

Lecture 92 Verifying everything works—don’t proceed if it doesn’t!

Lecture 93 Mac OS X: Fixing psycopg2 ‘library not loaded’ error

Lecture 94 What is a virtual environment?

Lecture 95 psycopg2 on a virtualenv on Windows (2018 update)

Lecture 96 Psycopg2 on a virtualenv on Windows (older versions)

Lecture 97 Setting up the app structure, pip, and requirements.txt

Lecture 98 Recap on classes and object-oriented programming

Lecture 99 Saving to database from Python

Lecture 100 Loading from the database from Python

Lecture 101 Removing some duplicate code from our app

Lecture 102 Connection pooling and why it is important

Lecture 103 Creating the ConnectionPool class

Lecture 104 Creating the ConnectionFromPool class

Lecture 105 Obtaining a cursor from the ConnectionFromPool class

Lecture 106 The Database class and selective initialisation

Lecture 107 Cleaning up the Database class

Lecture 108 End of section review

Lecture 109 Keep thinking: Section 9

Lecture 110 Download the code for this section here

Section 10: Python Web and APIs

Lecture 111 What is an API?

Lecture 112 Making requests in Python

Lecture 113 What is OAuth?

Lecture 114 Creating a Twitter app

Lecture 115 Setting up Twitter login

Lecture 116 Getting the OAuth request token

Lecture 117 More on the Python debugger—an essential tool

Lecture 118 Getting authorization by the user

Lecture 119 Getting the OAuth access token

Lecture 120 Performing Twitter requests: getting images

Lecture 121 Reusing code from the last section to save users

Lecture 122 Creating users in our app

Lecture 123 Retrieving users in our app

Lecture 124 Cleaning up the code—extremely important!

Lecture 125 Introduction to Flask and Python Web Development

Lecture 126 Adding a Twitter login endpoint

Lecture 127 Adding Twitter authorization

Lecture 128 Creating the user profile

Lecture 129 The Flask before_request decorator

Lecture 130 Checking if a user is already logged in

Lecture 131 Searching tweets and displaying them

Lecture 132 Searching for different things

Lecture 133 What is Bootstrap?

Lecture 134 Writing our own CSS

Lecture 135 Allowing users to perform custom searches

Lecture 136 Adding sentiment analysis with another API

Lecture 137 Section 10: Twitter Login code

Section 11: Introduction to Git and GitHub

Lecture 138 What is Git?

Lecture 139 Installing Git on Mac and Windows

Lecture 140 Introduction to the UNIX terminal

Lecture 141 The VIM text editor, a powerful terminal editor

Lecture 142 Dealing with files in the UNIX terminal

Lecture 143 What is a Git repository?

Lecture 144 git init — create a Git repository

Lecture 145 git add and git commit — staging and committing

Lecture 146 git log — viewing past commits

Lecture 147 Creating a repository on GitHub

Lecture 148 git remote — managing remote repositories

Lecture 149 Adding your SSH key to GitHub

Lecture 150 What is a README file? Introduction to Markdown

Lecture 151 git pull — pulling other’s changes

Lecture 152 Keep thinking: Section 11

Section 12: Advanced Python

Lecture 153 OOP: Inheritance

Lecture 154 OOP: Multiple Inheritance in Python

Lecture 155 OOP: What is composition?

Lecture 156 OOP: What is encapsulation?

Lecture 157 Introduction to Exceptions in Python

Lecture 158 Creating our own Exceptions

Lecture 159 Some of the available built-in Exceptions

Lecture 160 Python built-in methods

Lecture 161 Assertions in Python

Lecture 162 Lambda expressions in Python

Lecture 163 More uses of lambda expressions

Lecture 164 Lambda expressions in the wild

Lecture 165 Introduction to unit testing with unittest

Lecture 166 Section 12: Advanced Python code

Lecture 167 Keep thinking: Section 12

Section 13: Data Structures and Algorithms

Lecture 168 What are data structures?

Lecture 169 What is a Linked List?

Lecture 170 Introduction to Linked List Assignment

Lecture 171 Assignment: Linked List

Lecture 172 Programming our own Linked List in Python

Lecture 173 Creating a Queue

Lecture 174 Introduction to Queue Assignment

Lecture 175 Assignment: Queue

Lecture 176 Programming our own Queue in Python

Lecture 177 Creating a Stack

Lecture 178 Introduction to Stack Assignment

Lecture 179 Assignment: Stack

Lecture 180 Programming our own Stack in Python

Lecture 181 Creating a Binary Tree

Lecture 182 Introduction to Binary Tree Assignment

Lecture 183 Assignment: Binary Tree

Lecture 184 Programming our own Binary Tree in Python

Section 14: Conclusion

Lecture 185 Next steps

Lecture 186 Bonus lecture: other courses and next steps

Complete beginners to programming and Python. The course follows concise explanations with hands-on projects, and has been created with the beginner in mind.,Intermediate programmers can fly through the first couple of sections and quickly learn about PostgreSQL and advanced Python concepts,This course is likely not for advanced programmers, although it has a lot of useful information and can serve well as a reference!

Course Information:

Udemy | English | 21h 52m | 10.60 GB
Created by: Rob Percival

You Can See More Courses in the Developer >> Greetings from

New Courses

Scroll to Top