Interactive Course
Learn how to create and manage the structure of a relational database.
Ultimate money saver
With our Forever plan this course will cost you only
$ 4.97
83% OFF
41 hours left
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
Text info, numbers, dates, logical values. Learn how to tell your database what data you're going to store
Exercises completed
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
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
How to properly reference one table in another table
Exercises completed
It's not just tables in the database. Learn what views are
Exercises completed
Time to test your knowledge!
Exercises completed