SQL

 

 

Basic SQl

  • RDBMS Concepts
  • Databases
  • Syntax
  • Datatypes
  • Operators
  • Expressions
  • Create, Drop, Select Database
  • Create,Drop Table
  • Insert Query
  • Select Query
  • Where Clause
  • AND & OR Clause
  • Update Query
  • Delete Query
  • LIKE Clause
  • TOP CLause
  • Order By and Group By
  • Distinct Keyword
  • Sorting Results

Advanced SQL

  • Constraints
  • Joins
  • Union Clause
  • NULL Values
  • Alias Syntax
  • Indexes
  • Alter and Truncate
  • Using Views
  • Having Clause
  • Transactions
  • Wildcards
  • Date Functions
  • Temporary Tables
  • Clone Tables
  • Sub Queries
  • Using Sequences
  • Handling Duplicates
  • Summary