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

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

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

Thanks for reading ❤

If you liked this post, share it with all of your programming buddies!

Follow us on Facebook | Twitter

Further reading about CRUD, SQL and PostgreSQL

☞ How to build a CRUD Web App with Angular 8.0

☞ Laravel 5.8 CRUD Tutorial With Example Step By Step

☞ MEAN Stack Angular 8 CRUD Web Application

☞ Build a Basic CRUD App with Node and React

☞ Learn Database Administration - PostgreSQL Database Administration (DBA) for Beginners

☞ How to write SQL queries in PostgreSQL

#web-development #sql #postgresql #database