Certification training

Python And PostgresSQL: Complete Guide

Prepare for your exam with a structured video course built for focused study, topic review, and repeatable progress before exam day.

160Lectures
21h 27mDuration
Vendor
Python And PostgresSQL: Complete Guide course cover Best seller
certification training 160 lessons arranged in a guided course path
Course overview

Study with a clear path.

Move through focused sections, review lecture timing, and return directly to the objectives that need more work.

Sequenced lessons

Follow the course in order or jump directly to the section you need to revisit.

Video-first prep

Use concise lecture blocks for technical review before moving into exam practice.

Fast access

Your purchased course becomes available in the member area after confirmed payment.

Curriculum

Course sections.

13 sections, 160 lessons, and lecture-level duration details.

01 Installing Python on Mac 1m

01 The Python interactive shell (IDLE) 4m
02 Numbers and Strings in Python 5m
03 Variables in Python 6m
04 The str() method to convert to Strings 4m
05 Running a Python file from the IDLE 7m
06 Getting user input in Python 6m
07 The int() method to convert to Integers 2m
08 The format() method to simplify String formatting 7m

01 Lists in Python 5m
02 The for loop in Python 3m
03 Boolean expressions, True and False 5m
04 If statements in Python 5m
05 The 'in' keyword to check whether a list contains an element 5m
06 Giving the user multiple chances in our program 9m
07 Generating random integers in Python 8m
08 Defining our own methods in Python 7m
09 Returning values from our methods in Python 5m

01 The String split() method 4m
02 List comprehension in Python 7m
03 Python Sets — what is a Set? 7m
04 Set comprehension in Python 6m
05 Creating our lottery numbers 8m
06 Calculating the lottery winnings 6m

01 Installing PyCharm, a professional Python tool 3m
02 Setting up PyCharm on Mac 2m
03 Setting up PyCharm on Windows 4m
04 Dictionaries in Python 9m
05 Advanced Dictionary usage in Python 8m
06 Methods returning dictionaries 7m
07 Appending to a list in Python 5m
08 Adding marks to our student data structure 9m
09 The sum() method in Python 8m
10 Iterating over a list and using the dictionaries inside it 6m
11 Creating the application menu 15m

01 What are classes? Classes in Python 12m
02 The Movie Class 8m
03 The User Class (and the __repr__ method) 6m
04 The filter() method in Python 10m
05 More Movie operations and methods 6m
06 Writing to a file in Python 4m
07 Saving CSV files with our data 10m
08 Loading our data from CSV files 12m
09 Saving JSON files with our data 6m
10 Loading our data from JSON files 8m
11 Argument unpacking in Python (the two asterisks) 6m
12 Creating the menu for our application 15m

01 Introduction to databases 13m
02 Installing PostgreSQL on Windows 4m
03 Using PostgreSQL on Windows 7m
04 Executing SQL queries on Windows 2m
05 Installing PostgreSQL on Mac 5m
06 Using PostgreSQL on Mac 9m
07 Executing SQL commands on Mac 1m
08 Using the sample data provided 3m
09 SQL: The SELECT command 8m
10 SQL: filtering with WHERE 4m
11 SQL: LIMIT for limiting the number of results 2m
12 SQL: UPDATE data in a table 6m
13 SQL: DELETE data from a table 5m
14 SQL Wildcards for filtering unknowns 5m
15 What is a JOIN? 14m
16 SQL: JOINs and JOIN examples 10m
17 SQL: GROUP BY for aggregation of data 9m
18 SQL: ORDER BY for sorting data 5m
19 SQL: CREATE TABLE 12m
20 SQL: INSERT INTO for adding data to a table 10m
21 SQL: SEQUENCE for auto-incrementing fields 7m
22 SQL: CREATE INDEX and advanced information about indexes 12m
23 SQL: DROP TABLE for deleting tables and data 6m

01 SQL: VIEWs and what they are used for 19m
02 SQL: built-in functions and the HAVING construct 12m
03 Dates in SQL: an old problem 14m
04 Other data types in SQL (including JSON in PostgreSQL) 11m
05 Nested SELECT statements for complex queries 9m
06 The PostgreSQL SERIAL type 3m

