SQL

Module 1

  • Database
  • Create DB
  • Drop DB
  • Create Table
  • Drop Table
  • Alter Table
  • Constraints
  • Not Null
  • Unique

Module 2

  • Intro
  • Syntax
  • Select
  • Select Distinct
  • Where
  • And, Or, Not
  • Order By
  • Insert Into
  • Null Values
  • Update
  • Delete
  • Select Top
  • Min and Max
  • Count, Avg, Sum
  • Like
  • Wildcards
  • In
  • Between
  • Aliases

Module 3

  • Joins
  • Inner Join
  • Left Join
  • Right Join
  • Full Join
  • Self Join

Module 4

  • Union
  • Group By
  • Having
  • Exists
  • Insert Into Select
  • Null Functions
  • Comments

Module 5

  • Primary Key
  • Foreign Key
  • Composite Key
  • Alternate Key
  • Candidate Key