OCA Oracle Database 11g: SQL Fundamentals I Exam Guide (Exam 1Z0-051) [With CDROM] [OCA ORACLE DATABAS 11G-W/CDROM] [Paperback]

by John Watson, Roopesh Ramklass

This exclusive Oracle Press guide will prepare certification candidates for the newly reintroduced Oracle Certified Associate Oracle Database 11g: SQL Fundamentals I exam. All exam topics are covered including installation, configuration, application tuning, database management, backup and recovery, security, and more. The CD-ROM contains two practice exams and an electronic copy of the book. About The Author: John Watson, OCP, is a senior consultant with BLP management Consultants. Roopesh Ramklass, OCP, is a technical specialist with 10 years of experience in a wide variety of IT environments. Table of Contents Chapter 1. Oracle Server Technologies and the Relational Paradigm Chapter 2. Data Retrieval Using the SQL SELECT Statement Chapter 3. Restricting and Sorting Data Chapter 4. Single-Row Function Chapter 5. Using Conversion Functions and Conditional Expressions Chapter 6. Reporting Aggregated Data Using the Group Functions Chapter 7. Displaying Data from Multiple Tables Chapter 8. Using Subqueries to Solve Problems Chapter 9. Using the Set Operators Chapter 10. Manipulating Data Chapter 11. Using DDL Statements to Create and Manage Tables Chapter 12. Creating Other Schema Objects Appendix Glossary Index

Audio CD

First published January 1, 2008

About the author

John^^^^Watson

Librarian Note: There is more than one author by this name in the Goodreads data base.