Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Creating Tables in SQL

Your first table
3. Query the table
CREATE TABLE basics
Entity Relationship Diagrams (ERD)
DROP - how to remove a table

Instruction

Good job! You've added your first row to your first table and the museum exhibition starts to fill up!

Before we proceed, let's check if everything is working all right. We're going to write a simple SQL query.

Exercise

Let's find out if the row has been inserted correctly. Write a simple SQL query which will select the production_year column for the row with the name 'Matryoshka'.

Tip: you may want to check out our SQL Queries course.

Stuck? Here's a hint!

Type

SELECT production_year 
FROM exhibit 
WHERE name = 'Matryoshka';