Expands on Feuerstein's first book, Oracle PL/SQL Programming, taking you deep into the world of PL/SQL packages. Includes PL/Vision shareware library of packages. Demonstrates how to construct and properly build PL/SQL packages, providing a full-use shareware version of PL/Vision and a library of dozens of packages written by the author on the companion disk. Original. (Advanced).

This latest edition of the #1 guide to advanced PowerBuilder techniques reveals powerful solutions to hard-core programming problems. From building business logic with User Objects, to creating layout forms with the HTML DataWindow, it offers step-by-step guidance on mastering the latest features of PowerBuilder 7. And, like its critically-acclaimed predecessor, it is loaded with proven, hard-to-find programming techniques, ready-to-run code, and real-world examples. The authors show how to: Dev elop applications using PowerBuilder's new and improved user interfaceProgram using PowerBuilder Foundation ClassesBuild advanced applications with integrated Internet tools Develop robust, scaleable distributed applications with Jaguar CTSDevelop Distributed PowerBuilder (DPB) applications Interface with Microsoft Messaging API, Open Repository CASE API, Word, Excel, Windows SDK, and version control softwareSolve network and performance problems Test and debug PowerBuilder applications. CD-ROM includes: Source code from the book HOW 3.0 Learning Edition demo

Designed to exploit Oracle 10g's SQL, this book is a comprehensive look at Oracle 10g's analytical functions, MODEL statements, and regular expressions. In addition, the book covers collection/object-oriented structures and introduces new Oracle 10g topics like SQL, XML, and statistical functions.

Taken from our five day Basic PowerBuilder course, this book provides a hands-on introduction to all aspects of application development with PowerBuilder. Each component is covered in the context of using PowerBuilder to develop Windows-based, client/server production business applications. The topics are reinforced through a series of hands-on lab exercises in which the reader creates a fully functional PowerBuilder application. The lab setup and solution diskette included with the book provide s the files required to perform the hands-on labs, and includes a set of solutions to the lab exercises for student review. An instructor kit is provided, the kit includes the PowerPoint Slides and the instructor notes. This is the most popular PowerBuilder courseware on the market.

Oracle is the world's leading relational database. It provides a rich environment to store, handle, and extract data. When used properly, Oracle provides a solid foundation upon which to build enterprise scale applications. Mastering the Oracle database is not an overnight job. It takes time, practice, and a lot of real world experience. This book teaches you the core concepts behind using the database, shows you the tools and techniques you need to master, and gives you practical examples of p rogramming Oracle. By the time you have completed this book, you will have all the knowledge you need to use Oracle databases with confidence. You are setting out on the same journey we travelled some years ago. We know the things you are going to run into time and time again. We understand the challenges you are going to meet when you have to develop an application or administer your database. We can guarantee you that the techniques you'll learn in this book are proven and have led us through many successful implementations.

Are you fully harnessing the power of information to support management and marketing decisions? You will, with this one-stop guide to choosing the right tools and technologies for a state-of-the-art data management strategy built on a Customer Relationship Management (CRM) framework. Authors Alex Berson, Stephen Smith, and Kurt Thearling help you understand the principles of data warehousing and data mining systems, and carefully spell out techniques for applying them so that your business gets the biggest pay-off possible. Find out about Online Analytical Processing (OLAP) tools that quickly navigate within your collected data. Explore privacy and legal issues...evaluate current data mining application packages...and let real-world examples show you how data mining can impact -- and improve -- all of your key business processes. Start uncovering your best prospects and offering them the products they really want (not what you think they want)!

Oracle Corporation, committed to supporting XML in a wide range of products, has XML-enabled its entire Oracle Internet platform--the Oracle8i database, Oracle interMedia, Oracle Application Server, and a variety of other products. Building Oracle XML Applications, by Steve Muench, Oracle's lead "XML evangelist" and a key Oracle XML developer, gives Java and PL/SQL developers a rich and detailed look at the many tools Oracle has provided to support XML development, such as the Oracle XML Parser, the Oracle XML SQL Utility, and the XSQL Servlet. The company describes Oracle8i as "the first XML enabled database." This book shows how to combine the power of XML and XSLT with the speed, functionality, and reliability of the Oracle database to build flexible applications. The author delivers nearly 800 pages of entertaining text, helpful and time-saving hints, and extensive examples that developers can put to use immediately to build custom XML applications.

Explains how to use the common gateway interface (CGI) to create and deliver dynamic content on the web. The second edition has been rewritten to demonstrate current techniques available with the CGI.pm module and the latest versions of Perl. Programming on the Web today can involve any of several technologies, but the Common Gateway Interface (CGI) has held its ground as the most mature method--and one of the most powerful ones--of providing dynamic web content. CGI is a generic interface for c alling external programs to crunch numbers, query databases, generate customized graphics, or performing any other server-side task.

A quick guide to everything anyone would want to know about the soaringly popular Internet programming language, Python. Provides an introduction to new features introduced in Python 1.6, and topics covered include regular expressions, extending Python, and OOP. The CD-ROM includes the source code for all of the examples in the text.

The question, "Why isn't Oracle using my index?" must be one of the most popular (or perhaps unpopular) questions ever asked on the Oracle help forums. You've picked exactly the right columns, you've got them in the ideal order, you've computed statistics, you've checked for null columns--and the optimizer flatly refuses to use your index unless you hint it. What could possibly be going wrong? If you've suffered the frustration of watching the optimizer do something completely bizarre when the best execution plan is totally obvious, or spent hours or days trying to make the optimizer do what you want it to do, then this is the book you need. You'll come to know how the optimizer "thinks," understand why it makes mistakes, and recognize the data patterns that make it go awry. With this information at your fingertips, you will save an enormous amount of time on designing and trouble-shooting your SQL. The cost-based optimizer is simply a piece of code that contains a model of how Oracl e databases work. By applying this model to the statistics about your data, the optimizer tries to efficiently convert your query into an executable plan. Unfortunately, the model can't be perfect, your statistics can't be perfect, and the resulting execution plan may be far from perfect.

The dynamic memory features of Oracle9i make it possible to create a self-tuning database. This book explores proven techniques for monitoring the behavior of the Oracle System Global Area (SGA) and shows proven techniques that can be used to anticipate upcoming problems and adjust the SGA before a performance problem occurs. Written for senior Oracle DBA's this guide focuses on proactive tuning and scripting, and shows how to collect historical data and use it to develop signatures for all memo ry areas. Using these metrics DBAs will be able to develop scripts that will anticipate and correct upcoming SGA performance problems. Provided are the commands to modify the Oracle9i SGA areas, sample scripts for automating SGA tuning, and access to an online code deport full of interesting Oracle scripts.

Create dynamic, effective reports from Oracle databases using Crystal Reports 9 and the extensive information in this practical resource. Learn to use one of the most powerful data analysis tools to draw information from Oracle databases, query and rank data, consolidate results, and develop integrated, interactive reports. Plus, leverage the power of the Oracle database in your reports. You'll find full details on everything from Oracle SQL and PL/SQL functions, procedures, and expressions to t he Oracle data dictionary and the new Crystal object repository. Get the insider advice you need to optimize performance, solve difficult reporting problems, and integrate non-Oracle data.

The stability and reliability of the Linux operating system makes it an ideal platform on which to operate databases. Increasingly, major software vendors are designing their applications to run on Linux. DBA's Guide to Databases on Linux walks you through the installation and configuration of several major databases on Linux and provides a working example of an e-commerce Web site. Major commercial databases such as Oracle, Informix, Sybase, DB2 and Progress are covered in depth as well as the widely used freeware databases, MySQL and PostgreSQL. DBA's Guide to Databases on Linux is the ultimate resource and comparative reference for any DBA managing databases on Linux. This book is intended primarily for database administrators and Linux users who want to improve their skills and understanding of various databases. We hope you will come away with a better understanding of database design and implementation in general. This book will give you a better understanding of the Linux operat ing system when it is used as a database server.

CD-ROM contains the actual models that are described in the book, providing examples of the most commonly asked data mining questions regarding marketing, sales, and customer support applications. Complete working code written in SAS, the most popular mining modeling language, is also provided. Readers can use the CD-ROM to directly implement the models for business use--resulting in better campaigns, improved customer service, and increased profits. A step-by-step guide showing how to create an d implement models of the most commonly asked mining questions from a variety of disciplines. Provides proven techniques and numerous case studies that detail available data sources for developing target models. A walk through entire process of a data mining project.

