Course Content

- Introduction to SQL
o SQL HOME - Intro - Syntax - Comments
o SQL Select
o SQL Distinct
o SQL Where - And & Or - Order By - Insert Into
o SQL Update - Delete - Injection - Select Top
o SQL Like - Wild Cards
o SQL In - Between - Aliases
o SQL Joins - Inner Join - Left Join - Right Join - Full Join
o SQL Union
o SQL Select Into
o SQL Insert Into Select
o SQL Create DB
o SQL Create Table
o SQL Constraints - Not Null - Unique
o SQL Primary Key - Foreign Key - Check - Default
o SQL Create Index
o SQL Drop - Alter
o SQL Auto Increment
o SQL Views - Dates
o SQL Null Values - Null Functions
o SQL Data Types - DB Data Types

- SQL Functions
o SQL Avg()
o SQL Count()
o SQL First()
o SQL Last()
o SQL Max()
o SQL Min()
o SQL Sum()
o SQL Group By
o SQL Having
o SQL Ucase()
o SQL Lcase()
o SQL Mid()
o SQL Len()
o SQL Round()
o SQL Now()
o SQL Format()