Start developing applications with Oracle PL/SQL-fast! This integrated book-and-Web learning solution teaches all the Oracle PL/SQL skills you need, hands on, through real-world labs, extensive examples, exercises, projects, and a complete Web-based training site. Oracle PL/SQL by Example, Third Edition covers Oracle 10G and all the fundamentals: Master PL/SQL syntax, iterative and conditional control, scoping, anchored datatypes, cursors, triggers, security, tables, procedures, functions, packa ges and Oracle-supplied packages-plus powerful new techniques for working with exceptions, cursors, collections, and records. Your free Web-based training module includes a Virtual Study Lounge where you can interact with other learners, work on new projects, and get updates! Totally integrated with a FREE, state-of-the-art Oracle 10G learning Web site! Every Prentice Hall Oracle Interactive Workbook is fully integrated with its own exclusive Web site, giving you all this and more.

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.

Effectively create and manage complex databases with Oracle! Systems and database expert Kevin Owens explores PL/SQL, Oracle's answer to the Structured Query Language (SQL), and teaches you what you need to know to build robust and complex databases for your business. Using easy-to-follow instructions and examples, this book presents techniques to take advantage of Oracle features such as triggers and stored procedures-features that allow your databases to incorporate business rules which are e asy to manage and modify as the business evolves.

This 9x6 syntax reference for database administrators explains concepts of backup and recovery and how the Oracle tools work to support those concepts, then presents commands, tables, and flow charts for the Export, Import, and Oracle Data Pump utilities of Oracle 10g; describes the RMAN procedures used to perform everyday tasks that Oracle DBA needs; and offers a reference to the RMAN of Oracle 10g, showing the syntax and options for each command.

Start developing applications with Oracle PL/SQL-fast! This integrated book-and-Web learning solution teaches all the Oracle PL/SQL skills you need, hands on, through real-world labs, extensive examples, exercises, projects, and a complete Web-based training site. Oracle PL/SQL by Example, Third Edition covers Oracle 10G and all the fundamentals: Master PL/SQL syntax, iterative and conditional control, scoping, anchored datatypes, cursors, triggers, security, tables, procedures, functions

Gives background in Oracle's implementation of the SQL language. Each chapter is divided into labs, with objectives, examples, and exercises on specific tasks and questions that are designed to help readers discover important aspects of the SQL language. Exercises build knowledge step by step by introducing relational database concepts, the SQL*Plus environment, and the SQL language. Labs also include explained answers, multiple-choice review questions, and critical thinking questions.

Using a series of labs with examples and exercises, this guide introduces how to write programs in PL/SQL with discussion of syntax and structured programming, iterative control, scoping and anchored databases, cursors, triggers, security, tables, and packaging and parameter passing techniques. Integrated book-and-Web learning solution teaches all of the Oracle PL/SQL skills you need, through hands-on, real-world labs, exercises, projects, and the Web-based training site.

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 is the first complete guide to building Web applications with Oracle Portal 3.0 for Windows NT/2000 and Linux. Oracle Portal specialist Mohamed El-Mallah covers the entire development lifecycle, from product installation through configuration, capacity planning, development, integration, deployment, and administration. Through a start-to-finish case study, El-Mallah introduces every key concept and technique Oracle Web developers and Oracle9i Application Server administrators need to master . Complete lifecycle coverage: planning, development, deployment, and administration. Installation, tuning, and troubleshooting O9iAS/Portal on Windows and Unix. Building Portlets, PL/SQL and Java providers, even advanced PDK programming. Integrating Forms, Reports, interMedia Text, LDAP OiD, Dynamic Services, and supporting SSL in Oracle9iAS Portal. Includes the complete export of the demo application and the source code on CD-ROM. The book demo application is live on the Web.

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

A guide for Oracle developers and database administrators, covering every aspect of Oracle 8/8i SQL and PL/SQL tuning, with specific recommendations, detailed case studies, and real benchmarks. Coverage includes designing applications to maximize efficiency, building indexes, identifying and resolving Oracle Server bottlenecks, fixing poorly performed SQL code, and leveraging Oracle's parallel query facility.

