| SQL Commands and Data Types |
Types of SQL Commands (DDL,DML,DQL,DCL,TCL) and their applications Data Types in SQL (Numeric, Char, Datetime) |
| DQL & Operators |
SELECT:LIMIT,DISTINCT,WHERE AND,OR,IN, NOT IN,BETWEEN, EXIST, ISNULL ,IS NOT NULL,Wild Cards, ORDER BY |
| Case When Then and Handling NULL Values |
Usage of Case When then to solve logical problems and handling NULL Values (IFNULL, COALESCE) |
| Group Operations & Aggregate Functions |
Group By, Having Clause. COUNT, SUM,AVG,MIN, MAX, COUNT String Functions, Date & Time Function |
| Constraints |
NOT NULL, UNIQUE, CHECK, DEFAULT, ENUM, Primary key,Foreign Key (Both at column level and table level) |
| Joins |
Inner, Left, Right, Cross, Self Joins, Full outer join |
| DDL Commands |
DDL: Create, Drop, Alter, Rename, Truncate, Modify, Comment |
|
|
| DML & TCL Commands |
DML: Insert, Update & Delete TCL: Commit, Rollback, Savepoint and Data Partitioning |
| Indexes and Views |
Indexes (Different Type of Indexes) and Views in SQL |
| Stored Procedure |
Stored Procedures - Procedure with IN Parameter, Procedure with OUT parameter, Procedure with INOUT parameter |
| Function, Constructs |
User Define Function, Window Functions - Rank, Dense Rank, Lead, Lag, Row_number |
|
|
| Union, Intersect, Sub-query |
Union, Union all,Intersect, Sub Queries, Multiple Query |
| Exception Handling, Loops, Cursor |
Handling Exceptions in a query, CONTINUE Handler, EXIT handler, Loops: Simple, Repeat, While Cursor |
| Triggers |
Triggers - Before |