01 Installing psycopg2 on Windows (2018 update) 6m
02 Installing psycopg2 on Mac 4m
03 Verifying everything works—don't proceed if it doesn't! 3m
04 Mac OS X: Fixing psycopg2 'library not loaded' error 6m
05 What is a virtual environment? 8m
06 psycopg2 on a virtualenv on Windows (2018 update) 4m
07 Psycopg2 on a virtualenv on Windows (older versions) 5m
08 Setting up the app structure, pip, and requirements.txt 4m
09 Recap on classes and object-oriented programming 10m
10 Saving to database from Python 17m
11 Loading from the database from Python 16m
12 Removing some duplicate code from our app 4m
13 Connection pooling and why it is important 13m
14 Creating the ConnectionPool class 9m
15 Creating the ConnectionFromPool class 9m
16 Obtaining a cursor from the ConnectionFromPool class 8m
17 The Database class and selective initialisation 19m
18 Cleaning up the Database class 6m
19 End of section review 4m

01 What is an API? 26m
02 Making requests in Python 12m
03 What is OAuth? 7m
04 Creating a Twitter app 4m
05 Setting up Twitter login 5m
06 Getting the OAuth request token 15m
07 More on the Python debugger—an essential tool 5m
08 Getting authorization by the user 10m
09 Getting the OAuth access token 6m
10 Performing Twitter requests: getting images 17m
11 Reusing code from the last section to save users 11m
12 Creating users in our app 8m
13 Retrieving users in our app 14m
14 Cleaning up the code—extremely important! 19m
15 Introduction to Flask and Python Web Development 16m
16 Adding a Twitter login endpoint 11m
17 Adding Twitter authorization 23m
18 Creating the user profile 9m
19 The Flask before_request decorator 9m
20 Checking if a user is already logged in 3m
21 Searching tweets and displaying them 8m
22 Searching for different things 3m
23 What is Bootstrap? 9m
24 Writing our own CSS 6m
25 Allowing users to perform custom searches 7m
26 Adding sentiment analysis with another API 16m

01 What is Git? 5m
02 Installing Git on Mac and Windows 7m
03 Introduction to the UNIX terminal 8m
04 The VIM text editor, a powerful terminal editor 6m
05 Dealing with files in the UNIX terminal 4m
06 What is a Git repository? 6m
07 git init — create a Git repository 4m
08 git add and git commit — staging and committing 8m
09 git log — viewing past commits 2m
10 Creating a repository on GitHub 3m
11 git remote — managing remote repositories 3m
12 Adding your SSH key to GitHub 6m
13 What is a README file? Introduction to Markdown 7m
14 git pull — pulling other's changes 3m

01 OOP: Inheritance 15m
02 OOP: Multiple Inheritance in Python 5m
03 OOP: What is composition? 4m
04 OOP: What is encapsulation? 12m
05 Introduction to Exceptions in Python 11m
06 Creating our own Exceptions 7m
07 Some of the available built-in Exceptions 6m
08 Python built-in methods 21m
09 Assertions in Python 8m
10 Lambda expressions in Python 8m
11 More uses of lambda expressions 10m
12 Lambda expressions in the wild 17m
13 Introduction to unit testing with unittest 20m

01 What are data structures? 6m
02 What is a Linked List? 9m
03 Introduction to Linked List Assignment 10m
04 Programming our own Linked List in Python 9m
05 Creating a Queue 6m
06 Introduction to Queue Assignment 11m
07 Programming our own Queue in Python 15m
08 Creating a Stack 4m
09 Introduction to Stack Assignment 5m
10 Programming our own Stack in Python 7m
11 Introduction to Binary Tree Assignment 8m
12 Programming our own Binary Tree in Python 9m
Continue preparing

Connect the lessons to exam-day practice.

Use the course for structured review, then move into current questions, timed simulator sessions, and a broader vendor catalog.

VTSimu exam simulatorRehearse pacing in focused desktop sessions.
Unlimited AccessBuild a practice library across vendors and formats.
More video coursesExplore every available certification training track.