Search for:

  1. Writing Basic SQL SELECT Statements
  2. Creating and Managing Tables – Create, ADD, Modify, Drop, Truncate
  3. Restricting and Sorting Data – WHERE, BETWEEN, IN, LIKE, NULL, AND, OR, NOT, ORDER BY
  4. Single-Row Functions – Single row Function, Character function, NVL, NVL2, NULLIF, COALESCE, CASE
  5. Displaying Data from Multiple Tables – Inner, Outer, Full outer JOINS
  6. Aggregating Data Using Group Functions – GROUP BY ClauseSubqueries – Single row, Multiple row Subquery, HAVING Clause, ANY, ALL
  7. Manipulating Data – Insert, Update, Delete, Merge, Commit, Rollback
  8. Including Constraints – NOT NULL, UNIQUE, Primay Key, Foreign Key
  9. Other Database Objects – Sequence, Index, Synonyms
  10. Controlling User Access – GRANT, REVOKE
  11. Using SET Operators – SET, UNION, UNION ALL, INTERSECT, MINUS
  12. Advanced Subqueries – EXISTS, NOT EXISTS
  13. Creating Views
  14. PL/SQL Basic syntax
  15. Creating Stored Procedures
  16. Creating Functions
  17. Creating Cursors
  18. Creating Triggers