PostgreSQL INSERT, UPDATE, and DELETE Commands

Table of contents

1. 1. The basics of INSERT, UPDATE, and DELETE

   0/18

   Learn the basic data manipulation operations in PostgreSQL: INSERT, UPDATE, and DELETE

   List of exercises Start now
   1. Introduction
      1. Introduction
      2. The dish table
   2. Inserting data
      1. Insert data
      2. Insert partial data
      3. Insert NULL values
      4. Insert multiple rows
      5. Insert data – exercise
   3. Modifying data
      1. Modify data
      2. Modify multiple columns
      3. Modify multiple rows
      4. Modify data – arithmetic operations
   4. Deleting data
      1. Delete data
      2. Delete all rows
   5. CRUD
      1. Summary: CRUD
      2. Exercise 1 – Create
      3. Exercise 2 – Update
      4. Exercise 3 – Delete
      5. Summary

2. 2. Advanced features of INSERT, UPDATE, and DELETE

   0/20

   Practice the advanced version of data manipulation operations in PostgreSQL. Get to know how to return rows from INSERT, UPDATE and DELETE with RETURNING clause.

   List of exercises Buy course
   1. Introduction
      1. Introduction
      2. The student table
      3. The exam table
   2. Inserting and updating NULLs
      1. Review: Inserting partial data
      2. Insert NULL into a column
      3. UPDATE with NULL in SET
      4. IS NULL in UPDATE
      5. IS NULL in DELETE
   3. Conditions in UPDATE and DELETE
      1. UPDATE with conditions: AND, OR
      2. DELETE with conditions: AND, OR
   4. Updating the list of columns in one query
      1. Update a list of columns using a list of values
      2. Update a list of columns using a subquery
   5. Using values from another column
      1. Update using a value from another column
      2. Change values between columns
   6. Return rows in INSERT, UPDATE, DELETE
      1. Display deleted values
      2. Display inserted values
      3. Display values in UPDATE
      4. Display the expression value in UPDATE
      5. Display values when inserting multiple rows
   7. Summary
      1. Summary

3. 3. Working with DEFAULT values in INSERT and UPDATE

   0/16

   Learn how you can use default values in a database.

   List of exercises Buy course
   1. Introduction
      1. Welcome
      2. The author table
      3. The post table
   2. Default values
      1. DEFAULT – Explanation
      2. Inserting a DEFAULT value into one column
      3. Inserting DEFAULT values by omitting columns
      4. INSERT using DEFAULT for all columns
      5. Using DEFAULT for the current date and time
      6. Update a column using a DEFAULT value
   3. How to auto-generate values in a database
      1. Auto-generated values
      2. SERIAL – explanation
      3. SERIAL – simple example
      4. SERIAL with DEFAULT
      5. SEQUENCE – explanation
      6. INSERT using SEQUENCE
      7. Summary

4. 4. Referring to other tables in INSERT, UPDATE, and DELETE

   0/13

   Learn to use other tables in INSERT, UPDATE, and DELETE operations in PostgreSQL.

   List of exercises Buy course
   1. Introduction
      1. Welcome
      2. The employee table
      3. The customer table
      4. The product table
      5. The purchase table
   2. INSERT with SELECT
      1. Copy data with INSERT
      2. Complex SELECT with INSERT
   3. Referring to other tables
      1. Delete rows by referring to another table
      2. Update rows by referring to another table
      3. Insert rows using JOIN
   4. INSERT, UPDATE, and DELETE with subqueries
      1. DELETE with a subquery in WHERE
      2. UPDATE with a subquery in WHERE or SET
   5. Summary
      1. Summary

5. 5. Final Quiz

   0/13

   Do you remember how to insert, delete, and update in PostgreSQL?

   List of exercises Buy course
   1. Quiz
      1. Introduction
      2. The animal table
      3. The employee table
      4. The adoptive_person table
      5. Exercise 1
      6. Exercise 2
      7. Exercise 3
      8. Exercise 4
      9. Exercise 5
      10. Exercise 6
      11. Exercise 7
      12. Exercise 8
      13. Congratulations!

Get the Certificate of Competency in SQL

This certificate will confirm your practical SQL problem-solving skills

Obtain the Certificate Learn more