SQL CRUD Operations with PostgreSQL
4.3 (10 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,999 students enrolled

SQL CRUD Operations with PostgreSQL

Learn to perform CRUD Operations using PostgreSQL
4.3 (10 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,999 students enrolled
Last updated 7/2019
English
English [Auto]
Current price: $14.99 Original price: $24.99 Discount: 40% off
1 day left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2.5 hours on-demand video
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
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
Course content
Expand all 24 lectures 02:40:11
+ CRUD Operations on PostgreSQL Database
16 lectures 01:49:12
Introduction
00:56
Create a database with Pgadmin
05:40
Create a table with Pgadmin
07:48
Create a table with SQL statement
08:40
Insert data into table
09:37
Query data with SELECT statement
05:10
Filter data with WHERE clause
06:58
Retrieving all data from a table
06:33
Retrieving data from a specific column in a table
07:41
Modify data with UPDATE Statement
07:48
Deleting data
05:26
Using Subqueries
08:13
Removing duplicate records
05:00
Sorting data
08:16
Grouping data with GROUP BY clause
11:15
Using HAVING clause
04:11
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