Oracle database 12c : the complete reference /

"Maintain a scalable, highly available enterprise platform and reduce complexity by leveraging the powerful new tools and cloud enhancements of Oracle Database 12c. This authoritative Oracle Press guide offers complete coverage of installation, configuration, tuning, and administration. Find ou...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autores principales: Bryla, Bob (Autor), Loney, Kevin (Autor)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: New York : McGraw-Hill Education, [2014]
Temas:
Oracle (Computer file)
Database management.
Relational databases.
Bases de données > Gestion.
Bases de données relationnelles.
COMPUTERS > Database Management > General.
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • Cover
  • Oracle Database 12c: The Complete Reference
  • Copyright Page
  • About the Authors
  • Dedication
  • Contents at a Contents
  • Contents
  • Acknowledgments
  • PART I Critical Database Concepts
  • 1 Oracle Database 12c Architecture Options
  • Databases and Instances
  • Inside the Database
  • Storing the Data
  • Guarding the Data
  • Programmatic Structures
  • Choosing Architectures and Options
  • 2 Installing Oracle Database 12c and Creating a Database
  • Overview of Licensing and Installation Options
  • Installing the Oracle Software
  • Installing the Grid Infrastructure
  • Installing the Database
  • 3 Upgrading to Oracle Database 12c
  • Choosing an Upgrade Method
  • Before Upgrading
  • Upgrading the Grid Infrastructure and Database
  • Grid Infrastructure Upgrade
  • Database Upgrade
  • After Upgrading
  • 4 Planning Oracle Applications-Approaches, Risks, and Standards
  • The Cooperative Approach
  • Everyone Has "Data"
  • The Familiar Language of Oracle
  • Tables of Information
  • Structured Query Language
  • A Simple Oracle Query
  • Why It Is Called "Relational"
  • Some Common, Everyday Examples
  • What Are the Risks?
  • The Importance of the New Vision
  • Changing Environments
  • Codes, Abbreviations, and Naming Standards
  • How to Reduce the Confusion
  • Normalization
  • English Names for Tables and Columns
  • English Words for the Data
  • Capitalization in Names and Data
  • Normalizing Names
  • Good Design Has a Human Touch
  • Understanding the Application Tasks
  • Outline of Tasks
  • Understanding the Data
  • The Atomic Data Models
  • The Atomic Business Model
  • The Business Model
  • Data Entry
  • Query and Reporting
  • Toward Object Name Normalization
  • Level-Name Integrity
  • Foreign Keys
  • Singular Names
  • Brevity
  • Object Name Thesaurus
  • Intelligent Keys and Column Values
  • The Commandments
  • PART II SQL and SQL*Plus
  • 5 The Basic Parts of Speech in SQL
  • Style
  • Creating the NEWSPAPER Table
  • Using SQL to Select Data from Tables
  • SELECT, FROM, WHERE, and ORDER BY
  • Logic and Value
  • Single-Value Tests
  • LIKE
  • Simple Tests Against a List of Values
  • Combining Logic
  • Another Use for WHERE: Subqueries
  • Single Values from a Subquery
  • Lists of Values from a Subquery
  • Combining Tables
  • Creating a View
  • Expanding the View
  • 6 Basic SQL*Plus Reports and Commands

Ejemplares similares