Gardening Sale!
 
 

Special Offers see all

Enter to WIN!

Weekly drawing for $100 credit. Subscribe to our Specials newsletter for a chance to win.
Privacy Policy

More at Powell's

Recently Viewed clear list

Guests | May 15, 2013

Samuel Sattin: IMG Nanny of the Corn

0 comments By Samuel Sattin

Fear was my gateway to becoming interested in stories. My nanny growing up, a Scottish expat named Jackie with a fox pelt of red hair and a manic... Continue »
  1. $13.27 Sale Trade Paper add to wish list

    League of Somebodies

    Samuel Sattin 9780985035501
spacer
Ships free on qualified orders.
$62.00
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Qty Store Section
6 Local Warehouse Computers Reference- General

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

by

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

 

Synopses & Reviews

Publisher Comments:

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

Synopsis:

Complete exam prep from Oracle Press 

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.

back to top

About the Author

McGraw-Hill authors represent the leading experts in their fields and are dedicated to improving the lives, careers, and interests of readers worldwide
back to top

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

back to top
back to top

Product Details

ISBN:
9780071597869
Author:
Ramklass, Roopesh
Publisher:
McGraw-Hill/Osborne Media
Author:
Watson, John
Subject:
Non-Classifiable
Subject:
Technical Skills
Subject:
Oracle certification, OCA, 1Z0-051, OCA Oracle Database 11g Administration I Exam Guide, OCP Oracle Database 11g Administration II Exam Guide
Subject:
Electronic data processing personnel
Subject:
Certification
Subject:
Certification Guides - General
Subject:
Database Management - General
Subject:
Database Management - Oracle
Subject:
Oracle certification, OCA, 1Z0-051, OCA Oracle Database 11g Administration I Exam Guide, OCP Oracle Database 11g Administration II Exam Guide, 0071598758, 0071604596, 0071494456, 0071496610, 0071496637, 0071591028, 0071597867, 0071496823, 0071597093, 0071
Subject:
Oracle certification, OCA, 1Z0-051, OCA Oracle Database 11g Administration I Exam Guide, OCP Oracle Database 11g Administration II Exam Guide, 0071598758, 0071604596, 0071494456, 0071496610, 0071496637, 0071591028, 0071597867, 0071496823, 0071597093, 0071
Subject:
Computers-Reference - General
Copyright:
2009
Edition Description:
Softcover with CDROM
Series:
Osborne ORACLE Press Series
Publication Date:
June 2008
Binding:
TRADE PAPER
Grade Level:
Professional and scholarly
Language:
English
Illustrations:
Y
Pages:
573
Dimensions:
9.22x7.39x1.26 in. 2.29 lbs.
back to top

Related Subjects

Computers and Internet » Computers Reference » General
Computers and Internet » Database » Design
Computers and Internet » Software Engineering » Software Management
Reference » Test Guides
Transportation » Nautical » Boats » Boating

OCA Oracle Database 11g: SQL Fundamentals I Exam Guide (Exam 1Z0-051) with CDROM New Trade Paper
0 stars - 0 reviews
$62.00 In Stock
Product details 573 pages McGraw-Hill/Osborne Media - English 9780071597869 Reviews:
"Synopsis" by ,

Complete exam prep from Oracle Press 

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.
spacer
spacer
  • back to top
Follow us on...




Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and eBooks — here at Powells.com.