Your Must-Have Guide to Everything New in Oracle Database 11g
Realize the full potential of Oracle Database 11g with help from the experts. Written by Robert G. Freeman, and with insightful commentary throughout from Arup Nanda, this Oracle Press guide offers full details on the architectural changes, database administration upgrades, availability and recovery revisions, security enhancements, and programming innovations. Every new and updated feature is covered and presented with screenshots, code samples, tables, and charts. Find out how to take full advantage of all the new and improved capabilities of Oracle Database 11g, including:
New Oracle Automatic Storage Management features, such as Fast Disk Resync, Compatibility Attributes, Preferred Mirror Read, and Rolling Upgrade components
Improved Automated Memory Management capabilities
New database design features, such as virtual columns, tablespace encryption, and true table-level data compression
New Database Advisors for data recovery and repair, partitioning, and streams performance
New tuning features, such as Automatic SQL Tuning and SQL Performance Analyzer
Enhancements to Oracle RMAN, including active database duplication and UNDO backup optimization
Improved auditing and security capabilities
Advanced BI, data warehousing, and partitioning features
Learn to access Oracle databases through SQL statements and construct PL/SQL programs with guidance from Oracle expert, Jason Price. Published by Oracle Press, Oracle Database 11g SQL explains how to retrieve and modify database information, use SQL Plus and SQL Developer, work with database objects, write PL/SQL programs, and much more. Inside, you’ll find in-depth coverage of the very latest SQL features and tools, performance optimization techniques, advanced queries, Java support, and XML. This book contains everything you need to master SQL.
Explore SQL Plus and SQL Developer
Use SQL SELECT, INSERT, UPDATE, and DELETE statements
Write PL/SQL programs
Create tables, sequences, indexes, views, and triggers
Get a Solid Foundation in Oracle Database Technology
Master Oracle Database 11g fundamentals quickly and easily. Using self-paced tutorials, this book covers core database essentials, the role of the administrator, high availability, and large database features. Oracle Database 11g: A Beginner’s Guide walks you, step by step, through database setup, administration, programming, backup, and recovery. In-depth introductions to SQL and PL/SQL are included. Designed for easy learning, this exclusive Oracle Press guide offers:
Deliver dynamic, client/server PL/SQL applications with expert guidance from an Oracle programming professional. With full coverage of the latest features and tools, Oracle Database 11g PL/SQL Programming lays out each topic alongside detailed explanations, cut-and-paste syntax examples, and real-world case studies. Access and modify database information, construct powerful PL/SQL statements, execute effective queries, and deploy bulletproof security. You’ll also learn how to implement C, C++, and Java procedures, Web-enable your database, cut development time, and optimize performance.
Create, debug, and manage Oracle-driven PL/SQL programs
Use PL/SQL structures, delimiters, operators, variables, and statements
Identify and eliminate errors using PLSQL_WARNINGS and exception handlers
Work with functions, procedures, packages, collections, and triggers
Define and deploy varray, nested table, and associative array data types
Handle external routines, object types, large objects, and secure files
Communicate between parallel sessions using DBMS_ALERT and DBMS_PIPE
Call external procedures through Oracle Net Services and PL/SQL wrappers
Integrate internal and server-side Java class libraries using Oracle JVM
Develop robust Web applications using PL/SQL Gateway and Web Toolkit Download eBook Free »
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 Download eBook Free »
Entries
