OCA / OCP (eBook)

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

Chip Dawes, Biju Thomas (Autoren)

eBook Download: PDF

2006 | 1. Auflage
592 Seiten
John Wiley & Sons (Verlag)
978-0-7821-5250-0 (ISBN)

Infos

Here's the book you need to prepare for Exam 1Z0-007: Introductionto Oracle9i:* In-depth coverage of official exam objectives* Practical information on using SQL in a real-world Oracle9ienvironment* Hundreds of challenging review questions, in the book and on theCDAuthoritative 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

Autor

Chip Dawes is an OCP and has worked with Oracle databasessince 1990. He is a consultant with D&D Technologies andfrequently presents at various Oracle User Group conferences.Biju Thomas, OCP, has over 7 years of Oracle databasemanagement and application development experience. He currentlyworks as a Database Administrator Consultant for BurlingtonResources in Fort Worth, TX. Both authors contributed to OCP:Oracle8i DBA SQL Study Guide.

Inhalt

Introduction.Assessment Test.Chapter 1 Basic SQL SELECT Statements.Chapter 2 SQL*Plus Overview.Chapter 3 Single-Row Functions.Chapter 4 Aggregating Data And Group Functions.Chapter 5 Joins and Subqueries.Chapter 6 Modifying Data.Chapter 7 Managing Tables and Constraints.Chapter 8 Managing Views.Chapter 9 Other Database Objects.Chapter 10 User Access and Security.Glossary.Index.

Produkt-Details

• Erscheint lt. Verlag: 17.11.2006
• Sprache: englisch
• Themenwelt: Mathematik / Informatik ► Informatik
• Schlagworte: Certification (MSCE, Novell, etc.) • Oracle • Prüfungsvorbereitung • Prüfungsvorbereitung • Test Prep • Zertifizierung f. MSCE u. Novell
• ISBN-10: 0-7821-5250-3 / 0782152503
• ISBN-13: 978-0-7821-5250-0 / 9780782152500