On February 28 at 1:00 PM UTC the platform will be unavailable for a few minutes due to planned maintenance break.

Description

Take a look at today's applications and you will see how popular relational databases have become. Relational databases are now a powerful tool to store and manage data used everywhere.

In this course, you will find out how to manage the structure of a relational database. You will learn to create tables and drop them when they become unnecessary. Take a read and familiarize yourself with the best practices of database designers. You will discover how to define various table elements: primary keys, UNIQUE keys and foreign keys. We will show you how to use and define constraints. We will provide you with an explanation of how ALTER TABLE works and how you can apply it to modify your table structure. Finally, you will find out how to create views.

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

What are the requirements?

Just a web browser

What am I going to get from this course

  • do interactive exercises for practice
  • learn to create tables
  • find out how to define primary keys
  • discover how to create unique keys
  • learn what foreign keys are and how to use them
  • check out how constraints are used and how to define them
  • practice dropping tables
  • find out how to alter tables
  • discover views and learn to define them

Who is the target audience?

  • Students taking courses in relation databases
  • Analysts dealing with relational databases
  • Beginner developers
  • Hobbyist programmers
  • Anyone who wants to review their SQL knowledge

Table of contents

Create your first table

Create your first table

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

0% completed (13 of exercises done)

More Less
Try for free

Entity Relationship Diagrams (ERD)

DROP - how to remove a table

Data types

Data types

Text info, numbers, dates, logical values. Learn how to tell your database what data you're going to store

0% completed (43 of exercises done)

More Less
Try for free
Creating tables - revision

Creating tables - revision

Let's recap creating tables and the basic data types

0% completed (6 of exercises done)

More Less
Buy this course
Primary keys

Primary keys

How to tell the database that an id column is really an identifier

0% completed (30 of exercises done)

More Less
Buy this course
Constraints

Constraints

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

0% completed (36 of exercises done)

More Less
Buy this course
Foreign keys

Foreign keys

How to properly reference one table in another table

0% completed (27 of exercises done)

More Less
Buy this course
Views

Views

It's not just tables in the database. Learn what views are

0% completed (12 of exercises done)

More Less
Buy this course
Quiz

Quiz

Time to test your knowledge!

0% completed (10 of exercises done)

More Less
Buy this course

Reviews

Average rating

4.7/594.44444444444444 (54)

Details

5 Stars 80 %
4 Stars 13 %
3 Stars 7 %
2 Stars 0 %
1 Stars 0 %
    0