- SQL Overview
- Getting Started…
- Internal Working Of Query Execution
- Data Dictionary
- Datatypes in SQL
- Normalization
- SQL Statements
- DDL Commands
- DML Commands
- TCL Commands
- DCL Commands
- Dual Table
- Order By Clause
- Distinct Clause
- Where Clause
- Group By and Having Clause
- Wild Cards
- SQL Between
- In And Not In
- Logical Operators
- Exist And Not Exist
- Character Functions
- Aggregate Functions
- Date Functions
- Null Functions
- Constraints in SQL
- Types of Constraints
- User Defined Constraints
- Set Operators
- Joins & Its Types
- Non – Correlated Sub Queries
- Correlated Sub Queries
- Inline Sub Queries
- Rank & Dense Rank Functions
- Pseudo Columns Row ID
- Pseudo Columns Row Num
- Case Statement
- Backup Tables
- Views
- Indexes
- Anonymous PL/SQL Blocks
- Stored Procedures
- Deadlock
- Summarize SQL Syntaxes
- Basic SQL Queries
- Complex SQL Queries
- Interview Questions
Print 
PDF
