9780071597869

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

by ;
  • ISBN13:

    9780071597869

  • ISBN10:

    0071597867

  • Edition: 1st
  • Format: Package
  • Copyright: 2008-06-19
  • Publisher: McGraw-Hill Education
  • View Upgraded Edition
  • Purchase Benefits
  • Free Shipping On Orders Over $35!
    Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • Get Rewarded for Ordering Your Textbooks! Enroll Now
List Price: $62.00 Save up to $9.30
  • Buy New
    $52.70
    Add to Cart Free Shipping

    USUALLY SHIPS IN 3-4 BUSINESS DAYS

Supplemental Materials

What is included with this book?

  • The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

Summary

Complete exam prep from Oracle Press - This exclusive Oracle Press guide will prepare certification candidates for the newly reintroduced Oracle Certified Associate Oracle Database 11 g: 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.

Author Biography

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.

Table of Contents

Oracle Server Technologies and the Relational Paradigm
Retrieving Data Using the SQL SELECT Statement
Restricting and Sorting Data
Using Single-Row Functions to Customize Output
Using Conversion Functions and Conditional Expressions
Reporting Aggregated Data Using the Group Functions
Displaying Data From Multiple Tables
Using Sub-queries to Solve Queries
Using the SET Operators
Manipulating Data
Using DDL Statements to Create and Manage Tables
Creating Other Schema Objects About the CD
Glossary
Table of Contents provided by Publisher. All Rights Reserved.

Rewards Program

Write a Review