Learn to perform CRUD Operations using PostgreSQL

Description

PostgreSQL is a very popular , advanced, open-source object-relational database management system used by a lot of organizations.

 

It is a very robust database management system.

 

Any software or a web application will typically do these set of operations called C.R.U.D.

 

CRUD Stands for

 

Create (Insert)

 

Read (Select)

 

Update

 

Delete

 

In this course we will be using SQL and PostgreSQL to perform CRUD operations .

 

What we will learn include:

 

How to install PostgreSQL Database Server

 

How to Load a sample database into PostgreSQL Server

 

How to Create a database and table

 

How to insert data into a table

 

How to query and retrieve data from a table

 

How to update existing data inside a table

 

How to delete data from a table

 

How to sort retrieved data from a table

 

How to Filter data using WHERE clause

 

How to remove duplicate data

 

How to use subqueries to query and retrieve data

 

How to group data using GROUP BY clause

 

How to use the HAVING clause to group data

Who this course is for:

Beginners to SQL

Beginners to PostgreSQL

[maxbutton id=”1″ url=”https://www.udemy.com/course/sql-crud-operations-with-postgresql/?ranMID=39197&ranEAID=*7W41uFlkSs&ranSiteID=.7W41uFlkSs-pA.rSuoKTGoi4g4WSe2nUw&LSNPUBID=*7W41uFlkSs&utm_source=aff-campaign&utm_medium=udemyads&couponCode=5F20C9D0DF00A7AAC644″ ]