SQL Training Institute

SQL

BASIC SQL

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

SQL Functions

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