A step-by-step guide to the forms of Oracle 6i, from debugging and coding to project management and object-oriented analysis and design. Shows how to build GUIs that deliver breakthrough ease of use, create integrated Developer/2000 applications, and access the full power of Windows and other support programs. Oracle Forms is the most important tool used to create client/server and World Wide Web applications that run against Oracle databases. Oracle Forms Developer's Handbook is a complete refe rence guide for those who use Forms to build sophisticated database systems rapidly and productively. The book covers in detail all the aspects, features, and functionality of Oracle Forms.

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 Oracle DBA Interactive Workbook presents an introduction to Oracle database administration in a unique and highly effective format. It is organized more like a teaching aid than a reference manual in that to learn basic administration techniques, you are challenged to work through a set of guided tasks rather than to read through descriptions. There is a list of additional reading material in Appendix B that you can reference if you wish to delve deeper into any of the topics covered in this book. This book is intended for beginners in the world of Oracle database administration. It will take you through a set of tasks, starting with creating a database to using some of the Oracle database tuning, and backup and recovery utilities. Those experienced with Oracle databases will recognize that a workbook covering the topic of database administration will be an extremely useful introduction for the beginner, but it cannot be used as a deep study of the Oracle database environment. Aft er working through this book, you will have been launched into the exciting and interesting (sometimes nerve-racking) world of database administration, but it will take years of experience to become a senior database administrator. This book is intended for anyone who needs a quick and detailed introduction to Oracle database administration tasks. It is not the intention of this book to provide an in-depth study of the Oracle database server. The foundation for this book was developed to supplem ent the Introduction to Oracle Database Administration class in the Database Track at Columbia University's Computer Technology and Applications (CTA) program in New York City. The book's sidebars and answers often reflect questions that students have asked in class.

This video course contains three-and-a-half hours of QuickTime video instruction plus the Oracle Interactive Workbook e-Book. Caffrey and Scherer (database development and management, Columbia U. School of Continuing Education) present 17 video lectures that cover all key aspects of day-to-day Oracle database administration including creating new datasets; managing physical database layouts; administering users, privileges, and resource groups; tuning Oracle and SQL code for maximum performance; security, auditing, and data integrity; logical and practical backup and recovery; auditing; rollback segments; and other topics.

This video course contains three-and-a-half hours of QuickTime video instruction together with the Oracle PL/SQL Interactive Workbook e-Book. Silvestrova, Rosenzweig and Scherer (database development and management, Columbia U. School of Continuing Education) present 16 video lectures that cover Oracle PL/SQL techniques and concepts including syntax, structured programming, and iterative control; scoping and anchored datatypes; exception handling; scoping, cursors, packaged code, and triggers; a dvanced topics such as stored code, package and parameter passing, and more.

