About course

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!

What Do You Need to Take This Course?

Just a web browser and an Internet connection

This Course Will Teach You How To:

  • Create tables
  • Implement primary keys
  • Determine the best usage of unique keys
  • Define and use foreign keys
  • Apply and understand constraints
  • Understand when, how, and why you’ll need to drop tables
  • Change table structure using ALTER TABLE
  • Decide when and how to use views
 

Plus, you’ll get to practice your skills on 177 interactive exercises.

Who Should Take This Course?

  • Anyone who wants to refresh their knowledge of SQL
  • Analysts who use relational databases
  • Beginning developers
  • Hobbyist programmers
  • Students taking courses in relational databases
  • Business database users who want to improve their skills
    Start now
    Gift this course

    Table of contents

    Progress: 0% completed 0 of 177 exercises done

    1. Create your first table

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

    More details Less
    Start now

    0% completed 0 of 13 exercises done

    2. Data types

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

    More details Less
    Start now

    0% completed 0 of 43 exercises done

    3. Creating tables - revision

    Let's recap creating tables and the basic data types

    More details Less
    Start now

    0% completed 0 of 6 exercises done

    4. Primary keys

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

    More details Less
    Start now

    0% completed 0 of 30 exercises done

    5. 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

    More details Less
    Start now

    0% completed 0 of 36 exercises done

    6. Foreign keys

    How to properly reference one table in another table

    More details Less
    Start now

    0% completed 0 of 27 exercises done

    7. Views

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

    More details Less
    Start now

    0% completed 0 of 12 exercises done

    8. Quiz

    Time to test your knowledge!

    More details Less
    Start now

    0% completed 0 of 10 exercises done

    Reviews

    Average rating

    4.7/594.82758620689654 (58)

    Details

    5 Stars 81%
    4 Stars 12%
    3 Stars 7%
    2 Stars 0%
    1 Stars 0%
      Load more reviews

      Comments

      0