Tabla de Contenidos:
  • Ch. 1. Getting started with Oracle database
  • Ch. 2. Retrieving data (SELECT)
  • Ch. 3. Filtering (WHERE) and sorting data (ORDER BY)
  • Ch. 4. Operators, conditions, pseudocolumns, and expressions
  • Ch. 5. Single row functions
  • Ch. 6. Joining tables
  • Ch. 7. Groups and summaries (GROUP BY)
  • Ch. 8. Subqueries and other specialized queries
  • Ch. 9. SQL[superscript *]Plus formatting
  • Ch. 10. Changing data (DML)
  • Ch. 11. Tables, datatypes, and constraints (DDL)
  • Ch. 12. Views, indexes, sequences, and synonyms (DDL)
  • Ch. 13. Security (DDL)
  • Ch. 14. Practice test #1 (60 questions)
  • Ch. 15. Answer key to practice test #1
  • Ch. 16. Practice test #2
  • Ch. 17. Answer key to practice test #2.