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

Targeting the data warehouse professional, this book provides tips on how to glean hidden trends and correlations from terabytes of Oracle data using proven tools such as SAS and ODM. Instructions for performing complex predictive analysis are also included.

Asynchronous JavaScript and XML (Ajax) is a web technique used to transfer data between a browser and server asynchronously without posting the web page to the server. "Asynchronously" implies that the processing of the web page continues while the Ajax request is sent to the server and a response is received from the server. The web page, or section(s) of the web page, is refreshed with the Ajax response without reposting the web page. Ajax has the following advantages over non-Ajax web applications.

- Reduced response time and reduced server load, as the complete web page is not reposted.

- Reduced bandwidth of web applications as only data is transferred and the HTML format is applied in the browser.

- Separation of data, format and style.

The book covers web search and RSS Feed with Ajax as well as form validation with Ajax frameworks for Java, JSP, JSF, and PHP. It discusses using Ajax in Oracle JDeveloper and is IDE based. JDeveloper has the following advantages over Eclipse IDE.

- JDeveloper 11g provides an integrated JavaScript Editor for Ajax/Web development.

- It also provides a PHP extension.

- JDeveloper has a built-in support for JSF and for JDBC.

This unique book focuses on removing the guesswork from creating dynamic web pages with Oracle content. Packed with working code examples, this book shows working examples of connecting to Oracle and delivering data into an HTML page. This indispensable reference shows working examples of complex Oracle queries in PHP, updating Oracle from PHP, and passing parameters to a PHP program.

This is a practical guide to working with the Oracle 10g v10.2 database from Visual Studio .NET 2005, using Oracle Data Provider for .NET and Oracle Developer Tools. ODP.NET optimizes Oracle database access from a .NET environment, allowing developers to leverage advanced Oracle database functionality, including Real Application Clusters, XML DB, and advanced security, using VB.NET, C#, or any .NET language. With many hands-on examples the book provides the in-depth information to use ODP.NET and Oracle Developer Tools from Visual Studio 2005. After introducing ODP.NET, it covers using SQL, PL/SQL, LOBs, and XML DB through ODP.NET; developing Web Applications, Web Services, and Mobile Applications; and finally Oracle Developer Tools for VS.NET. All the code examples use Visual Basic.NET 2005. This book is for professional .NET developers with a minimum knowledge of Oracle SQL and PL/SQL who need to work with and take full advantage of the Oracle Database 10g using Visual Studio 2005.

Designed to exploit Oracle 10g's SQL, this book takes a comprehensive look at Oracle 10g's analytical functions, MODEL statements, and regular expressions. In addition, the book covers collection objects and object-oriented structures and introduces new Oracle 10g topics such as XML and statistical functions. The authors' logical and developmental approach to query building includes a review of older Oracle tools to help in the transition to newer material. This text will teach the reader how to format result sets with SQL*Plus reporting tools; use aggregate functions for partitioning, ordering, and reporting; perform calculations with the MODEL statement; search within strings using regular expressions; work with collection objects; handle XML within SQL.

"This book should satisfy those who want a different perspective than the official Oracle documentation. It will cover all important aspects of a data warehouse while giving the necessary examples to make the reading a lively experience."
- Tim Donar, Author and Systems Architect
for Enterprise Data Warehouses
Tuning a data warehouse database focuses on large
transactions, mostly requiring what is known as throughput. Throughput is the passing of large amounts of information through a server, network
and Internet environment, backwards and forwards, constantly! The ultimate objective of a data warehouse is the production of meaningful and useful reporting, from historical and archived data. The trick is to make the reports print within an acceptable time frame.
A data model contains tables and relationships between tables. Tuning a data model involves Normalization and Denormalization. Different approaches are required depending on the application, such as OLTP or a Data Warehouse. Inappropriate database design can make SQL code impossible to tune. Poor data modeling can have a most profound effect on database performance since all SQL code is constructed from the data model.
* Takes users beyond basics to critical issues in running most efficient data warehouse applications
* Illustrates how to keep data going in and out in the most productive way possible
* Focus is placed on Data Warehouse performance tuning

The new Oracle Application Server offers a wide range of functionality, including Java runtime and development tools, portal development tools, business intelligence, single sign-on identify management, and much more. It's so powerful and complex, in fact, that many people who use the product (or are considering using it) are familiar with only a portion of the entire range of its capabilities. The choices can be overwhelming. Few people grasp how the larger issues--such as the interplay between components or the various architectural choices in the product--play out in the Oracle Application Server.

This new guide provides the perfect introduction to the Oracle Application Server for users of any level. Regardless of which of the server's capabilities you use, you'll benefit from this tightly focused, all-in-one technical overview. It's written for anyone who is concerned with using and managing web servers, doing Java development and deployment, using Oracle's own tools--like Forms and Reports, using or developing for Oracle Portal, or those who use and administer business intelligence, mobile or integration software.

