Hands-on Oracle Database 10g Express Edition for Windows /

Readers will learn to install the database on Windows and take full advantage of all of the powerful features. Tutorials and step-by-step guidelines throughout will equip you with the key concepts and hands-on experience necessary to get started using Oracle Database 10g Express Edition right away.

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Bobrowski, Steven M.
Formato: Electrónico eBook
Idioma:Inglés
Publicado: New York : McGraw-Hill, ©2006.
Colección:Oracle Press.
Temas:
Oracle (Computer file)
Microsoft Windows (Computer file)
Database management.
Online databases.
Bases de données > Gestion.
Bases de données en ligne.
CD-ROMs.
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • Cover
  • Contents
  • Foreword
  • Acknowledgments
  • Introduction
  • Part I58; Getting Started
  • 1 Introduction to Databases and Oracle
  • Information Management
  • Oracle Fundamentals
  • Chapter Summary
  • 2 Install and Start Using Oracle Database 10g Express Edition
  • Installation Overview
  • Database Server System Requirements
  • Oracle Database 10g Express Edition Software
  • Installation
  • Post45;Installation Exercises
  • Basic Oracle XE Skills
  • Troubleshooting Tips
  • Oracle Database 10g Express Edition Updates
  • Using This Book39;s Support Files
  • Chapter Summary
  • Part II58; Fundamentals of Application Development
  • 3 Access Database Data with SQL
  • Chapter Prerequisites
  • What Is SQL63;
  • Retrieving Data with Queries
  • Inserting44; Updating44; and Deleting Rows in Tables
  • Committing and Rolling Back Transactions
  • Transaction Design
  • Building SQL with Oracle Application Express
  • Chapter Summary
  • 4 Code Database Access Programs with PL47;SQL
  • Chapter Prerequisites
  • What Is PL47;SQL63;
  • PL47;SQL Blocks
  • The Fundamentals of PL47;SQL Coding
  • Types of PL47;SQL Programs
  • Chapter Summary
  • 5 Build a Basic Relational Schema
  • Chapter Prerequisites
  • Schemas
  • Database Tables
  • Views
  • Sequences
  • Synonyms
  • Indexes
  • The Data Dictionary58; A Unique Schema
  • Exploring Other Object Browser Features
  • Chapter Summary
  • 6 Build an Application with Oracle Application Express
  • Chapter Prerequisites
  • Introducing the Application Development Lifecycle
  • Software Modeling and the Unified Modeling Language
  • Building the Application Schema
  • Loading Schema Data
  • Creating the SysMgmt Application
  • Running and Testing the Application
  • Refining the Application
  • Maintaining the Application
  • Deploying the Application
  • Managing Application Access and Application Users
  • Chapter Summary
  • Part III58; Database Administration
  • 7 Secure Database Access
  • Chapter Prerequisites
  • User Management
  • Privilege Management
  • Resource Limitation
  • Displaying Security Information
  • Chapter Summary
  • 8 Manage Database Space
  • Chapter Prerequisites
  • Logical vs46; Physical Storage Structures
  • Tablespaces and Data Files
  • Segments44; Extents44; and Data Blocks
  • Undo Tablespaces
  • Temporary Segments44; Tablespaces44; and Groups
  • Chapter Summary
  • 9 Protect Your Oracle XE Database
  • About This Chapter39;s Practice Exercises
  • An Overview of Database Problems and Solutions
  • Oracle Database Backup and Recovery Overview
  • Configuring Oracle XE Database Protection
  • Backing Up Databases with Recovery Manager
  • Additional Database Backup Topics
  • More Database Recovery Options
  • Recovering Databases from Problems
  • Using Oracle Flashback Features
  • Chapter Summary
  • 10 Tune Application and Database Instance Performance
  • Chapter Prerequisites
  • Oracle Tuning Concepts
  • Tuning Statistics
  • Application Tuning
  • Database Instance Tuning
  • Chapter Summary
  • Index
  • A
  • B
  • C
  • D
  • E
  • F
  • G
  • H
  • I
  • J
  • L
  • M
  • N
  • O
  • P
  • Q
  • R
  • S
  • T
  • U
  • V
  • W
  • X
  • Z.

Ejemplares similares