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