Python And PostgresSQL: Complete Guide

What’s included

$14.99 / $24.99

Get ready for your exam by enrolling in our comprehensive training course. This course includes a full set of instructional videos designed to equip you with in-depth knowledge essential for passing the certification exam with flying colors.

4.59

Pay once, own it forever

Video Courses

Installing Python

Lectures	Duration
1. Installing Python on Mac	1m

1. Installing Python on Mac

Python 101

Lectures	Duration
1. The Python interactive shell (IDLE)	4m
2. Numbers and Strings in Python	5m
3. Variables in Python	6m
4. The str() method to convert to Strings	4m
5. Running a Python file from the IDLE	7m
6. Getting user input in Python	6m
7. The int() method to convert to Integers	2m
8. The format() method to simplify String formatting	7m

1. The Python interactive shell (IDLE)

2. Numbers and Strings in Python

3. Variables in Python

4. The str() method to convert to Strings

5. Running a Python file from the IDLE

6. Getting user input in Python

7. The int() method to convert to Integers

8. The format() method to simplify String formatting

Magic Numbers in Python

Lectures	Duration
1. Lists in Python	5m
2. The for loop in Python	3m
3. Boolean expressions, True and False	5m
4. If statements in Python	5m
5. The 'in' keyword to check whether a list contains an element	5m
6. Giving the user multiple chances in our program	9m
7. Generating random integers in Python	8m
8. Defining our own methods in Python	7m
9. Returning values from our methods in Python	5m

1. Lists in Python

2. The for loop in Python

3. Boolean expressions, True and False

4. If statements in Python

5. The 'in' keyword to check whether a list contains an element

6. Giving the user multiple chances in our program

7. Generating random integers in Python

8. Defining our own methods in Python

9. Returning values from our methods in Python

A Lottery app

Lectures	Duration
1. The String split() method	4m
2. List comprehension in Python	7m
3. Python Sets — what is a Set?	7m
4. Set comprehension in Python	6m
5. Creating our lottery numbers	8m
6. Calculating the lottery winnings	6m

1. The String split() method

2. List comprehension in Python

3. Python Sets — what is a Set?

4. Set comprehension in Python

5. Creating our lottery numbers

6. Calculating the lottery winnings

More complex applications: a student registration system

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

1. Installing PyCharm, a professional Python tool

2. Setting up PyCharm on Mac

3. Setting up PyCharm on Windows

4. Dictionaries in Python

5. Advanced Dictionary usage in Python

6. Methods returning dictionaries

7. Appending to a list in Python

8. Adding marks to our student data structure

9. The sum() method in Python

10. Iterating over a list and using the dictionaries inside it

11. Creating the application menu

15m

Object-Oriented Programming: a movie rental system

Lectures	Duration
1. What are classes? Classes in Python	12m
2. The Movie Class	8m
3. The User Class (and the __repr__ method)	6m
4. The filter() method in Python	10m
5. More Movie operations and methods	6m
6. Writing to a file in Python	4m
7. Saving CSV files with our data	10m
8. Loading our data from CSV files	12m
9. 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

1. What are classes? Classes in Python

12m

2. The Movie Class

3. The User Class (and the __repr__ method)

4. The filter() method in Python

10m

5. More Movie operations and methods

6. Writing to a file in Python

7. Saving CSV files with our data

10m

8. Loading our data from CSV files

12m

9. Saving JSON files with our data

10. Loading our data from JSON files

11. Argument unpacking in Python (the two asterisks)

12. Creating the menu for our application

15m

Introduction to PostgreSQL

Lectures	Duration
1. Introduction to databases	13m
2. Installing PostgreSQL on Windows	4m
3. Using PostgreSQL on Windows	7m
4. Executing SQL queries on Windows	2m
5. Installing PostgreSQL on Mac	5m
6. Using PostgreSQL on Mac	9m
7. Executing SQL commands on Mac	1m
8. Using the sample data provided	3m
9. 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

1. Introduction to databases

13m

2. Installing PostgreSQL on Windows

3. Using PostgreSQL on Windows

4. Executing SQL queries on Windows

5. Installing PostgreSQL on Mac

6. Using PostgreSQL on Mac

7. Executing SQL commands on Mac

8. Using the sample data provided

9. SQL: The SELECT command

10. SQL: filtering with WHERE

11. SQL: LIMIT for limiting the number of results

12. SQL: UPDATE data in a table

13. SQL: DELETE data from a table

14. SQL Wildcards for filtering unknowns

15. What is a JOIN?

14m

16. SQL: JOINs and JOIN examples

10m

17. SQL: GROUP BY for aggregation of data

18. SQL: ORDER BY for sorting data

19. SQL: CREATE TABLE

12m

20. SQL: INSERT INTO for adding data to a table

10m

21. SQL: SEQUENCE for auto-incrementing fields

22. SQL: CREATE INDEX and advanced information about indexes

12m

23. SQL: DROP TABLE for deleting tables and data

Advanced PostgreSQL

Lectures	Duration
1. SQL: VIEWs and what they are used for	19m
2. SQL: built-in functions and the HAVING construct	12m
3. Dates in SQL: an old problem	14m
4. Other data types in SQL (including JSON in PostgreSQL)	11m
5. Nested SELECT statements for complex queries	9m
6. The PostgreSQL SERIAL type	3m

