Course

Basic

Creating Tables in SQL

Learn how to create and manage the structure of a relational database.

Table of contents

17 free interactive coding challenges

Lifetime access

B042DDD8-A1C9-4053-8AF3-463EB31543B8@2x

limited to this course only

$39

Buy now

Want a better deal?

B042DDD8-A1C9-4053-8AF3-463EB31543B8@2x

Get unlimited lifetime access to all 69 present and future courses

Save $450

Unlimited lifetime access

B042DDD8-A1C9-4053-8AF3-463EB31543B8@2x

to all 69 present and future courses

$149

$599

75% OFF

Buy now
Details
177

Interactive exercises

12 h

Estimated time

1135

Users enrolled

☆☆☆☆☆
★★★★★

77 ratings

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

Table of contents

Free

Paid content

0%

Course progress

0/177

Exercises completed

1.

Create your first table

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

0/13

Your first table

CREATE TABLE basics

Entity Relationship Diagrams (ERD)

DROP - how to remove a table

2.

Data types

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

0/43

Introduction

Text information

Numbers

Boolean

Date and time

Summary

3.

Creating tables - revision

Let's recap creating tables and the basic data types

0/6

Revision

4.

Primary keys

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

0/30

Primary keys - the basics

Single-column primary keys

Multicolumn primary keys

Auto-increment columns and sequences

Revision

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

0/36

Introduction

UNIQUE

NOT NULL

CHECK

DEFAULT

Summary

6.

Foreign keys

How to properly reference one table in another table

0/27

Introduction

Foreign keys

Multicolumn foreign keys

Updates and deletes

Revision

7.

Views

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

0/12

Views

Revision

8.

Quiz

Time to test your knowledge!

0/10

Quiz

Reviews (0)

Average rating

4.81/5

☆☆☆☆☆
★★★★★

77 ratings

Details

5 stars

91%

4 stars

7%

3 stars

0%

2 stars

0%

1 stars

2%