Go beyond simple SELECT statements! Learn all about the SQL UPDATE, INSERT, and DELETE commands, and find out how to combine them with NULLs and JOINs.
In this online course, you’ll learn how to retrieve, store, modify, delete, insert, and update data with the SQL data manipulation language (DML).
DML commands give you control over the information inside your database and the ability to change that data, allowing you to greatly expand your basic SQL toolkit.
This online course is perfect for SQL beginners, aspiring database administrators (DBAs), and programmers working with databases. Read on to learn more about what functions are covered and who else will benefit from completing the course.
Learn the basic data manipulation operations in SQL: INSERT, UPDATE and DELETE
Practice advanced version of data manipulation operations in SQL.
Inserting and updating NULLs
Conditions in UPDATE and DELETE
Using values from another column
Inserting data from a query
Learn how you can use default values in a database.
Check your knowledge of data manipulation in this quiz.
4.75 / 5