Secrets of the Oracle Database is the definitive guide to undocumented and partially-documented features of the Oracle Database server. Covering useful but little-known features from Oracle Database 9through Oracle Database 11, this book will improve your efficiency as an Oracle database administrator or developer. Norbert Debes shines the light of day on features that help you master more difficult administrative, tuning, and troubleshooting tasks than you ever thought possible.

Finally, in one place, you have at your fingertips knowledge that previously had to be acquired through years of experience and word of mouth through knowing the right people. What Norbert writes is accurate, well-tested, well-illustrated by clear examples, and sure to improve your ability to make an impact on your day-to-day work with Oracle. Table of Contents Partially Documented Parameters Hidden Initialization Parameters Introduction to Data Dictionary Base Tables IND$, V$OBJECT_USAGE, and Index Monitoring Event 10027 and Deadlock Diagnosis Event 10046 and Extended SQL Trace Event 10053 and the Cost Based Optimizer Event 10079 and Oracle Net Packet Contents Introduction to X$ Fixed Tables X$BH and Latch Contention X$KSLED and Enhanced Session Wait Data X$KFFXP and ASM Metadata ALTER SESSION/SYSTEM SET EVENTS ALTER SESSION SET CURRENT_SCHEMA ALTER USER IDENTIFIED BY VALUES SELECT FOR UPDATE SKIP LOCKED DBMS_BACKUP_RESTORE DBMS_IJOB DBMS_SCHEDULER DBMS_SYSTEM DBMS_UTILITY Perl DBI and DBD:: Oracle Application Instrumentation and End-to-End Tracing Extended SQL Trace File Format Reference Statspack Integrating Extended SQL Trace and AWR ESQLTRCPROF Extended SQL Trace Profiler The MERITS Performance Optimization Method TNS Listener IP Address Binding and IP=FIRST TNS Listener TCP/IP Valid Node Checking Local Naming Parameter ENABLE=BROKEN Default Host Name in Oracle Net Configurations Session Disconnection, Load Rebalancing, and TAF Removing the RAC Option Without Reinstalling OERR Recovery Manager Pipe Interface ORADEBUG SQL*Plus Command

Pro SQL Server 2008 Administration is critical for database administrators seeking in-depth knowledge on administering SQL Server 2008. This book covers the impact of the new features available in SQL Server 2008 specifically targeted for database administrators, along with the tried-and-true advanced techniques required to support and maintain Microsoft SQL Server.Introduces new administration features of SQL Server 2008 Shows how to manage a SQL Server 2008 database at professional level Provides guidance on performance optimization What you'll learn Take advantage of the new administrative features in SQL Server 2008 Make intelligent decisions when choosing an installation or upgrade path Define and implement database policies to create a consistent, predictable environment throughout the organization Automate repetitive Tasks for increased productivity Create baseline monitors using Performance Monitor, Profiler, and System Dynamic Management views Identify and resolve long-running, I/O, and CPU-intensive queries Who this book is for

