Course Details

SQL is a standard language for storing, manipulating and retrieving data in databases

COURSE OUTLINE

 

SQL Syntax

SQL Select

SQL Select Distinct

SQL Where

SQL And, Or, Not

SQL Order By

SQL Insert Into

SQL Null Values

SQL Update

SQL Delete

SQL Select Top

SQL Min and Max

SQL Count, Avg, Sum

SQL Wildcards

SQL In

SQL Joins

SQL Inner Join

SQL Left Join

SQL Right Join

SQL Full Join

SQL Self Join

SQL Union

SQL Group By

SQL Having

SQL Exists

SQL Any, All

SQL Select Into

SQL Insert Into Select

SQL Comments

 

SQL Database

SQL Create DB

SQL Drop DB

SQL Create Table

SQL Drop Table

SQL Alter Table

SQL Constraints

SQL Not Null

SQL Unique

SQL Primary Key

SQL Foreign Key

SQL Check

SQL Default

SQL Index

SQL Auto Increment

SQL Views

SQL Injection

SQL Hosting