Chip Dawes, Biju Thomas

OCA/OCP: Introduction to Oracle9i SQL Study Guide

Exam 1Z0-007

• Gebundenes Buch

Produktbeschreibung

Here's the book you need to prepare for Exam 1Z0-007: Introduction to Oracle9i:
In-depth coverage of official exam objectives
Practical information on using SQL in a real-world Oracle9i environment
Hundreds of challenging review questions, in the book and on the CD
Authoritative coverage of all exam objectives, including:
Writing basic SQL SELECT statements
Restricting and sorting data
Displaying data from multiple tables
Aggregating data using group functions
Producing readable output with iSQL Plus
Creating and managing tables
Controlling user access

Produktdetails

• Verlag: Wiley & Sons
• 1. Auflage
• Seitenzahl: 592
• Englisch
• Abmessung: 239mm x 198mm x 41mm
• Gewicht: 1206g
• ISBN-13: 9780782140620
• ISBN-10: 0782140629
• Artikelnr.: 21917554

Autorenporträt

Chip Dawes is an OCP and has worked with Oracle databases since 1990. He is a consultant with D&D Technologies and frequently presents at various Oracle User Group conferences. Biju Thomas, OCP, has over 7 years of Oracle database management and application development experience. He currently works as a Database Administrator Consultant for Burlington Resources in Fort Worth, TX. Both authors contributed to OCP: Oracle8i DBA SQL Study Guide.

Inhaltsangabe

Introduction.
Assessment Test.
Chapter1 Basic SQL SELECT Statements.
Chapter2 SQL Plus Overview.
Chapter3 Single-Row Functions.
Chapter4 Aggregating Data And Group Functions.
Chapter5 Joins and Subqueries.
Chapter6 Modifying Data.
Chapter7 Managing Tables and Constraints.
Chapter8 Managing Views.
Chapter9 Other Database Objects.
Chapter10 User Access and Security.
Glossary.
Index.