SQL CRUD Operations with PostgreSQL
Learn to perform CRUD Operations using PostgreSQL
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
Who this course is for:
- Beginners to SQL
- Beginners to PostgreSQL