Udemy – The Complete Python/PostgreSQL Course 2.0 2020-6

Description

The Complete Python / PostgreSQL Course 2.0 is a PostgreSQL database management system tutorial for building and using databases in Python-based applications. Python and PostgreSQL are the two most in-demand skills in the world. The focus of this training is on these two skills. With this tutorial, you will gain a thorough understanding of PostgreSQL and then learn how to integrate this system with your Python-based applications. PostgreSQL tutorials in this course will apply not only to this system but also to other database management systems such as MySQL, Microsoft SQL Server and Amazon Redshift. During this tutorial, with the help of various moving diagrams that have been designed, concepts and communications in a database have been well illustrated and made easier to understand.

This course enables you to add a data storage location to your Python applications using PostgreSQL and SQLite, and learn the difference between using different types of databases. Two sample applications are also included in this course: building a SQLite-based movie watchlist to learn how to build all kinds of relationships between data, then changing the program to comply with PostgreSQL to learn the difference between the two systems, and building a survey application to learn data analysis. Advanced with the help of GROUP BY tools, PostgreSQL window functions and nested queries. More advanced topics and concepts in SQL and PostgreSQL, such as user-defined functions, stored procedures, flipping, and asynchronous database connections are other topics in this course.

What do you learn?

Upgrade Python-based applications with a variety of databases such as in-memory, SQLite, PostgreSQL

Understand how the database works and how to use it usefully

Efficient use of date and time in Python-assisted databases

Avoid general vulnerabilities such as SQL injection attacks, secure credit storage, and

Create charts, graphs and reports with the help of database data

This training is suitable for people who

Beginner Python developers who want to upgrade their applications with database power

All Python developers unfamiliar with databases, applications, and how to use them

Business analysts and data science professionals who need to build large applications or work with big data

Specifications of The Complete Python / PostgreSQL Course 2.0

Publisher: Udemy

Teacher: Codestars by Rob Percival, Jose Salvatierra, Teclado by Jose Salvatierra

English language

Level of education: Intermediate

Number of lessons: 153 lessons in 9 sections

Duration: 13h 39m

Prerequisites

Foundational Python knowledge is required (a Python refresher is provided), as the course focuses on using PostgreSQL with Python

A Python editor or IDE, such as Visual Studio Code or PyCharm

You don’t need to install anything more for this course, everything we do is on the cloud (although guidance to do it locally is also provided)

Installation

After Extract, watch with your favorite Player.

English subtitle

Quality: 720p