This text, Data Mining: Building Competitive Advantage, resulted from the revelation that data mining is becoming mainstream and that there are few books about data mining devoted to the business professional. It provides an innovative, easy approach to learning data mining for business professionals, students, and consultants. The CD-ROM at the back of the book makes learning data mining a hands-on activity. You can try out different software packages available for data mining and learn how the se tools are being used to solve industry problems. This book focuses on how knowledge discovery is used in different industries, and discusses several of the data-mining software products available. Sample studies are provided for specific industries, including retail, banking, insurance, and healthcare. This text takes a different approach to introducing data mining than the academic books currently on the market. The focus of this book is on industry applications, discussions of specific busi ness problems, and a hands-on teaching style to demonstrate how tools can be used to attain business benefit.

Here's the resource you need if you want to apply today's most powerful data mining techniques to meet real business challenges. Data Mining: Concepts and Techniques equips you with a sound understanding of data mining principles and teaches you proven methods for knowledge discovery in large corporate databases. Written expressly for database practitioners and professionals, this book begins with a conceptual introduction designed to get you up to speed. This is followed by a comprehensive and state-of-the-art coverage of data mining concepts and techniques. Each chapter functions as a stand-alone guide to a critical topic, presenting proven algorithms and sound implementations ready to be used directly or with strategic modification against live data. Wherever possible, the authors raise and answer questions of utility, feasibility, optimization, and scalability, keeping your eye on the issues that will affect your project's results and your overall success. Data Mining: Concepts and Techniques is the master reference that practitioners and researchers have long been seeking. It is also the obvious choice for academic and professional classrooms.

Data mining techniques are used to power intelligent software, both on and off the Internet. Data Mining: Practical Machine Learning Tools explains the magic behind information extraction in a book that succeeds at bringing the latest in computer science research to any IS manager or developer. In addition, this book provides an opportunity for the authors to showcase their powerful reusable Java class library for building custom data mining software.This text is remarkable with its comprehensiv e review of recent research on machine learning, all told in a very approachable style. (While there is plenty of math in some sections, the authors' explanations are always clear.) The book tours the nature of machine learning and how it can be used to find predictive patterns in data comprehensible to managers and developers alike. And they use sample data (for such topics as weather, contact lens prescriptions, and flowers) to illustrate key concepts. After setting out to explain the types of machine learning models (like decision trees and classification rules), the book surveys algorithms used to implement them, plus strategies for improving performance and the reliability of results. Later the book turns to the authors' downloadable Weka (rhymes with "Mecca") Java class library, which lets you experiment with data mining hands-on and gets you started with this technology in custom applications. Final sections look at the bright prospects for data mining and machine learning on th e Internet (for example, in Web search engines).

A guide to the use of ERwin--a visual data modeling tool that supports logical and physical data modeling. The program supports the design of large, complex enterprise models by dividing them into smaller more manageable subject areas which allows multiple views of the same subject area. After describing the basics of modeling concepts and the program, the author explains how to use ERwin to create a logical model that represents necessary information requirements and business rules. Finally the use of database administration for developing physical models is explained. From the first chapter, author Carla DeAngelis skillfully explains the normally complex concepts of Data Modeling-a critical success factor in the information-based enterprises of today. Carla tackles complex topics such as Logical Data Models, Modeling Methodologies, Relationships, and Attributes in a clear style that makes it simple for anyone to begin applying them immediately. Once the foundation has been laid, Carl a teaches you to develop your own databases with ERwin.

Data warehouses store millions of records, allowing managers to ask the big-picture questions about their businesses. The authors of Data Warehouse Design Solutions share their expertise in designing successful data warehouses and concentrate on understanding business processes within a variety of industries. First, the authors outline the promise--and potential hurdles--of data warehousing. They thoroughly explain the idea of dimensional data, which is used to represent the quantities or attrib utes that can be queried in a data warehouse. The authors argue that data warehouses need to adapt to changing business conditions and often must be more flexible than planned. They advise building the Enterprise Data Warehouse (EDW) as a series of interlocking data marts (which contain different dimensions). Developers can build part of a solution and add new data marts later. The result is a more adaptable approach to warehousing data. The heart of Data Warehouse Design Solutions is the descri ptions of data warehouses tailored to specific industries--sales, marketing, fulfillment, production, inventory, and capacity--using real-world businesses. The authors offer business models, sample dimensions, database schema, and sample reports for each business area. Later chapters discuss more advanced areas for data warehousing, including budget tracking, financial reporting (and managerial accounting), and even how to look at profitability and intellectual capital. The authors round out the ir nuts-and-bolts tour of today's businesses with a summary of the various measures that fit each type of organization. Finally, the authors come back to theory, with some ideas on building effective systems that are fast and that generate easy-to-read reports. The last chapter argues convincingly that their incremental approach to building data warehousing has some distinct advantages.

If you want to see how your next database project can profit from object-oriented design, check out Database Design for Smarties, a lively and intelligent guide to using objects in databases. The book begins with a tour of some underlying factors in modeling databases. Here, the author distinguishes between the external, conceptual, and internal models of database design.) Then it's on to data architectures, be they the traditional relational or the newer object-relational and object-oriented (O O) database types. After discussing some of the pitfalls of gathering and implementing user requirements, the author looks at UML notation for use case diagrams. (His example here, a crime database for tracking Sherlock Holmes's stories, along with criminals and clues, is both intelligent and entertaining.) The author's guide to UML class design is topnotch. He covers basic and advanced OO concepts such as inheritance, aggregation, composition, and polymorphism with clear and concise explanation s. He also shows you how to model business rules using objects and UML class diagrams. The most valuable part of this book comes with the mapping of UML class diagrams onto three different kinds of databases: relational (on Oracle7), object-relational (on Oracle8), and object-oriented (on the POET platform). The author shows how to emulate object-oriented ideas successfully using stored procedures and triggers, even if you are not running on a "true" object-oriented platform.

Examples abound in database applications of well-formulated queries running slowly, even if all levels of the database are properly tuned. It is essential to address each level separately by focusing first on underlying principles and root causes, and only then proposing both theoretical and practical solutions. "Database Performance Tuning and Optimization" provides comprehensive coverage of database performance tuning using Oracle 8i and select 9i examples as the RDBMS. The coverage contains b oth theoretical discussions dealing with principles and methodology as well as actual SQL scripts to implement the methods. The book combines theory with practical tools (in the form of Oracle and Unix shell scripts) to address the tuning and optimization issues of DBAs and developers, irrespective of whether they use Oracle. Readers not using Oracle can implement the essential principles via scripts of their own written for the RDBMS used by them.

Java and databases make a powerful combination. Getting the two sides to work together, however, takes some effort--largely because Java deals in objects while most databases do not. This book describes the standard Java interfaces that make portable object-oriented access to relational databases possible and offers a robust model for writing applications that are easy to maintain. It introduces the JDBC and RMI packages and uses them to develop three-tier applications (applications divided into a user interface, an object- oriented logic component, and an information store). The book begins with a quick overview of SQL for developers who may be asked to handle a database for the first time. It then explains how to issue database queries and updates through SQL and JDBC. It also covers the use of stored procedures and other measures to improve efficiency, where these are available. But the book's key contribution is a set of patterns that let developers isolate critical tasks like obje ct creation, information storage and retrieval, and the committing or aborting of transactions. The second edition includes more basics of JDBC and SQL, with more examples, and a deeper discussion about the architecture of a robust, maintainable database application. The second edition also explains the relationship between JDBC and Enterprise JavaBeans.

This text on the Structured Query language and the Programming Language/Structured Query Language (PL/SQL) in Oracle version 8 or higher offers step-by-step instructions supplemented by hands-on examples, exercise questions, and lab activities. Two real-life running databases are used as models to explore database issues. Early chapters cover relational concepts and database design techniques, and later chapters concentrate of the primary nonprocedural relational database language SQL and the pr ocedural language PL/SQL. Final chapters introduce the architecture and administration of Oracle 8.

This book focuses on discussing the issues that a DBA would face in extending existing systems for eBusiness. The book also discusses how DBAs can prepare themselves for the challenge. An example business 'DOeBIZ Corporation' is used to help the reader understand the various issues involved and how an Oracle DBA can deal with them.

