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.
Interactive Course
Learn how to create and manage the structure of a relational database.
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!
Just a web browser and an Internet connection
Plus, you’ll get to practice your skills on 177 interactive exercises.
Course progress
Exercises completed
Remember what tables are? You will learn how to create simple tables
Exercises completed
Your first table
CREATE TABLE basics
Entity Relationship Diagrams (ERD)
DROP - how to remove a table
Text info, numbers, dates, logical values. Learn how to tell your database what data you're going to store
Exercises completed
Introduction
Text information
Numbers
Date and time
Let's recap creating tables and the basic data types
Exercises completed
How to tell the database that an id column is really an identifier
Exercises completed
Primary keys - the basics
Single-column primary keys
Multicolumn primary keys
Auto-increment columns and sequences
Revision
Price below zero? A person over 1000 years old? It's not going to happen again. Learn how to tell the database what are the restriction for the data it stores
Exercises completed
Introduction
UNIQUE
NOT NULL
CHECK
DEFAULT
Summary
How to properly reference one table in another table
Exercises completed
Introduction
Foreign keys
Multicolumn foreign keys
Updates and deletes
It's not just tables in the database. Learn what views are
Exercises completed
Time to test your knowledge!
Exercises completed