SQL CRUD Operations with PostgreSQL

Name: SQL CRUD Operations with PostgreSQL
Rating: 4.1 (51 reviews)

Learn to perform CRUD Operations using PostgreSQL

(51 ratings)

15,530 students

Created by Bluelime Learning Solutions

Last updated 9/2021

English

English [Auto]

What you'll learn

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

Requirements

Be able to use a computer
Be able to use the internet

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

Bluelime Learning Solutions

Learning made simple

4.1 Instructor Rating
34,449 Reviews
735,247 Students
418 Courses

Bluelime is UK based and creates quality easy to understand eLearning solutions .All our courses are 100% video based. We teach hands –on- examples that teach real life skills .

Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.