OCA/OCP: Introduction to Oracle9i SQL Study Guide

Chip Dawes, Biju Thomas

  • 出版商: Sybex
  • 出版日期: 2002-02-19
  • 售價: $1,890
  • 貴賓價: 9.5$1,796
  • 語言: 英文
  • 頁數: 512
  • 裝訂: Hardcover
  • ISBN: 0782140629
  • ISBN-13: 9780782140620
  • 相關分類: OracleSQL
  • 已過版

買這商品的人也買了...

相關主題

商品描述

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 CD

Authoritative 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

Contents

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