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
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.
Learn to use other tables in INSERT, UPDATE, and DELETE operations in PostgreSQL.
Referring to other tables
INSERT, UPDATE, and DELETE with subqueries