Prepares students for the first exam in both the Oracle DBA and Internet Application Developer Certification Tracks, and offers a solid general understanding of Oracle9i SQL.

Using a series of labs with examples and exercises, this guide introduces how to write programs in PL/SQL with discussion of syntax and structured programming, iterative control, scoping and anchored databases, cursors, triggers, security, tables, and packaging and parameter passing techniques. Integrated book-and-Web learning solution teaches all of the Oracle PL/SQL skills you need, through hands-on, real-world labs, exercises, projects, and the Web-based training site.

Save 20% on four books! Prepare for the Oracle Certified Professional exams using this complete Oracle Press study system. In each book, you'll find in-depth details on all the material covered on these challenging exams, followed by practice questions and chapter summaries to highlight what you've learned. Books and CD-ROMs combined contain 1,200+ practice exam questions. This boxed set includes: OCP Introduction to Oracle9i: SQL Exam Guide, OCP Oracle9i Database: Fundamentals I Exam Guide, OCP Oracle9i Database: Fundamentals II Exam Guide, OCP Oracle9i Database: Performance Tuning Exam Guide.

Full Coverage of exams 1Z0-007 and 1Z0-031! Prepare for the Oracle Certified Associate (OCA) exams with this exam guide from the exclusive publishers of Oracle Press books. This volume is comprised of OCP Introduction to Oracle9i: SQL Exam Guide and OCP Oracle9i Database: Fundamentals I Exam Guide. Books and CD-ROMs combined contain more than 600 practice questions and cover all objectives for OCA certification.

The perfect way to prepare for the Oracle9i Performance Tuning exam! -Contains exam essentials, real-world scenario sidebars, scenario-based questions, and fill-in-the-blank questions. -The CD includes flashcards, chapter-by-chapter exams, randomly generated question sets, a bonus exam, and an electronic version of the book.

The perfect way to prepare for the Oracle9i DBA Fundamentals II exam! -Contains exam essentials, real-world scenario sidebars, scenario-based questions, and fill-in-the-blank questions. -The CD includes flashcards, chapter-by-chapter exams, randomly generated question sets, a bonus exam, and an electronic version of the book. The book you need to prepare for Exam 1Z1-032 Oracle 9i Database: Fundamentals II. Provides indepth coverage of official exam objectives and hundreds of challenging review questions. CD-ROM included.

Here's the book you need to prepare for Exam 1Z1-031: OCA/OCP: Oracle9i DBA Fundamentals I Study Guide In-depth coverage of official exam objectives Practical information on implementing and managing Oracle9i databases Hundreds of challenging review questions, in the book and on the CD Authoritative coverage of all exam objectives, including: Understanding Oracle architecture and its main components Identifying DBA administrative tools Setting up password file authentications Creating and managi ng Initialization Parameter Files Configuring OMF Create a database using Oracle Database Configuration Assistant Creating a database manually Featured on the CD The enclosed CD is packed with vital preparation tools and materials, beginning with the Sybex EdgeTest testing engine for the Oracle9i Fundamentals I exam. Loaded with hundreds of practice questions, it lets you test yourself chapter by chapter or according to objective areas. You'll also find electronic flashcards for your PC and Palm handhelds and two bonus exams that will help you prepare for the test. Also included is a complete electronic version of the book.

Get Certified with Official Exam Prep Material from Oracle Press. Prepare for the Oracle Certified Professional Oracle9i Database: Performance Tuning exam--a required exam for Oracle9i DBA certification--using this Oracle Press study guide. Throughout each chapter, you'll find in-depth details on all the material covered on this challenging exam, followed by practice questions and chapter summaries to highlight what you've learned. Authorized by Oracle Corporation, this book and CD-ROM package is the most comprehensive preparation tool available for the Oracle9i Database: Performance Tuning exam. Book and CD-ROM include more than 300 interactive exam-based questions. CD-ROM contains interactive exams that simulate the actual OCP exams and include hotlinked questions, answers, and explanations.

Prepare for the Oracle Certified Professional Oracle9i Database: New Features for Administrators exam--a required exam for upgrading your Oracle8i or earlier DBA certification--using this Oracle Press study guide. Throughout each chapter, you'll find in-depth details on all the material covered on this challenging exam, followed by practice questions and chapter summaries to highlight what you've learned. Authorized by Oracle Corporation, this book and CD-ROM package is the most comprehensive pr eparation tool available for the Oracle9i Database: New Features for Administrators exam. Book and CD-ROM include more than 300 interactive exam-based questions. CD-ROM contains interactive exams that simulate the actual OCP exams and include hotlinked questions, answers, and explanations.

Learn the ins and outs of 9i with the OCA/OCP: Introduction to Oracle9i SQL Study Guide. This release from Sybex will prepare you for Exam 1Z0-007, Introduction to Oracle9i: SQL. You get hundreds of challenging review questions in the book and on the CD and authoritative coverage of all exam objectives. 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 en Hundr eds 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.

Prepare for the Oracle Certified Professional Oracle9i Database: Fundamentals II exam--a required exam for Oracle9i DBA certification--using this Oracle Press study guide. Throughout each chapter, you'll find in-depth details on all the material covered on this challenging exam, followed by practice questions and chapter summaries to highlight what you've learned. Authorized by Oracle Corporation, this book and CD-ROM package is the most comprehensive preparation tool available for the Oracle9i Database: Fundamentals II exam.