This video course contains four-and-a-half hours of QuickTime video instruction as well as the Oracle Forms Interactive Workbook e-Book that integrates the tutorials with hands-on practical exercises, self-review questions, and real-world labs. The 13 video lectures cover topics including Oracle Forms development environment, form builder, reusable objects and code, triggers and built-ins, LOVs and alerts, canvases and windows, multiple form applications, and integration with Oracle reports. Req uires a basic understanding of the Oracle 7/8/8i database, SQL, PL/SQL, and database design. Prepared by Rosenzweig (consultant for Oracle Corporation) and Motivala (former Oracle Tools employee and Forms instructor.

The purpose of this book is to share my experiences in the areas of UNIX and Oracle performance and tuning. The chapters of this book provide a tremendous level of detail on the internal workings of the Oracle and UNIX kernels. The purpose of including so much detail is to give the reader a complete understanding of Oracle and UNIX. It is this understanding that will enable the reader to apply these concepts to specific applications and/or user environments, thus enabling the reader to maximize the performance of his or her environment. It is a key characteristic of this book that only the latest versions of Oracle and UNIX are discussed, such as Oracle8i and Solaris 8. This will enable the reader to focus on the functionality and enhancements of the new versions, avoiding discussion of old releases. Another characteristic of this book is that I have organized it into two major areas: data warehousing and Online Transaction Processing (OLTP). This edition of the book places more of an emphasis on application tuning since the application has the most control over the overall performance and scalability. It is important that the application be well designed and highly optimized. Recommended prerequisites for this book are a basic understanding of SQL, UNIX shell language, and experience with UNIX system and Oracle database administration.

Gives background in Oracle's implementation of the SQL language. Each chapter is divided into labs, with objectives, examples, and exercises on specific tasks and questions that are designed to help readers discover important aspects of the SQL language. Exercises build knowledge step by step by introducing relational database concepts, the SQL*Plus environment, and the SQL language. Labs also include explained answers, multiple-choice review questions, and critical thinking questions. Morrison works in Internet development. Rischert is co-chair of Columbia University's Database Application Development and Design track at the Computer Technology and Application Program.

The Oracle Forms Interactive Workbook presents Oracle Forms in a unique and highly effective format. It challenges you to learn Oracle Forms by using it rather than by simply reading about it. Just as a grammar workbook would teach you about nouns and verbs by first showing you examples and then asking you to write sentences, the Oracle Forms workbook teaches you about Forms, triggers, and items by first showing you examples and then asking you to create these objects yourself. This book is inte nded for anyone who needs a quick but detailed introduction to building applications with Oracle Forms. The ideal readers are those with some experience with relational databases, specifically Oracle, but little or no experience with Oracle Forms or application development.

The Oracle PL/SQL Interactive Workbook presents the Oracle PL/SQL programming language in a unique and highly effective format. It challenges you to learn Oracle PL/SQL by using it rather than by simply reading about it. Just as a grammar workbook would teach you about nouns and verbs by first showing you examples and then asking you to write sentences, the Oracle PL/SQL workbook teaches you about cursors, procedures, and triggers by first showing you examples, and then asking you to create thes e objects yourself. Is For This book is intended for anyone who needs a quick but detailed introduction to programming with Oracle's PL/SQL language. The ideal readers are those with some experience with relational databases, with some Oracle experience, specifically with SQL and SQL*Plus, but with little or no experience with PL/SQL, or with most other programming languages.

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.

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.

Outlines standards for system development and sets naming conventions for logical and physical objects as well as for data and process elements, and documents recommended conventions for use with the primary diagramming tools found in Oracle Designer. Conventions are presented for the business process modeler, and the function hierarchy, entity relationship and server model diagrammers. The CD-ROM contains a standards document template in Word.

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.

A book/disk package presenting principles of data modeling, GUI design, and coding with SQL and PL/SQL within the context of Oracle's tools, and covering forms, reports, graphics, and tools such as Terminal and Procedure Builder. Appendices list forms object properties, and built-ins for each tool and those common to all Developer/2000 tools. The accompanying disk contains examples from the book, and a shareware version of Barclock. For applications developers with a working knowledge of SQL and relational databases. A tutorial and reference to make up for the lack of hard-copy documentation accompanying the software package itself. Provides step- by-step instructions for every component, including forms, reports, graphics, data modeling, and design tools. Also offers information on Oracle's Web architecture, tuning applications for optimal performance, building graphical user interfaces, and avoiding pitfalls and traps. The CD-ROM contains Developer/2000 sample code plus a full traini ng module.

Written for database administrators, this text covers architecture, installation, tuning, security, networking, and the basics of application development with PL/SQL. Addressing the fundamental enhancements that have been made to Oracle7, this title covers installation of Oracle8 on the Windows NT platform. The CD-ROM contains a trial version of DBAWare, a database performance and analysis tool from MenloSoftware.

Oracle Senior Performance Engineer Ahmed Alomari covers virtually every relevant optimization technique in Oracle8, Oracle7, and three leading versions of UNIX: Solaris 2.6, HP-UX 11, and Sequent Dynix-ptx 4.4. He presents in-depth coverage of both OLTP and DSS applications, covering optimization of the UNIX kernel, memory, processors and I/O, and all these major Oracle8 performance enhancements.

This kit includes three books: Oracle SQL highperformance tuning, Oracle database administration on UNIX systems, and Oracle and UNIX performance tuning. Three CD ROMs included. The complete professional's resource for building, managing, and optimizing Oracle databases! Oracle DBA Reference Library is an unparalleled practical resource for DBAs, database programmers, IT managers, and anyone who needs to make the most of Oracle database technology. It's three comprehensive, up-to-date books by w orld-class Oracle professionals, plus three CD-ROMs packed with tools and information, all for one great price!

A book/CD-ROM for new and experienced database administrators and managers, reviewing Oracle database architecture and offering step-by- step instructions for planning, sizing, and installing Oracle systems, focusing UNIX-specific configuration and tuning issues. Other topics include security, backup and recovery, and application development. The accompanying CD-ROM contains a multimedia installation and configuration tutorial, readable with any Web browser. Oracle is the leading enterprise data base management system, and more Oracle databases are deployed on UNIX systems than any other platform. There is no introduction to database administration that focuses exclusively on the UNIX platform--this book fills that critical void. The CD-ROM includes a multimedia tutorial on installing and configuring the Oracle server.

A book/CD-ROM package on tuning both current Oracle releases and the underlying Solaris, HP-UX, or Sequent Dynix systems they run on, and on optimizing both OLTP and OLAP decision support systems. Presents a systematic approach to tuning Oracle databases based on UNIX, reviews UNIX kernal-related issues, and introduces techniques for tuning memory, processors, and I/O. Also covers optimizing SQL code. The companion CD-ROM contains tuning tools. Assumes basic understanding of SQL, UNIX shell lang uage, and database administration.

A guide to using Oracle's parallel query facility for large volume queries focusing on SQL and PL/SQL. Harrison, an Oracle developer and consultant, overviews SQL processing and introduces guidelines to improve applications, including execution plans, work with joins, nulls and ranges search, index building, hierarchical queries, table scans, GROUP BY, updates, and distributed SQL. The accompanying CD- ROM features a set of tools for detecting and correcting SQL bottlenecks.

2001-2011 Oracle-Books.com