Divided into three concise sections, the book covers server basics, core components, and server functionality. The book leads with the history of Oracle Application Server, its architecture, management, standards, and third-party support for languages and tools such as Java, Perl, and HTTP. The next section covers Oracle's web server, containers for Java web caching, and the server's security features. And finally, the book discusses HTML development, Java development, and Oracle development. Although the book refers mainly to Oracle Application Server 10g, theauthors also describe features in earlier product releases where necessary, particularly Oracle9i Application Server.

More comprehensible than a large reference and more detailed than a primer, the book provides a foundation for understanding and using Oracle Application Server effectively and efficiently. Readers concentrate on the most important issues and components of the server, focusing primarily on principles rather than syntax. Designed to be the ideal first OracleAS book, "Oracle Application Server 10g Essentials" offers Oracle application developers and administrators everything they need to know about this powerful server.

The essential reference for PL/SQL has been revised and expanded, featuring all new examples throughout based on the new Oracle Database 10g sample schema plus a CD with all the book’s code as well as development environments. Written by a senior member of the technical staff on the Diagnostics and Defect Resolution (DDR) team in Oracle’s Server Technologies Division.

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. Troubleshoot, tune, and optimize your Oracle database efficiently and successfully every time This book explains how to take full advantage of the revolutionary Oracle Wait Interface to quickly pinpoint--and solve--core problems and bottlenecks, and increase productivity exponentially.

Oracle security expert David Knox explains how to design and develop an integrated, secure Oracle environment.
“In my experience in the security world, including 32 years at the Central Intelligence Agency, I’ve not found anyone with more experience in the theory and practice of protecting your data than David Knox.” --Dave Carey, former Executive Director of the CIA

Develop Integrated Mobile Applications

Design, deploy, and manage flexible mobile applications on the Oracle platform. From the exclusive publishers of Oracle Press Books, Oracle9"i Mobile explains how to use and extend the mobile services available in Oracle9"iAS Wireless and integrate with other Oracle technologies. Mobilize any e-business, reach new customers, and deliver critical information to mobile users with the most scalable and reliable mobile infrastructure available.Administer wireless services with Oracle9"iAS Wireless Take advantage of Oracle9"iAS Wireless prebuilt services Build applications in Oracle9"iAS Wireless multichannel XML and Java/JSP Use transcoding to adapt and mobilize legacy applications Develop location-based features into your mobile applications Use Mobile Personal Information Management and Mobile E-mail services Implement Oracle9"iAS Wireless mCommerce Service Build, test, and deploy mobile applications using the Oracle9"iAS Mobile Studio

“In this book, Mr. Price takes you from making simple database connections to using object-relational features and covers such essential topics as Oracle9IAS Containers for J2EE (OC4J), JDeveloper, and performance tuning. Read this book and learn how to leverage the full power of Oracle’s implementation of JDBC.”
--Thomas Kurian, Senior Vice President, Oracle Server Technologies, Oracle Corporation

From the authentic Oracle Press comes the definitive guide to writing JDBC programs for use with the Oracle8i and Oracle9i databases, including details on Oracle extensions. In addition, JDBC support in the Oracle9i database as well as in Oracle9i Internet Application Server (via the containers for J2EE) is covered.

Explore connectivity options, then delve into optimization methods that can be implemented in the Crystal environment, including the use of SQL Expressions and SQL Commands. Coverage includes an execution plan, optimization of indexes, and reduction of parsing, and Oracle-specific features such as external tables, Heterogeneous Connectivity, and Oracle Flashback. Common difficulties when using Oracle are described, and solutions provided.

This authorized guide from Oracle Press explains how to implement the Oracle9i Server on Windows NT/2000. Youll get details on operating system fundamentals, installation, and configuration, plus intermediate and advanced topics such as architecture, migration, clustering, parallel server, performance monitoring, troubleshooting, and using Oracle Enterprise Manager.

Your Oracle career starts here! Ideal for those new to Oracle technology, this officially authorized entry-level book shows new DBAs various methods for backup and recovery--including Recovery Manager (RMAN). Includes hands-on exercises and end-of-chapter reviews to reinforce just-learned concepts.

Manage a Peak-Performance Oracle Application Environment

