cookies-icon

Our website uses cookies. By using this website, you agree to their use in accordance with the browser settings. You can modify your browser settings on your own. For more information see our Privacy Policy.

Course

Basic

PostgreSQL INSERT, UPDATE, and DELETE Commands

A data manipulation language (DML) helps you retrieve, store, modify, and delete data in a database. In this online course, you'll learn how to use PostgreSQL INSERT, UPDATE, and DELETE DML commands to control the information inside.

Table of contents

10 free interactive coding challenges

Lifetime access

B042DDD8-A1C9-4053-8AF3-463EB31543B8@2x

limited to this course only

$39

Buy now

Want a better deal?

B042DDD8-A1C9-4053-8AF3-463EB31543B8@2x

Get unlimited lifetime access to all 66 present and future courses

Save $450

Unlimited lifetime access

B042DDD8-A1C9-4053-8AF3-463EB31543B8@2x

to all 66 present and future courses

$149

$599

75% OFF

Buy now
Details
80

Interactive exercises

8 h

Estimated time

4121

Users enrolled

☆☆☆☆☆
★★★★★

444 ratings

Description Table of contents Reviews Start learning

This beginner-friendly online course is dedicated to aspiring database administrators, business professionals working with PostgreSQL, and more. We assume you know the basic PostgreSQL concepts introduced in our PostgreSQL Basics online course.

Cover image for the course 'PostgreSQL INSERT, UPDATE, and DELETE Commands'

PostgreSQL (pronounced "post-gress-Q-L") is an open-source relational database management system supporting the SQL standard language. There are four types of PostgreSQL statements based on their functionality. In this online course, you'll learn about one type – the data manipulation language (DML). Using the DML, you will retrieve, modify, and update PostgreSQL data like a professional. Moreover, you will have the opportunity to test newly acquired skills in practice.

Expand your PostgreSQL toolkit and unlock new career possibilities. Start our online course for free, and see how easy it is.

What Are the Requirements?

  • A web browser and an internet connection.
  • Understanding of basic PostgreSQL concepts that we present in our SQL Basics in PostgreSQL online course.

Learn How To:

  • Work with PostgreSQL INSERT, UPDATE, and DELETE commands.
  • Deal with auto-filling values and combine PostgreSQL DML commands with IDENTITY, SEQUENCE, and NEWID().
  • Combine PostgreSQL DML commands with NULL values.
  • Combine PostgreSQL DML commands with JOIN functions.
  • Update PostgreSQL data using default values in columns.

What's in It for Me?

  • 52 interactive, real-life-inspired exercises designed to help you practice PostgreSQL. Learn at your own pace, from anywhere and at any time.
  • Lifetime access to the course. When you purchase the course, you'll get instant personal access to all of its content.
  • Online certificate. If you complete all of the exercises successfully, you'll get a certificate. You can publish the certificate on your LinkedIn profile (here's how).
  • 30-day money-back guarantee. If you're not satisfied with the quality of the course, you can receive a refund within 30 days of your purchase.
  • Hints for the exercises. Utilize our ready-made hints for the exercises, or ask questions and share insights with other members of our community through the Discuss tab.

Who Can Take This Course?

  • Aspiring database administrators (DBAs)
  • Software testers
  • Programmers dealing with databases
  • Business professionals working with PostgreSQL
  • PostgreSQL enthusiasts
  • Anyone who'd like to get the hang of PostgreSQL DML skills

Table of contents

Free

Paid content

0%

Course progress

0/80

Exercises completed

1.

The basics of INSERT, UPDATE, and DELETE

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

0/18
Start now

Introduction

Introduction
The dish table

Inserting data

Insert data
Insert partial data
Insert NULL values
Insert multiple rows
Insert data – exercise

Modifying data

Modify data
Modify multiple columns
Modify multiple rows
Modify data – arithmetic operations

Deleting data

Delete data
Delete all rows

CRUD

Summary: CRUD
Exercise 1 – Create
Exercise 2 – Update
Exercise 3 – Delete
Summary

2.

Advanced features of INSERT, UPDATE, and DELETE

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.

0/20

Introduction

Introduction
The student table
The exam table

Inserting and updating NULLs

Review: Inserting partial data
Insert NULL into a column
UPDATE with NULL in SET
IS NULL in UPDATE
IS NULL in DELETE

Conditions in UPDATE and DELETE

UPDATE with conditions: AND, OR
DELETE with conditions: AND, OR

Updating the list of columns in one query

Update a list of columns using a list of values
Update a list of columns using a subquery

Using values from another column

Update using a value from another column
Change values between columns

Return rows in INSERT, UPDATE, DELETE

Display deleted values
Display inserted values
Display values in UPDATE
Display the expression value in UPDATE
Display values when inserting multiple rows

Summary

Summary

3.

Working with DEFAULT values in INSERT and UPDATE

Learn how you can use default values in a database.

0/16

Introduction

Welcome
The author table
The post table

Default values

DEFAULT – Explanation
Inserting a DEFAULT value into one column
Inserting DEFAULT values by omitting columns
INSERT using DEFAULT for all columns
Using DEFAULT for the current date and time
Update a column using a DEFAULT value

How to auto-generate values in a database

Auto-generated values
SERIAL – explanation
SERIAL – simple example
SERIAL with DEFAULT
SEQUENCE – explanation
INSERT using SEQUENCE
Summary

4.

Referring to other tables in INSERT, UPDATE, and DELETE

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

0/13

Introduction

Welcome
The employee table
The customer table
The product table
The purchase table

INSERT with SELECT

Copy data with INSERT
Complex SELECT with INSERT

Referring to other tables

Delete rows by referring to another table
Update rows by referring to another table
Insert rows using JOIN

INSERT, UPDATE, and DELETE with subqueries

DELETE with a subquery in WHERE
UPDATE with a subquery in WHERE or SET

Summary

Summary

5.

Final Quiz

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

0/13

Quiz

Introduction
The animal table
The employee table
The adoptive_person table
Exercise 1
Exercise 2
Exercise 3
Exercise 4
Exercise 5
Exercise 6
Exercise 7
Exercise 8
Congratulations!

Reviews (15)

Average rating

4.70/5

☆☆☆☆☆
★★★★★

444 ratings

Details

5 stars

78%

4 stars

17%

3 stars

5%

2 stars

0%

1 stars

0%