MP4 | Video: h264, 1280×720 | Audio: AAC, 48 KHz, 2 ChGenre: eLearning | Language: English + .VTT | Duration: 2.5 hour | Size: 837 MBLearn to perform CRUD Operations using PostgreSQLWhat you’ll learnHow to install PostgreSQL Database ServerHow to Load a sample database into PostgreSQL ServerHow to Create a database and tableHow to insert data into a tableHow to query and retrieve data from a tableHow to update existing data inside a tableHow to delete data from a tableHow to sort retrieved data from a tableHow to Filter data using WHERE clauseHow to remove duplicate dataHow to use subqueries to query and retrieve dataHow to group data using GROUP BY clauseHow to use the HAVING clause to group dataRequirementsBe able to use a computerBe able to use the internetDescriptionPostgreSQL 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 forCreate (Insert)Read (Select)UpdateDeleteIn this course we will be using SQL and PostgreSQL to perform CRUD operations .

What we will learn include:How to install PostgreSQL Database ServerHow to Load a sample database into PostgreSQL ServerHow to Create a database and tableHow to insert data into a tableHow to query and retrieve data from a tableHow to update existing data inside a tableHow to delete data from a tableHow to sort retrieved data from a tableHow to Filter data using WHERE clauseHow to remove duplicate dataHow to use subqueries to query and retrieve dataHow to group data using GROUP BY clauseHow to use the HAVING clause to group dataWho this course is for:Beginners to SQLBeginners to PostgreSQL