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.
Remember what tables are? You will learn how to create simple tables
CREATE TABLE basics
Text info, numbers, dates, logical values. Learn how to tell your database what data you're going to store
Date and time
Let's recap creating tables and the basic data types
How to tell the database that an id column is really an identifier
Primary keys - the basics
Single-column primary keys
Multicolumn primary keys
Auto-increment columns and sequences
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
How to properly reference one table in another table
Multicolumn foreign keys
Updates and deletes
It's not just tables in the database. Learn what views are
Time to test your knowledge!