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.



Creating Tables in SQL

Learn how to create and manage the structure of a relational database.

Table of contents

Lifetime access


limited to this course only


Buy now

Want a better deal?


Get unlimited lifetime access to all 62 present and future courses

Save $420

Unlimited lifetime access


to all 62 present and future courses

$ 179

$ 599

70% OFF

Buy now Full pricing

Interactive exercises

12 h

Estimated time


Users enrolled


1 ratings

Look at today’s software industry and you’ll see how popular relational databases have become. Creating Tables in SQL will show you how to start building your own custom database.

In this course, you’ll discover how to manage the structure of a relational database. You’ll be asked to create tables and drop (delete) them when they are no longer needed. You’ll also get acquainted with some of the best practices guiding database design.

Discover how to define various table elements, including constraints, primary keys, UNIQUE keys, and foreign keys. Learn how ALTER TABLE works and how you can use it to modify your table structure. Finally, learn how to create virtual tables called views.

If you want to take control of your database structure and understand it perfectly, this is the right course for you!

What Do You Need to Take This Course?

Just a web browser and an Internet connection

This Course Will Teach You How To:

  • Create tables
  • Implement primary keys
  • Determine the best usage of unique keys
  • Define and use foreign keys
  • Apply and understand constraints
  • Understand when, how, and why you’ll need to drop tables
  • Change table structure using ALTER TABLE
  • Decide when and how to use views

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

Who Should Take This Course?

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

Table of contents


Paid content


Course progress


Exercises completed


Create your first table

Remember what tables are? You will learn how to create simple tables

Start now


Creating tables - revision

Let's recap creating tables and the basic data types


Reviews (0)

Average rating

5.00 / 5


1 ratings


5 stars


4 stars


3 stars


2 stars


1 stars