This book is for junior and seasoned database administrators who are looking to develop their knowledge and skill set in Microsoft SQL Server 2008. Table of Contents New Feature Overview Pre-Installation Considerations Choosing a High Availability Solution Installing Microsoft SQL Server 2008 Upgrading to Microsoft SQL Server 2008 Post Installation Multi-Server Administration Managing Security within the Database Engine Administering Database Objects Indexing for Performance Managing Backups Restore and Recovery Strategies Automating Routine Maintenance Monitoring Your Server Auditing SQL Server Managing Query Performance Secrets to Excelling as a Professional DBA What's Next?

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Extend and Customize Oracle E-Business Suite Transform your Oracle E-Business Suite infrastructure to suit enterprise requirements using the comprehensive development methods in this Oracle Press guide. Oracle E-Business Suite Development & Extensibility Handbook lays out each tool alongside reusable code and step-by-step examples. Learn how to create multiorg objects, integrate Java and PL/SQL, design custom user interfaces, and use Oracle Application Framework and Oracle Workflow. This detailed volume also explains how to work with Oracle XML Gateway, publish dynamic business intelligence reports, and tune your configuration. Manage an efficient development platform with Oracle Application Object Library Develop concurrent programs, customized forms, and personalized graphical user interfaces Securely share data between organizations Distribute business communiques through Oracle Reports and Oracle Business Intelligence Publisher Develop Java extensions with Oracle JDeveloper and Oracle Application Framework Capture and graphically map business processes using Oracle Workflow Exchange data between applications via Oracle XML Gateway Change the appearance of applications using Custom Look and Feel Integrate Oracle E-Business Suite with service-oriented architecture using Oracle Applications Adapter On Demand

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Take your MySQL skills to the top tierMaximize every powerful feature available in MySQL 5.1 with hands-on instruction from a MySQL expert. This definitive guide shows you how to use MySQL's advanced suite of data management tools, optimize performance and reliability, and secure and administer a robust RDBMS. MySQL Database Usage & Administration includes detailed code examples in each chapter to highlight real-world applications of the material covered. If you want to get the most out of MySQL, you need this practical handbook. Understand MySQL's features, technical architecture, subsystems, and commands Make database design decisions that optimizre performance, storage, and reliability Write complex queries using joins, subqueries, and views Group SQL statements into transactions and execute them atomically Build and use sophisticated stored procedures and functions Automate database operations with triggers and scheduled events Import and export data in different formats, includiong SQL, CSV, and XML Optimize server and query performance Administer a secure, high availability MySQL RDBMS Manage users and control access Perform database maintenance, replication, backup, and recovery Vikram Vaswani is the founder and CEO of Melonfire (www.melonfire.com), a consultancy firm with special expertise in open-source tools and technologies. His previous books include MySQL: The Complete Reference, PHP: A Beginner's Guide, and PHP Programming Solutions.

Application Express, or APEX, is one of the most innovative products to come out of Oracle in years. APEX is an application development framework for developing databasebacked applications. It's easy enough to get started in that power users can quit storing data in random spreadsheets and instead centralize their data in the powerful Oracle database, all without developer help. Developers aren't left out, however. Those who choose to do socan go deep and leverage the full power and flexibility of Oracle's database engine.

Getting started with APEX is easy; learning how to take full advantage of APEX is the problem. It was the problem, that is, until this book came along. In Pro Oracle Application Express, authors John Scott and Scott Spendolini open the hood of APEX and expose the full power behind its easytouse GUI. They show you what you need to know to produce powerful, professionally polished applicationssuch as user-authentication models, approaches to layout and navigation, how to integrate Ajax, how to deal with localization issues such as time zones and translations, how to customize the look and feel of an APEX web site, and much, much more.

The authors are wellqualified to write on APEX. John Scott runs ShellPrompt, a hosting service that handles many large-scale APEX applications, some of which he is paid to develop. John is a hardcore APEX developer. His co-author, Scott Spendolini, is one of the original creators of APEX. Both John and Scott now base their full-time careers on developing APEX applications. Pro Oracle Application Express is your opportunity to learn APEX from the very best.

Businesses today want actionable insights into their datathey want their data to reveal itself to them in a natural and userfriendly form. What could be more natural than human language? Naturallanguage search is at the center of a storm of everincreasing webdriven demand for humancomputer communication and information access. SQL Server 2008 provides the tools to take advantage of the features of its builtin enterpriselevel naturallanguage search engine in the form of integrated fulltext search (iFTS). iFTS uses textaware relational queries to provide your users with fast access to content. Whether you want to set up an enterprisewide Internet or intranet search engine or create less ambitious naturallanguage search applications, this book will teach you how to get the most out of SQL Server 2008 iFTS: Introducing powerful iFTS features in SQL Server, such as the FREETEXT and CONTAINS predicates, custom thesauruses, and stop lists Showing you how to optimize fulltext query performance through features like fulltext indexes and iFilters Providing examples that help you understand and apply the power ofiFTS in your daily projects What you'll learn Harness the power of iFTS for your applicationsAdminister iFTS catalogs and indexesUse new iFTS features such as stop lists and iFTSbased dynamic management functionsOptimize and tune iFTS queriesImplement languageaware, naturallanguage searches for dataSimplify searches of structured and unstructured content Who this book is for

The audience for this book includes SQL Server, SQL and Transact-SQL developers, and also .NET developers, who want to take advantage of the integrated full-text search (iFTS) functionality available in SQL Server 2008.

