The Complete Python/PostgreSQL Course 2.0

The Complete Python/PostgreSQL Course 2.0, available at $89.99, has an average rating of 4.7, with 155 lectures, based on 1931 reviews, and has 14607 subscribers.

You will learn about 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 This course is ideal for individuals who are Beginner Python developers who want to take the next step in upgrading their applications by leveraging the power of databases. or Any Python developer who is not familiar with databases and wants to fully understand their choices before using one in their applications or Business analysis and data scientists who want to create larger applications or interact with larger data sets through a database It is particularly useful for Beginner Python developers who want to take the next step in upgrading their applications by leveraging the power of databases. or Any Python developer who is not familiar with databases and wants to fully understand their choices before using one in their applications or Business analysis and data scientists who want to create larger applications or interact with larger data sets through a database.

Enroll now: The Complete Python/PostgreSQL Course 2.0

Summary

Title: The Complete Python/PostgreSQL Course 2.0

Price: $89.99

Average Rating: 4.7

Number of Lectures: 155

Number of Published Lectures: 155

Number of Curriculum Items: 155

Number of Published Curriculum Objects: 155

Original Price: $199.99

Quality Status: approved

Status: Live

What You Will 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 Should Attend

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

Target Audiences

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!

Course Curriculum

Chapter 1: Introduction

Lecture 1: Welcome to this course!

Lecture 2: Initial setup (for newer Pythonistas)

Lecture 3: Get the complete e-book here

Chapter 2: A Full Python Refresher

Lecture 1: Introduction to this section

Lecture 2: Access the code for this section here

Lecture 3: Variables in Python

Lecture 4: String formatting in Python

Lecture 5: Getting user input

Lecture 6: Writing our first Python app

Lecture 7: Lists, tuples and sets

Lecture 8: Advanced set operations

Lecture 9: Booleans in Python

Lecture 10: If statements

Lecture 11: The "in" keyword in Python

Lecture 12: If statements with the "in" keyword

Lecture 13: Loops in Python

Lecture 14: List comprehensions in Python

Lecture 15: Dictionaries

Lecture 16: Destructuring variables

Lecture 17: Functions in Python

Lecture 18: Function arguments and parameters

Lecture 19: Default parameter values

Lecture 20: Functions returning values

Lecture 21: Lambda functions in Python

Lecture 22: Dictionary comprehensions

Lecture 23: Unpacking arguments

Lecture 24: Unpacking keyword arguments

Lecture 25: Object-Oriented Programming in Python

Lecture 26: Magic methods: _str_ and _repr_

Lecture 27: @classmethod and @staticmethod

Lecture 28: Class inheritance

Lecture 29: Class composition

Lecture 30: Type hinting in Python 3.5+

Lecture 31: Imports in Python

Lecture 32: Relative imports in Python

Lecture 33: Errors in Python

Lecture 34: Custom error classes

Lecture 35: First-class functions

Lecture 36: Simple decorators in Python

Lecture 37: The 'at' syntax for decorators

Lecture 38: Decorating functions with parameters

Lecture 39: Decorators with parameters

Lecture 40: Mutability in Python

Lecture 41: Mutable default parameters (and why they're a bad idea)

Chapter 3: Build a Programming Journal with Python & SQL

Lecture 1: Overview of the project

Lecture 2: Creating our user menu

Lecture 3: What is SQL?

Lecture 4: Using Python lists as an in-memory database

Lecture 5: A SQLite data viewer

Lecture 6: CREATE TABLE: new tables with SQL

Lecture 7: How to write comments in SQL

Lecture 8: CREATE TABLE exercises

Lecture 9: How to connect to a SQLite database with Python

Lecture 10: Connecting to SQLite in our app

Lecture 11: What is a cursor?

Lecture 12: INSERT INTO: add data to a table

Lecture 13: INSERT INTO exercises

Lecture 14: How to insert data into SQLite with Python

Lecture 15: SELECT: retrieve data from a table

Lecture 16: SELECT exercises

Lecture 17: Retrieving results from a cursor

Lecture 18: WHERE: search with SQL

Lecture 19: WHERE exercises

Lecture 20: DROP TABLE: deleting entire tables

Lecture 21: DROP TABLE exercise

Lecture 22: What is a SQL injection attack?

Chapter 4: A Movie Watchlist App with Python & SQL

Lecture 1: Overview of the project

Lecture 2: Three development stages of our project

Lecture 3: Our starting code for this project

Lecture 4: Queries we'll need for the project to begin with

Lecture 5: Write the database.py file

Lecture 6: UPDATE: changing data with SQL

Lecture 7: UPDATE exercises

Lecture 8: Write our user menu and functions

Lecture 9: Watched movies: second approach

Lecture 10: DELETE FROM: removing rows with SQL

Lecture 11: DELETE FROM exercises

Lecture 12: Stage 2: watching movies

Lecture 13: Relational data: primary and foreign keys

Lecture 14: Relational data exercise

Lecture 15: Watched movies: final approach

Lecture 16: Stage 3: adding new watched movies

Lecture 17: Auto-incrementing row IDs

Lecture 18: Auto-incrementing exercise

Lecture 19: JOIN: access two tables at once with SQL

Lecture 20: Use JOINs to retrieve the movies a user has watched

Lecture 21: Types of JOINs with examples

Lecture 22: ORDER BY: sort the returned table

Lecture 23: LIMIT: getting a certain number of rows

Lecture 24: LIKE: flexible searching

Lecture 25: What is an index in SQL?

Lecture 26: Adding an index to our table for more efficient searching

Chapter 5: Introduction to PostgreSQL: Migrating our App

Lecture 1: SQLite vs. PostgreSQL

Lecture 2: How to install PostgreSQL

Lecture 3: How to run and access PostgreSQL

Instructors

Codestars • over 2 million students worldwide!
Teaching the Next Generation of Coders
Jose Salvatierra
Founder of Teclado and Software Engineer
Teclado by Jose Salvatierra
Software Development For Everyone

Rating Distribution

1 stars: 19 votes
2 stars: 21 votes
3 stars: 110 votes
4 stars: 604 votes
5 stars: 1177 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu