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

  • 15h 14m
  • Biju Thomas
  • Sybex
  • 2009

Study, 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 exam
  • Practical hands-on exercises to reinforce critical skills
  • Real-world scenarios that put what you've learned in the context of actual job roles
  • Challenging review questions in each chapter to prepare you for exam day
  • Exam Essentials, a key feature in each chapter that identifies critical areas you must become proficient in before taking the exam

Look inside for complete coverage of all exam objectives.

About the Author

Biju Thomas is an Oracle 7.3, Oracle8, Oracle8i, Oracle9i, Oracle 10g, and Oracle 11g OCP certified professional. He is also a certified Oracle Database SQL Expert. Biju has been developing and administering Oracle databases since 1993, starting with Oracle version 6. He is a senior database consultant at OneNeck IT Services Corporation.

In this Book

  • SQL Fundamentals I Assessment Test
  • Administration I Assessment Test
  • Introducing SQL
  • Using Single‐Row Functions
  • Using Group Functions
  • Using Joins and Subqueries
  • Manipulating Data
  • Creating Tables and Constraints
  • Creating Schema Objects
  • Introducing Oracle Database 11g Components and Architecture
  • Creating an Oracle 11g Database
  • Allocating Database Storage and Creating Schema Objects
  • Understanding Network Architecture
  • Implementing Security and Auditing
  • Managing Data and Undo
  • Maintaining the Database and Managing Performance
  • Implementing Database Backups
  • Recovering the Database
  • Moving Data and Using EM Tools
  • Glossary
SHOW MORE
FREE ACCESS