OCA: Oracle Database 11g Administrator Certified Associate Study Guide: Exams 1Z0-051 and 1Z0-052

OCA: Oracle Database 11g Administrator Certified Associate Study Guide: Exams 1Z0-051 and 1Z0-052

Paperback

By (author) Biju Thomas

$57.79
List price $94.27
You save $36.48 38% off

Free delivery worldwide
Available
Dispatched in 4 business days
When will my order arrive?

  • Publisher: John Wiley & Sons Ltd
  • Format: Paperback | 1152 pages
  • Dimensions: 188mm x 234mm x 58mm | 1,066g
  • Publication date: 6 April 2009
  • Publication City/Country: Chichester
  • ISBN 10: 0470395125
  • ISBN 13: 9780470395127
  • Edition statement: Study Guide
  • Sales rank: 637,634

Product description

Candidates for the Oracle Certified Associate in Oracle Database 11g need to pass Exams 1Z0-051 and 1Z0-052 to achieve their certification--this guide prepares you for taking both those exams. This two-in-one study guide covers the Oracle Certified Associate certification for Oracle database 11g and reviews exam topics such as restricting and sorting data, using conversion functions and conditional expressions, displaying data from multiple tables, and exploring the Oracle database architecture. Plus, you'll learn how to create and maintain an Oracle database, perform database backups and recovery, move and manipulate data, prepare the database environment, and more. Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file. For Instructors: Teaching supplements are available for this title.

Other people who viewed this bought:

Showing items 1 to 10 of 10

Other books in this category

Showing items 1 to 11 of 11
Categories:

Author information

Biju Thomas, OCA, OCP, is a senior database administrator with more than 15 years of Oracle application development and database management experience. He has coauthored five Oracle certification books published by Sybex and has written articles for multiple Oracle technical publications.

Back cover copy

Prepare for two OCA certification exams with this one bookStudy, practice, and review for OCA certification in Oracle 11g, Oracle's new release of its top-selling database software. Inside this in-depth guide, you'll find full coverage of essential topics for two required OCA certification exams: SQL Fundamentals I (1Z0-051) and Administration I (1Z0-052). Explore topics such as basic SQL SELECT statements, group functions, creating schema objects, restricting and sorting data, and much more with this essential two-in-one guide. Inside, you'll find: Full coverage of all exam objectives in a systematic approach, so you can be confident you're getting the instruction you need for the examPractical hands-on exercises to reinforce critical skillsReal-world scenarios that put what you've learned in the context of actual job rolesChallenging review questions in each chapter to prepare you for exam dayExam Essentials, a key feature in each chapter that identifies critical areas you must become proficient in before taking the examA handy tear card that maps every official exam objective to the corresponding chapter in the book, so you can track your exam prep objective by objectiveLook inside for complete coverage of all exam objectives.Featured on the CDSYBEX TEST ENGINE: Test your knowledge with advanced testing software. Includes all chapter review questions and bonus exams.ELECTRONIC FLASHCARDS: Reinforce your understanding with flashcards that can run on your PC, Pocket PC, or Palm handheld.Also on CD, you'll find the entire book in searchable and printable PDF. Study anywhere, any time, and approach the exam with confidence.

Table of contents

Part I: Oracle Database 11g: SQL Fundamentals I. 1. Basic SQL SELECT Statements. 2. Single-Row Functions. 3. Group Functions. 4. Joins and Sub-queries. 5. Modifying Data. 6. Creating Tables. 7. Creating Schema Objects. Part II: Oracle Database 11g: Administration I. 8. Oracle Database 11g Components and Architecture. 9. Create an Oracle11g Database. 10. Database Storage and Schema Objects. 11. Oracle Network Architecture. 12. Security and Auditing. 13. Managing Data and Undo. 14. Proactive Maintenance and Performance Monitoring. 15. Implementing Database Backups. 16. Recovering Database. 17. EM Tools and Data Utilities.