OCA Oracle Database SQL Certified Expert Exam Guide (Exam 1Z0-047) (häftad)
Fler böcker inom
Format
Mixed media product
Språk
Engelska
Antal sidor
753
Utgivningsdatum
2010-01-26
Upplaga
ed
Förlag
OSBORNE/MCGRAW
Illustrationer
illustrations
Volymtitel
Exam 1Z0-047
Dimensioner
234 x 190 x 44 mm
Vikt
1360 g
Antal komponenter
2
Komponenter
Paperback (1), CD-ROM (1)
ISBN
9780071614214

OCA Oracle Database SQL Certified Expert Exam Guide (Exam 1Z0-047)

av Steve O'Hearn
Mixed media product,  Engelska, 2010-01-26

Slutsåld

A Fully Integrated Study System for OCA Exam 1Z0-047

Prepare for the Oracle Certified Associate SQL Certified Expert exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, and a two-minute drill to highlight what you've learned. This authoritative guide will help you pass the test and serve as your essential on-the-job reference. Get complete coverage of all objectives for exam 1Z0-047, including:
  • DDL and SQL SELECT statements
  • Manipulating, restricting, and sorting data
  • Single-row and group functions
  • Subqueries
  • Schema objects
  • Set operators
  • Data dictionary views
  • Large data sets
  • Hierarchical retrieval
  • Regular expression support
  • User access control
  • And more
On the CD-ROM:
  • One full practice exam
  • Detailed answers and explanations
  • Score report performance assessment tool
  • Complete electronic book
  • Bonus exam available with free online registration
For a complete list of Oracle Press titles, visit www.OraclePressBooks.com

Kundrecensioner

Sätt ditt betyg »

Fler böcker av Steve O'Hearn

Övrig information

April Wells is an Oracle DBA, an Oracle Apps DBA, and the author of several computer books. She has been a presenter at several Oracle User Group conferences.

Innehållsförteckning

Chapter 1. Introduction to SQL;Chapter 2. Using DDL Statements to Create and Manage Tables; Chapter 3. Manipulating Data; Chapter 4. Retrieving Data Using the SQL SELECT Statement; Chapter 5. Restricting and Sorting Data; Chapter 6. Using Single-Row Functions to Customize Output; Chapter 7. Reporting Aggregated Data Using the Group Functions; Chapter 8. Displaying Data from Multiple Tables; Chapter 9. Retrieving Data Using Subqueries; Chapter 10. Creating Other Schema Objects; Chapter 11. Managing Schema Objects; Chapter 12. Using the Set Operators; Chapter 13. Generating Reports by Grouping Related Data; Chapter 14. Managing Objects with Data Dictionary Views; Chapter 15. Manipulating Large Data Sets; Chapter 16. Hierarchical Retrieval; Chapter 17. Regular Expression Support; Chapter 18. Controlling User Access; Appendix A. About the CD; Glossary; Index

Du kanske gillar