Excel 2007 VBA Programming with XML and ASP offers a hands-on approach for those looking to extend and customize Excel functionality. From recording a simple macro and writing VBA code to working with XML documents and using ASP to access and display data, this book takes you on a programming journey that will change the way you work with Excel Learn how to: * Automate spreadsheet tasks with macros. * Write VBA code to program PivotTables, generate charts, build dialog boxes, and customize the Ribbon. * Handle errors and debug programs. * Create hyperlinks and publish HTML files. * Retrieve data from the web directly into Excel. * Develop and manipulate smart tags using XML.

IBM's DB2 Express Edition is one of the most capable of the free database platforms available in today's marketplace. In Beginning DB2, author Grant Allen gets you started using DB2 Express Edition for web sites, desktop applications, and more. The author covers the basics of DB2 for developers and database administrators, shows you how to manage data in both XML and relational form, and includes numerous code examples so that you are never in doubt as to how things work. In this book, you'll find: A friendly introduction to DB2 Express Edition, an industrialstrength, relational database from IBM Dozens of examples so that you are never in doubt as to how things work Coverage of important language interfaces, such as from PHP, Ruby, C#, Python, and more

The book is aimed at developers who want a robust database to back their applications. What you'll learn Install and manage DB2 Express Edition on Linux and WindowsManage IML data seamlessly using IBM's pureXML storage engineConnect DB2 databases to web and desktop applications via languages such as PHP, Ruby, C#, Python, and moreProtect your data with a sound backup and restore strategyDesign and manage database schema and security within the databaseKnow when and why to upgrade to more powerful editions of DB2 Who this book is for

Application developers, including web application developers, looking for a robust, zero-cost database to back their applications; database administrators looking to get up to speed quickly with DB2.

Take full advantage of everything SQL Server 2008 Reporting Services has to offer and deliver customizable, webenabled reports across your business at a reasonable cost. Learn bestpractices from professionals who use SQL Server Reporting Services daily to deliver solutions to paying clients and gain the competitive edge on using Microsoft's enterpriselevel reporting platform.Provides bestpractices for using Reporting Services Written by practicing professionals with paying clients Your key to delivering business intelligence across the enterprise What you'll learn Write efficient queries on which to base a report Build and lay out a report using Report Designer Enable end users to create ad hoc reports on demand Combine Reporting Services with Analysis Services, SharePoint Portal Server, and other technologies to deliver business intelligence across the enterprise Secure and audit your reports as part of your regulatory compliance efforts Customize your reports using C# assemblies and embedded Visual Basic .NET code Who this book is for

Data analysts, developers, database administrators, and others who develop and deploy reports using Microsoft SQL Server Reporting Services.

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Master Oracle E-Business Suite's Oracle Procure-to-Pay Drive better decision making and maximize asset usage with Oracle E-Business Suite's comprehensive end-to-end procurement solution. This Oracle Press guide details, step-by-step, how to streamline and optimize your enterprise acquisition cycle using Oracle Procure-to-Pay. Set up and configure each module, generate contracts and purchase orders (POs), perform automatic invoicing, process payments, and enforce fiscal policies. You will also learn how to use powerful new purchasing and payables features. Manage POs and strengthen policy compliance using Oracle Purchasing Track documents from the buyers work center and demand workbench Centralize requisition creation and approvals Create and use sourcing rules for supplier purchases Use Oracle Payables to process invoices and handle settlements Consolidate and disburse funds using Oracle Payments Understand key setups for Oracle Purchasing, Oracle Payables, and Oracle Payments

