Oracle SQL

  1. Oracle Sample Data Dump
  2. Setup
    1. Install Oracle SQL Developer
    2. Connect MySQL to Oracle SQL Developer
    3. Install Oracle 11g on ubuntu
  3. Types of SQL Statement
  4. DB Componets
    1. Tables (Table Dumps)
    2. Constraints
    3. Views
    4. Indexes
    5. Triggers
    6. Sequence
    7. Functions
    8. Schedulers
    9. Synonyms
  5. DataTypes
    1. Char, Varchar, Varchar2
    2. NUMBER, NUMERIC
    3. Date and TimeStamp
    4. Blob
  6. Keys in Oracle SQL
  7. Constrains in Oracle SQL
  8. Joins in Oracle
  9. Subqueries (Types /Correlated)
  10. IN vs EXIST vs JOIN
  11. Set Operators (Union/ UnionAll / Intersect / Minus)
  12. Where Clause
    1. And, Or, In , Not
    2. Minus
    3. Any
    4. All
    5. Between
  13. Aggregate Functions
    1. Group by, Order by, Having
    2. Count, Avg, Sum
    3. Min, Max
    4. rank vs dense rank
    5. Different ways to get unique records from a table
    6. Find nth Max salary in a table
  14. Rownum and Rowid
  15. delete vs truncate
  16. replace vs translate
  17. distinct vs unique
  18. Merge
  19. Pagniation Query in Oracle
  20. Null related functions (NVL / NVL2 / NULLIF / COALESCE)
  21. Decode and case
  22. WITH As clause
  23. Difference between count(*) and count(1)
  24. Savepoint
  25. Normalization (Candidates Key)
    1. Candidates Key for Normalization
    2. 1NF Normal Form (Single valued attribute only allowed)
    3. 2NF Normal Form (No Non-prime attribute partially dependent on Candidate Key allowed)
    4. 3NF Normal Form (No Non-prime attribute depended on Non-prime attribute allowed)
    5. BCFN Normal Form (No prime attribute depended on prime/non-prime allowed)
  26. SuperKey, CandidateKey and PrimaryKey
  27. Partition in Oracle
  28. Index Organized table
  29. Cluster
  30.  scalar typed object attributes of a table
  31. Nested tables
  32. Global Temp Tables (GTT)
  33. Check the stats of the SQL Query already executed

Reference :

Structure Reference of all topics

Interview Questions :
Set 1
Set 2
Set 3 – Siva Blog (youtube) SubscribersQuestion