The Complete Python/PostgreSQL Course 2.0

BY
Udemy

Utilize the power of PostgreSQL and databases to build advanced and dynamic python programs with The Complete Python/PostgreSQL Course 2.0.

Mode

Online

Fees

₹ 699 4099

Quick Facts

particular details
Medium of instructions English
Mode of learning Self study
Mode of Delivery Video and Text Based

Course overview

The Complete Python/PostgreSQL Course 2.0 certification course is created by Codestars by Rob Percival - Teaching the Next Generation of Coders, Teclado by Jose Salvatierra - Software Development For Everyone, and Jose Salvatierra - Founder of Teclado and Software Engineer and is offered by Udemy Inc., an online learning platform that aides amateurs in learning new skills and knowledge and professional people in enhancing their competencies to enhance their skills.

The Complete Python/PostgreSQL Course 2.0 online course is designed for individuals who want to improve their database skills, learn about PostgreSQL and use it from Python. Learners will be skilled enough to apply their learning in other database systems such as MySQL, Microsoft SQL Server, and Oracle.

The Complete Python/PostgreSQL Course 2.0 online training is focused to help the learners get an understanding of the following topics such as user-defined functions, stored procedures, locking, and async database connections of advanced PostgreSQL.  The interested learners could enrol on the course by paying the fee. Early birds will be given a discount if available.  

The highlights

  • Certificate of completion
  • Self-paced course
  • English videos with multi-language subtitles
  • 13.5 hours of pre-recorded video content
  • Online programme
  • 30-day money-back guarantee
  • Unlimited access
  • Accessible on mobile devices and TV

Program offerings

  • Certificate of completion
  • Self-paced course
  • English videos with multi-language subtitles
  • 13.5 hours of pre-recorded video content
  • 16 articles
  • 10 downloadable resources
  • 30-day money-back guarantee
  • Unlimited access

Course and certificate fees

Fees information
₹ 699  ₹4,099
certificate availability

Yes

certificate providing authority

Udemy

What you will learn

Data science knowledge Knowledge of python

After completing The Complete Python/PostgreSQL Course 2.0 online certification, learners will get an understanding of using PostgreSQL, integrating database functionality to any Python application, using data to answer tough queries and produce reports, to develop skills in PostgreSQL. Learners will have an understanding of working on databases and taking advantage of their features to build multiple projects, working with dates and times in Python, and creating charts, graphs, and reports using the data provided by the database.

The syllabus

Introduction

  • Welcome to this Course!
  • Initial setup (for newer Pythonistas)
  • Get the complete e-book here

