The Complete Python/PostgreSQL Course 2.0
Focused View
Jose Salvatierra,Teclado by Jose Salvatierra,Codestars • over 2 million students worldwide!
13:31:23
168 View
001 Welcome to this course!.mp4
02:31
002 Initial setup (for newer Pythonistas).html
003 Get the complete e-book here.html
001 Introduction to this section.mp4
01:01
002 Access the code for this section here.html
003 Variables in Python.mp4
08:26
003 how-to-set-up-vscode-with-python.zip
004 String formatting in Python.mp4
06:26
005 Getting user input.mp4
05:16
005 formatting-numbers-for-printing-in-python.zip
006 Writing our first Python app.mp4
03:19
007 Lists, tuples and sets.mp4
06:31
008 Advanced set operations.mp4
04:39
008 python-set-operators.zip
009 Booleans in Python.mp4
05:00
010 If statements.mp4
08:17
011 The in keyword in Python.mp4
02:02
012 If statements with the in keyword.mp4
08:18
013 Loops in Python.mp4
11:07
014 List comprehensions in Python.mp4
07:24
015 Dictionaries.mp4
08:31
016 Destructuring variables.mp4
08:28
016 destructuring-in-python-teclado-blog.zip
017 Functions in Python.mp4
10:41
018 Function arguments and parameters.mp4
07:40
019 Default parameter values.mp4
03:54
020 Functions returning values.mp4
07:19
021 Lambda functions in Python.mp4
07:52
022 Dictionary comprehensions.mp4
04:01
023 Unpacking arguments.mp4
10:24
024 Unpacking keyword arguments.mp4
08:44
025 Object-Oriented Programming in Python.mp4
15:52
026 Magic methods _str_ and _repr_.mp4
06:25
027 @classmethod and @staticmethod.mp4
14:03
028 Class inheritance.mp4
08:32
029 Class composition.mp4
06:08
030 Type hinting in Python 3.5+.mp4
05:08
031 Imports in Python.mp4
09:33
032 Relative imports in Python.mp4
08:53
033 Errors in Python.mp4
12:47
034 Custom error classes.mp4
05:04
035 First-class functions.mp4
07:52
036 Simple decorators in Python.mp4
07:12
037 The 'at' syntax for decorators.mp4
03:33
038 Decorating functions with parameters.mp4
02:24
039 Decorators with parameters.mp4
04:50
040 Mutability in Python.mp4
06:03
041 Mutable default parameters (and why they're a bad idea).mp4
04:27
external-links.zip
001 Overview of the project.mp4
02:30
002 Creating our user menu.mp4
06:22
002 set-up-vscode-for-python-development.zip
003 What is SQL.mp4
05:42
003 how-to-set-up-vscode-with-python.zip
004 Using Python lists as an in-memory database.mp4
12:28
005 A SQLite data viewer.mp4
05:16
006 CREATE TABLE new tables with SQL.mp4
04:15
006 postgresql-data-types-official-documentation-.zip
006 sqlite-create-table-official-documentation-.zip
006 sqlite-data-types-official-documentation-.zip
007 How to write comments in SQL.html
008 CREATE TABLE exercises.html
009 How to connect to a SQLite database with Python.mp4
07:16
009 sql-transaction-w3resource-.zip
010 Connecting to SQLite in our app.mp4
03:23
011 What is a cursor.mp4
05:11
011 why-do-you-need-to-create-cursors-stackoverflow-.zip
012 INSERT INTO add data to a table.mp4
04:26
012 single-quotes-vs.double-quotes-in-databases-stackoverflow-.zip
012 sqlite-insert-into-official-documentation-.zip
013 INSERT INTO exercises.html
014 How to insert data into SQLite with Python.mp4
07:15
015 SELECT retrieve data from a table.mp4
02:40
015 the-select-command-in-sqlite.zip
016 SELECT exercises.html
017 Retrieving results from a cursor.mp4
07:38
017 what-is-the-purpose-of-row-factory-stackoverflow-.zip
018 WHERE search with SQL.mp4
07:03
019 WHERE exercises.html
020 DROP TABLE deleting entire tables.mp4
01:39
020 drop-table-in-sqlite-official-documentation-.zip
021 DROP TABLE exercise.html
022 What is a SQL injection attack.mp4
03:37
external-links.zip
001 Overview of the project.mp4
02:08
002 Three development stages of our project.mp4
04:15
003 Our starting code for this project.mp4
01:25
003 our-starting-code-for-this-project.zip
003 progdiary-starter.zip
004 Queries we'll need for the project to begin with.mp4
05:07
004 why-does-unix-time-start-at-1970-01-01-.zip
005 Write the database.py file.mp4
07:01
005 -ebook-using-context-managers-for-automatic-commit-and-rollback.zip
006 UPDATE changing data with SQL.mp4
03:35
006 the-sql-update-command-in-sqlite-official-documentation-.zip
006 -ebook-setting-movies-to-watched.zip
006 -ebook-update-updating-rows.zip
007 UPDATE exercises.html
008 Write our user menu and functions.mp4
11:45
008 how-to-work-with-dates-and-times-in-python.zip
008 watchlist-complete-stage-1.zip
009 Watched movies second approach.mp4
01:01
009 watchlist-complete-stage-2.zip
010 DELETE FROM removing rows with SQL.mp4
02:15
010 the-sql-delete-command-in-sqlite-official-documentation-.zip
011 DELETE FROM exercises.html
012 Stage 2 watching movies.mp4
07:56
013 Relational data primary and foreign keys.mp4
04:15
013 enabling-foreign-key-support-in-sqlite-official-documentation-.zip
013 -ebook-relational-data.zip
014 Relational data exercise.html
015 Watched movies final approach.mp4
02:52
015 watchlist-complete-stage-3.zip
016 Stage 3 adding new watched movies.mp4
08:49
016 destructuring-in-python.zip
017 Auto-incrementing row IDs.mp4
03:41
017 sqlite-autoincrement.zip
018 Auto-incrementing exercise.html
019 JOIN access two tables at once with SQL.mp4
03:16
020 Use JOINs to retrieve the movies a user has watched.mp4
08:52
021 Types of JOINs with examples.html
022 ORDER BY sort the returned table.mp4
01:51
023 LIMIT getting a certain number of rows.mp4
01:06
024 LIKE flexible searching.mp4
06:50
025 What is an index in SQL.mp4
04:46
026 Adding an index to our table for more efficient searching.mp4
04:27
external-links.zip
001 SQLite vs. PostgreSQL.mp4
04:27
001 foreign-key-constraints-official-documentation-.zip
002 How to install PostgreSQL.mp4
04:47
002 -ebook-how-to-install-postgresql.zip
003 How to run and access PostgreSQL.mp4
03:57
003 -ebook-how-to-run-and-access-postgresql.zip
004 binary-install-from-pypi-official-documentation-.zip
004 how-to-set-up-your-local-environment.zip
004 pipenv-cannot-install-psycopg2-binary-but-pip-can-py-3.8-.zip
004 psycopg2 vs psycopg2-binary.mp4
11:16
004 psycopg2-2.7.4-released-initd.org-.zip
004 psycopg2-binary-why-.zip
004 what-is-a-virtual-environment-.zip
005 How to store (and not store!) sensitive information in your code.mp4
08:21
006 Psycopg2 cursors and query parameters.mp4
04:56
006 the-with-statement-psycopg2-official-documentation-.zip
007 Auto-incrementing columns SEQUENCE and SERIAL in PostgreSQL.mp4
01:55
007 create-sequence-official-documentation-.zip
008 Our changed code, and finding differences between files.mp4
01:30
008 database.py-diff-between-sqlite-and-postgresql.zip
008 diffchecker-great-tool-.zip
external-links.zip
001 Overview of the project.mp4
03:06
001 making-an-online-voting-app-part-1-.zip
001 online-voting-app-part-2-.zip
002 What is ACID.mp4
03:57
002 can-a-database-support-atomicity-but-not-consistency-.zip
003 Essential queries we'll need for this project.mp4
09:38
003 formatting-numbers-for-printing-in-python.zip
003 poll-completed.zip
003 poll-starter.zip
004 RETURNING data from modified rows.mp4
06:34
004 fast-execution-helpers-psycopg2-official-documentation-.zip
004 returning-data-from-modified-rows-postgresql-official-documentation-.zip
005 Nested queries getting the latest poll.mp4
06:16
006 SQL built-in functions.mp4
04:20
006 aggregate-functions-in-postgresql-official-documentation-.zip
006 mathematical-functions-in-postgresql-official-documentation-.zip
007 GROUP BY and calculating vote percentages.mp4
12:13
007 aggregate-functions-in-postgresql-official-documentation-.zip
008 PostgreSQL window functions.mp4
05:45
009 PostgreSQL window functions (part 2).mp4
05:06
010 How to use ORDER BY with window functions.mp4
04:14
010 interactive-database-fiddle-for-this-chapter.zip
011 How to use PARTITION with window functions.mp4
04:18
011 more-postgresql-window-functions.zip
012 SQL DISTINCT and DISTINCT ON.mp4
06:33
013 The SQL HAVING clause.mp4
01:14
013 how-to-avoid-invoking-functions-twice-when-using-group-by-and-having-stackoverflow-.zip
014 SQL VIEW virtual tables.mp4
09:52
014 create-view-postgresql-official-documentation-.zip
014 view-examples-postgresql-official-documentation-.zip
015 33.libpq-c-library.zip
015 37.1.how-extensibility-works.zip
015 How to read the PostgreSQL documentation.mp4
08:10
015 sql-commands-reference.zip
016 Adding type hinting to our application.mp4
07:16
016 type-hinting-in-python-3.5-.zip
external-links.zip
001 How to separate our database entities into models.mp4
11:23
001 completed-poll-2-with-models.zip
001 diff-of-app.py-changes.zip
001 -ebook-separating-into-models.zip
002 Creating our Option model class.mp4
04:15
003 Changes needed in database.py.mp4
07:40
004 Changes needed in app.py.mp4
11:50
005 What is connection pooling.mp4
03:56
006 How to create a connection pool with psycopg2.mp4
05:51
007 Reduce pooling duplication with context managers.mp4
05:03
007 completed-poll-3-with-context-managers.zip
007 how-to-write-decorators-in-python.zip
007 the-curious-case-of-pythons-context-manager.zip
007 what-does-the-yield-keyword-do-stackoverflow-.zip
008 Reduce cursor creation duplication with context managers.mp4
02:57
009 The Python datetime module.mp4
04:41
009 how-to-work-with-dates-and-times-in-python.zip
009 python-strftime-reference.zip
010 How to calculate new dates with timedelta.mp4
03:04
011 How to handle timezones with pytz.mp4
10:24
011 pytz-official-documentation.zip
011 timezonedb-free-timezone-database.zip
011 what-are-timezones-.zip
012 How to save dates to PostgreSQL.mp4
08:25
013 Add the vote date to our polling app.mp4
08:28
013 completed-poll-4-with-dates.zip
external-links.zip
001 Composite primary keys.mp4
02:58
001 foreign-keys-postgresql-official-documentation-.zip
001 primary-keys-postgresql-official-documentation-.zip
002 User-defined functions in PostgreSQL.mp4
09:16
002 create-function-postgresql-official-documentation-.zip
002 interactive-database-for-this-lecture.zip
002 pl-pgsql-function-parameters-postgresql-tutorial-.zip
002 query-language-sql-functions-postgresql-official-documentation-.zip
002 user-defined-functions-postgresql-official-documentation-.zip
003 Composite types and sets in functions.mp4
07:47
003 interactive-database-for-this-lecture.zip
003 postgresql-create-function-statement-postgresql-tutorial-.zip
003 query-language-sql-functions-postgresql-official-documentation-.zip
004 Stored procedures in PostgreSQL.mp4
05:25
004 postgresql-stored-procedures-carto.com-.zip
004 postgresql-stored-procedures-postgresql-tutorial-.zip
004 user-defined-functions-postgresql-official-documentation-.zip
004 what-is-acid-our-e-book-.zip
005 Connections vs transactions in psycopg2.mp4
03:28
005 how-to-work-with-postgresql-transactions-enterprisedb-.zip
005 postgresql-if-i-run-multiple-queries-concurrently.stackoverflow-.zip
006 Locking in PostgreSQL.mp4
08:56
006 advisory-locks-postgresql-official-documentation-.zip
006 deadlocks-postgresql-official-documentation-.zip
006 lock-postgresql-official-documentation-.zip
006 postgresql-conflicting-lock-modes.zip
006 postgresql-rocks-except-when-it-blocks-understanding-locks-citusdata-.zip
006 select-postgresql-official-documentation-.zip
006 viewing-locks-postgresql-official-documentation-.zip
007 Asynchronous psycopg2.mp4
01:39
007 aiopg-official-documentation-.zip
007 thread-and-process-safety-psycopg2-official-documentation-.zip
008 SQL string composition with psycopg2.mp4
04:40
008 psycopg2.sql-sql-string-composition-psycopg2-official-documentation-.zip
external-links.zip
001 Overview creating graphs from poll data.mp4
02:28
002 How to install matplotlib.html
002 installation-official-documentation-.zip
003 How to draw a line graph with matplotlib.mp4
04:35
003 matplotlib.pyplot.plot-official-documentation-.zip
004 Matplotlib backends.html
004 usage-guide-backends-official-documentation-.zip
005 Matplotlib figures, axes, and plots.mp4
03:56
006 The Object-Oriented Approach with matplotlib.mp4
03:25
007 How to add multiple subplots to a figure.mp4
04:39
008 How to draw a pie chart with matplotlib.mp4
13:27
009 How to draw a bar chart with matplotlib.mp4
05:26
010 How to adjust the size of a matplotlib plot.mp4
03:25
011 How to adjust the x axis tick labels so they fit in the screen.mp4
05:11
012 How to draw a stacked bar chart with matplotlib.mp4
06:20
013 How to create a legend from your graphed data.mp4
02:44
014 How to export an image with matplotlib.mp4
07:42
015 How to create one document with multiple matplotlib plots.mp4
02:45
016 How to create a custom legend with matplotlib.mp4
03:02
external-links.zip
Description
Take the next step in your Python development by leveraging the power of PostgreSQL and databases!
What You'll Learn?
- How to leverage the power of databases (in-memory, SQLite, and PostgreSQL) to upgrade your Python applications
- Prevent common pitfalls: avoid SQL injection attacks, store database credentials securely, and optimize the performance of your applications
- Understand how databases work and how to take advantage of their features from the ground up, by building multiple projects
- This is a no-nonsense, no-frills course on fully mastering PostgreSQL and how to use it effective within and outside of your Python apps
- Learn how to work with dates and times effectively in Python applications
- Produce engaging charts, graphs, and reports using database data
Who is this for?
More details
DescriptionMaster PostgreSQL and use it in your Python apps!
Python and PostgreSQL are two of the most in-demand skills in the world. After completing this course, you'll be confident in adding both to your resume/CV.
Everything you'll learn in this course is relevant to other database systems too, like MySQL, Microsoft SQL Server, or Oracle.
With this course, you'll master PostgreSQL and how to work with it from Python. If you use Python and you want to augment your skills with a database, you'll love this course!
You will:
Work with different types of databases (in-memory, SQLite, and PostgreSQL), and understand when to use each in your Python apps.
Build a programming journal project to add a SQLite database to your Python application.
Improve a database design incrementally so you're not bound by your initial design.
Model different relationships with PostgreSQL, including one-to-many and many-to-many.
Reduce errors by applying database changes using database migrations with Python and alembic.
Build a polling app to learn about advanced data analysis with GROUP BY, PostgreSQL window functions, and nested queries.
Work with dates and times in PostgreSQL, and avoid common timezone pitfalls.
Structure Python apps like a professional, to make development much easier.
Produce data analysis reports and charts using matplotlib with PostgreSQL data.
You'll also tackle advanced PostgreSQL topics, such as:
User-Defined Functions
Stored Procedures
Locking
Async database connections
As you can see, you're going to learn a lot!
But this is a no-nonsense, no-frills course. We have planned, crafted, and edited every lecture to be concise and compact. No time wasted, so you can master PostgreSQL in record time.
We've created dozens of diagrams to explain database concepts, as well as code-along videos. But you won't just be watching me code! You'll develop the projects yourself first, to gain hands-on experience and master PostgreSQL.
Also, throughout the course, I provide data sets with challenges and exercises for you to practice what you've learned.
I've been teaching and helping students online for over 8 years, and this course is the culmination of my teaching experience. I know how to help you understand concepts fully and quickly, in the best way for you.
When you complete this course you'll be able to:
Extend your Python applications with database functionality using PostgreSQL.
Answer complex questions using data and generate reports.
List PostgreSQL as one of your strongest skills.
Check out the free preview videos for more information and to try out the course!
I'll see you on the inside!
Who this course is for:
- Beginner Python developers who want to take the next step in upgrading their applications by leveraging the power of databases.
- Any Python developer who is not familiar with databases and wants to fully understand their choices before using one in their applications
- Business analysis and data scientists who want to create larger applications or interact with larger data sets through a database
Master PostgreSQL and use it in your Python apps!
Python and PostgreSQL are two of the most in-demand skills in the world. After completing this course, you'll be confident in adding both to your resume/CV.
Everything you'll learn in this course is relevant to other database systems too, like MySQL, Microsoft SQL Server, or Oracle.
With this course, you'll master PostgreSQL and how to work with it from Python. If you use Python and you want to augment your skills with a database, you'll love this course!
You will:
Work with different types of databases (in-memory, SQLite, and PostgreSQL), and understand when to use each in your Python apps.
Build a programming journal project to add a SQLite database to your Python application.
Improve a database design incrementally so you're not bound by your initial design.
Model different relationships with PostgreSQL, including one-to-many and many-to-many.
Reduce errors by applying database changes using database migrations with Python and alembic.
Build a polling app to learn about advanced data analysis with GROUP BY, PostgreSQL window functions, and nested queries.
Work with dates and times in PostgreSQL, and avoid common timezone pitfalls.
Structure Python apps like a professional, to make development much easier.
Produce data analysis reports and charts using matplotlib with PostgreSQL data.
You'll also tackle advanced PostgreSQL topics, such as:
User-Defined Functions
Stored Procedures
Locking
Async database connections
As you can see, you're going to learn a lot!
But this is a no-nonsense, no-frills course. We have planned, crafted, and edited every lecture to be concise and compact. No time wasted, so you can master PostgreSQL in record time.
We've created dozens of diagrams to explain database concepts, as well as code-along videos. But you won't just be watching me code! You'll develop the projects yourself first, to gain hands-on experience and master PostgreSQL.
Also, throughout the course, I provide data sets with challenges and exercises for you to practice what you've learned.
I've been teaching and helping students online for over 8 years, and this course is the culmination of my teaching experience. I know how to help you understand concepts fully and quickly, in the best way for you.
When you complete this course you'll be able to:
Extend your Python applications with database functionality using PostgreSQL.
Answer complex questions using data and generate reports.
List PostgreSQL as one of your strongest skills.
Check out the free preview videos for more information and to try out the course!
I'll see you on the inside!
Who this course is for:
- Beginner Python developers who want to take the next step in upgrading their applications by leveraging the power of databases.
- Any Python developer who is not familiar with databases and wants to fully understand their choices before using one in their applications
- Business analysis and data scientists who want to create larger applications or interact with larger data sets through a database
User Reviews
Rating
average 0
Focused display
Category
Jose Salvatierra
Instructor's CoursesHi, I'm Jose! I love helping students learn to code and master software development. I've been teaching online for over 7 years, and I founded Teclado to bring software development to everyone—my objective is for you to truly understand everything that goes on behind the scenes.Coding is extremely rewarding. As you learn, things start to click and make sense. You can join the dots of all the things that weren't quite clear before. I'm here to make that journey quick and painless!I can help you with Python and JavaScript issues, particularly in web and backend development. I'm experienced with programming libraries and frameworks like Flask, React, React Native, and AngularJS. I've worked extensively with UNIX systems, MongoDB, PostgreSQL, and advanced system architecture design.
Teclado by Jose Salvatierra
Instructor's CoursesTeclado was founded by best-selling instructor Jose Salvatierra to bring software development to everyone. We create and develop great, informative, and fun courses for you to advance your career and acquire new skills.Excellent quality, superb student support, and on-demand topics mark our courses. We hope to see you on the inside!
Codestars • over 2 million students worldwide!
Instructor's CoursesBest-selling Udemy instructor Rob Percival wants to revolutionize the way people learn to code by making it simple, logical, fun and, above all, accessible. But as just one man, Rob couldn’t create all the courses his students - more than half a million of them - wanted.
That’s why Rob created Codestars. Together, the instructors that make up the Codestars team create courses on all the topics that students want to learn in the way that students want to learn them: courses that are well-structured, super interactive, and easy to understand. Codestars wants to make it as easy as possible for learners of all ages and levels to build functional websites and apps.
Udemy
View courses UdemyStudents take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.
- language english
- Training sessions 137
- duration 13:31:23
- Release Date 2022/12/24
