SQL In 7 Days

--------------------------------------------- Day 1 ---------------------------------------------

• Introduction To SQL
• Data Types
• DRL, DDL, DML, TCL and DCL Commands
• DRL (Data Retrieval Language)
• DDL (Data Definition Language)
• DML (Data Manipulation Language)
• TCL (Transaction Control Language)
• DCL (Data Control Language)

--------------------------------------------- Day 2 ---------------------------------------------

• Select and Where Clause
• Aliases, Literals and Concatenation
• Arithmetic and Comparison Operators
• Logical Operators
• SQL Operators
• Order By Clause

--------------------------------------------- Day 3 ---------------------------------------------

• SQL Functions
• Character Functions
• Number Functions
• Date Functions
• NVL, Decode And Case Functions
• To_Char, To_Number, To_Date Functions

--------------------------------------------- Day 4 ---------------------------------------------

• Group by, Grouping Functions and Having Clause
• Integrity Constraints
• NOT NULL Constraint
• UNIQUE Constraint
• PRIMARY KEY Constraint
• FOREIGN KEY Constraint
• CHECK Constraint
• Constraints Maintenance

--------------------------------------------- Day 5 ---------------------------------------------

• Joins
• Self, Equi, NON Equi and Outer Joins
• Categories of Joins
• Pseudo Column
• Set Operators

--------------------------------------------- Day 6 ---------------------------------------------

• Sub Queries
• Types of Sub Queries
• Views
• DDL on Views
• DML and Constraints on Views
• Indexes

--------------------------------------------- Day 7 ---------------------------------------------

• Sequences
• Synonyms
• Hierarchical or Recursive Queries
• OLAP Functions