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.

Basic

Interactive Course

Operating on Data in SQL

Find out how to use Data Manipulation Language to insert, update, and delete data from an SQL database.

Table of contents
19

Interactive exercises

2 h

Estimated time

44

Users enrolled

☆☆☆☆☆
★★★★★

151 ratings

Data changes over time. In this course, you will learn how to keep data records current using SQL’s INSERT, DELETE, and UPDATE commands. These three operations represent the basics of DML (Data Manipulation Language, a special set of SQL commands). They give you the power to control the information inside your database.

If you use a relational database, you’ve probably heard about CRUD. That’s an acronym for the most important part of DML operations. This course will explain the meaning of CRUD and help you become a more proficient database user.

You may already know how to retrieve information from a database using SELECT statements. Find out how to take your SQL skills to the next level with this course!

What Do You Need to Take This Course?

Just a web browser and an Internet connection

This Course Will Teach You How To:

  • Manage data in a relational database
  • Insert information into a database
  • Update information
  • Delete information from a database
 

Plus, you’ll get to practice your skills on 19 interactive exercises.

Who Should Take This Course?

  • Anyone who wants to refresh their knowledge of SQL
  • Analysts who use relational databases
  • Beginning programmers
  • Students taking courses in relational databases
  • Business database users who want to improve their skills

Table of contents

Free

Paid content

0%

Course progress

0/19

Exercises completed

1. Introduction

Find out what you'll learn in this course. Get to know tables you'll work with.

0/2

Exercises completed

2. How to insert data into a database

First things first. Discover how to enter data into a database.

0/5

Exercises completed

3. Modifying data in a database

Learn how to modify data in a database.

0/4

Exercises completed

4. Deleting data from a database

Done with your data? Learn how to remove it from a database.

0/3

Exercises completed

Upgrade

5. CRUD - the four operations

Learn about the four basic operations each application handling data should have

0/5

Exercises completed

Upgrade

Reviews (0)

Average rating

4.74 / 5

☆☆☆☆☆
★★★★★

151 ratings

Details

5 stars

80%

4 stars

16%

3 stars

4%

2 stars

0%

1 stars

0%