Basic Course
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.
4.76
7,236 learners enrolled
Free trial Yes
Certificate of completion Yes
Time to complete 8 h
Coding challenges 52
Skills you will gain
- 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.
Last reviews
- 03/02/2024★★★★★★★★★★
This course was the hardest ive done so far, I feel like Ive learned a lot on more complex queries.
Guilherme Mateus
Description
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:
- A web browser and an Internet connection.
- Basic knowledge of SQL.
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. There are hints available in the exercises to help you if you get stuck.
Table of contents
Course progress 0%
Exercises completed 0/52
-
The basics of INSERT, UPDATE, and DELETE
0/18Learn the basic data manipulation operations in SQL: INSERT, UPDATE and DELETE
-
Advanced features of INSERT, UPDATE, and DELETE
0/15Practice advanced version of data manipulation operations in SQL.
-
Working with DEFAULT values in INSERT and UPDATE
0/10Learn how you can use default values in a database.
-
Final Quiz
0/9Check your knowledge of data manipulation in this quiz.
Get the Certificate of Competency in SQL
This certificate will confirm your practical SQL problem-solving skills
Reviews (15)
This course was the hardest ive done so far, I feel like Ive learned a lot on more complex queries.
Guilherme Mateus
Excellent!
Manoj Singh Rawat
Great course and friendly knowledgable people, thanks!
Lorenzo Morgan
Very good!
Adriana Vesa
I really enjoyed the final quiz. It turned out that I remembered quite a lot.
Ed McKenzie
Suaper course.
Nsamba Ahmed
This is a perfect learning formula. You need to practice to progress 6/5!
Donald Meyer
Good content, but i would like to have more excersieses.
Lawrence Gale
Very thourough course. Loved all the topics.
Marcus Houston
Fun and useful. Essential for people working with databases
Alyssa Cox