OCA/OCP : introduction to Oracle9i SQL : study guide / Chip Dawes, Biju Thomas.

Format:

Book

Author/Creator:

Dawes, Chip.

Contributor:

Thomas, Biju.

Language:

English

Subjects (All):

Electronic data processing personnel--Certification.

Electronic data processing personnel.

Database management--Examinations--Study guides.

Database management.

SQL (Computer program language).

Oracle (Computer file).

Physical Description:

1 online resource (611 p.)

Edition:

1st ed.

Place of Publication:

San Francisco, CA : Sybex, 2002.

Language Note:

English

Summary:

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 CDAuthoritative 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

Contents:

OCA/OCP: Introduction to Oracle9i SQL; Acknowledgments; Contents at a Glance; Contents; Introduction; Why Become an Oracle Certified Professional?; What Does This Book Cover?; How to Contact the Authors; Assessment Test; Answers to Assessment Test; Chapter 1: Basic SQL SELECT Statements; SQL Fundamentals; Writing Simple Queries; Other Operators; Sorting Rows; Using Expressions; Summary; Exam Essentials; Key Terms; Commands Used in This Chapter; Review Questions; Answers to Review Questions; Chapter 2: SQL*Plus Overview; SQL*Plus Fundamentals; Producing More Readable Output

Accepting Values at RuntimeUsing iSQL*Plus; Summary; Exam Essentials; Key Terms; Commands Used in This Chapter; Review Questions; Answers to Review Questions; Chapter 3: Single-Row Functions; Single-Row Function Fundamentals; NULLs and Single-Row Functions; Using Single-Row Character Functions; Using Single-Row Numeric Functions; Using Single-Row Date Functions; Using Single-Row Conversion Functions; Using Other Single-Row Functions; Summary; Exam Essentials; Key Terms; Review Questions; Answers to Review Questions; Chapter 4: Aggregating Data And Group Functions; Group Function Fundamentals

Using Group FunctionsNesting Functions; Summary; Exam Essentials; Key Terms; Review Questions; Answers to Review Questions; Chapter 5: Joins and Subqueries; Multiple-Table Queries; Subqueries; Summary; Exam Essentials; Key Terms; Review Questions; Answers to Review Questions; Chapter 6: Modifying Data; Using DML Statements; Inserting into Multiple Tables; Updating Rows in a Table; Merging Rows into a Table; Deleting Rows from a Table; Truncating a Table; Selecting Rows; Locking a Table; Understanding Transaction Control; Summary; Exam Essentials; Key Terms; Review Questions

Answers to Review QuestionsChapter 7: Managing Tables and Constraints; Database Objects Review; Built-in Datatypes; Creating Tables; Modifying Tables; Managing Constraints; Creating Constraints; Dropping Constraints; Enabling and Disabling Constraints; Deferring Constraint Checks; Summary; Exam Essentials; Key Terms; Review Questions; Answers to Review Questions; Chapter 8: Managing Views; Creating and Modifying Views; Using Views; Summary; Exam Essentials; Key Terms; Review Questions; Answers to Review Questions; Chapter 9: Other Database Objects; Creating and Managing Sequences

Creating and Managing SynonymsCreating and Managing Indexes; Calling Stored Programs; Summary; Exam Essentials; Key Terms; Review Questions; Answers to Review Questions; Chapter 10: User Access and Security; Creating and Modifying User Accounts; Creating and Using Roles; Granting and Revoking Privileges; Managing User Groups with Profiles; Summary; Exam Essentials; Key Terms; Review Questions; Answers to Review Questions; Index

Notes:

"Exam 1Z0-007"--Cover.

ISBN:

1-280-65252-7

9786610652525

0-585-47721-3

0-7821-5250-3

OCLC:

476021388