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

by Thomas, Biju

• ISBN13: 9780470395127
• ISBN10: 0470395125
• Edition: 1st
• Format: Paperback
• Copyright: 2009-04-06
• Publisher: Sybex

Summary

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.

Author Biography

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.

Table of Contents

Oracle Database 11g: SQL Fundamentals I

Basic SQL SELECT Statements

Single-Row Functions

Group Functions

Joins and Sub-queries

Modifying Data

Creating Tables

Creating Schema Objects

Oracle Database 11g: Administration I

Oracle Database 11g Components and Architecture

Create an Oracle11g Database

Database Storage and Schema Objects

Oracle Network Architecture

Security and Auditing

Managing Data and Undo

Proactive Maintenance and Performance Monitoring

Implementing Database Backups

Recovering Database

EM Tools and Data Utilities

Table of Contents provided by Publisher. All Rights Reserved.