The Complete Python/PostgreSQL Course 2.0

سرفصل های دوره

Take the next step in your Python development by leveraging the power of PostgreSQL and databases!

01 - Introduction

001 Welcome to this course!

002 Initial setup (for newer Pythonistas).html

003 Get the complete e-book here.html

02 - A Full Python Refresher

001 Introduction to this section

002 Access the code for this section here.html

003 Variables in Python

003 how-to-set-up-vscode-with-python.zip

004 String formatting in Python

005 Getting user input

005 formatting-numbers-for-printing-in-python.zip

006 Writing our first Python app

007 Lists, tuples and sets

008 Advanced set operations

008 python-set-operators.zip

009 Booleans in Python

010 If statements

011 The in keyword in Python

012 If statements with the in keyword

013 Loops in Python

014 List comprehensions in Python

015 Dictionaries

016 Destructuring variables

016 destructuring-in-python-teclado-blog.zip

017 Functions in Python

018 Function arguments and parameters

019 Default parameter values

020 Functions returning values

021 Lambda functions in Python

022 Dictionary comprehensions

023 Unpacking arguments

024 Unpacking keyword arguments

025 Object-Oriented Programming in Python

026 Magic methods _str_ and _repr_

027 @classmethod and @staticmethod

028 Class inheritance

029 Class composition

030 Type hinting in Python 3.5+

031 Imports in Python

032 Relative imports in Python

033 Errors in Python

034 Custom error classes

035 First-class functions

036 Simple decorators in Python

037 The 'at' syntax for decorators

038 Decorating functions with parameters

039 Decorators with parameters

040 Mutability in Python

