SQL
  • Oracle 18/21c Installation
  • Basics
    • Oracle Basics
    • Database models
    • ER Model Overview
    • Data types
    • Understanding Test Database
    • Basics Queries
    • Arithmetic and String functions
    • DML Operations - Insert, Update and Delete
    • FETCH command - Top N, Top % Rows
  • Writing Queries
  • Filters
    • DISTINCT
    • BETWEEN
    • IN
    • LIKE
    • NOT
    • NULL
    • AND, OR, NOT etc
    • Using Complex Data Filtering Techniques
  • Sorting
    • Ascending Order
    • Descending Order
    • Complex Sorting
  • Functions
    • String Functions - lower case, uppercase, substring, instring, trim etc.
    • Number Functions
    • Date Manipulation
    • Null Value Functions - NVL, NVL2, NULLIF, COALESCE
    • Conditional Expressions - Case and Decode
  • Groups
    • Basics
    • Grouping functions - AVG, MIN, MAX, COUNT, DISTINCT COUNT etc
    • Grouping Filters - HAVING
    • Rollups & Cubes
  • Analytic (Window) Functions
    • Over() with summary functions
    • Partition By Queries
    • ROW_NUMBER()
    • RANK()
    • DENSE_RANK()
  • Joins
    • Cartesian Product
    • Equi and Non-Equi Joins
    • Left Outer Join
    • Right Outer Join
    • Full Outer Join
    • Self Join
    • Complex Queries - Joins & Groups Integration
  • SET Operators
    • Union
    • Union All
    • Intersect
    • Minus
  • Subquery
    • Single Valued Row Sub Query
    • Multi Valued Sub Query
  • Views
  • Inline Views
  • ROWID & ROWNUM
  • TOP N Analysis or Complex Inline View
  • DDL
    • Tables - Create, Alter, Drop
    • Indexes - Types, Create, Drop
    • Constraints - Not Null, Primary Key, Unique Key, Foreign Key
    • Sequence
    • Synonyms
  • Foreign Keys
  • DML operations - Insert, Update & Delete
    • Insert, Update, Delete & Truncate
    • Common Operations
    • Creating Tables using queries
    • Bulk Data Inserts using Queries
  • Transactions ( T SQL)
    • Commit
    • Rollback
    • Savepoint
  • DCL - Grant & Revoke
  • Project