OCA / OCP: Introduction to Oracle9i SQL Study Guide PDF Download

Author: Chip Dawes
Publisher: John Wiley & Sons
ISBN: 0782152503
Category : Computers
Languages : en
Pages : 611

View

Book 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

Author: Daniel Benjamin
Publisher: McGraw-Hill/Osborne Media
ISBN: 9780072195309
Category : Computers
Languages : en
Pages : 436

View

Book Description
This is the only authorized Oracle exam preparation for upgrading an Oracle8ito and Oracle9i certification, from the creators of Oracle certification bookstudy. The book focuses exclusively on the upgrade material need.

Author: Niemiec
Publisher: Tata McGraw-Hill Education
ISBN: 9780070540651
Category :
Languages : en
Pages : 0

View

Book Description
Maintain a high-performance Oracle9i environment using the proven tuning methods presented in this authoritative resource. This book offers hundreds of essential tips guaranteed to enhance system performance. Real-world examples illustrate insider best practices and in-depth details throughout the book highlight the new tuning options available in Oracle9i.

Author: Donald K. Burleson
Publisher: McGraw Hill Professional
ISBN: 9780072223040
Category : Computers
Languages : en
Pages : 544

View

Book Description
The definitive book covering Oracle databases in UNIX environments--the fastest growing segment of the Oracle database market. This guide contains proven techniques and UNIX scripts that can be used to perform dozens of UNIX related tasks.

Author: Matthew Weishan
Publisher: John Wiley & Sons
ISBN: 078215249X
Category : Computers
Languages : en
Pages : 532

View

Book Description
Here's the book you need to prepare for Exam 1Z0-032: Oracle9i Database: Fundamentals II. 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: Identifying solutions included with Oracle9i for managing complex networks Using Oracle Net Services and client server connections Establishing web client connections through Oracle networking products Troubleshooting database connections Using and configuring the Oracle Shared Server Backing up, restoring, and recovering databases Configuring the database archiving mode Using Recovery Manager (RMAN) Loading data into, and transporting data between databases Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Author: Donald K. Burleson
Publisher: McGraw-Hill Education
ISBN: 9780072223606
Category : Computers
Languages : en
Pages : 676

View

Book Description
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. Get complete coverage of STATSPACK—Oracle’s powerful tuning tool--inside this official guide Including ready-to-use STATSPACK scripts you’ll be able to collect and analyze system data and soon have your Oracle database running at peak performance.

Author: Joline Morrison
Publisher:
ISBN: 9780619159597
Category : Computers
Languages : en
Pages : 988

View

Book Description
Accompanying 2 CD-ROM set titled: Oracle9i developer suite.

Author: Kevin Loney
Publisher: McGraw-Hill Companies
ISBN:
Category : Oracle (Computer file)
Languages : en
Pages : 630

View

Book Description
This text provides readers with a comprehensive collection of SQL and PL/SQL scripts. It is organized into chapters by function and each script is fully documented with sample results shown. Readers can understand how the script works, learn to customize the script with confidence, and act properly on the script's results. Features include: scripts specifically for Oracle9i; a CD-ROM including major scripts from book; CD-icon with script name next to scripts that appear on the CD to allow for a quick search; a list of scripts and a brief description at the beginning of each chapter; and Programmer's Notes and Annotations that provide expert explanations on the scripts and how they can be customized.

Author: Nilesh Shah
Publisher: Pearson Education India
ISBN: 9332573093
Category :
Languages : en
Pages : 458

View

Book Description
Updated to cover Oracle 9i, this text first introduces students to relational database concepts and database designing techniques, then teaches them how to design and implement accurate and effective database systems. With its subsequent in-depth coverage of SQL (the universal query language for relational databases) and PL/SQL (Oracle's procedural language extension to SQL), this text serves not only as an introductory guide but also as a valuable future reference. Part IV, Advanced Topics, allows students to further understand and utilize Oracle 9i architecture and administration.

Author: Chip Dawes
Publisher: John Wiley & Sons
ISBN: 0782140629
Category : Computers
Languages : en
Pages : 611

View

Book Description
The perfect way to prepare for the Introduction to Oracle9i SQL 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, random-generated question sets, a bonus exam, and an electronic version of the book.