041 Mutable default parameters (and why they're a bad idea)

external-links.zip

03 - Build a Programming Journal with Python & SQL

001 Overview of the project

002 Creating our user menu

002 set-up-vscode-for-python-development.zip

003 What is SQL

003 how-to-set-up-vscode-with-python.zip

004 Using Python lists as an in-memory database

005 A SQLite data viewer

006 CREATE TABLE new tables with SQL

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

009 sql-transaction-w3resource-.zip

010 Connecting to SQLite in our app

011 What is a cursor

011 why-do-you-need-to-create-cursors-stackoverflow-.zip

012 INSERT INTO add data to a table

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

015 SELECT retrieve data from a table

015 the-select-command-in-sqlite.zip

016 SELECT exercises.html

017 Retrieving results from a cursor

017 what-is-the-purpose-of-row-factory-stackoverflow-.zip

018 WHERE search with SQL

019 WHERE exercises.html

020 DROP TABLE deleting entire tables

020 drop-table-in-sqlite-official-documentation-.zip

021 DROP TABLE exercise.html

022 What is a SQL injection attack

external-links.zip

04 - A Movie Watchlist App with Python & SQL

001 Overview of the project

002 Three development stages of our project

003 Our starting code for this project

003 our-starting-code-for-this-project.zip

003 progdiary-starter.zip

004 Queries we'll need for the project to begin with

004 why-does-unix-time-start-at-1970-01-01-.zip

005 Write the database.py file

005 -ebook-using-context-managers-for-automatic-commit-and-rollback.zip

006 UPDATE changing data with SQL

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

008 how-to-work-with-dates-and-times-in-python.zip

008 watchlist-complete-stage-1.zip

009 Watched movies second approach

009 watchlist-complete-stage-2.zip

010 DELETE FROM removing rows with SQL

010 the-sql-delete-command-in-sqlite-official-documentation-.zip

011 DELETE FROM exercises.html

012 Stage 2 watching movies

013 Relational data primary and foreign keys

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

015 watchlist-complete-stage-3.zip

016 Stage 3 adding new watched movies

016 destructuring-in-python.zip

017 Auto-incrementing row IDs

017 sqlite-autoincrement.zip

018 Auto-incrementing exercise.html

019 JOIN access two tables at once with SQL

020 Use JOINs to retrieve the movies a user has watched

021 Types of JOINs with examples.html

022 ORDER BY sort the returned table

023 LIMIT getting a certain number of rows

024 LIKE flexible searching

025 What is an index in SQL

026 Adding an index to our table for more efficient searching

external-links.zip

05 - Introduction to PostgreSQL Migrating our App

001 SQLite vs. PostgreSQL

001 foreign-key-constraints-official-documentation-.zip

002 How to install PostgreSQL

002 -ebook-how-to-install-postgresql.zip

003 How to run and access PostgreSQL

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

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

006 Psycopg2 cursors and query parameters

006 the-with-statement-psycopg2-official-documentation-.zip

007 Auto-incrementing columns SEQUENCE and SERIAL in PostgreSQL

007 create-sequence-official-documentation-.zip

008 Our changed code, and finding differences between files

008 database.py-diff-between-sqlite-and-postgresql.zip

008 diffchecker-great-tool-.zip

external-links.zip

06 - Building a Poll App & Advanced SQL

001 Overview of the project

001 making-an-online-voting-app-part-1-.zip

001 online-voting-app-part-2-.zip

002 What is ACID

002 can-a-database-support-atomicity-but-not-consistency-.zip

003 Essential queries we'll need for this project

003 formatting-numbers-for-printing-in-python.zip

003 poll-completed.zip

003 poll-starter.zip

004 RETURNING data from modified rows

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

006 SQL built-in functions

006 aggregate-functions-in-postgresql-official-documentation-.zip

006 mathematical-functions-in-postgresql-official-documentation-.zip

007 GROUP BY and calculating vote percentages

007 aggregate-functions-in-postgresql-official-documentation-.zip

008 PostgreSQL window functions

009 PostgreSQL window functions (part 2)

010 How to use ORDER BY with window functions

010 interactive-database-fiddle-for-this-chapter.zip

011 How to use PARTITION with window functions

011 more-postgresql-window-functions.zip

012 SQL DISTINCT and DISTINCT ON

013 The SQL HAVING clause

013 how-to-avoid-invoking-functions-twice-when-using-group-by-and-having-stackoverflow-.zip

014 SQL VIEW virtual tables

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

015 sql-commands-reference.zip

016 Adding type hinting to our application

016 type-hinting-in-python-3.5-.zip

external-links.zip

07 - Working with dates and times

001 How to separate our database entities into models

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

003 Changes needed in database.py

004 Changes needed in app.py

005 What is connection pooling

006 How to create a connection pool with psycopg2

007 Reduce pooling duplication with context managers

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

009 The Python datetime module

009 how-to-work-with-dates-and-times-in-python.zip

009 python-strftime-reference.zip

010 How to calculate new dates with timedelta

011 How to handle timezones with pytz

011 pytz-official-documentation.zip

011 timezonedb-free-timezone-database.zip

011 what-are-timezones-.zip

012 How to save dates to PostgreSQL

013 Add the vote date to our polling app

013 completed-poll-4-with-dates.zip

external-links.zip

08 - Python and Advanced PostgreSQL with psycopg2

001 Composite primary keys

001 foreign-keys-postgresql-official-documentation-.zip

001 primary-keys-postgresql-official-documentation-.zip

002 User-defined functions in PostgreSQL

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

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

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

005 how-to-work-with-postgresql-transactions-enterprisedb-.zip

005 postgresql-if-i-run-multiple-queries-concurrently.stackoverflow-.zip

006 Locking in PostgreSQL

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

007 aiopg-official-documentation-.zip

007 thread-and-process-safety-psycopg2-official-documentation-.zip

008 SQL string composition with psycopg2

008 psycopg2.sql-sql-string-composition-psycopg2-official-documentation-.zip

external-links.zip

09 - Charting data from our tables using matplotlib

001 Overview creating graphs from poll data

002 How to install matplotlib.html

002 installation-official-documentation-.zip

003 How to draw a line graph with matplotlib

003 matplotlib.pyplot.plot-official-documentation-.zip

004 Matplotlib backends.html

004 usage-guide-backends-official-documentation-.zip

005 Matplotlib figures, axes, and plots

006 The Object-Oriented Approach with matplotlib

007 How to add multiple subplots to a figure

008 How to draw a pie chart with matplotlib

009 How to draw a bar chart with matplotlib

010 How to adjust the size of a matplotlib plot

011 How to adjust the x axis tick labels so they fit in the screen

012 How to draw a stacked bar chart with matplotlib

013 How to create a legend from your graphed data

014 How to export an image with matplotlib

015 How to create one document with multiple matplotlib plots

016 How to create a custom legend with matplotlib

external-links.zip

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training