SQL Server 2008 is a first-rate database management system. It offers more capability than any previous release of SQL Server. More than just a classic relational database management system, SQL Server 2008 includes exciting and powerful features that make it useful for everything from large corporate data warehouses to ad hoc departmental databases. You'll find enhanced support for XML, new support for spatial data, transparent data encryption, a policy-based management system, and more. Author and developer Robin Dewson will show you the way from beginner to SQL Server 2008 professional. Learn to install SQL Server 2008 and navigate around Management Studio before getting right to the heart of mastering fundamental SQL Server 2008 tasks: creating tables, storing data, securing data, and retrieving it again. Dewson ensures you'll be fully prepared to use all the basics and create a solid foundation for your own projects. Don't forget about backups Your database will house important data, so backing up is essential to protect yourself from inevitable hardware failure. Dewson walks you through SQL Server 2008's easy-to-use backup and recovery feature set, giving you the grounding that you need in order to set up a reliable plan for recovery in your own environment. Learn to use Transact-SQL, a full-blown procedural language that is built right into the database system. Transact-SQL is the key to unlocking everything that SQL Server 2008 has to offer. Using Transact-SQL, you can write centrally encapsulated business logic through the use of stored procedures, automatically trigger processing through the use of triggers, and manipulate data within the server without having tomove data back and forth across the network. Finally, you'll learn a bit about SQL Server 2008 Reporting Services, a powerful tool that allows enterprise reporting. Reporting Services enables you to develop and serve reports across your organization and even to business partners outside your company. Reporting Services also gives end users the ability to create their own reports, helping them transform business data into valuable, usable information to guide their day-to-day decisions. What you'll learn Install and manage SQL Server on your system. Create and secure tables. Store and query data; use indexes to improve query performance. Sleep when the wind blows, because you have a solid backup and recovery process. Run procedural code inside your database in the form of Transact-SQL procedures and triggers. Serve up business reports to in-house users and outside business partners via SQL Server 2008 Reporting Services. Who is this book for? Developers new to SQL Server 2008. If you are just beginning to develop software using SQL Server 2008, or if you are planning to do so in the near future, this book will set you on the road to success. About the Apress Beginning Series The Beginning series from Apress is the right choice to get the information you need to land that crucial entry-level job. These books will teach you a standard and important technology from the ground up because they are explicitly designed to take you from novice to professional. You'll start your journey by seeing what you need to know--but without needless theory and filler. You'll build your skill set by learning how to put together real-world projects step by step. So whether your goal is your nextcareer challenge or a new learning opportunity, the Beginning series from Apress will take you there--it is your trusted guide through unfamiliar territory Related Titles Applied Mathematics for Database Professionals

Oracle SQL is one of the world's most powerful dialects, packed with advanced functions and features that give Oracle SQL procedural language capabilities. Using these powerful features it is no longer necessary to embed Oracle SQL inside a procedural language, and native Oracle SQL can now be used to solve complex query problems. This is an indispensable book for all Oracle DBA's and developers who need to understand how to apply Oracle SQL features for complex queries. Written by a certified Oracle Master and Oracle ACE, this advanced book shows working examples of how to leverage Oracle SQL's powerful built-in functions for fast extraction of complex data and how to use native SQL for procedural processing. Every developer needs to know how to use Oracle SQL to summarize and aggregate data from large tables and how to use powerful features such as the "model" clause to make SQL act as a procedural language. This book shows important techniques on how to leverage Oracle's powerful XML interface to quickly format Oracle data with XML for instant publication. This is not a book for beginners or dilettantes and it is designed for the professional Oracle developer, covering many advanced Oracle SQL techniques including XML queries, Oracle SQL analytics, SQL for aggregation, and traversing Hierarchies. Best of all, the author reveals secrets for retrieving Oracle data faster and more elegantly than the traditional approaches to writing SQL.

Learn effective and scalable database design techniques in a SQL Server environment.Pro SQL Server 2008 Relational Database Design and Implementation covers everything from design logic that business users will understand, all the way to the physical implementation of the design in a SQL Server database. Grounded in best practices and a solid understanding of the underlying theory, authors Louis Davidson, Kevin Kline, Scott Klein, and Kurt Windisch show how to 'get it right' in SQL Server database design and lay a solid groundwork for the future use of valuable business data. Solid foundation in best practices and relational theory Maximize SQL Server features to enhance security, performance, scalability Thorough treatment from conceptual design to an effective, physical implementation What you'll learn Develop conceptual models of client data using interviews and client documentation Normalize data models to enhance scalability and the long term use of valuable data Translate conceptual models into high-performing SQL Server databases Secure and protect the integrity of data as part of meeting regulatory requirements Take full advantage of new SQL Server features such as the spatial datatype, XML support, transparent data encryption, and more Create effective indexing to speed query performance Who this book is for

Pro SQL Server 2008 Relational Database Design and Implementation is designed for programmers of all types who want to use SQL Server 2008 to store data. Rookie database programmers will find a complete course on the fundamentals of database design that includes conceptual designs and physical implementation. Seasoned veterans will find many tips and tricks for implementing database systems that will be well worth the time invested in reading this book.

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. 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: Core Concepts--Oracle Database 11g topics presented in logically organized chapters Critical Skills--Lists of specific skills covered in each chapter Projects--Practical exercises that show how to apply the critical skills learned in each chapter Progress Checks--Quick self-assessment sections to check your progress Notes--Extra information related to the topic being covered Mastery Checks--Chapter-ending quizzes to test your knowledge

