OCA / OCP: Introduction to Oracle9i SQL Study Guide: Exam 1Z0-007

OCA / OCP: Introduction to Oracle9i SQL Study Guide: Exam 1Z0-007
ISBN-10
0782152503
ISBN-13
9780782152500
Category
Computers
Pages
592
Language
English
Published
2006-02-20
Publisher
John Wiley & Sons
Authors
Chip Dawes, Biju Thomas

Description

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

Other editions

Similar books

  • Oca/Ocp: Introduction To Oracle 9I Sql Study Guide (Exam 1Z0-007)
    By Chip Dawes, Biju Thomas

    Here's The Book You Need To Prepare For Exam 1Z0-007: Introduction To Oracle9I:,1) In-Depth Coverage Of Official Exam Objectives,2) Practical Information On Using Sql In A Real-World Oracle9I Environment,3) Hundreds...

  • OCP Introduction to Oracle9i: SQL Exam Guide
    By Jason Couchman

    ... FUNCTIONS ------------------------------ SMITH does the filing---- ALLEN does the golfing--- WARD does the golfing--- JONES does the managing-- TIP This example also illustrates another important principle—the output from one SQL ...

  • OCP Introduction to Oracle9i: SQL Exam Guide
    By Jason S. Couchman

    Prepare to pass the OCP Introduction to Oracle9i SQL exam--a required exam for OCA/OCP DBA certification--using this Oracle Press study guide.

  • OCA / OCP: Oracle9i DBA Fundamentals I Study Guide: Exam 1Z0-031
    By Bob Bryla, Biju Thomas

    Whenever an extent is allocated or freed, the information is updated in the corresponding dictionary tables. Such updates also generate undo information. If you store the management information in a tablespace itself, by using bitmaps ...

  • OCP: Oracle9i Performance Tuning Study Guide: Exam 1Z0-033
    By Joseph C. Johnson

    Sybex offers several study guides to help you achieve this certification: OCA/OCP: Introduction to Oracle9iTM SQL Study Guide (exam 1Z0-007: Introduction to Oracle9i: SQL) OCA/OCP: Oracle9iTM DBA Fundamentals I Study Guide (exam ...

  • OCP: Oracle9i DBA Fundamentals II Study Guide: Exam 1Z0-032
    By Matthew Weishan, Doug Stuns

    Oracle9i: High Availability in an Internet Environment Oracle9i: Database: Implement Partitioning Oracle9i: Real ... Sybex offers several study guides to help you achieve this certification: OCA/OCP: Introduction to Oracle9iTM SQL Study ...

  • Oracle9i DBA JumpStart
    By Bob Bryla

    Oracle Certified Associate (OCA) OCA candidates must pass two exams: Introduction to Oracle9i: SQL (1Z0-007) and Oracle9i ... To help you obtain the OCA, Sybex provides the following: · OCA/OCP: Introduction to Oracle9i SQL Study Guide ...

  • OCA: Oracle Database 12c Administrator Certified Associate Study Guide: Exams 1Z0-061 and 1Z0-062
    By Biju Thomas

    Written by an industry expert with hands-on Oracle database experience, this book not only prepares you for the OCA exams, but also for the day-to-day work world of a database administrator.

  • Mastering Dreamweaver MX Databases
    By Susan Sales Harkins, Bryan Chamberlain, Darren McGee

    Mastering Dreamweaver MX Databases equips you with all the coding and database skills you need.

  • OCP: Oracle Database 11g Administrator Certified Professional Study Guide: Exam 1Z0-053
    By Robert G. Freeman, Doug Stuns, Charles A. Pack

    This updated study guide for the latest release of the most popular database software in the world—Oracle Database 11g— reviews using the RMAN recovery catalog, handling Flashback technology, managing memory and resources, automating ...