SQL

• 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