Write SQL Queries for Data Analysis and Manipulation on PostgreSQL Databases


SQL stands for Structured Query Language. It is one of the most in-demand tech skills in the world.


What Can SQL do?


SQL lets you access and manipulate databases


SQL can execute queries against a database


SQL can retrieve data from a database


SQL can insert records in a database


SQL can update records in a database


SQL can delete records from a database


SQL can create new databases


SQL can create new tables in a database


SQL can create stored procedures in a database


SQL can filter data returned from a database


SQL can sort data returned by a database.


SQL can be used to truncate and drop tables.




PostgreSQL is a powerful, open source object-relational database management system.


PostgreSQL is an advanced, enterprise-class, and open-source relational database system. PostgreSQL supports both SQL (relational) and JSON (non-relational) querying.


PostgreSQL is a highly stable database backed by more than 20 years of development by the open-source community.


PostgreSQL is used as a primary database for many web applications as well as mobile and analytics applications.




What You Will Learn


Perform CRUD Operations


PostgreSQL Database Objects


Database Concepts


Creating a database using PostgreSQL GUI


Creating tables with PostgreSQL GUI and SQL Commands


Inserting Data into tables


Query and read data stored inside a table


Filter and Sort data from a table


Using Sub query to retrieve data


Updating existing data stored inside a database


Query and eliminate duplicate records


Deleting records stored inside database


Truncating a database table


Dropping a database table


Implementing Stored Procedure


Joining and querying data from multiple tables


Using various aggregate functions and grouping data


Using various Operators to query data


Using various Analytic Functions

Who this course is for:

Beginners to SQL

Beginners to PostgreSQL

Beginners to Databases

[maxbutton id=”1″ url=”https://www.udemy.com/course/sql-with-postgresql-for-beginners-analyze-manipulate-data/?ranMID=39197&ranEAID=*7W41uFlkSs&ranSiteID=.7W41uFlkSs-AExFhS9sHYah4vjkLuopeg&LSNPUBID=*7W41uFlkSs&utm_source=aff-campaign&utm_medium=udemyads&couponCode=639540BA19CF573CB425″ ]