OCA Oracle Database Sql Expert Exam Guide (Exam 1Z0-047)

ISBN-10: 0071614214

ISBN-13: 9780071614214

Edition: 2010

List price: $68.00 Buy it from $21.00
eBook available
This item qualifies for FREE shipping

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

30 day, 100% satisfaction guarantee

If an item you ordered from TextbookRush does not meet your expectations due to an error on our part, simply fill out a return request and then return it by mail within 30 days of ordering it for a full refund of item cost.

Learn more about our returns policy

Description: A fully integrated study system for Oracle Certification exam 1Z0-047This exclusive Oracle Press guide covers all of the objectives on the newly created Oracle SQL Expert exam in detail, including control privileges, creating indexes and constraints, altering existing schema objects, creating and querying external tables, and using the advanced SQL features to query and manipulate data within the database.Oracle Database SQL Expert Exam Guide features real-world examples, practice questions, and chapter summaries to help you learn the material. The CD-ROM contains two practice exams and an electronic copy of the book.

New Starting from $48.53
eBooks Starting from $68.00
Buy eBooks
what's this?
Rush Rewards U
Members Receive:
coins
coins
You have reached 400 XP and carrot coins. That is the daily max!

Study Briefs

Limited time offer: Get the first one free! (?)

All the information you need in one place! Each Study Brief is a summary of one specific subject; facts, figures, and explanations to help you learn faster.

Add to cart
Study Briefs
Periodic Table Online content $4.95 $1.99
Add to cart
Study Briefs
SQL Online content $4.95 $1.99
Add to cart
Study Briefs
MS Excel® 2010 Online content $4.95 $1.99
Add to cart
Study Briefs
MS Word® 2010 Online content $4.95 $1.99

Customers also bought

Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading

Book details

List price: $68.00
Copyright year: 2010
Publisher: McGraw-Hill Osborne
Publication date: 12/23/2009
Binding: Paperback
Pages: 796
Size: 7.50" wide x 9.25" long x 1.75" tall
Weight: 2.992
Language: English

Joseph Phillips, PMP, CompTIA Project+, CompTIA CTT+, a leading project management consultant and educator, has been a PMP and a CompTIA Certified Technical trainer for more than 12 years. He is the director of education for Project Seminars, Inc., and the bestselling author of several books, including PMP Project Management Professional Study Guide, Fourth Edition and CompTIA CTT+ Certified Technical Trainer All-in-One Exam Guide.Editor Admir Hadzic, MD, PhD Professor of Anesthesiology Department of Anesthesiology St. Luke's-Roosevelt Hospital Center College of Physicians & Surgeons Columbia University New York, New York Associate Editors Ana Carrera, PhD, MD Thomas B. Clark, DC, RVT Jeff Gadsden, MD, FRCPC, FANZCA Manoj Kumar Karmakar, MD, FRCA, FHKCA, FHKAM Xavier Sala-Blanch, MD Catherine F.M. Vandepitte, MD Daquan Xu, MD, MSc, MPHSteve O’Hearn, OCP (Bowie, MD) has been an Oracle Certified Application Developer since 1999 and has designed databases for the U.S. Army, U.S. Navy, the FAA, the World Bank, NASA, and others. He is the author of OCP Developer PL/SQL Program Units Exam Guide and OCA Oracle Database SQL Certified Expert Exam Guide, both from Oracle Press.

Retrieving Data Using the SQL Select Statement
Restricting and Sorting Data
Using Single-Row Functions to Customize Output
Reporting Aggregated Data Using the Group Functions
Displaying Data from Multiple Tables
Using Subqueries to Solve Queries
Using the Set Operators
Manipulating Data
Using DDL Statements to Create and Manage Tables
Creating Other Schema Objects
Managing Objects with Data Dictionary Views
Controlling User Access
Managing Schema Objects
Manipulating Large Data Sets
Generating Reports by Grouping Related Data
Managing Data in Different Time Zones
Retrieving Data Using Subqueries
Hierarchical Retrieval
Regular Expression Support
×
Free shipping on orders over $35*

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

Learn more about the TextbookRush Marketplace.

×