Book description
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
Table of contents
- Cover
- About the Author
- Copyright
- Dedication
- Contents at a Glance
- Contents
- Introduction
- 1. Oracle Server Technologies and the Relational Paradigm
- 2. Data Retrieval Using the SQL SELECT Statement
- 3. Restricting and Sorting Data
- 4. Single-Row Functions
- 5. Using Conversion Functions and Conditional Expressions
- 6. Reporting Aggregated Data Using the Group Functions
-
7. Displaying Data from Multiple Tables
-
Write SELECT Statements to Access Data from More Than One Table Using Equijoins and Nonequijoins
- Types of Joins
- Joining Tables Using SQL:1999 Syntax
- Qualifying Ambiguous Column Names
- The NATURAL JOIN Clause
- Exercise 7-1: Using the NATURAL JOIN
- The Natural JOIN USING Clause
- The Natural JOIN ON Clause
- Exercise 7-2: Using the NATURAL JOIN…ON Clause
- N-Way Joins and Additional Join Conditions
- Nonequijoins
- Join a Table to Itself Using a Self-Join
- View Data that Does Not Meet a Join Condition by Using Outer Joins
- Generate a Cartesian Product of Two or More Tables
- Two-Minute Drill
- Q&A Self Test
-
Write SELECT Statements to Access Data from More Than One Table Using Equijoins and Nonequijoins
- 8. Using Subqueries to Solve Problems
- 9. Using the Set Operators
- 10. Manipulating Data
- 11. Using DDL Statements to Create and Manage Tables
- 12. Creating Other Schema Objects
- Appendix
- Glossary
- Index
Product information
- Title: OCA Oracle Database 11g SQL Fundamentals I Exam Guide
- Author(s):
- Release date: June 2008
- Publisher(s): McGraw Hill Computing
- ISBN: 9780071643801
You might also like
book
OCA Oracle Database 12c SQL Fundamentals I Exam Guide (Exam 1Z0-061), 2nd Edition
A Complete Study System for OCA Exam 1Z0-061 Prepare for the Oracle Certified Associate Oracle Database …
book
Oracle Database 11g SQL
Write powerful SQL statements and PL/SQL programs Learn to access Oracle databases through SQL statements and …
book
Oracle Database 12c SQL
Write Powerful SQL Statements and PL/SQL Programs Learn how to access Oracle databases through SQL statements …
book
Oracle Database 12c The Complete Reference
Master the Cutting-Edge Features of Oracle Database 12c Maintain a scalable, highly available enterprise platform and …