This book, written by veteran Oracle database administrator Iggy Fernandez, a regular on the Oracle conference circuit and the editor of NoCOUG Journal, is a manageable introduction to key Oracle database administration topics including planning, installation, monitoring, troubleshooting, maintenance, and backups, to name just a few. As is clear from the table of contents, this book is not simply a recitation of Oracle Database features such as what you find in the reference guides available for free download on the Oracle web site. For example, the chapter on database monitoring explains how to monitor database availability, database changes, database security, database backups, database growth, database workload, database performance, and database capacity.

The chapters of this book are logically organized into four parts that closely track the way your database administration career will naturally evolve. Part 1 gives you necessary background in relational database theory and Oracle Database concepts, Part 2 teaches you how to implement an Oracle database correctly, Part 3 exposes you to the daily routine of a database administrator, and Part 4 introduces you to the fine art of performance tuning. Each chapter has exercises designed to help you apply the lessons of the chapter. Each chapter also includes a list of reference works that contain more information on the topic of the chapter.

In this book, you'll find information that you won't find in other books on Oracle Database. Here you'll discover not only technical information, but also guidance on work practices that are as vital to your success as technical skills. The author's favorite chapter is "The Big Picture and the Ten Deliverables." If you take the lessons in that chapter to heart, you can quickly become a much better Oracle database administrator than you ever thought possible. What you'll learn Theory of relational database management systems Oracle Database internals Licensing, architecture, and sizing Software installation and database creation Using indexes to improve performance User management and data loading How to monitor all aspects of your database How to solve and fix problems Database backups and database recovery Database maintenance Database tuning SQL tuning Who this book is for

If you are an IT professional who has been thrust into an Oracle database administration role without the benefit of formal training, or you just want to understand how Oracle Database works, this book is for you. It's the book the author wishes he'd had when he first started using Oracle Database many years ago. It's the book that he would have liked to have given to the many IT colleagues and friends who, over the years, have asked him to teach them the basics of Oracle Database.

The ability to manage information is the key to businesses thriving in an increasingly competitive market. With FileMaker (R) Pro Business Applications, small business owners and workgroup managers can find out how to write custom database applications in order to add value to critical business information. After demonstrating how easily a database can be written using FileMaker Pro, this book presents a set of 11 business database case studies, all of which can be easily adapted by readers for their own data management requirements. The final section of the book offers ideas on deploying database solutions over a network and the web. Learn how to build a database and design layouts; create relationships between tables; automate tasks using scripts and buttons; secure data through the use of accounts and privileges; exchange data with other applications.

When your database application isn't running fast enough, troubleshooting is usually your first move. Finding the slow part of an application is often easy, but discovering a solution can prove much more difficult. Troubleshooting Oracle Performance helps by providing a systematic approach to addressing the underlying causes of poor database application performance. Written for developers by an application developer who has learned by doing, this book shows you how to plan for performance as you would for any other application requirement.

SQL Server Profiler is one of the most useful of SQL Server's "built-in" tools, recording data about various SQL Server events. "Mastering SQL Server Profiler" will make it easier for you to learn how to use Profiler, analyze the data it provides, and to take full advantage of its potential for troubleshooting SQL Server problems. All the examples have been optimized to work with both SQL Server 2005 and 2008.

'Rough Computing' explores the application of rough set theory, which has attracted attention because of the ability to enhance databases by allowing for the management of uncertainty, a comparative analysis between rough sets, and other intelligent data analysis.

While building on the skills you already have, Expert SQL Server 2005 Development will help you become an even better developer by focusing on best practices and demonstrating how to design high-performance, maintainable database applications. This book starts by reintroducing the database as a integral part of the software development ecosystem. You'll learn how to think about SQL Server development as you would any other software development. For example, there's no reason you can't architect and test database routines just as you would architect and test application code. And nothing should stop you from implementing the types of exception handling and security rules that are considered so important in other tiers, even if they are usually ignored in the database. You'll learn how to apply development methodologies like these to produce high-quality encryption and SQLCLR solutions. Furthermore, you'll discover how to exploit a variety of tools that SQL Server offers in order to properly use dynamic SQL and to improve concurrency in your applications. Finally, you'll become well versed in implementing spatial and temporal database designs, as well as approaching graph and hierarchy problems.

