Enrolment options
Udemy - The Complete PythonPostgreSQL Course 2.0 1080 2025-5
- Enrolled students: There are no students enrolled in this course.
Guests cannot access this course. Please log in.
Course content
Sections:
9
•
Activities:
1
•
Resources:
137
- Announcements
- 1 Welcome to this course
- 1 Introduction to this section
- 3 Variables in Python
- 4 String formatting in Python
- 5 Getting user input
- 6 Writing our first Python app
- 7 Lists tuples and sets
- 8 Advanced set operations
- 9 Booleans in Python
- 10 If statements
- 11 The in keyword in Python
- 12 If statements with the in keyword
- 13 Loops in Python
- 14 List comprehensions in Python
- 15 Dictionaries
- 16 Destructuring variables
- 17 Functions in Python
- 18 Function arguments and parameters
- 19 Default parameter values
- 20 Functions returning values
- 21 Lambda functions in Python
- 22 Dictionary comprehensions
- 23 Unpacking arguments
- 24 Unpacking keyword arguments
- 25 Object Oriented Programming in Python
- 26 Magic methods _str_ and _repr_
- 27 classmethod and staticmethod
- 28 Class inheritance
- 29 Class composition
- 30 Type hinting in Python 35
- 31 Imports in Python
- 32 Relative imports in Python
- 33 Errors in Python
- 34 Custom error classes
- 35 First class functions
- 36 Simple decorators in Python
- 37 The at syntax for decorators
- 38 Decorating functions with parameters
- 39 Decorators with parameters
- 40 Mutability in Python
- 41 Mutable default parameters and why theyre a bad idea
- 1 Overview of the project
- 2 Creating our user menu
- 3 What is SQL
- 4 Using Python lists as an in memory database
- 5 A SQLite data viewer
- 6 CREATE TABLE new tables with SQL
- 9 How to connect to a SQLite database with Python
- 10 Connecting to SQLite in our app
- 11 What is a cursor
- 12 INSERT INTO add data to a table
- 14 How to insert data into SQLite with Python
- 15 SELECT retrieve data from a table
- 17 Retrieving results from a cursor
- 18 WHERE search with SQL
- 20 DROP TABLE deleting entire tables
- 22 What is a SQL injection attack
- 1 Overview of the project
- 2 Three development stages of our project
- 3 Our starting code for this project
- 4 Queries well need for the project to begin with
- 5 Write the databasepy file
- 6 UPDATE changing data with SQL
- 8 Write our user menu and functions
- 9 Watched movies second approach
- 10 DELETE FROM removing rows with SQL
- 12 Stage 2 watching movies
- 13 Relational data primary and foreign keys
- 15 Watched movies final approach
- 16 Stage 3 adding new watched movies
- 17 Auto incrementing row IDs
- 19 JOIN access two tables at once with SQL
- 20 Use JOINs to retrieve the movies a user has watched
- 22 ORDER BY sort the returned table
- 23 LIMIT getting a certain number of rows
- 24 LIKE flexible searching
- 25 What is an index in SQL
- 26 Adding an index to our table for more efficient searching
- 1 SQLite vs PostgreSQL
- 2 How to install PostgreSQL
- 3 How to run and access PostgreSQL
- 4 psycopg2 vs psycopg2 binary
- 5 How to store and not store sensitive information in your code
- 6 Psycopg2 cursors and query parameters
- 7 Auto incrementing columns SEQUENCE and SERIAL in PostgreSQL
- 8 Our changed code and finding differences between files
- 1 Overview of the project
- 2 What is ACID
- 3 Essential queries well need for this project
- 4 RETURNING data from modified rows
- 5 Nested queries getting the latest poll
- 6 SQL built in functions
- 7 GROUP BY and calculating vote percentages
- 8 PostgreSQL window functions
- 9 PostgreSQL window functions part 2
- 10 How to use ORDER BY with window functions
- 11 How to use PARTITION with window functions
- 12 SQL DISTINCT and DISTINCT ON
- 13 The SQL HAVING clause
- 14 SQL VIEW virtual tables
- 15 How to read the PostgreSQL documentation
- 16 Adding type hinting to our application
- 1 How to separate our database entities into models
- 2 Creating our Option model class
- 3 Changes needed in databasepy
- 4 Changes needed in apppy
- 5 What is connection pooling
- 6 How to create a connection pool with psycopg2
- 7 Reduce pooling duplication with context managers
- 8 Reduce cursor creation duplication with context managers
- 9 The Python datetime module
- 10 How to calculate new dates with timedelta
- 11 How to handle timezones with pytz
- 12 How to save dates to PostgreSQL
- 13 Add the vote date to our polling app
- 1 Composite primary keys
- 2 User defined functions in PostgreSQL
- 3 Composite types and sets in functions
- 4 Stored procedures in PostgreSQL
- 5 Connections vs transactions in psycopg2
- 6 Locking in PostgreSQL
- 7 Asynchronous psycopg2
- 8 SQL string composition with psycopg2
- 1 Overview creating graphs from poll data
- 3 How to draw a line graph with matplotlib
- 5 Matplotlib figures axes and plots
- 6 The Object Oriented Approach with matplotlib
- 7 How to add multiple subplots to a figure
- 8 How to draw a pie chart with matplotlib
- 9 How to draw a bar chart with matplotlib
- 10 How to adjust the size of a matplotlib plot
- 11 How to adjust the x axis tick labels so they fit in the screen
- 12 How to draw a stacked bar chart with matplotlib
- 13 How to create a legend from your graphed data
- 14 How to export an image with matplotlib
- 15 How to create one document with multiple matplotlib plots
- 16 How to create a custom legend with matplotlib