A Full Python Refresher

  • Introduction to this section
  • Access the code for this section here
  • Variables in Python 
  • String formatting in Python
  • Getting user input
  • Writing our first Python app
  • Lists, tuples and sets
  • Advanced set operations
  • Booleans in Python
  • If statements
  • The "in" keyword in Python
  • If statements with the "in" keyword
  • Loops in Python
  • List comprehensions in Python
  • Dictionaries
  • Destructuring variables
  • Functions in Python
  • Function arguments and parameters
  • Default parameter values
  • Functions returning values
  • Lambda functions in Python
  • Dictionary comprehensions
  • Unpacking arguments
  • Unpacking keyword arguments
  • Object-Oriented Programming in Python
  • Magic methods: _str_ and _repr_
  • @classmethod and @staticmethod
  • Class inheritance
  • Class composition
  • Type hinting in Python 3.5+
  • Imports in Python
  • Relative imports in Python
  • Errors in Python
  • Custom error classes
  • First-class functions
  • Simple decorators in Python
  • The 'at' syntax for decorators
  • Decorating functions with parameters
  • Decorators with parameters
  • Mutability in Python
  • Mutable default parameters (and why they're a bad idea)

Build a Programming Journal with Python & SQL

  • Overview of the Project
  • Creating Our User Menu
  • What is SQL?
  • Using Python Lists as an in-memory database 
  • A SQLite data viewer
  • CREATE TABLE: new tables with SQL
  • How to write comments in SQL
  • CREATE TABLE exercises
  • How to connect to a SQLite database with Python
  • Connecting to SQLite in our app
  • What is a cursor?
  • INSERT INTO: add data to a table
  • INSERT INTO exercises
  • How to insert data into SQLite with Python
  • SELECT: retrieve data from a table
  • SELECT exercises
  • Retrieving results from a cursor
  • WHERE: search with SQL
  • WHERE exercises
  • DROP TABLE: deleting entire tables
  • DROP TABLE exercise
  • What is a SQL injection attack?

A Movie Watchlist App with Python & SQL

  • Overview of the project
  • Three development stages of our project
  • Our starting code for this project
  • Queries we'll need for the project to begin with
  • Write the database.py file
  • UPDATE: changing data with SQL
  • UPDATE exercises
  • Write our user menu and functions
  • Watched movies: second approach
  • DELETE FROM: removing rows with SQL
  • DELETE FROM exercises
  • Stage 2: watching movies
  • Relational data: primary and foreign keys
  • Relational data exercise
  • Watched movies: final approach
  • Stage 3: adding new watched movies
  • Auto-incrementing row IDs
  • Auto-incrementing exercise
  • JOIN: access two tables at once with SQL
  • Use JOINs to retrieve the movies a user has watched
  • Types of JOINs with examples
  • ORDER BY: sort the returned table
  • LIMIT: getting a certain number of rows
  • LIKE: flexible searching
  • What is an index in SQL?
  • Adding an index to our table for more efficient searching

Introduction to PostgreSQL: Migrating our App

  • SQLite vs. PostgreSQL
  • How to install PostgreSQL
  • How to run and access PostgreSQL
  • psycopg2 vs psycopg2-binary
  • How to store (and not store!) sensitive information in your code
  • Psycopg2 cursors and query parameters
  • Auto-incrementing columns: SEQUENCE and SERIAL in PostgreSQL
  • Our changed code, and finding differences between files

Building a Poll App & Advanced SQL

  • Overview of the project
  • What is ACID?
  • Essential queries we'll need for this project
  • RETURNING data from modified rows
  • Nested queries: getting the latest poll
  • SQL built-in functions
  • GROUP BY and calculating vote percentages
  • PostgreSQL window functions
  • PostgreSQL window functions (part 2)
  • How to use ORDER BY with window functions
  • How to use PARTITION with window functions
  • SQL DISTINCT and DISTINCT ON
  • The SQL HAVING clause
  • SQL VIEW: virtual tables
  • How to read the PostgreSQL documentation
  • Adding type hinting to our application

Working with dates and times

  • How to separate our database entities into models
  • Creating our Option model class
  • Changes needed in database.py
  • Changes needed in app.py
  • What is connection pooling?
  • How to create a connection pool with psycopg2
  • Reduce pooling duplication with context managers
  • Reduce cursor creation duplication with context managers
  • The Python datetime module
  • How to calculate new dates with timedelta
  • How to handle timezones with pytz
  • How to save dates to PostgreSQL
  • Add the vote date to our polling app

Python and Advanced PostgreSQL with psycopg2

  • Composite primary keys
  • User-defined functions in PostgreSQL
  • Composite types and sets in functions
  • Stored procedures in PostgreSQL
  • Connections vs transactions in psycopg2
  • Locking in PostgreSQL
  • Asynchronous psycopg2
  • SQL string composition with psycopg2

Charting data from our tables using matplotlib

  • Overview: creating graphs from poll data
  • How to install matplotlib
  • How to draw a line graph with matplotlib
  • Matplotlib backends
  • Matplotlib figures, axes, and plots
  • The Object-Oriented Approach with matplotlib
  • How to add multiple subplots to a figure
  • How to draw a pie chart with matplotlib
  • How to draw a bar chart with matplotlib
  • How to adjust the size of a matplotlib plot
  • How to adjust the x axis tick labels so they fit in the screen
  • How to draw a stacked bar chart with matplotlib
  • How to create a legend from your graphed data
  • How to export an image with matplotlib
  • How to create one document with multiple matplotlib plots
  • How to create a custom legend with matplotlib

Instructors

Mr Jose Salvatierra
Software Engineer
Udemy

Articles

Popular Articles

Latest Articles

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books