Thakkar, a software engineer for Quest, shows how to create a web- enabled database application using the Java features of Oracle8i, reviewing the issues in such a project and suggesting ideas for using the Internet capabilities of Oracle8i to resolve those issues. An online coffee shop is used as an example project throughout the book to demonstrate analysis, design, implementation, testing and deployment. In Building e-Commerce Database Applications Using Oracle8i and Java from scratch, Meghra j Thakkar takes novice web programmers through the process of creating a web-enabled database application. You will look at the requirements, analysis, design, implementation, testing and deployment of an "Online Coffee Shop" from scratch. You will also learn to create database objects (tables and indexes), populate the database, and use SQL, PL/SQL and Java to manipulate the data. e-Commerce Applications Using Oracle8i and Java From Scratch (From Scratch)

By removing the guesswork from Oracle HTML manipulation, this book shows working examples of complex HTML-DBA database access and techniques for creating easy HTML-DB applications. All HTML-DB concepts are described, and working examples of each HTML-DB feature are provided. Examples of HTML-DB data access and document formatting, information on how to update Oracle HTML-DB, and methods of customizing applications with Themes and CSS are also included.

Explaining how to use the powerful Oracle10g automatic features for simple database administration, this book has complete coverage for 10g Automatic Storage Management (ASM), 10g Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), Automatic SGA Management (ASM), and the SQL Tuning Advisor. Demonstrated is how a non-Oracle person can quickly install and configure Oracle database 10g for automatic database administration and how, in less than a day, a complete Oracl e10g database can be ready to use. Also explained is easy disk and file management with the 10g Automatic Storage Management and how the 10g Automatic Workload Repository collects important Oracle performance statistics.

Targeting those new to Oracle data warehousing who need to get started right away, this book presents real-world problems and issues with managing large volumes of data in an Oracle database. All aspects of Oracle data warehouse management?including Oracle warehouse database administration, OLAP with Oracle Discoverer, Oracle Warehouse Builder, and Oracle data mining?are covered in detail. An overview of Oracle business intelligence tools and a downloadable code depot are also included.

Targeted at Oracle professionals who need fast and accurate working examples of complex issues, Oracle In-focus books target specific areas of Oracle technology in a concise manner. Plenty of working code is provided without a lot of theory, allowing database managers to solve their problems quickly without reviewing data that they already know. All code scripts are available for instant download from a companion web site.

Simplifying the work of creating dynamic web pages with Oracle content is the focus of this guide, which provides working examples of connecting to Oracle and delivering data into an HTML page. It thoroughly details information on complex Oracle queries in PHP, updating Oracle from PHP, and passing parameters to a PHP program.

Targeted at Oracle professionals who need fast and accurate working examples of complex issues, Oracle In-focus books target specific areas of Oracle technology in a concise manner. Plenty of working code is provided without a lot of theory, allowing database managers to solve their problems quickly without reviewing data that they already know. All code scripts are available for instant download from a companion web site.

Targeted at Oracle professionals who need fast and accurate working examples of complex issues, Oracle In-focus books target specific areas of Oracle technology in a concise manner. Plenty of working code is provided without a lot of theory, allowing database managers to solve their problems quickly without reviewing data that they already know. All code scripts are available for instant download from a companion web site.

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.

This comprehensive guide focuses on developing Web and component-based applications with PowerBuilder 7. With an experts look at the mechanics of the software, this complete reference shows how to develop powerful, industrial-strength applications that can access data-aware components in distributed PowerBuilder, Jaguar Component Transaction Server, and Microsoft Transaction Server. In addition, you'll learn how to take advantage of the Enterprise Application Studio to build and deploy enterpris e Web, distributed, and client/server applications. The online web site is packed with sample applications, source code, reference material, as well as links to author's other articles. Some of the topics covered in this book are: Developing Component-centric Applications, Building Jaguar CTS Components/Clients, Building COM/MTS Components/Clients, Building and Using Java Components, Automation Servers, Remote Debugging, Using the JavaBeans Proxy, Introduction to Java, Java for PowerScript'ers, Web Development and Deployment Kit, DataWindow Web Control, OLE DB, JDBC, CORBA, Adaptive SQL Anywhere, Adaptive Server Enterprise, and lots more.

Written by the former principal product manager for Grid Computing at Oracle, this is the only book on the market that explains how to take full advantage of the agility, reliability, and low cost of Enterprise Grid Computing in the Oracle environment. The book discusses the technologies and processes involved in moving towards the grid model at every layer of the IT stack, including storage, servers, databases and applications.

The Essential Guide to PeopleSoft Development and Customization is an exhaustive, as well as practical, guide that covers PeopleSoft 7.5 and many new features in release 8.0. Both novice and experienced programmers will benefit from the detailed coverage of topics ranging from the basics of Application Designer to the proper use of PeopleCode within the Application Processor. The book serves as both a reference and a tutorial and covers advanced topics that other books avoid. The reader can gain valuable expertise by following the exercises and building sample applications and utilities. Extensive coverage of PeopleCode including scroll and function library examples can be found as well as methodology behind customization and upgrades. Discover how to effectively utilize SQR and Process Scheduler. Master various levels of PeopleSoft security. Most developers won't touch PeopleSoft COBOL programs with a ten foot pole. Expand your horizons by uncovering the secrets of PeopleSoft COBOL an d the PTPSQLRT module and even walk through a sample customization. Application Engine is a powerful PeopleTool - but one of the least understood. Through a series of simple but effective exercises the reader will learn Application Engine concepts such as dynamic SQL, decision logic and dynamic sections. A useful Application Engine utility is produced that will enhance the delivered Process Scheduler panels. This book takes a soup-to-nuts approach leading the reader through the full cycle of app lication development.

A soup-to-nuts guide to building and managing high-performance Oracle8i data warehouses In an effort to help companies manage what Information Week has referred to as the "Web Data Deluge," Oracle has released Oracle8i (the "i" stands for "Internet"), a major upgrade to their flagship database product that provides powerful new data warehousing capabilities. In this updated and expanded edition of their critically acclaimed Oracle8 Data Warehousing, Gary Dodge and Tim Gorman provide database dev elopers and administrators with complete, detailed coverage of all they need to know to build and manage a fast, high-performance data warehouse using the Oracle8i technology. Step-by-step, they cover all the bases, including designing a data warehouse for optimum performance, building a data warehouse, loading data into the data warehouse, improving warehouse performance with aggregate data, and administering data warehouse performance.

McGraw-Hill is the exclusive publisher of Oracle Press, working closely for more than ten years with Oracle experts and the user community to develop the most authoritative, comprehensive, and current references for Oracle products and technologies. Written in an accessible, engaging, and logical way this book will quickly become the fingertip quick reference for Oracle database administrators who want to get more done faster. Filled with shortcuts, this handy reference is divided into logical s ections: Administration, Tuning, backup and recovery, SQL and Pl/SQL, troubleshooting, and a general section on interesting ways to get everything done that has to be done. From the exclusive Oracle Press, this will be a well-thumbed reference that will have to be on every DBA's bookshelf.

Tom Kyte is of a rare breed. To begin, he's technically expert in his subject (administration of and development of applications for Oracle database management systems). What's more (and what distinguishes him from the ranks of the super-competent), he is both able and willing to share his considerable store of wisdom with Oracle users via books like Expert One on One: Oracle. Perhaps the best book about Oracle products ever put out, this book is a model of all aspects of technical publishing: s cope, level of detail, clarity of explanations, and quality of examples. It's pretty much certain that you will learn a great deal about Oracle from Kyte's work, and that you'll become more capable in your work as a result of studying this book. Kyte - it's very tempting to call him an Oracle oracle - seems not to have had to struggle to fit his message into the Wrox Press form, which relies on a running commentary interspersed with code listings and conceptual diagrams. Kyte's commentary is em inently informed and packed with references to the differences between that which is ideal and that which often must be done to accommodate reality. He takes care to explain how little-known pieces of the Oracle environment - and alternative ways of looking at the more familiar ones - solve problems, an approach that leads to elegant, efficient solutions. Kyte boosts his readers across the chasm that separates people who can write applications for Oracle databases from people who understand Orac le databases.

