cookies-icon

Our website uses cookies. By using this website, you agree to their use in accordance with the browser settings. You can modify your browser settings on your own. For more information see our Privacy Policy.

Basic

Interactive Course

Creating Tables in SQL

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

Table of contents
177

Interactive courses

12 h

Estimated time

57

Users enrolled

☆☆☆☆☆
★★★★★

68 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

Exercises completed

3. Creating tables - revision

Let's recap creating tables and the basic data types

0/6

Exercises completed

Reviews (0)

Average rating

4.76 / 5

☆☆☆☆☆
★★★★★

68 ratings

Details

5 stars

84%

4 stars

11%

3 stars

5%

2 stars

0%

1 stars

0%