Introduction
1. Introduction

Instruction

Welcome to our course "Operating on Data in SQL," where you will learn how to manage data in your database!

Data in any database are constantly changing. You will learn how to add new information to a database, how to modify information and how to remove information from a database.

We assume that you already know how to create SQL queries and how to deal with them. If you don't, feel free take a look at our SQL Queries course first.

We'll provide you with easy-to-understand examples based on a simple table called user:

user (id, name, age)

Each user has a unique id, a specific name and age. Easy, right?

To make things more exciting, however, you'll be working with another table, table dish. C'mon, take a look at it.

Exercise

Select all data from table dish and take a look at them.

When you're done, press Run and check code to continue.

If you don't know how to select data from a table, take a look at our SQL Queries course.

Stuck? Here's a hint!

Type

SELECT * FROM dish;