This is a unique, one-volume guide to the administration and management of the Oracle database. Fully revised and updated from its best-selling 9i predecessor, this edition covers all new features, with fully field-tested examples--not just "showcase" examples. This book covers the new 10g management and performance tools and provides essential primers on Unix, Linux and Windows NT administration and on core SQL and PL/SQL programming techniques. And it provides everything the new and aspring O racle DBA needs to build and admisiter complex Oracle 10g databases.

This is a defining book on the Oracle database for any developer or DBA who works with Oracle-driven database applications. Tom has a simple philosophy: you can treat Oracle as a black box and just stick data into it or you can understand how it works and exploit it as a powerful computing environment. If you choose the latter, then you will find that there are few information management problems that you cannot solve quickly and elegantly. Each feature is taught in a proof-by-example manner, n ot only discussing what it is, but also how it works, how to implement software using it, and the common pitfalls associated with it. This fully revised edition covers both the 9i and 10g versions. It also comes with a CD containing a searchable PDF of the 8i version of the book. Tom has fully revised and expanded the architecture-related sections from Expert One-on-One Oracle (a searchable PDF of which is included on the CD accompanying this book), and added substantial new material. He focus es solely on 9i and 10g architecture in this book and refers to the CD for 8i-specific details. The number of changes will surprise you. In summary, this book provides a one-stop resource containing deep wisdom on the design, development and administration of Oracle applications, written by one of the world's foremost Oracle experts, Thomas Kyte.