Maximize the capabilities of Oracle Financials Release 11"i--an integral component of the Oracle E-Business Suite. Officially authorized by Oracle Corporation, this essential resource explains how to install and upgrade Oracle Financials, apply patches, trace and tune critical application modules, and manage customizations. You'll also get details on day-to-day tasks, such as managing concurrent requests, adding users, handling backup and recovery, troubleshooting, capacity planning, and much more. This is a must-have resource for any Oracle DBA or Financials Administrator.Install and configure the Oracle Technology Stacks--database, middle, and desktop tiers Effectively utilize Application Development utilities and workflow functionality Control and schedule batch and reporting requirements with the Concurrent Manager Implement and manage the Cost Based Optimizer (CBO) Import data from legacy applications using Oracle Open Interfaces Install and configure STATSPACK for the Oracle E-Business Suite Financials environment Monitor Oracle Applications using Oracle Enterprise Manager Management Pack Implement security measures, such as fine-grained access control Enable self-service customizations with Oracle Portal Implement new Oracle8"i features in the application environment for added performance and scalability

Your Oracle career starts here! Ideal for those new to Oracle technology, this officially authorized guide teaches new DBAs the essentials of keeping an Oracle database running at top performance. You’ll get coverage of application, instance, database, I/O, OS, and contention tuning.

Includes information that every Oracle administrator and programmer must know to maximize uptime and recover data without compromising mission critical systems.

Learn the essentials of using Oracle8i on a network.

Get step-by-step details on implementing Net8 - the Oracle8i mode of networking.

Oracle8i Networking 101 explains how interactions over a network take place, describes the hardware and software required, and how all the components interface to produce successful communications between computers and databases. Step-by-step procedures illustrated by screen shots demonstrate precisely how to configure on Oracle8i network. Details on Internet protocols and network encrytion are also included.Determine the hardware and software components required for an Oracle networkConfigure Oracle clients and servers to communicate using Net8Configure Oracle Names serversMake us of configuration tools, including Net8 Assitant, Net8 Configuration Assistant, and the Connection ManagerSupport large networks with multi-threading and client load balancingUse Oracle WebDB, internet Application Server (iAS), and Internet Directory serverHandle security and troublehsooting

Written by an Oracle DBA and authorized by Oracle Corporation, this hands-on resource shows you everything you need to know to plan and set up an Oracle8i networking environment.

Nearly a quarter-million PL/SQL programmers--novices and experienced developers alike--have found the first and second editions of Oracle PL/SQL Programming to be indispensable references to this powerful language. Packed with examples and recommendations, this book has helped everyone, from Oracle Forms developers to database administrators, make the most
of PL/SQL.

Authored by renowned PL/SQL experts Steven Feuerstein and Bill Pribyl, this new edition is a comprehensive update of the original book, covering all versions of PL/SQL through Oracle9i Release 2. It adds much-requested new chapters on how to create and run PL/SQL programs, call Java methods from within PL/SQL, and define and use database triggers. An extensive new chapter---designed especially for experienced PL/SQL developers--describes PL/SQL's runtime architecture and how
to use knowledge of Oracle internals to get the best performance from PL/SQL. Regardless of the version you are using, from Oracle 7.3.4 to Oracle 9i, this book will answer your questions.

Your Oracle career starts here! Ideal for those new to Oracle technology, this officially authorized guide explains in easy-to-follow detail how to administer an Oracle database using this state-of-the-art tool. Inside, youll learn to eliminate, simplify, and automate administrative tasks and use Oracle Enterprise Manager (EM) as a management framework for your entire Oracle environment.

Get complete coverage of STATSPACK—Oracle’s powerful tuning tool--inside this official guide. Including ready-to-use STATSPACK scripts you’ll be able to collect and analyze system data and soon have your Oracle database running at peak performance.

Knowledge of "insider" tips on administering Oracle databases can mean the difference between a secure, smoothly running database and a corporate disaster. This book provides high-end administrative solutions for the day-to-day DBA by leveraging relatively unexplored Oracle features with methods that have proven merit in practical situations.

Best Practices from Oracle Experts

Find Undocumented, Expert Advice Inside

Take full advantage of the strength and reliability of Oracle9"i and the management features of Windows 2000. Written by the experts and authorized by Oracle Corporation, Oracle9"i for Windows 2000 Tips & Techniques presents insider best practices for installation, upgrades, migration, tuning, backup and recovery, clustering, and high availability. You'll also get in-depth details on the new features of Oracle9"i.Configure Oracle9"i on Windows 2000 as a management platform, database client, and database server Ease administrative tasks with database templates and Oracle Managed Files Monitor and manage Oracle to maximize available memory, CPU, and I/O Use Oracle9"i Recovery Manager for backup, restore, and recovery Implement Standby Databases for greater availability Use Oracle9"i Oracle Enterprise Manager for enterprisewide database administration Execute clustering and high availability solutions, using Microsoft Cluster Server, Oracle Failsafe, and Real Application Clusters Implement Advanced Replication to provide database load balancing, disaster recovery, and offline distributed transaction processing

Covers Oracle Database Releases 7.x, 8"i, and 9"i