Oracle Database SQL Expert Exam Guide (Exam 1Z0-047)

Complete Exam Preparation

Steve O'Hearn, Gavin Powell, April J. Wells

712 pages, parution le 01/10/2009

Ajouter à une liste

Indisponible

Résumé

This is a fully integrated study system for Oracle Certification exam 1Z0-047. This exclusive Oracle Press guide covers all of the objectives on the newly created Oracle SQL Expert exam in detail, including control privileges, creating indexes and constraints, altering existing schema objects, creating and querying external tables, and using the advanced SQL features to query and manipulate data within the database. Oracle Database SQL Expert Exam Guide features real-world examples, practice questions, and chapter summaries to help you learn the material. The CD-ROM contains two practice exams and an electronic copy of the book.

L'auteur - Gavin Powell

Gavin Powell BSc. Comp.Sci., OCR (Oracle Certified Professional), author of Oracle High Performance Tuning for 9i and 10g and Oracle SQL with Carol McCullogh-Dieter, has nineteen years of diverse experience in database administration and development, using both relational and object databases. His applications experience is both procedural and object-oriented. Powell has consulted for software vendors, internet dot-corns, accounting, banking, financial services, travel, construction, retail, mining, shipping, education and training companies in various parts of the world.

Autres livres de Gavin Powell

Oracle Performance Tuning for 10gR2

Découvrir tous les livres de Gavin Powell

L'auteur - April J. Wells

April Wells is a Senior Oracle DBA, APRS DBA, and DB2 DBA and an Oracle 8, 8i, and 9i OCR April has recently published articles for Oracle 11i E-Business Suite from the Front Lines, Grid Database Design, and InformlT. She graduated with a BS in information science from the University of Pittsburgh's School of Library and Information Sciences and earned her MBA from the Texas A&M University system.

Sommaire

Introduction to SQL
Using DDL Statements to Create and Manage Tables
Manipulating Data
Retrieving Data Using the SQL SELECT Statement
Restricting and Sorting Data
Using Single-Row Functions to Customize Output
Reporting Aggregated Data Using the Group Functions
Displaying Data from Multiple Tables
Retrieving Data Using Subqueries
Creating Other Schema Objects
Managing Schema Objects
Using the Set Operators
Generating Reports by Grouping Related Data
Managing Objects with Data Dictionary Views
Manipulating Large Data Sets
Hierarchical Retrieval
Regular Expression Support
Controlling User Access
Appendix A. About the CD
Glossary
Index

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	Mc Graw-Hill - Osborne
Auteur(s)	Steve O'Hearn, Gavin Powell, April J. Wells
Parution	01/10/2009
Nb. de pages	712
Couverture	Broché
Poids	1312g
Intérieur	Noir et Blanc
EAN13	9780071614214
ISBN13	978-0-07-161421-4

Avantages Eyrolles.com

Livraison à partir de 0,01 € en France métropolitaine

Paiement en ligne SÉCURISÉ

Livraison dans le monde

Retour sous 15 jours

+ d'un million et demi de livres disponibles