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
1.
Remember what tables are? You will learn how to create simple tables
2.
Text info, numbers, dates, logical values. Learn how to tell your database what data you're going to store
3.
Let's recap creating tables and the basic data types
4.
How to tell the database that an id column is really an identifier
5.
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
6.
How to properly reference one table in another table
7.
It's not just tables in the database. Learn what views are
8.
Time to test your knowledge!