Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

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 for free
    Gift this course

    Bundle deals

    86%
    off

    Reg. price
    $1512

    One to Rule 'Em All

    Includes 41 courses Python Basics. Part 1, Python Basics. Part 2, Python Basics. Part 3, Python Data Structures in Practice, Built-in Algorithms in Python, Working with Strings in Python, SQL Basics, SQL Practice Set, SQL JOINs, Standard SQL Functions, Creating Basic SQL Reports, Window Functions, Revenue Trend Analysis in SQL, How to INSERT, UPDATE, and DELETE Data in SQL, Recursive Queries, Creating Tables in SQL, Introduction to R, Tidyverse, Data Visualization 101, Statistics 101, SQL Basics in MS SQL Server, How to Insert, Update, or Delete Data in MS SQL Server, Common Functions in MS SQL Server, Revenue Trend Analysis in SQL Server, Creating Basic SQL Reports in SQL Server, Window Functions in MS SQL Server, Recursive Queries in MS SQL Server, GROUP BY Extensions in MS SQL Server, Introduction to Python for Data Science, How to Read and Write CSV Files in Python, How to Read and Write JSON Files in Python, Lists and Functions in R, Data Manipulation in R, SQL Basics in PostgreSQL, PostgreSQL JOINs, SQL Practice Set in PostgreSQL, Window Functions in PostgreSQL, Recursive Queries in PostgreSQL, Writing User-Defined Functions in PostgreSQL, PostGIS, How to Read and Write Excel Files in Python

    Bundle price $199

    39 hours left at this price!

    73%
    off

    Reg. price
    $359

    SQL Complete Track

    Includes 9 courses SQL Basics, SQL Practice Set, SQL JOINs, Standard SQL Functions, Window Functions, How to INSERT, UPDATE, and DELETE Data in SQL, Recursive Queries, Creating Tables in SQL, PostGIS

    Bundle price $95

    39 hours left at this price!

    66%
    off

    Reg. price
    $193

    SQL First Aid

    Includes 5 courses SQL Basics, SQL Practice Set, SQL JOINs, Standard SQL Functions, Creating Tables in SQL

    Bundle price $65

    39 hours left at this price!

    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.20289855072463 (69)

    Details

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

      Comments

      0