- ホーム
- > 洋書
- > 英文書
- > Computer / Databases
Full Description
Publisher's Noteguaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.A Fully Integrated Study System for OCA Exam 1Z0-051Prepare for the Oracle Certified Associate Oracle Database 11g: SQL Fundamentals I exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary to highlight what you've learned. This authoritative guide will help you pass the test and serve as your essential on-the-job reference. Get complete coverage of all OCA objectives for exam 1Z0-051, including:SQL SELECT statementsRestricting and sorting dataSingle-row functionsConversion functions and conditional expressionsGroup functionsDisplaying data from multiple tablesSubqueriesSet operatorsDML and DDL statementsSchema objectsOn the CD-ROM:One full practice exam that simulates the actual OCA examDetailed answers and explanationsScore report performance assessment toolComplete electronic bookBonus exam available free with online registration
Contents
Chapter 1. Oracle Server Technologies and the Relational ParadigmChapter 2. Data Retrieval Using the SQL SELECT StatementChapter 3. Restricting and Sorting DataChapter 4. Single-Row FunctionChapter 5. Using Conversion Functions and Conditional ExpressionsChapter 6. Reporting Aggregated Data Using the Group FunctionsChapter 7. Displaying Data from Multiple TablesChapter 8. Using Subqueries to Solve ProblemsChapter 9. Using the Set OperatorsChapter 10. Manipulating DataChapter 11. Using DDL Statements to Create and Manage TablesChapter 12. Creating Other Schema ObjectsAppendixGlossaryIndexNER(01): WOW
