Name: OCA Oracle Database 11g SQL Fundamentals I Exam Guide By John Watson
SKU: 9780071597869
Price: 36.99 AUD
Availability: InStock

OCA Oracle Database 11g SQL Fundamentals I Exam Guide Summary

OCA Oracle Database 11g SQL Fundamentals I Exam Guide by John Watson

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

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 is an Oracle Certified Master with expertise in middleware and database architecture. He has worked for Oracle Global Support, Advanced Customer Services, and Oracle University. He is actively involved in the Oracle community, speaking at Oracle conferences, serving as an executive of the Toronto Oracle Users Group, and participating in the Oracle ACE program. Roopesh is the author of several Oracle technology books and blogs and is passionate about serving others through education.

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

Additional information

Sku

GOR005419085

ISBN 13

9780071597869

ISBN 10

0071597867

Title

OCA Oracle Database 11g SQL Fundamentals I Exam Guide by John Watson

Author

John Watson

Series

Oracle Press

Condition

Used - Very Good

Binding type

Hardback

Publisher

McGraw-Hill Education - Europe

Year published

2008-06-19

Number of pages

581

Prizes

N/A

Cover note

Book picture is for illustrative purposes only, actual binding, cover or edition may vary.

Note

This is a used book - there is no escaping the fact it has been read by someone else and it will show signs of wear and previous use. Overall we expect it to be in very good condition, but if you are not entirely satisfied please get in touch with us

OCA Oracle Database 11g SQL Fundamentals I Exam Guide John Watson

OCA Oracle Database 11g SQL Fundamentals I Exam Guide by John Watson

Summary

OCA Oracle Database 11g SQL Fundamentals I Exam Guide Summary

OCA Oracle Database 11g SQL Fundamentals I Exam Guide by John Watson

About John Watson

Table of Contents

Additional information

Customer Reviews - OCA Oracle Database 11g SQL Fundamentals I Exam Guide