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.

Course

Basic

Creating Tables in SQL

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

Table of contents

Lifetime access

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

limited to this course only

$29

Buy now

Want a better deal?

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

Get unlimited lifetime access to all 41 present and future courses

Save $420

Unlimited lifetime access

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

to all 41 present and future courses

$ 179

$ 599

70% OFF

Buy now Full pricing
177

Interactive exercises

12 h

Estimated time

109

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
Start now

3.

Creating tables - revision

Let's recap creating tables and the basic data types

0/6

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%