Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

PostgreSQL INSERT, UPDATE, and DELETE Commands

Introduction
1. Introduction
Inserting data
Modifying data
Deleting data
CRUD

Instruction

Welcome to our "How to INSERT, UPDATE, and DELETE Data in PostgreSQL" course, where you will learn how to manage data in PostgreSQL!

Data in any database is constantly changing. You will learn how to add new information to a database, modify database information, and remove information from a database.

We assume that you already know how to create SQL queries and how to work with them. If you don't, feel free to take a look at our SQL Basics in PostgreSQL course first.

We'll provide you with easy-to-understand examples based on a simple table named user:

user (id, name, age)

Each user has a unique id, a specific name, and an age. Easy, right?

To make things more exciting, though, you'll be working with another table, dish. Let's take a look at it.

Exercise

Select all data from the dish table, and explore the contents.

When you're done, click Run and check code to continue.

If you don't know how to SELECT data from a table, take a look at our SQL Basics in PostgreSQL course.

Stuck? Here's a hint!

Type:

SELECT *
FROM dish;