Introduction
  • Introduction
  • Introduction to Data Table Structure
  • SQL Statements vs SQL*Plus or iSQL*Plus commands
  • Writing basic SQL SELECT statement
Restricting and Sorting Data
  • WHERE Clause
  • Comparison Operators(BETWEEN ..AND.. , IN, LIKE, IS NULL)
  • Logical Operators(AND , OR, NOT)
  • Sorting: ORDER BY Clause
SQL Single-Row Functions
  • Introduction to SQL Functions
  • Character Functions
  • Number Functions & usage of DUAL Table
  • Working with HR Schema
  • Working with DATES
  • DATE Functions
  • Conversion Function: TO_CHAR( )
  • Conversion Function: TO_NUMBER( ) & Implicit conversion
  • Conversion Function:TO_DATE( )
  • General Functions: NVL( )
  • General Functions: NVL2( )
  • General Functions: DECODE( )
  • Other Functions
Display Data from Multiple Tables
  • Introduction to Joining
  • Equi-Join
  • Non-Equi Join
  • Full Outer Join
  • Self Join
Aggregating Data Using Group Functions
  • Group Functions
  • Group By Clause
  • Having Clause
Subqueries
  • Introduction to subquery
  • Single Row Subquery
  • Multi Row Subquery
DML Data Manipulation Language
  • Inserting Rows in a Table
  • Updating Rows
  • Deleting Rows
DDL Data Definition Language
  • Creating Tables