Course

Basic

How to Insert, Update, or Delete Data in MS SQL Server

Discover SQL Server data manipulation language (DML) processes. Learn how to insert, update, and delete data from a database.

Table of contents

10 free interactive coding challenges

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 68 present and future courses

Save $450

Unlimited lifetime access

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

to all 68 present and future courses

$149

$599

75% OFF

Buy now
Details
79

Interactive exercises

8 h

Estimated time

2104

Users enrolled

☆☆☆☆☆
★★★★★

185 ratings

Formally, a data manipulation language (DML) deals with the manipulation of data present in a relational database. English, please? Simply put, DML commands empower you to control the information inside your database. This online course covers the MS SQL Server DML and is a great starting point for SQL beginners and aspiring database administrators (DBAs).

If you think SQL ends with SELECT statements, you’re wrong. You can go beyond simple queries and take your skills to a whole new level by exploring the SQL Server DML.

Ever heard of CRUD? That’s an acronym for the most important part of DML operations. This course explains the meaning of CRUD and helps you become a proficient database user.

Cover image for the course 'How to Insert, Update, or Delete Data in MS SQL Server'

In this interactive course, you’ll complete 79 exercises on DML statements in SQL Server. You’ll not only learn about INSERT, UPDATE, and DELETE but also find out how to combine these statements with NULLs and JOINs.

Do you know that INSERT, UPDATE, and DELETE commands also work with DEFAULT? In this course, you’ll learn how modify data using default values of columns. These statements also deal with auto-filling values. Thus, you’ll also gain valuable skills in using IDENTITY, SEQUENCE, and the NEWID() function for auto-generated values and learn how use them with INSERT, UPDATE, and DELETE statements.

Unlock your full SQL potential and take your skills to a higher level. You have at least 79 reasons (read: exercises) to do it! ;-)

What Do You Need to Take This Course?

Just a web browser and an Internet connection.

This Course Will Teach You How To:

  • Modify data stored in MS SQL Server.
  • Use DEFAULT and NULL in DML statements.
  • Display inserted and deleted values in DML commands.
  • Modify data in columns with auto-generated values .
  • Refer to other tables in DML queries.

Who Should Take This Course?

  • Users who completed the SQL Basics or SQL Basics in MS SQL Server course.
  • Aspiring Database Administrators (DBAs).
  • Business professionals dealing with MS SQL Server.
  • MS SQL Server enthusiasts.
  • Anyone who’d like to improve and refine their DML skills.

Table of contents

Free

Paid content

0%

Course progress

0/79

Exercises completed

1.

The basics of INSERT, UPDATE, and DELETE

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

0/18

Introduction

Inserting data

Modifying data

Deleting data

CRUD

2.

Advanced features of INSERT, UPDATE, and DELETE

Practice advanced version of data manipulation operations in SQL Server. Get to know how to return rows from INSERT, UPDATE and DELETE with OUTPUT clause.

0/17

Introduction

Inserting and updating NULLs

Conditions in UPDATE and DELETE

Using values from another column

Return rows in INSERT, UPDATE, DELETE

Summary

3.

Auto-filling values in INSERT, UPDATE, and DELETE

Learn how database can automatically fill certain values. Get to know how you can use auto-filling features in INSERT, UPDATE and DELETE.

0/18

Introduction

Default values

How to auto-generate values in a database

Summary

4.

Referring to other tables in INSERT, UPDATE, and DELETE

Learn how you can refer to other tables in INSERT, UPDATE, and DELETE operations in SQL Server.

0/15

Introduction

INSERT with SELECT

Referring to other tables

INSERT, UPDATE and DELETE with JOIN

INSERT, UPDATE, and DELETE with subqueries

Summary

5.

Final Quiz

Check your knowledge of data manipulation in this quiz.

0/11

Quiz

Reviews (15)

Average rating

4.67/5

☆☆☆☆☆
★★★★★

185 ratings

Details

5 stars

69%

4 stars

31%

3 stars

0%

2 stars

0%

1 stars

0%