Oracle

  1. Create Database
  2. Data Types
    • Character
    • Numeric
    • Date/Time
    • Binary
    • Large Object (LOB)
    • Miscellaneous
  3. Operators
    1. Arithmetic
    2. Comparison
    3. Logical
  4. Expressions
    1. Boolean
    2. Numeric
    3. Date
  5. Drop Database
  6. Select Database
  7. Create Table
  8. Rename Table
  9. Drop Table
  10. Truncate Table
  11. Alter Table
  12. Insert Query
  13. Select Query
  14. Where Clause
  15. Update Query
  16. Delete Query
  17. AND Clause
  18. OR Clause
  19. Like Clause
    1. Wildcard Operators
  20. Top/Limit/RowNum Clause
  21. Order By
  22. Group By
  23. Distinct Keyword
  24. IN
  25. NULL
  26. Constraints
    • NOT NULL Constraint
    • DEFAULT Constraint
    • UNIQUE Constraint
    • PRIMARY Constraint
    • FOREIGN Constraint
    • CHECK Constraint
    • INDEX Constraint
  27. Joins
    1. INNER Join
    2. LEFT Join
    3. RIGHT Join
    4. FULL / FULL OUTER Join
    5. CARTESIAN / CROSS Join
    6. SELF Join
  28. Operators
    1. Union
    2. Except
    3. Intersect
  29. Auto Increment
  30. Sub Query
  31. Duplicate Table
  32. Having
  33. Aliases
  34. View
  35. Transaction
  36. Index
    1. Clustered Index
    2. Non-Clustered Index
    3. Column Store Index
    4. Filtered Index
    5. Hash Index
    6. Unique Index
Subscribe to: Posts (Atom)