vedaetl24@gmail.com   +91 9866978830
Menu

SQL

Home Courses SQl

  • Introduction to Oracle
  • Purpose
  • What is Oracle?
  • How to create Schema / User?
  • SQL Classification
    • Create (DDL)
    • Insert (DML)
    • Commit (TCL)
    • Select (DRL)
    • Update (DML)
    • Delete (DML)
    • Truncate (DDL)
    • Using DDL
    • Using TCL
    • Using DCL
  • Synonym
  • Conditional Selection Operators
    • Where Clause
    • Order By
  • Toad
  • Aliases
  • Functions
    • Row – Level Functions
    • Group By and Having Clause
    • Analytical Functions
  • Set Operators
  • Constraints
  • Joins
  • Case OR Decode()
  • Merge Statement
  • Sub – Queries
  • Correlated Sub – Queries
  • Views
  • Materialized View
  • Normalization
  • Indexes
  • Partitions
  • Query Tuning Approach
  • Difference between DELETE, TRUNCATE and DROP
  • Difference between ROWID and ROWNUM
  • Difference between WHERE and HAVING
  • PL/SQL Basics
    • Stored Procedure
    • Packages
    • Triggers