Course Table

Basic SQL Tutorial

• SQL Tutorial
• SQL Introduction
• SQL Syntax
• SQL select
• SQL distinct
• SQL where
• SQL AND & OR
• SQL Order By
• SQL insert
• SQL update
• SQL delete

Advanced SQL Tutorial

• SQL Top
• SQL Like
• SQL Wildcard
• SQL In
• SQL Between
• SQL Aliases
• SQL Join
• SQL Inner Join
• SQL Left Join
• SQL Right Join
• SQL Full Join
• SQL Union
• SQL Select Into
• SQL Create DB
• SQL Create Table
• SQL Constraints
• SQL Not Null
• SQL Unique
• SQL Primary Key
• SQL Foreign Key
• SQL Check
• SQL Default
• SQL Create Index
• SQL Drop
• SQL Alter
• SQL Increment
• SQL View
• SQL Date
• SQL Nulls
• SQL isnull()
• SQL Data Types
• SQL Server

SQL Functions

• SQL Functions
• SQL avg()
• SQL count()
• SQL first()
• SQL last()
• SQL max()
• SQL min()
• SQL sum()
• SQL Group By
• SQL Having
• SQL ucase()
• SQL lcase()
• SQL mid()
• SQL len()
• SQL round()
• SQL now()
• SQL format()

SQL Summary

• SQL Quick Reference
• SQL Tutorial Summary

SQL Quiz

• SQL Quiz

Elective Course

Course Recommendation:

• CodeW3C.com Treasure Box

SQL Constraints

Constraints are used to limit the type of data that can be added to the table.

Constraints can be specified when creating a table (through the CREATE TABLE statement), or after the table is created (through the ALTER TABLE statement).

We will mainly discuss the following constraints:

• NOT NULL
• UNIQUE
• PRIMARY KEY
• FOREIGN KEY
• CHECK
• DEFAULT

Note:In the following chapters, we will explain each constraint in detail.

Toolbox

SQL Quiz

Sponsor Links