Operating on Data in SQL

Table of contents

1. 1. Introduction

   0/2

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

   List of exercises Start now
   1. Introduction
      1. Introduction
      2. Table dish

2. 2. How to insert data into a database

   0/5

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

   List of exercises Start now
   1. Inserting data
      1. Insert data
      2. Insert partial data
      3. Insert NULL values
      4. Insert multiple rows
      5. Insert data - exercise

3. 3. Modifying data in a database

   0/4

   Learn how to modify data in a database.

   List of exercises Start now
   1. Modifying data
      1. Modify data
      2. Modify multiple columns
      3. Modify multiple rows
      4. Modify data - arithmetic operations

4. 4. Deleting data from a database

   0/3

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

   List of exercises Buy course
   1. Deleting data
      1. Delete data
      2. Delete all rows
      3. Delete data - exercise

5. 5. CRUD - the four operations

   0/5

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

   List of exercises Buy course
   1. CRUD
      1. The four operations
      2. Exercise 1 - create
      3. Exercise 2 - update
      4. Exercise 3 - delete
      5. Summary

Get the Certificate of Competency in SQL

This certificate will confirm your practical SQL problem-solving skills

Obtain the Certificate Learn more