Tutorials
Constraints
NOT NULL Column does not accept NULL values
CHECK Enforces integrity by limiting the values that can be placed in a column
UNIQUE Values for the columns must be unique
PRIMARY KEY Identify the column or set of columns whose values uniquely identify a row in a table
FOREIGN KEY Identify the relationships between tables
SQL
Database Indexes
Create Table
SQL Select
SQL Alias
SQL Insert
SQL Update
SQL Delete
SQL Alter
SQL group by & having
SQL Subqueries
SQL Exists, All & Any
SQL Joins
SQL Aggregate Functions
SQL Drop
SQL Union & All
Constraints
Create Views
SQL Transactions