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.
Interactive Course
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.
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.
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.
Course progress
Exercises completed
Learn the basic data manipulation operations in PostgreSQL: INSERT, UPDATE, and DELETE
Exercises completed
Introduction
Inserting data
Modifying data
Deleting data
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.
Exercises completed
Introduction
Inserting and updating NULLs
Conditions in UPDATE and DELETE
Updating the list of columns in one query
Using values from another column
Return rows in INSERT, UPDATE, DELETE
Summary
Learn how you can use default values in a database.
Exercises completed
Introduction
Default values
How to auto-generate values in a database
Learn to use other tables in INSERT, UPDATE, and DELETE operations in PostgreSQL.
Exercises completed
INSERT with SELECT
Referring to other tables
INSERT, UPDATE, and DELETE with subqueries
Summary
Do you remember how to insert, delete, and update in PostgreSQL?
Exercises completed