OCA Oracle Database 11g: SQL Fundamentals I Exam Guide (Exam 1Z0-051)

Erscheinungsjahr 2008
ISBN: 978-0-07-026499-1
Verlag: McGraw-Hill Education

Sonstiges, Englisch, Format (B × H): 185 mm x 242 mm

Autoren/Hrsg.

Watson, John

Ramklass, Roopesh

Fachgebiete

• Mathematik | Informatik EDV | Informatik Informatik

Inhaltsverzeichnis

Chapter 1. Oracle Server Technologies and the Relational Paradigm
Chapter 2. Data Retrieval Using the SQL SELECT Statement
Chapter 3. Restricting and Sorting Data
Chapter 4. Single-Row Function
Chapter 5. Using Conversion Functions and Conditional Expressions
Chapter 6. Reporting Aggregated Data Using the Group Functions
Chapter 7. Displaying Data from Multiple Tables
Chapter 8. Using Subqueries to Solve Problems
Chapter 9. Using the Set Operators
Chapter 10. Manipulating Data
Chapter 11. Using DDL Statements to Create and Manage Tables
Chapter 12. Creating Other Schema Objects
Appendix
Glossary
Index

Über Autor(innen)

Ramklass, Roopesh
Roopesh Ramklass, OCM, is a technical specialist with 10 years of experience in a wide variety of IT environments, including software development, system administration, systems analysis, software design, systems architecture, courseware development, and lecturing. Ramklass is experienced in managing and executing IT development projects, including infrastructure systems provisioning, software development, and systems integration.

Watson, John
John Watson (UK) OCP DBA 8.0, 8.i, & 9i, 10g, 11g, Interrnet Application Server Administrator, and certified on Managing Oracle on Unix, is a senior consultant with BLP Management Consultants, and taught for Oracle University in South Africa for four years. John taught the DB10g New Features course, the DB10g Manageability and Performance seminars. He validated hundreds of OCP 10g New Features exam questions and contributed to the course material for all the 10g courses. John is the author of numerous articles on technology.