1. SQL: VIEWs and what they are used for

19m

2. SQL: built-in functions and the HAVING construct

12m

3. Dates in SQL: an old problem

14m

4. Other data types in SQL (including JSON in PostgreSQL)

11m

5. Nested SELECT statements for complex queries

6. The PostgreSQL SERIAL type

Python and PostgreSQL

Lectures	Duration
1. Installing psycopg2 on Windows (2018 update)	6m
2. Installing psycopg2 on Mac	4m
3. Verifying everything works—don't proceed if it doesn't!	3m
4. Mac OS X: Fixing psycopg2 'library not loaded' error	6m
5. What is a virtual environment?	8m
6. psycopg2 on a virtualenv on Windows (2018 update)	4m
7. Psycopg2 on a virtualenv on Windows (older versions)	5m
8. Setting up the app structure, pip, and requirements.txt	4m
9. 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

1. Installing psycopg2 on Windows (2018 update)

2. Installing psycopg2 on Mac

3. Verifying everything works—don't proceed if it doesn't!

4. Mac OS X: Fixing psycopg2 'library not loaded' error

5. What is a virtual environment?

6. psycopg2 on a virtualenv on Windows (2018 update)

7. Psycopg2 on a virtualenv on Windows (older versions)

8. Setting up the app structure, pip, and requirements.txt

9. 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

13. Connection pooling and why it is important

13m

14. Creating the ConnectionPool class

15. Creating the ConnectionFromPool class

16. Obtaining a cursor from the ConnectionFromPool class

17. The Database class and selective initialisation

19m

18. Cleaning up the Database class

19. End of section review

Python Web and APIs

Lectures	Duration
1. What is an API?	26m
2. Making requests in Python	12m
3. What is OAuth?	7m
4. Creating a Twitter app	4m
5. Setting up Twitter login	5m
6. Getting the OAuth request token	15m
7. More on the Python debugger—an essential tool	5m
8. Getting authorization by the user	10m
9. 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

1. What is an API?

26m

2. Making requests in Python

12m

3. What is OAuth?

4. Creating a Twitter app

5. Setting up Twitter login

6. Getting the OAuth request token

15m

7. More on the Python debugger—an essential tool

8. Getting authorization by the user

10m

9. Getting the OAuth access token

10. Performing Twitter requests: getting images

17m

11. Reusing code from the last section to save users

11m

12. Creating users in our app

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

19. The Flask before_request decorator

20. Checking if a user is already logged in

21. Searching tweets and displaying them

22. Searching for different things

23. What is Bootstrap?

24. Writing our own CSS

25. Allowing users to perform custom searches

26. Adding sentiment analysis with another API

16m

Introduction to Git and GitHub

Lectures	Duration
1. What is Git?	5m
2. Installing Git on Mac and Windows	7m
3. Introduction to the UNIX terminal	8m
4. The VIM text editor, a powerful terminal editor	6m
5. Dealing with files in the UNIX terminal	4m
6. What is a Git repository?	6m
7. git init — create a Git repository	4m
8. git add and git commit — staging and committing	8m
9. 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

1. What is Git?

2. Installing Git on Mac and Windows

3. Introduction to the UNIX terminal

4. The VIM text editor, a powerful terminal editor

5. Dealing with files in the UNIX terminal

6. What is a Git repository?

7. git init — create a Git repository

8. git add and git commit — staging and committing

9. git log — viewing past commits

10. Creating a repository on GitHub

11. git remote — managing remote repositories

12. Adding your SSH key to GitHub

13. What is a README file? Introduction to Markdown

14. git pull — pulling other's changes

Advanced Python

Lectures	Duration
1. OOP: Inheritance	15m
2. OOP: Multiple Inheritance in Python	5m
3. OOP: What is composition?	4m
4. OOP: What is encapsulation?	12m
5. Introduction to Exceptions in Python	11m
6. Creating our own Exceptions	7m
7. Some of the available built-in Exceptions	6m
8. Python built-in methods	21m
9. 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

1. OOP: Inheritance

15m

2. OOP: Multiple Inheritance in Python

3. OOP: What is composition?

4. OOP: What is encapsulation?

12m

5. Introduction to Exceptions in Python

11m

6. Creating our own Exceptions

7. Some of the available built-in Exceptions

8. Python built-in methods

21m

9. Assertions in Python

10. Lambda expressions in Python

11. More uses of lambda expressions

10m

12. Lambda expressions in the wild

17m

13. Introduction to unit testing with unittest

20m

Data Structures and Algorithms

Lectures	Duration
1. What are data structures?	6m
2. What is a Linked List?	9m
3. Introduction to Linked List Assignment	10m
4. Programming our own Linked List in Python	9m
5. Creating a Queue	6m
6. Introduction to Queue Assignment	11m
7. Programming our own Queue in Python	15m
8. Creating a Stack	4m
9. 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

1. What are data structures?

2. What is a Linked List?

3. Introduction to Linked List Assignment

10m

4. Programming our own Linked List in Python

5. Creating a Queue

6. Introduction to Queue Assignment

11m

7. Programming our own Queue in Python

15m

8. Creating a Stack

9. Introduction to Stack Assignment

10. Programming our own Stack in Python

11. Introduction to Binary Tree Assignment

12. Programming our own Binary Tree in Python