OCA Oracle Database 11g SQL Fundamentals I Exam Guide

OCA Oracle Database 11g SQL Fundamentals I Exam Guide

3.72 (43 ratings by Goodreads)
By (author)  , By (author) 

Free delivery worldwide

Available. Dispatched from the UK in 2 business days
When will my order arrive?


Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.

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
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
show more

Product details

  • Book | 581 pages
  • 191 x 229 x 31mm | 1,009g
  • MCGRAW-HILL Professional
  • New York, NY, United States
  • English
  • 200 Illustrations, unspecified
  • 0071597867
  • 9780071597869
  • 264,372

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
show more

About John Watson

John Watson (UK) OCP DBA 8.0, 8.i, & 9i, 10g, 11g, Interrnet Application Server Administrator, and certified on Managing Oracle on Unix, is a senior consultant with BLP Management Consultants, and taught for Oracle University in South Africa for four years. John taught the DB10g New Features course, the DB10g Manageability and Performance seminars. He validated hundreds of OCP 10g New Features exam questions and contributed to the course material for all the 10g courses. John is the author of numerous articles on technology.

Roopesh Ramklass, OCM, is a technical specialist with 10 years of experience in a wide variety of IT environments, including software development, system administration, systems analysis, software design, systems architecture, courseware development, and lecturing. Ramklass is experienced in managing and executing IT development projects, including infrastructure systems provisioning, software development, and systems integration.
show more

Rating details

43 ratings
3.72 out of 5 stars
5 28% (12)
4 33% (14)
3 26% (11)
2 12% (5)
1 2% (1)
Book ratings by Goodreads
Goodreads is the world's largest site for readers with over 50 million reviews. We're featuring millions of their reader ratings on our book pages to help you find your new favourite book. Close X