OCA Oracle Database 11g: SQL Fundamentals I Exam Guide (Exam 1Z0-051)

OCA Oracle Database 11g: SQL Fundamentals I Exam Guide (Exam 1Z0-051)

9780071597869 (0071597867), McGraw-Hill, 2008

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

Prepare for the Oracle Certified Associate Oracle Database 11g: SQL Fundamentals I exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary 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 OCA objectives for exam 1Z0-051, including:

SQL SELECT statements
Restricting and sorting data
Single-row functions
Conversion functions and conditional expressions
Group functions
Displaying data from multiple tables
Subqueries
Set operators
DML and DDL statements
Schema objects

On the CD-ROM:

One full practice exam that simulates the actual OCA exam
Detailed answers and explanations
Score report performance assessment tool
Complete electronic book
Bonus exam available free with online registration

About the Author

John Watson, OCP, is a senior consultant with BLP management Consultants and taught for Oracle University in South Africa for four years. He is the coauthor of Oracle Database 10g OCP Certification All-in-One Exam Guide.

Roopesh Ramklass, OCP, is a technical specialist with 10 years of experience in a wide variety of IT environments.

Advertisement

Comments

Amazing Books

OCA Oracle Database 11g: Administration I Exam Guide (Exam 1Z0-052)

McGraw-Hill, 2008

There are several Oracle certification tracks—this book is concerned with the Oracle Database Administration certification track, specifically for release 11g of the database. There are three levels of DBA certification: Certified Associate (OCA), Certified Professional (OCP), and Certified Master (OCM). The OCA qualification is based on two...

Oracle Database 11g, A Beginner's Guide

McGraw-Hill, 2008

The release of Oracle Database 11g is one that comes with much anticipation. We are at a time when data is exploding and the cost of operations must be reduced. Oracle 11g is a release that addresses many of these concerns and provides a database that can help organizations move forward without boundaries. With the release of Oracle Database 11g: A...

OCP: Oracle Database 11g Administrator Certified Professional Study Guide: (Exam 1Z0-053)

Sybex, 2009

This updated study guide for the latest release of the most popular database software in the world—Oracle Database 11g— reviews using the RMAN recovery catalog, handling Flashback technology, managing memory and resources, automating tasks, diagnosing the database, and much more. Plus, more than 100 pages of workbook exercises...

OCP Oracle Database 11g Administration II Exam Guide: Exam 1Z0-053 (Osborne ORACLE Press Series)

McGraw-Hill, 2008

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

Prepare for the Oracle Certified Associate Oracle Database 11g Administration I exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary to...

Database Design Using Entity-Relationship Diagrams (Foundations of Database Design, 1)

Auerbach Publications, 2003

Database Design Using Entity-Relationship Diagrams clarifies ER diagram design by defining it in terms of requirements (end user requests) and specifications (designer feedback to that request). The book emphasizes how communication between designers and users during design is crucial for the elicitation of targeted data, and for the creation of...

Oracle SQL Recipes: A Problem-Solution Approach

Apress, 2009

Have you ever been faced with a new type of query to write, or been asked to create an unfamiliar database object? In such situations, you have probably wanted a good, solid example upon which to build, and instead have been forced into the drudgery of parsing railroad-style syntax diagrams in Oracle's manual set. This book frees you from that...