Prepare for the Oracle Certified Professional Oracle9i Database: Fundamentals I exam--a required exam for Oracle9i DBA certification--using this Oracle Press study guide. Throughout each chapter, you'll find in-depth details on all the material covered on this challenging exam, followed by practice questions and chapter summaries to highlight what you've learned. Authorized by Oracle Corporation, this book and CD-ROM package is the most comprehensive preparation tool available for the Oracle9i D atabase: Fundamentals I exam.

This book delivers comprehensive coverage of exam objectives, presented according to Oracle's certification guide. Because Oracle's exam scoring provides section scores according to exact objectives, this organization of the book allows you to refocus. Each exam objective is covered in a chapter complete with self-assessment opportunities. Four appendices include a listing and description of Oracle's initialization parameters and other elements to be tested on the exam. These appendices provide information useful post-exam in real-work implementation of Oracle Systems.

Prepare to pass the OCP Building Internet Applications I ; II exams--two of four required exams for OCP Application Developer certifications--using this Oracle Press study guide. You'll get complete coverage of all exam topics followed by practice questions and chapter summaries. The CD-ROM contains hundreds of practice exam questions in an adaptive format.

Oracle 8i Performance and Tuning Exam Cram is the most recognized, and highly focused, exam preparation product available to professionals gearing up for the Oracle 8i Network Administration exam (1Z0-024). The book's well organized, concise layout provides thorough coverage of test content and objectives like describing Oracle Alert and Trace files, tuning the Shared Pool and Buffer Cache.

Oracle 8i Backup and Recovery Exam Cram is the most recognized, and highly focused, exam preparation product available to professionals gearing up for the Oracle 8i Backup and Recovery exam (1Z0-025). The book's well organized, concise layout provides thorough coverage of test content and objectives like using Oracle export and import utilities, understanding utilities for troubleshooting, describing Oracle recovery catalog creation and maintenance, and configuring an Oracle standby database. In cludes the supportive Exam Cram features of helpful hints and tips, test taking strategies, realistic case studies, and challenging practice questions.

Test your knowledge with exclusive software to prepare you for all five OCP Oracle8i DBA exams. --Contains 1000 questions in a tough adaptive format with a unique benchmarking feature to help you identify weak areas. --Delivers four sample exams for each test and is a great companion to the Sybex OCP: Oracle8i Study Guides.

Boxed set certification kit for the Oracle 8i DBA exams, numbers 1Z0-001, 1Z0-023, 1Z0-024, 1Z0-025, and 1Z0-026. Includes three study guide texts, each with its own CD-ROM. Each includes custom testing engines with hundreds of sample questions, electronic flashcards for PC and Palm devices, and other helpful features.

Prepare to pass All Five exams required for OCP DBA Certification. The only OCP DBA exam guide officially authorized by Oracle Corporation, this book/CD-ROM package offers comprehensive coverage of all five required exams: 1Z0-001: SQL and PL/SQL, 1Z0-023: Database Administration, 1Z0-025: Backup/Recovery, 1Z0-024: Tuning, 1Z0-026: Net8 Administration

The DBA (database administrator) track is the most popular, with more than 8,000 DBAs being certified each year. Sybex's OCP DBA Study Guides provide complete coverage of exam objectives for the five exams in the DBA track: SQL and PL/SQL, Database Administration, Backup & Recovery, Performance Tuning, and Network Administration. The books are fully up-to-date for Oracle8i and include all the new features of Sybex's best-selling Study Guides. The companion CDs contain exclusive self-testing software. The DBO (database operator) exam is a new offering from Oracle, which prepares students for the full DBA track. It is fully supported by Oracle's partners: Sun, Novell, Compaq, and HP. Sybex's Study Guide provides complete coverage of the exam objectives and includes a companion CD with exclusive self-testing software.

Make a smart career move and begin enjoying all the rewards of OCP Financial Applications Consultant certification! This Oracle-endorsed study guide offers a complete preparation system geared to help you pass your exams with flying colors! The design of Oracle Press's OCP series is unprecedented in its level of focus. It provides readers with thorough explanatory text and plenty of examples. Following the main content will be: short chapter review; two-minute drill; 10-15 multiple choice questi ons modeled after the OCP exam questions and answers to chapter questions along with explanations. CD-ROM includes electronic, fully searchable version of the Exam Guide hyperlinked to over 300 practice exam questions.

Specially designed and written to help you pass the Oracle8: Network Administration (1Z0-016) exam, Oracle DBA Network Administration Exam Cram is packed with time-saving study tips, test-taking strategies, and warnings on how to deal with trick questions. Includes a sixty-two question sample test with answer key and a special CRAM SHEET with tips, acronyms, and memory joggers with help you pass the exam the first time. Oracle DBA Network Administration Exam Cram will help you learn how to use t he Net8 Assistant; configure local naming; configure host naming; configure an Oracle Names Server; set up connection pooling; configure LISTENER processes; set up multiple LISTENER processes on a server; configure client profiles; set parameters for MTS; monitor MTS processes; set up connection; start, stop, and monitor LISTENER; configure Intelligent Agent; start, stop, and monitor Intelligent Agent; implement security with Net8; troubleshoot Net8 problems on the client and the server, use the Connection Manager.