MTU Library Catalogue

Syndetics cover image
Image from Syndetics

Oracle database 11g : the complete reference / Kevin Loney.

By: Loney, Kevin.
Material type: materialTypeLabelBookPublisher: New York : McGraw-Hill, c2009Description: xxix, 1334 p. : ill. ; 24 cm. + hbk.ISBN: 9780071598750 ; 0071598758 .Subject(s): Oracle (Computer file) | Database management | Relational databasesDDC classification: 005.7565
Contents:
Part I: Critical database concepts -- Part II: SQL and SQL* Plus -- Part III: Beyond the basics -- Part IV: PL/SQL -- Part V: Object-relational databases -- Part VI: Java in Oracle -- Part VII: Hitchhiker's guides.
Holdings
Item type Current library Call number Copy number Status Barcode
General lending MTU Bishopstown Library Lending 005.7565 (Browse shelf(Opens below)) 1 Available 00114540
Total holds: 0

Enhanced descriptions from Syndetics:

The Definitive Guide to Oracle Database 11g

Get full details on the powerful features of Oracle Database 11g from this thoroughly updated Oracle Press guide. Oracle Database 11g: The Complete Reference explains how to use all the new features and tools, execute powerful SQL queries, construct PL/SQL and SQL*Plus statements, and work with large objects and object-relational databases. Learn how to implement the latest security measures, tune database performance, and deploy grid computing techniques. An invaluable cross-referenced appendix containing Oracle commands, keywords, features, and functions is also included.

Install Oracle Database 11g or upgrade from an earlier version Create database tables, sequences, indexes, views, and user accounts Construct SQL statements, procedures, queries, and subqueries Optimize security using virtual private databases and transparent data encryption Import and export data using SQL*Loader and Oracle Data Pump Use SQL replay, change management, and result caching Avoid human errors using flashback and automatic undo management Build and tune PL/SQL triggers, functions, and packages Develop database applications using Java, JDBC, and XML Optimize availability and scalability with Oracle Real Application Clusters

Oracle Press.
Includes index.

Part I: Critical database concepts -- Part II: SQL and SQL* Plus -- Part III: Beyond the basics -- Part IV: PL/SQL -- Part V: Object-relational databases -- Part VI: Java in Oracle -- Part VII: Hitchhiker's guides.

Table of contents provided by Syndetics

  • Part 1 Critical Database Concepts
  • Ch 1 Oracle Database 11gArchitecture Options
  • Ch 2 Installing Oracle Database 11gand Creating a Database
  • Ch 3 Upgrading to Oracle Database 11g
  • Ch 4 Planning Oracle Applicationsn++Approaches, Risks, and Standards
  • Part 2 SQL and SQL*Plus
  • Ch 5 The Basic Parts of Speech in SQL
  • Ch 6 Basic SQL*Plus Reports and Commands
  • Ch 7 Getting Text Information and Changing It
  • Ch 8 Searching for Regular Expressions
  • Ch 9 Playing the Numbers
  • Ch 10 Dates: Then, Now, and the Difference
  • Ch 11 Conversion and Transformation Functions
  • Ch 12 Grouping Things Together
  • Ch 13 When One Query Depends upon Another
  • Ch 14 Some Complex Possibilities
  • Ch 15 Changing Data: insert, update, merge, and delete
  • Ch 16 DECODE and CASE: if, then, and else in SQL
  • Ch 17 Creating and Managing Tables, Views, Indexes, Clusters, and Sequences
  • Ch 18 Partitioning
  • Ch 19 Basic Oracle Security
  • Part 3 Beyond the Basics
  • Ch 20 Advanced Securityn++Virtual Private Databases
  • Ch 21 Advanced Security: Transparent Data Encryption
  • Ch 22 Working with Tablespaces
  • Ch 23 Using SQL*Loader to Load Data
  • Ch 24 Using Data Pump Export and Import
  • Ch 25 Accessing Remote Data
  • Ch 26 Using Materialized Views
  • Ch 27 Using Oracle Text for Text Searches
  • Ch 28 Using External Tables
  • Ch 29 Using Flashback Queries
  • Ch 30 Flashbackn++Tables and Databases
  • Ch 31 SQL Replay
  • Part 4 PL/SQL
  • Ch 32 An Introduction to PL/SQL
  • Ch 33 Online Application Upgrades
  • Ch 34 Triggers
  • Ch 35 Procedures, Functions, and Packages
  • Ch 36 Using Native Dynamic SQL and DBMS_SQL
  • Ch 37 PL/SQL Tuning
  • Part 5 Object-Relational Databases
  • Ch 38 Implementing Types, Object Views, and Methods
  • Ch 39 Collectors (Nested Tables and Varying Arrays)
  • Ch 40 Using Large Objects
  • Ch 41 Advanced Object-Oriented Concepts
  • Part 6 Java in Oracle
  • Ch 42 An Introduction to Java
  • Ch 43 JDBC Programming
  • Ch 44 Java Stored Procedures
  • Part 7 Hitchhiker's Guides
  • Ch 45 The Hitchhiker's Guide to Oracle Data Dictionary
  • Ch 46 The Hitchhiker's Guide to Tuning Applications and SQL
  • Ch 47 SQL Result Cache and Client-Side Query Cache
  • Ch 48 Case Studies in Tuning
  • Ch 49 Advanced Architecture Options--DB Vault, Content DB, and Records DB
  • Ch 50 Oracle Real Application Clusters
  • Ch 51 The Hitchhikern++s Guide to Database Administration
  • Ch 52 The Hitchhikern++s Guide to XML in Oracle
  • Part 8 Alphabetical
  • Reference
  • Index

Author notes provided by Syndetics

Kevin Loney was named Consultant ofthe Year by ORACLE Magazine in 2002. He is an internationally recognized Oracle expert who frequently presents at Oracle user conferences in North America and Europe where he is regularly among the highest-rated presenters.