With Oracle in the process of de-supporting SQLJ, JDBC is now really the only recommended means of interfacing between Java and Oracle. Consequently, this book is a must have for any developer building an Oracle Java application. Many Java developers tend to treat Oracle as a "black box"; as a consequence, developers tend to write incorrect, non-scalable code. If you don't intimately know how Oracle works and expects you to program, you might avoid Oracle extensions to the standard for fear of your code becoming database-dependent. If you give in to that fear, you'll miss out on the extensive out-of-the-box functionality that Oracle offers. This book teaches you how to build efficient, high-performance, and robust Oracle-based JDBC applications. You'll discover the full details of Oracle's implementation of the JDBC 3.0 standard (what it supports, what it doesn't and what extensions Oracle provides), and more. This book tackles issues head-on, detailing concisely and clearly the vita l details of Oracle's architecture and mode of operation that directly impact the manner in which JDBC applications should be written. Only when armed with this knowledge, a willingness to exploit the database to its full potential in your JDBC code, and the ability to use Oracle's SQL and PL/SQL features when appropriate, is it possible to write truly efficient, robust, scalable and high performance applications.

Experienced PL/SQL programmers and Oracle developers will learn to master Oracle's procedural extension to industry-standard SQL. Using this authoritative resource, readers will become experts at developing robust, high-performance enterprise applications with PL/SQL. Detailed examples describe the practical aspect of each feature, and provide ideas to the reader of how they can best exploit the functionality.

Tom Kyte is of a rare breed. To begin, he's technically expert in his subject (administration of and development of applications for Oracle database management systems). What's more (and what distinguishes him from the ranks of the super-competent), he is both able and willing to share his considerable store of wisdom with Oracle users via books like Expert One on One: Oracle. Perhaps the best book about Oracle products ever put out, this book is a model of all aspects of technical publishing: s cope, level of detail, clarity of explanations, and quality of examples. It's pretty much certain that you will learn a great deal about Oracle from Kyte's work, and that you'll become more capable in your work as a result of studying this book. Kyte--it's very tempting to call him an Oracle oracle--seems not to have had to struggle to fit his message into the Wrox Press form, which relies on a running commentary interspersed with code listings and conceptual diagrams. Kyte's commentary is emin ently informed and packed with references to the differences between that which is ideal and that which often must be done to accommodate reality. He takes care to explain how little-known pieces of the Oracle environment--and alternative ways of looking at the more familiar ones--solve problems, an approach that leads to elegant, efficient solutions. Kyte boosts his readers across the chasm that separates people who can write applications for Oracle databases from people who understand Oracle d atabases.

This is the only real Oracle 9i Database Administration book on the market! This 1,000 page book enables a beginner or intermediate level Oracle DBA of Oracle Developer/Manager to master the art of building and managing complex Oracle 9i databases. "Expert Oracle9i Database Administration" is thorough in covering all aspects of the 9i database and also includes a UNIX primer, as well as an introduction to SQL and PL/SQL. Sam R. Alapati covers the entire spectrum of the new Oracle 9i RDBMS softwa re and clearly explains how to use all of its powerful features. Currently, there is no one book that combines the necessary UNIX administration, Windows NT management, and SQL backgrounds and the necessary database administration principles. Sam R. Alapati's book fills that gap well, by providing all the necessary material in one comprehensive volume. "Expert Oracle9i Database Administration" is designed as the most complete Oracle 9i database text available today. It takes several courses, as well as mastery of several Oracle manuals, to become a proficient DBA. A major focus of this book is on the most important features of the Oracle 9i database. Readers will be able to become expert Oracle DBAs by using this book.

Opportunities presented by mobile and wireless applications are numerous, and this book provides an objective analysis of both the potentials and pitfalls, pointing out situations where mobile technology may or may not be the right solution. For those businesses where it does fit, the authors guide readers on how to form a strategic vision and tactical plan for implementing real-time/anytime communications. Detailed case studies demonstrate how a particular company or agency has saved time, mone y, or labor by going mobile.

Flexible, reliable, and inexpensive, enterprise grid computing is the ideal solution to today?s changing business needs. Perfect for business decision-makers, Grid Revolution provides an accessible overview of this technology. The book covers current grid standards activities and outlines the strategic steps required to phase grid computing into an existing infrastructure.

These Starter Kits include the full distribution of Oracle Database 10g Express Edition on CD-ROM. Readers will learn to install the database on Linux and take full advantage of all of the powerful features. Tutorials and step-by-step guidelines throughout will equip you with the key concepts and hands-on experience necessary to get started using Oracle Database 10g Express Edition right away.

These Starter Kits include the full distribution of Oracle Database 10g Express Edition on CD-ROM. Readers will learn to install the database on Windows and take full advantage of all of the powerful features. Tutorials and step-by-step guidelines throughout will equip you with the key concepts and hands-on experience necessary to get started using Oracle Database 10g Express Edition right away.

High Performance Oracle Data Warehousing takes readers beyond the basics, showing them how to create compact, efficient, lightning-fast data warehouse systems with Oracle. The CD-ROM contains all examples and source code used in the book, including SQL scripts, optimized database tables, templates, and more. High Performance Oracle Data Warehousing provides everything that the Oracle developer and DBA need to know to design and implement fast and functional Oracle data warehouses. Using proven t echniques from actual systems, this book is full of practical tips and tricks for getting the most out of the Oracle architecture and ensuring maximum performance from the data warehouse. You'll also find advance information on the eagerly awaited Oracle8. And unlike other books on data warehousing, High Performance Oracle Data Warehousing contains invaluable information and actual code examples that demonstrate the use of Oracle data warehouse features.

Ensuring high-performance and continuous availability of Oracle software is a key focus of database managers. At least a dozen books address the subject of "performance tuning"?? that is, how to fine-tune the Oracle database for its greatest processing efficiency. Geoff Ingram argues that this approach simply isn?t enough. He believes that performance needs to be addressed right from the design stage, and it needs to cover the entire system??not just the database. High-Performance Oracle is a h ands-on book, loaded with tips and techniques for ensuring that the entire Oracle database system runs efficiently and doesn?t break down. Written for Oracle developers and DBAs, and covering both Oracle8i and Oracle9i, the book goes beyond traditional performance-tuning books and covers the key techniques for ensuring 24/7 performance and availability of the complete Oracle system.

More than half a million job seekers turn to this classic guide to write better resumes. It has been updated and revised to satisfy the needs of today's candidates. Readers now get more than 150 resumes covering an array of careers, with variants reflecting all career stages. All resume types and formats are covered, with a wealth of word-processing formatting solutions. In addition, there are expert tips on how to conduct a successful job search, compose dynamite cover letters, and ace any inte rview.

This book is about database security and auditing. You will learn many methods and techniques that will be helpful in securing, monitoring and auditing database environments. It covers diverse topics that include all aspects of database security and auditing - including network security for databases, authentication and authorization issues, links and replication, database Trojans, etc. You will also learn of vulnerabilities and attacks that exist within various database environments or that hav e been used to attack databases (and that have since been fixed). These will often be explained to an internals level. There are many sections which outline the anatomy of an attack before delving into the details of how to combat such an attack. Equally important, you will learn about the database auditing landscape both from a business and regulatory requirements perspective as well as from a technical implementation perspective.

Oracle database administration goes far beyond installation and tuning of the database - topics covered by the majority of books on the market. As DBAs become more involved in the business process, architecture, and planning, there may be more to do up front, but the end result is less chaotic. To better prepare those who are up to the new eBusiness challenges, the chapters in this book have been organized with information to not only provide IT professionals with information that can be applied for a more challenging and successful career, but also for those companies who are trying to attract and retain them.

Students need a big-picture introduction to Oracle and they need specific examples and steps. This concise book covers all of the topics students need in a first class by using step-by-step techniques with a rich set of databases to provide students with practical experience ? all in one book.

Provides a definitive description of the JDBC API, the technology that enables universal data access for the Java programming language. Combines a step-by-step tutorial with a comprehensive reference to all of the classes and interface, and gives in-depth explanations that go beyond the specification. Offers an introduction for those new to the Java programming language and to SQL, then walks through creating a JDBC application, with many examples, and discusses advanced topics. This book provid es the definitive description of the JDBC(tm) API, the technology that enables universal data access for the Java(tm) programming language. This new edition has been updated and expanded to cover all of the JDBC 2.0 API, including the JDBC 2.0 core API and the JDBC Standard Extension API, the package that facilitates building server-side applications.

For every computer subject, there must be a large, shelf-straining tome that attempts to cover everything about the subject and more. JDBC Developer's Resource fills that niche for JDBC. Taylor's book opens with information about the Java language, including the now-hackneyed story of the language's development and a comparison to C and C++. Then, there's a valuable chapter for programmers who haven't done database work before that explains in clear terms how relational databases work. After a g lancing introduction to the JDBC application programming interface (API), the author walks the reader through the creation of all the critical elements of a JDBC application, including inserts, deletes, and updates. He covers the applet-specific implications of JDBC and explores three-tiered databases. The entire second half of JDBC Developer's Resource is given over to a full JDBC API reference.

JDBC Metadata, MySQL, and Oracle Recipes is the only book that focuses on metadata or annotation-based code recipes for JDBC API for use with Oracle and MySQL. It continues where the author's other book, JDBC Recipes: A Problem-Solution Approach, leaves off. This new edition is also a Java EE 5-compliant book, perfect for lightweight Java database development. And it provides cut-and-paste code templates that can be immediately customized and applied in each developer's application development.

Ideal for any Java programmer trying to master JDBC database programming in a hurry, the remarkably concise and useful JDBC: Practical Guide for Java Programmers offers an example-based quick tour of essential APIs and techniques that you can use every day at your desk.

Welcome to the Java 2 Programmer's Interactive Workbook. This book will help guide you as you learn the Java programming language, which is regarded as the future of computer programming. Never before has a computer language so successfully combined a powerful object-oriented language with all of the graphical tools needed to create a fully functional program that can run on any system and in any Web browser. With the advance of the Internet, Java has become the language of choice for developers who need to create and distribute their applications quickly. Java was developed by Sun Microsystems in the early 1990s and has been gaining popularity every since. Prior to Java, the two main languages used by the computer industry were C, and C++. C is simple, powerful, and sometimes elegant, but it is also a procedural language. C++ is object-oriented, but also hugely complex and requires a great deal of overhead to maintain a program. Both languages are also machine-dependent, meaning that their programs only run on one type of computer (PC, Mac, Unix). The program must be recompiled, and sometimes rewritten, to work on a different computer. This can lead to long development times for projects. Likewise, neither C nor C++ have built-in graphical utilities. Both must use special libraries that allow the program to use the windowing features of the computer. These libraries can be vastly different on various computer platforms, requiring more rewriting of the programs.

Computer professionals increasingly rely on the Web, online help, and other online information sources to ease information pain. Now The Java Enterprise CD Bookshelf gives you convenient online access to your favorite books from your CD-ROM drive. The Java Enterprise CD Bookshelf contains a powerhouse of books from O'Reilly: both electronic and print versions of Java Enterprise in a Nutshell, plus electronic versions of Java in a Nutshell, 3rd Edition; Java Foundation Classes in a Nutshell; Ente rprise JavaBeans, 2nd Edition; Java Servlet Programming; Java Security; and Java Distributed Computing. Never has it been easier to learn, or look up, what you need to know online. Formatted in HTML, The Java Enterprise CD Bookshelf can be read using any Web browser. The books are fully searchable and cross-referenced. In addition to individual indexes for each book, a master index for the entire library is provided.

JDBC is the key Java technology for relational database access. Oracle is arguably the most widely used relational database platform in the world. In this book, Donald Bales brings these two technologies together, and shows you how to leverage the full power of Oracle's implementation of JDBC. You begin by learning the all-important mysteries of establishing database connections. This can be one of the most frustrating areas for programmers new to JDBC, and Donald covers it well with detailed i nformation and examples showing how to make database connections from applications, applets, Servlets, and even from Java programs running within the database itself. Next comes thorough coverage of JDBC's relational SQL features. You'll learn how to issue SQL statements and get results back from the database, how to read and write data from large, streaming data types such as BLOBs, CLOBs, and BFILEs, and you'll learn how to interface with Oracle's other built-in programming language, PL/SQL. If you're taking advantage of the Oracle's relatively new ability to create object tables and column objects based on user-defined datatypes, you'll be pleased with Don's thorough treatment of this subject. Don shows you how to use JPublisher and JDBC to work seamlessly with Oracle database objects from within Java programs. You'll also learn how to access nested tables and arrays using JDBC. Donald concludes the book with a discussion of transaction management, locking, concurrency, and perfo rmance--topics that every professional JDBC programmer must be familiar with. If you write Java programs to run against an Oracle database, this book is a must-have.

If you're a Java programmer working in an Oracle environment, you're probably familiar with JDBC as a means of accessing data within an Oracle database. SQLJ takes you further, allowing you to access a database using embedded SQL statements. Java Programming with Oracle SQLJ shows you how to get the most out of SQLJ. Layered on top of JDBC, SQLJ greatly simplifies database programming. Rather than make several calls to the JDBC API just to execute a simple SQL statement, SQLJ executes that state ment simply by embedding it within the Java code. In this book, Jason Price explains SQLJ programming from a task-oriented point of view. You'll learn how to: Embed queries and other SQL statements within Java programs. Deploy SQLJ code not only on client machines, but also to JServer--Oracle's Java engine built into the database. Use advanced techniques for working with collections, streams, large objects, and database objects, all without leaving the comfort of the SQLJ environment. Tune SQLJ programs for maximum performance. Throughout this book, the exposition of SQLJ and SQLJ programming techniques reflect the author's many years of professional experience as a programmer and consultant. Examples are first-rate, enabling you to learn SQLJ in no time. If you're writing Java code to access an Oracle database, you can't afford not to know about SQLJ.

A beginner's guide to programming terminology, fundamental concepts, and techniques for writing code. The author focuses on the four basic constructs of programming--sequences, loops, branches, and modules--then walks step-by-step through the development of a word counter and a guessing game. The CD-ROM contains Python version 1.5.2 and a Python tutorial. Topics covered include data types and variables, debugging, and namespaces. Also includes sample applications that illustrate ideas and techn iques in action. The CD-ROM contains an online Python tutorial.

Oracle development tools come and go, but one of the few constants in the Oracle database environment is the PL/SQL programming language, which has been around for more than a decade. As Oracle's premier tool for building store procedures, PL/SQL uniquely supplements the standard relational database language, SQL, with the features needed to build real-world applications. Among our best-selling books on PL/SQL, Learning Oracle PL/SQL is the first one a newcomer to the language will want to read . Beginning with a discussion of what PL/SQL is and what it's good for, this book then presents language features, one at a time, in an engaging and readable way. A consistent and understandable example application--the development of a library's electronic catalog system--runs through the chapters. Topics include: Why use PL/SQL at all? Fundamental components of the language Fast ways to read and write Oracle data Organizing code for reusability Using PL/SQL to generate web-based applications Making sure your PL/SQL application is secure against hackers Benefits of using third-party developer tools Interacting with the internet (e.g., sending email from the database) New PL/SQL features in Oracle9i Learning Oracle PL/SQL introduces PL/SQL in a way that's useful to a variety of audiences: beginning programmers, new Oracle database administrators, and developers familiar with other databases who now need to learn Oracle.

The authors of Learning Python show you enough essentials of the Python scripting language to enable you to begin solving problems right away, then reveal more powerful aspects of the language one at a time. This approach is sure to appeal to programmers and system administrators who have urgent problems and a preference for learning by semi-guided experimentation. First off, Learning Python shows the relationships among Python scripts and their interpreter (in a mostly platform-neutral way). T hen, the authors address the mechanics of the language itself, providing illustrations of how Python conceives of numbers, strings, and other objects as well as the operators you use to work with them. Dictionaries, lists, tuples, and other data structures specific to Python receive plenty of attention including complete examples.

Starts with very simple Oracle SQL concepts and slowly builds into more complex query development and PL/SQL. Covers SQL as it is invoked via SQL Plus, a command-line system to launch interactive queries. Provides an appendix for UNIX users of Oracle.

In their critically acclaimed book, Data Mining Techniques, Michael Berry and Gordon Linoff showed readers how to use data mining techniques to improve marketing and sales. In their new, book they take readers to the next level with a series of step-by-step lessons, built around 20 real-world cases illustrating how they used their techniques to solve problems.

Stop dreaming small, or you will always be small. From the beginning of time, people have been working for a living and, chances are, you're carrying on this tradition. Whether you labor as a frontline worker or toil in high-level management, this book is for you. This isn't a Greek tragedy nor a retelling of the woes of the business world that we hear about every day in the news, and it's not a comedy that pokes fun at the idiocies that people witness daily in the workplace. Unite the Tribes: E nding Turf Wars for Career and Business Success shows the imaginary lines that divide companies into separate "tribes," with each fighting the other in small and petty turf wars. From this new perspective, you'll see how such internal divisiveness weakens your business and makes employees vulnerable to competitors in the marketplace.

If you write programs to run against an Oracle database, you spend a lot of time and mental energy writing queries to return the data your programs need. Knowledge of SQL, and particularly of Oracle's implementation of SQL, is the key to writing good queries in a timely manner.

SQL is the ANSI-standard language for accessing and manipulating relational databases. Anyone (programmers, administrators, or designers) who work with a relational databases need to understand the SQL language. While most books on the market do not properly cover the basics, this book differs: it explains fundamentals in detail, supported by realistic examples.You will gain full competence to define, access, and manipulate data in an Oracle database. This book is an effective tool for you to w rite effective SQL for the Oracle database. The text is fully compliant with the latest version of the ANSI SQL standard, and fully update for the Oracle 10g database. This book is a translation of popular Netherlands college text (currently in its third edition). Author Lex de Haan is highly experienced with the Oracle database, and has twenty-five years of teaching experience. de Haan is also a member of the ANSI/ISO SQL standardization national body.

The vast majority of Oracle SQL books discuss some syntax, provide the barest rudiments of using Oracle SQL, and perhaps include a few simple examples. It might be enough to pass a survey course, or give you some buzz words to drop in conversation with real Oracle DBAs. But if you use Oracle SQL on a regular basis, you want much more. You want to access the full power of SQL to write queries in an Oracle environment. You want a solid understanding of what's possible with Oracle SQL, creative tec hniques for writing effective and accurate queries, and the practical, hands-on information that leads to true mastery of the language. Simply put, you want useful, expert best practices that can be put to work immediately, not just non-vendor specific overview or theory. Updated to cover the latest version of Oracle, Oracle 10g, this edition of the highly regarded Mastering Oracle SQL has a stronger focus on technique and on Oracle's implementation of SQL than any other book on the market. It c overs Oracle s vast library of built-in functions, the full range of Oracle SQL query-writing features, regular expression support, new aggregate and analytic functions, subqueries in the SELECT and WITH clauses, multiset union operators, enhanced support for hierarchical queries: leaf and loop detection, and the CONNECT_BY_ROOT operator, new partitioning methods (some introduced in Oracle9i Release 2), and the native XML datatype, XMLType. Mastering Oracle SQL, 2nd Edition fills the gap between the sometimes spotty vendor documentation, and other books on SQL that just don't explore the full depth of what is possible with Oracle-specific SQL. For those who want to harness the untapped (and often overlooked) power of Oracle SQL, this essential guide for putting Oracle SQL to work will prove invaluable.

Massive in size, comprehensive in scope, and unfortunately quite dry in tone, Mastering Oracle 8i has the answers you need if you're working with the Oracle 8i database management system. The authors, one of whom holds an Oracle certification, go into considerable detail on the procedures to be followed for administrative tasks like backing up data, rolling back transactions, and configuring monitoring schemes. They usually share their thoughts on when and why you'd want to put the procedures to use, as well. Better yet, they go beyond everyday administrative work to cover subjects like materialized views, advanced user management, and performance-tuning techniques. There's some discussion of hooks for software developers, as well. The authors' approach is to take a feature of the Oracle 8i environment--locks, say--and explain what purpose it serves, then break it down into component types with more detailed explanations. From there, the authors provide the commands and codes for view ing and manipulation of the feature, often with extensive tables. The really useful information comes next, in the form of sections on how to deal with related problems. The section on locks, for example, shows how to zero in on blocking locks. Other excellent coverage deals with how to dimension hardware, while a commendable section explains the object-oriented features of Oracle 8i.

A guide to Oracle DBA management scripts, this book is indispensable for all Oracle professionals who must quickly automate and manage their Oracle databases with scripts. An online code depot full of more than 200 pretested Oracle DBA scripts is provided. Coverage of all areas of Oracle database administration including data files, tablespace, and table and index management scripts is included. Also reviewed are mechanisms for automating Oracle database administration tasks and tips for automat ing without buying expensive tools.

Prepare for the Oracle Certified Administrator Oracle Application Server 10g exam with help from this exclusive Oracle Press guide. Get complete coverage of all topics on the exam 1Z0-311, including installation, configuration, and management of Oracle Application Server 10g, as well as details on Oracle Internet Directory, Oracle HTTP Server, Oracle Single Sign-On Server, Oracle Portal, Oracle Application Server Containers for J2EE (OC4J), and Oracle Web Cache. In each chapter, you?ll find cert ification objectives, examples, a two-minute drill, and a self-test to highlight what you?ve learned. This book and CD-ROM package is the most comprehensive preparation tool available for this OCA exam.

Full Coverage of exams 1Z0-007 and 1Z0-031! Prepare for the Oracle Certified Associate (OCA) exams with this exam guide from the exclusive publishers of Oracle Press books. This volume is comprised of OCP Introduction to Oracle9i: SQL Exam Guide and OCP Oracle9i Database: Fundamentals I Exam Guide. Books and CD-ROMs combined contain more than 600 practice questions and cover all objectives for OCA certification.

Learn the ins and outs of 9i with the OCA/OCP: Introduction to Oracle9i SQL Study Guide. This release from Sybex will prepare you for Exam 1Z0-007, Introduction to Oracle9i: SQL. You get hundreds of challenging review questions in the book and on the CD and authoritative coverage of all exam objectives. Here's the book you need to prepare for Exam 1Z0-007: Introduction to Oracle9i: In-depth coverage of official exam objectives Practical information on using SQL in a real-world Oracle9i en Hundr eds of challenging review questions, in the book and on the CD Authoritative coverage of all exam objectives, including: Writing basic SQL SELECT statements Restricting and sorting data Displaying data from multiple tables Aggregating data using group functions Producing readable output with iSQL*Plus Creating and managing tables Controlling user access.

Here's the book you need to prepare for Exam 1Z1-031: OCA/OCP: Oracle9i DBA Fundamentals I Study Guide In-depth coverage of official exam objectives Practical information on implementing and managing Oracle9i databases Hundreds of challenging review questions, in the book and on the CD Authoritative coverage of all exam objectives, including: Understanding Oracle architecture and its main components Identifying DBA administrative tools Setting up password file authentications Creating and managi ng Initialization Parameter Files Configuring OMF Create a database using Oracle Database Configuration Assistant Creating a database manually Featured on the CD The enclosed CD is packed with vital preparation tools and materials, beginning with the Sybex EdgeTest testing engine for the Oracle9i Fundamentals I exam. Loaded with hundreds of practice questions, it lets you test yourself chapter by chapter or according to objective areas. You'll also find electronic flashcards for your PC and Palm handhelds and two bonus exams that will help you prepare for the test. Also included is a complete electronic version of the book.

Here's the book you need to prepare for the Oracle Database 10g Administration I exam, 1Z0-042. This Study Guide was developed to meet the exacting requirements of today's Oracle certification candidates. In addition to the consistent and accessible instructional approach that has earned Sybex the "Best Study Guide" selection in CertCities Readers Choice Awards for two consecutive years

Complete coverage of the exam objectives, hands-on exercises, review questions, and more, this is the first and only book to offer such in-depth coverage of this challenging exam. Takes into consideration that candidates must not only know how to install and configure Oracle Application Server 10g, but how to use the robust tool set, including Oracle HTTP Server and OracleAS Portal. The book features an interactive CD-ROM, including the Sybex Test Engine with chapter review questions and bonus exams, a series of flash cards that can be used on a PC or handheld, and an e-version of the book

An instructor's guide for teaching Oracle DBA certification candidates, this book is highly technical and written for Oracle Certified Professional (OCP) DBA instructors who want to ensure that their students successfully pass their Oracle OCP certification exam. Covering those OCP topics that students find the most challenging, instructors will find targeted Oracle OCP testing content, test taking tips, and actual OCP test content. Other test topics covered include database architectures, desig n review meetings, software installation, database objects, backup and recovery, and tuning and performance.

Prepare for the Oracle Certified Professional Oracle Database 10 g New Features for Administrators exam with help from this exclusive Oracle Press guide. Get complete coverage of all topics on the upgrade exam, including installation, configuration, application tuning, database management, backup and recovery, security, and more. In each chapter, you'll find examples, practice questions, lab questions, a two-minute drill, and a chapter summary to highlight what you've learned. This book and CD-R OM package is the most comprehensive preparation tool available for this OCP exam.

Prepare for the Oracle Certified Professional Oracle9i Database: Fundamentals I exam--a required exam for Oracle9i DBA certification--using this Oracle Press study guide. Throughout each chapter, you'll find in-depth details on all the material covered on this challenging exam, followed by practice questions and chapter summaries to highlight what you've learned. Authorized by Oracle Corporation, this book and CD-ROM package is the most comprehensive preparation tool available for the Oracle9i D atabase: Fundamentals I exam.

Prepare for the Oracle Certified Professional Oracle9i Database: Fundamentals II exam--a required exam for Oracle9i DBA certification--using this Oracle Press study guide. Throughout each chapter, you'll find in-depth details on all the material covered on this challenging exam, followed by practice questions and chapter summaries to highlight what you've learned. Authorized by Oracle Corporation, this book and CD-ROM package is the most comprehensive preparation tool available for the Oracle9i Database: Fundamentals II exam.

Prepare for the Oracle Certified Professional Oracle9i Database: New Features for Administrators exam--a required exam for upgrading your Oracle8i or earlier DBA certification--using this Oracle Press study guide. Throughout each chapter, you'll find in-depth details on all the material covered on this challenging exam, followed by practice questions and chapter summaries to highlight what you've learned. Authorized by Oracle Corporation, this book and CD-ROM package is the most comprehensive pr eparation tool available for the Oracle9i Database: New Features for Administrators exam. Book and CD-ROM include more than 300 interactive exam-based questions. CD-ROM contains interactive exams that simulate the actual OCP exams and include hotlinked questions, answers, and explanations.

Get Certified with Official Exam Prep Material from Oracle Press. Prepare for the Oracle Certified Professional Oracle9i Database: Performance Tuning exam--a required exam for Oracle9i DBA certification--using this Oracle Press study guide. Throughout each chapter, you'll find in-depth details on all the material covered on this challenging exam, followed by practice questions and chapter summaries to highlight what you've learned. Authorized by Oracle Corporation, this book and CD-ROM package is the most comprehensive preparation tool available for the Oracle9i Database: Performance Tuning exam. Book and CD-ROM include more than 300 interactive exam-based questions. CD-ROM contains interactive exams that simulate the actual OCP exams and include hotlinked questions, answers, and explanations.

Here's the book you need to prepare for the Oracle Database 10g Administration II exam, 1Z0-043. This Study Guide was developed to meet the exacting requirements of today's Oracle certification candidates. In addition to the consistent and accessible instructional approach that has earned Sybex the "Best Study Guide" selection in CertCities Readers' Choice Awards for two consecutive years

Here's the comprehensive and affordable self-study solution you need to prepare for the Oracle Database 10g Administration I and Administration II exams. These Study Guides were developed to meet the exacting requirements of today's Oracle certification candidates. In addition to the consistent and accessible instructional approach that has earned Sybex the reputation as the preferred publisher for IT certification exam candidates worldwide, each book provides: * Clear and concise information on database administration with Oracle 10g * Practical examples and insights drawn from the authors' real-world experiences * Leading-edge exam preparation software, including a test engine and electronic flashcards

Here's the book you need to prepare for Oracle's 10g upgrade exam, Oracle Database 10g: New Features for Administrators (1Z0-040). This Study Guide was developed to meet the exacting requirements of today's Oracle certification candidates. In addition to the consistent and accessible instructional approach that has earned Sybex the "Best Study Guide" selection in CertCities Readers Choice Awards for two consecutive years

The DBA (database administrator) track is the most popular, with more than 8,000 DBAs being certified each year. Sybex's OCP DBA Study Guides provide complete coverage of exam objectives for the five exams in the DBA track: SQL and PL/SQL, Database Administration, Backup & Recovery, Performance Tuning, and Network Administration. The books are fully up-to-date for Oracle8i and include all the new features of Sybex's best-selling Study Guides. The companion CDs contain exclusive self-testing software. The DBO (database operator) exam is a new offering from Oracle, which prepares students for the full DBA track. It is fully supported by Oracle's partners: Sun, Novell, Compaq, and HP. Sybex's Study Guide provides complete coverage of the exam objectives and includes a companion CD with exclusive self-testing software.

Boxed set certification kit for the Oracle 8i DBA exams, numbers 1Z0-001, 1Z0-023, 1Z0-024, 1Z0-025, and 1Z0-026. Includes three study guide texts, each with its own CD-ROM. Each includes custom testing engines with hundreds of sample questions, electronic flashcards for PC and Palm devices, and other helpful features.

Test your knowledge with exclusive software to prepare you for all five OCP Oracle8i DBA exams. --Contains 1000 questions in a tough adaptive format with a unique benchmarking feature to help you identify weak areas. --Delivers four sample exams for each test and is a great companion to the Sybex OCP: Oracle8i Study Guides.

The perfect way to prepare for the Oracle9i DBA Fundamentals II exam! -Contains exam essentials, real-world scenario sidebars, scenario-based questions, and fill-in-the-blank questions. -The CD includes flashcards, chapter-by-chapter exams, randomly generated question sets, a bonus exam, and an electronic version of the book. The book you need to prepare for Exam 1Z1-032 Oracle 9i Database: Fundamentals II. Provides indepth coverage of official exam objectives and hundreds of challenging review questions. CD-ROM included.

The perfect way to prepare for the Oracle9i Performance Tuning exam! -Contains exam essentials, real-world scenario sidebars, scenario-based questions, and fill-in-the-blank questions. -The CD includes flashcards, chapter-by-chapter exams, randomly generated question sets, a bonus exam, and an electronic version of the book.

The popularity of object-oriented concepts, design, and programming has stimulated the need for a database system that enables a straightforward process to store and retrieve object instances. Exploring object-oriented features and techniques in Oracle DBMS, this book describes the fundamental aspects of data modeling and implementation in Oracle. The implementation of structural aspects of an object model are covered, including object types, collection types, object referencing, nested tables, and inheritance structures, as well as the behavioral aspects that include encapsulated member procedures and functions. The complete cycle of database design using object-oriented concepts, implementation on object-relational Oracle, and data manipulations using member procedures/functions and object-relational queries is also addressed.

Oracle & Open Source is the first book to tie together the commercial world of Oracle and the free-wheeling world of open source software. As this book reveals, these two worlds are not as far apart as they may seem. Today, there are many excellent and freely available software tools that Oracle developers and database administrators can use, at no cost, to improve their own coding productivity and their system's performance. Moreover, many of the finest Oracle developers are now making thei r source code freely available so their peers can build upon this code base. Oracle Corporation is even porting its RDBMS to Linux and starting to incorporate a growing number of open source tools in the company's own software. Oracle & Open Source describes close to 100 open source tools you can use for Oracle development and database administration, from large and widely known open source systems (like Linux, Perl, Apache, TCL/Tk and Python) to more Oracle-specific tools (like Orasoft, Ora c, OracleTool, and OraSnap). You'll learn how to obtain the software and how to adapt it to best advantage. The book abounds with code examples, download and installation instructions, and helpful usage hints. Not only does it tell you how to find and use existing open source code; Oracle & Open Source gives you the details and the motivation to build your own open source contributions and release them to the Oracle community. You'll lear n all about tools like the Oracle Call Interface (OCI) and Perl-DBI (Database Interface), which provide the glue allowing new open source tools to link into commercial Oracle software. With Oracle & Open Source as a guide, you'll discover an enormous number of highly effective open source tools, while getting involved with the thriving community of open source development.

Oracle 10g Data Warehousing is a guide to using the Data Warehouse features in the latest version of Oracle Oracle Database 10g. Written by people on the Oracle development team that designed and implemented the code and by people with industry experience implementing warehouses using Oracle technology, this thoroughly updated and extended edition provides an insiders view of how the Oracle Database 10g software is best used for your application. It provides a detailed look at the new features of Oracle Database 10g and other Oracle products and how these are used in the data warehouse. This book will show you how to deploy the Oracle database and correctly use the new Oracle Database 10g features for your data warehouse. It contains walkthroughs and examples on how to use tools such as Oracle Discoverer and Reports to query the warehouse and generate reports that can be deployed over the web and gain better insight into your business. This how-to guide provides step by step instruct ions including screen captures to make it easier to design, build and optimize performance of the data warehouse or data mart. It is a must have reference for database developers, administrators and IT professionals who want to get to work now with all of the newest features of Oracle Database 10g.

Oracle 10g Database Administrator II: Backup/Recovery uses the most current database release from Oracle to provide thorough coverage of an Oracle database through the day-to-day duties of a database administrator.

This book is written with the objective of providing the students or professionals with the knowledge of how to develop and manipulate a relational database through the medium of the Internet. It provides a hands-on approach toward applying the database application concepts for Web development. In an academic environment, the book can be adopted in any class or course that emphasizes relational database application concepts and/or Web application development. This textbook goes beyond mere refin ements of database or Web application concepts. It contains many distinct features and presents concepts in a significant new way. These features together provide a complete package for Web application development.

Revealing the secrets for quickly implementing and tuning Oracle RAC database systems, this book covers all areas of Oracle Real Application Clusters including Oracle10g new features. Oracle DBAs who are charged with configuring and implementing a RAC clusters database will benefit from this complete guide to the installation as well as configuration and design of Oracle Real Application Clusters. Information is supplied on expert internals of shared disk technology, raw devices and RAID with RA C, the internal concurrency, resource coordination, and the locking mechanism within RAC. Also explained are Transparent Application Failover (TAF) and monitoring and tuning Oracle10g RAC applications.

Grid architecture is Oracles strategy for high-end computing and RAC is the stepping stone into this arena. This book focuses on current technology including all valid RAC features up through Oracle Database 10g Release 2, with a primary focus on deploying it in a high-end grid environment. The book discusses this technology at length which users will find beneficial when researching, implementing or monitoring a RAC environment. The author covers workshop implementation of services and the dist ribution of workload across instances, with threshold definitions and the new load balancing algorithms. In addition it includes detailed discussions on ASM that complements the implementation of RAC in Oracle Grid strategy. The book also includes discussions on new Oracle Clusterware, its components and its integration with RAC. Oracle 10g RAC focuses on RAC-specific topics including ASM, operating system configuration, installation and configuration of RAC and much more. Coverage includes net work configuration for high availability, FAN, TAF, ONS, implementation of maximum availability architecture (MAA), EM Grid Control, AWR, ADDM and other performance-related tools. The author includes several scripts for performance tuning and implementation that the reader can use to configure a RAC environment either on a 2, 4, 8, 60 or 99 node configuration.

This textbook is not simply a study guide; it is written for individuals who have just a basic knowledge of databases and can be utilized in a course on this latest implementation of SQL from Oracle.

Time-tested information--Strategies come straight from an Oracle DBA who's worked in the trenches for the Quatar Government keeping systems online 24x7. 8i Coverage--Version 8i's web functionality makes working in 24x7 mode available to a wider spectrum of corporations. Specific discussions--Covers areas of database installation, configuration, and management of security, performance, and recoverability. Diagnostic and database monitoring scripts--Scripts can be deployed immediately to help DBAs achieve high-availability databases.

Oracle database administrators always have plenty on their plate. Oracle8i Administration and Management comes to the rescue with lots of guidance in creating and maintaining Oracle databases and keeping them running at top performance. This is the latest revision of the DBA guide that has previously covered Oracle7 and, more recently, Oracle8. This update adds full coverage of Oracle 8i and includes an integrated discussion of the new version's object-oriented additions to the popular SQL data base product. Author Michael R. Ault meticulously goes through the topics administrators care about most, presenting a detailed discussion of the underlying architectural details. By organizing chapters according to administrative functions, such as "Tuning Oracle Applications" and "Database Internals Tuning," Ault has created a text that is quite handy for on-the-spot reference. A number of useful appendices on the companion CD-ROM offer plenty of useful management tidbits, as well as all of t he code scripts used in the book and demonstration versions of management utilities.

Two members of the Oracle8i summary management development team explain how to design, implement, and administer data warehouses and data marts using the new Oracle8i database program. Dimension and fact tables, indexes, partitions, materialized views, and the Oracle discoverer, express, time series and enterprise manager are all discussed.

This book/CD-ROM shows how to use programming tools to bring databases to the Internet using the new integration between Java and Oracle. Coverage includes Oracle object-relational databases and the SQL language, Oracle PL/SQL and Java stored procedures, middleware, and Java components in the database. Material is written from a software developer's perspective, but will be of interest to application designers and system architects as well. Assumes background in Java and SQL. The CD-ROM contains sample code from the book for Linux/UNIX, Windows, and MacOS. Bonazzi develops performance monitoring tools for Java. Stokol is a Java trainer in the private sector. Oracle 8i and Java: From Client Server to E-Commerce

Whether you're studying for the Oracle 9i Fundamentals I exam or just need to take the New Features update exam, Oracle 9i Funamentals I Exam Cram 2 can help you get certified. This efficient guide follows the exam objectives clearly and concisely. New Features materials are also included in the book, as well as a full-customizable practice test engine on CD. Oracle 9i Fundamentals I Exam Cram 2 is your smartest way to get certified.

Maximize all of the enhanced capabilities of Oracle9i using the precise information presented in this convenient resource, officially authorized by Oracle Corporation. Inside, you'll find full details on all the new Oracle9i features, including database administration and management improvements, architecture changes, performance enhancements, security advancements, and high-availability innovations.

PL/SQL Server Pages is a technology introduced by Oracle for developing Web applications by using Oracle's PL/SQL language as a server-side scripting language. This book is written with the objective of allowing the student to learn development of database-driven Web applications through the utilization of SQL and PL/SQL languages for relational database processing. It provides a hands-on approach toward Web development. To facilitate development of PL/SQL Server Pages, NetObject Fusion Web auth oring software is adopted to supplement the HTML coding of a Web page. There are sample databases, numerous examples and tutorials in the book to explain the various concepts. Each chapter ends with Review Questions and Problem Solving Exercises. The book is written for college students and moves at a pace suitable for students.

Like the earlier versions, this manual is intended for beginners and is not a reference book. This manual covers basics and advanced topics of SQL covering Oracle 8i version. This book is a training manual where anyone can learn SQL. This book has lot of exercises and solutions at the end of each chapter.

Whether you're studying for the Oracle 9i SQL exam or just need to take the New Features update exam, Oracle 9i: SQL Exam Cram 2 can help you get certified. This efficient study guide follows the exam objectives clearly and concisely. New Features materials are also included in the book, as well as a full-customizable practice test engine on CD. Oracle 9i: SQL Exam Cram 2 is your smartest way to get certified.