OCA Oracle Database 11g SQL Fundamentals I Exam Guide Exam 1Z0-051
by Watson, John; Ramklass, RoopeshEdition: 1st
Format: Package
Pub. Date: 2008-06-19
Publisher(s): McGraw-Hill Education
Other versions by this Author
-
This Item Qualifies for Free Shipping!*
*Excludes marketplace orders.
List Price: $65.10
Buy New
Arriving Soon. Will ship when available.
$62.00
Rent Book
Select for Price
Used Book
We're Sorry
Sold Out
eBook
We're Sorry
Not Available
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. |
An electronic version of this book is available through VitalSource.
This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.
By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.
Digital License
You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.
More details can be found here.
A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.
Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.
Please view the compatibility matrix prior to purchase.