The first edition of this book became a classic for developers and DBAs. This edition offers 400 pages of updated material on Oracle features, including parallel server, parallel query, Oracle Performance Pack, disk striping and mirroring, RAID, MPPs, SMPs, distributed databases, backup and recovery, and much more.

Many would argue that the single, most important job of a SQL Server database administrator is to be able to recover your database in the event of loss or damage. Pro SQL Server Disaster Recovery helps you meet that goal by showing you how to think about and plan for potential problems. You'll learn to anticipate and reduce the likelihood of a disaster, and to mitigate the effects of a disaster when one does occur. Perhaps most importantly, you'll learn how to prepare so that you can return a system to its normal state quickly, ensuring system availability and the continued success and operation of your business.

Many SQL Server features and technologies are, or can be put to good use in disaster recovery planning. In this book, you'll learn about powerful tools and features -- such as Database Snapshots and Mirroring -- for data backup and disaster recovery that are present in SQL Server 2005, and that are enhanced in SQL Server 2008. Also covered are common issues to expect when using these features. This book explores your options by examining the technical details of disaster recovery features and then applying that knowledge to practical scenarios.

There's a human side to disaster recovery planning as well. Like few other activities, disaster recovery planning requires that you work closely with a wide variety of people from all across your organization. People skills are as critical to disaster recovery planning as technical skills, and perhaps more so. This book does not leave you in the dark, but provides sound advice on how to keep disaster recovery planning projects on track, how to avoid dangerous scope creep, and how to work effectively with the variety ofpersonality types that you will encounter.

Disaster recovery planning is really about sleep. When you get the call at 3: 00 am that your database is lost, don't wake up with that icy feeling in your veins. Instead wake up with confidence that you have a plan in place, a plan that you've practiced, that management has bought into, a plan that you can execute even while half-asleep to get your database, your company, and your job back on track. What you'll learn

This book shows you how to implement an effective disaster recovery strategy for SQL Server 2005 databases. It covers: Real-world examples of data loss and what might have been done to prevent it A systematic, problem-based approach to designing a disaster recovery plan Pitfalls one might encounter, and how to deal with them Team dynamics, and the soft-side of disaster planning New technology in SQL Server 2005 and 2008 that takes disaster recovery beyond the simple backup/recovery plan When and why to use disaster recovery features, as opposed to just describing how they work
Who is this book for?

SQL Server database administrators

Pro Access 2007 will help readers overcome any upgrade issues, covering the new features of Microsoft Access 2007, including working with SharePoint Office Server and customizing Ribbons (the new UI in office 2007). It includes solid examples that thoroughly explain new features. This book is aimed at professional developers and power users new to Access 2007. Author Martin Reid is also a working Access developer who is respected by his peers and knows what working developers face, especially at the time of a new release.

Essential Skills--Made Easy!

Written to the SQL:2006 ANSI/ISO standard, this easy-to-follow guide will get you started programming in SQL right away. You will learn how to retrieve, insert, update, and delete database data, and perform management and administrative functions. SQL: A Beginner's Guide, Third Edition covers new features, including SQL/XML, and is loaded with updated SQL examples along with notes on using them with the latest RDBMS software versions such as MySQL 5.0, SQL Server 2008, and Oracle Database 11g.

Designed for Easy Learning: Key Skills & Concepts--Lists of specific skills covered in the chapter Ask the Experts--Q&A sections filled with bonus information and helpful tips Try This--Hands-on exercises that show how to apply your skillsNotes--Extra information related to the topic being coveredSelf-Tests--Chapter-ending quizzes to test your knowledgeAnnotated Syntax--Example code with commentary that describes the programming techniques being illustrated

This brilliant new book gives readers the lowdown on the most important new features in the latest release of Oracle's flagship database product. Authors Sam Alapati and Charles Kim are experienced database administrators who go beyond regurgitating Oracle's new feature documentation to report on "what's new that really matters." Readers whose careers are bound up in Oracle's database system need to know what's new. Sam and Charles deliver with a rigor and candor that will help readers choose the best of the new features to apply in their own environments.