cookies-icon

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.

Course

Basic

How to INSERT, UPDATE, and DELETE Data in SQL

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.

Table of contents

Lifetime access

B042DDD8-A1C9-4053-8AF3-463EB31543B8@2x

limited to this course only

$39

Buy now

Want a better deal?

B042DDD8-A1C9-4053-8AF3-463EB31543B8@2x

Get unlimited lifetime access to all 71 present and future courses

Save $440

Unlimited lifetime access

B042DDD8-A1C9-4053-8AF3-463EB31543B8@2x

to all 71 present and future courses

$159

$599

73% OFF

Buy now
Details
52

Interactive exercises

8 h

Estimated time

6218

Users enrolled

☆☆☆☆☆
★★★★★

827 ratings

Description Table of contents Reviews Start learning

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.

Requirements:

Learn How To:

  • Work with SQL UPDATE, INSERT, and DELETE commands.
  • Combine SQL DML commands with NULLs.
  • Combine SQL DML commands with JOINs.
  • Modify data using default values of columns.
  • Perform CRUD operations—the most important part of DML operations.

Who Should Take This Course?

  • Users who completed the SQL Basics course.
  • Aspiring Database Administrators (DBAs).
  • Software testers.
  • Programmers working with databases.
  • Business professionals dealing with SQL.
  • SQL enthusiasts.
  • Anyone who’d like to improve and refine their SQL DML skills.

What's in It for Me?

  • 52 interactive exercises. Learn at your own pace, from anywhere and anytime. Interact with hands-on exercises for improved retention.
  • Lifetime access to the course. When you purchase the course, you’ll get instant personal access to all of its content.
  • Certificate of completion. After you successfully finish all of the exercises, you’ll get a downloadable PDF certificate to showcase your accomplishment.
  • 30-day money-back guarantee. If you’re not satisfied with the quality of the course, you can get a refund within 30 days of your purchase.
  • Hints for the exercises. You can ask questions and share insights with other members of our community through the Disqus tab.

Table of contents

Free

Paid content

0%

Course progress

0/52

Exercises completed

1.

The basics of INSERT, UPDATE, and DELETE

Learn the basic data manipulation operations in SQL: INSERT, UPDATE and DELETE

0/18
Start now

Introduction

Introduction
The dish table

Inserting data

Insert data
Insert partial data
Insert NULL values
Insert multiple rows
Insert data—exercise

Modifying data

Modify data
Modify multiple columns
Modify multiple rows
Modify data—arithmetic operations

Deleting data

Delete data
Delete all rows

CRUD

Summary: CRUD
Exercise 1—Create
Exercise 2—Update
Exercise 3—Delete
Summary

2.

Advanced features of INSERT, UPDATE, and DELETE

Practice advanced version of data manipulation operations in SQL.

0/15

Introduction

Introduction
The student table
The exam table

Inserting and updating NULLs

Review: Inserting partial data
Insert NULL into a column
UPDATE with NULL in SET
IS NULL in UPDATE
IS NULL in DELETE

Conditions in UPDATE and DELETE

UPDATE with conditions: AND, OR
DELETE with conditions: AND, OR

Using values from another column

Update using a value from another column
Change values between columns

Inserting data from a query

INSERT INTO ... SELECT
INSERT INTO ... SELECT with GROUP BY

Summary

Summary

3.

Working with DEFAULT values in INSERT and UPDATE

Learn how you can use default values in a database.

0/10

Introduction

Welcome
The author table
The post table

Default values

DEFAULT — explanation
Inserting a DEFAULT value into one column
Inserting DEFAULT values by omitting columns
INSERT using DEFAULT for all columns
Using DEFAULT for the current date and time
Update a column using a DEFAULT value

Summary

Summary

4.

Final Quiz

Check your knowledge of data manipulation in this quiz.

0/9

Quiz

Introduction
The animal table
The adoptive_person table
Exercise 1
Exercise 2
Exercise 3
Exercise 4
Exercise 5
Congratulations!

Reviews (14)

Average rating

4.76/5

☆☆☆☆☆
★★★★★

827 ratings

Details

5 stars

82%

4 stars

17%

3 stars

1%

2 stars

0%

1 stars

0%