Brief Introduction
Learn to perform CRUD Operations using PostgreSQLDescription
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
Requirements
- Requirements
- Be able to use a computer
- Be able to use the internet
Knowledge
- 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
Bluelime Learning Solutions
4.3 Raiting
MongoDB - The Complete Developer's Guide 2021
- 4.7
-
![]()
![]()
![]()
![]()
![]()
Master MongoDB Development for Web & Mobile Apps. CRUD Operations, Indexes, Aggregation Framework - All about MongoDB! It's extremely popular and MongoDB developers are in high demand....
Full Stack Foundations
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Interacting with a persistent datastore is what transforms static web pages into powerful and effective web applications. Implement CRUD operations on a database....
Microservices Architecture and Implementation on .NET 5
- 4.5
-
![]()
![]()
![]()
![]()
![]()
Building Microservices on . Net which used Asp. Net Web API, Docker, RabbitMQ,Ocelot API Gateway, MongoDB,Redis,SqlServer **** Course Completely Renewed at April 2021 ****...
Database Architecture, Scale, and NoSQL with Elasticsearch
- 4.2
-
![]()
![]()
![]()
![]()
![]()
In this final course, you will explore database architecture, PostgreSQL, and various scalable deployment configurations. Scaling Databases Welcome to the Course...
