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.

Advanced

Interactive Course

SQL Constraints

Constraints tell the database how to check the correctness of input data. Get to know the constraints available in SQL Server, MySQL, Oracle, and PostgreSQL. Learn how to create and alter constraints in a relational database.

Table of contents
76

Interactive exercises

10 h

Estimated time

17

Users enrolled

☆☆☆☆☆
★★★★★

0 ratings

Welcome to SQL Constraints! This is the third course in the track Creating Database Structure. We assume that you know the basic syntax of how to create a table in SQL. You should also know the data types available in a SQL database.

If you’re not familiar with creating tables or with SQL data types, we recommend you do The Basics of Creating Tables in SQL and Data Types in SQL courses before starting this one.

In this course, we talk about database constraints. A constraint is a mechanism that relational databases use to check data correctness. They can verify if a value is unique or is a certain type of data. You can also use constraints to make sure important fields are not left empty.

SQL databases have several types of constraints: primary keys, foreign keys, UNIQUE, NOT NULL, CHECK, and DEFAULT. We will show you how to create tables with constraints and how to drop or modify a constraint.

This interactive tutorial is based on standard SQL; what you learn here will work in all popular relational database management systems, including SQL Server, MySQL, Oracle, and PostgreSQL.

This is a course for beginning IT professionals, computer science students, programmers, developers, and junior database administrators (DBAs). If you need to learn about controlling data entered into a relational database, this is the course for you.

The topics discussed in this course are:

  • Primary keys and foreign keys. We start with a review of primary and foreign keys, which we introduced in The Basics of Creating Tables in SQL.
  • The UNIQUE constraint, which ensures that values or combinations of values are found only once in a table. We show how to create a table with this constraint and how to add a UNIQUE constraint to an existing table.
  • NOT NULL. We review this constraint, which was introduced in the first course of the track. We also discuss how to alter a table and add a NOT NULL constraint.
  • The CHECK constraint, which verifies that values meet a specified criteria.
  • DEFAULT. We discuss how to set up a default value for a column and how to add a default value to an existing column.

This course is interactive. You solve the exercises directly in your web browser and learn how different constraints work. You’ll be writing real SQL commands, which our online platform runs and verifies. You don’t need to install anything on your computer.

What Do You Need to Take This Course?

  • A web browser and an internet connection.
  • Knowledge of SQL, including SELECT, INSERT, UPDATE, and DELETE.
  • Basic understanding of the CREATE TABLE syntax.

This Course Will Teach You How To:

  • Define, modify, and remove primary keys.
  • Define, modify, and remove foreign keys.
  • Define a UNIQUE constraint on a column or set of columns.
  • Add and remove NOT NULL constraints.
  • Add, modify, and remove CHECK constraints.
  • Add, modify, and remove DEFAULT constraints.
  • Alter existing tables to remove or modify constraints.

Who Should Take This Course?

  • Beginning developers and programmers
  • Beginning database administrators (DBAs)
  • Students taking classes in relational databases
  • Anyone who wants to learn how to apply constraints to columns and tables

Table of contents

Free

Paid content

0%

Course progress

0/76

Exercises completed

4. CHECK constraint

Price below zero? Customer over 200 years old? Learn how CHECK constraints can ensure that information in a database is correct.

0/14

Exercises completed

Upgrade

6. Final Quiz

Time to test your knowledge!

0/6

Exercises completed

Upgrade

Reviews (0)

Average rating

3.5 / 5

☆☆☆☆☆
★★★★★

0 ratings

Details

5 stars

0%

4 stars

0%

3 stars

0%

2 stars

0%

1 stars

0%