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.
Learn the basic data manipulation operations in PostgreSQL: 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.
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
Learn how you can use default values in a database.
How to auto-generate values in a database
Learn to use other tables in INSERT, UPDATE, and DELETE operations in PostgreSQL.
INSERT with SELECT
Referring to other tables
INSERT, UPDATE, and DELETE with subqueries
Do you remember how to insert, delete, and update in PostgreSQL?
3.5 / 5