Search⌘ K
Home
Courses
Getting Started with SQL and Relational Databases

Challenge: Create a Table

Explore how to create a relational table in MySQL, insert and update data, and retrieve results using fundamental SQL commands. This lesson helps you build core skills in table creation, data manipulation, and querying within a structured database.

We'll cover the following...

Create a table

In this challenge, we’re going to create a table. Follow the steps below to create the table with the specified properties.

Create and show database

The table belongs to the school_db database. We have to create this database below:

MySQL
/* implement the (1) part here */

Create and show table

  • The name of the ...