Learn the essentials of using Oracle8i on a network.

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

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

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

A concise, comprehensive study guide to the core SAP BW certification exam

The SAP Business Information Warehouse (SAP BW) is the data warehousing solution developed by SAP AG for SAP-centric data warehouses. Professionals seeking to become SAP BW application consultants need to pass the SAP BW certification exam in order to prove that they have a fundamental knowledge of this particular area of the SAP system, as well as to demonstrate that they are able to apply this knowledge within a project environment. SAP BW Certification: A Business Information Warehouse Study Guide provides candidates with the training and information they need in order to achieve certification.

SAP BW Certification begins with critical background information on Enterprise Resource Planning systems (ERP), software packages that integrate the entire flow of information throughout an organization, of which SAP is the market leader. The book then covers how SAP BW relates to SAP as a whole and discusses fundamental SAP BW functions such as data modeling, reporting, and extraction. Features of this Study Guide include:

• An introduction to the BW certification exam
• An overview of the exam’s topics, including such features as "On the Exam," "Optimization Tips," "Note," "Restrictions," "Unique to SAP," and "New to SAP"
• Exercises that can be performed with a small test-BW server
• Practice test questions and answers that assess the reader’s knowledge of current exam topics
• A complete simulated certification exam

SAP BW practitioners who are preparing for the SAP BW certification exam, or for the SAP BW delta (recertification) exam, will find SAP BW Certification the premier study guide on the market today.

"Advanced SQL:1999 - Understanding Object-Relational and Other Advanced Features" is the practitioner's handbook to the standard's advanced features. It is not a re-presentation of the standard, but rather an authoritative, in-depth guide to its practical application. Like its companion, "SQL:1999 - Understanding Relational Language Components," which explained the standard's basic features, this book will show you how to make your applications both effective and standard-compliant.

This handy reference has a modular format so you can explore specific topics with ease. It is equally useful to those upgrading from earlier versions of SQL and those with no previous experience. Written by the standard's distinguished editor, "Advanced SQL:1999" will complete your knowledge and support your skills like no other book can.
* Focuses entirely on the issues that matter to programmers who are connecting applications to databases.
* Details SQL:1999's object facilities, including structured user-defined types, typed tables, user-defined routines, and routine invocation.
* Examines facilities new to SQL, including those relating to on-line analytical processing (OLAP), management of external data (SQL/MED), and Java support.
* Covers the ongoing development of XML support.
* Includes appendices that cover the SQL:1999 annexes, a SQL:1999 example using UDTs, status codes, and useful information on the standardization process.

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

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

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

Now you can make exciting digital movies using this easy-to-use and information-packed resource. Covering all editing basics, as well as serious film-making techniques, you will be able to successfully apply visual effects and control sound with pinpoint accuracy-- and deliver digital stories you never thought possible.

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

Small, special-purpose computing devices and high-end core Internet servers need fast, reliable database management. Berkeley DB is an embedded database that provides high-performance, scalable, transaction-protected and recoverable data management services to applications. Extremely portable, this library runs under almost all UNIX and Windows variants, as well as a number of embedded, real-time operating systems.

Berkeley DB is the ultimate resource for the world's most widely deployed embedded database engine. This book will aid software architects and engineers, product managers, and systems and network administrators without the overhead imposed by other database products.

Designed by programmers for programmers, this classic library style toolkit provides a broad base of functionality to application writers. This book will help you to make intelligent choices about when and how to use Berkeley DB to meet your needs.

You can visit the Sleepycat website to get the latest errata for this book.

NOTE: The first printing of this book contained an error in the table of contents that caused the page numbers to be off. This will be corrected in the second printing. If you have an earlier edition, you can download a pdf of the correct table of contents that you can print out and use with your book. If you have any questions, please feel free to contact the editor of this book at [email protected].

Essential Skills for First-Time Developers

Discover the easiest way to construct Web-based applications and interactive Web sites with help from this instructive guide. "ColdFusion 5: A Beginner's Guide uses a proven learning method to give even total beginners profound and useful insights into the world of programming. Cover server setup and administration, learn programming fundamentals and specifics of the ColdFusion language, then follow examples and tutorials designed to help you build and deploy your own dynamic Web site--including incorporating data from ODBC Databases, such as Access or SQL Server. Whether you're new to programming, or brushing up on ColdFusion techniques, this potent learning tool will help you meet your goals.

This Beginner's Guide is Designed for Easy Learning: Modules--Each concept is divided into logical modules (chapters), ideal for individualized learning Goals--Each module opens with the specific skills you'll have by the end of the module Ask the Experts--Q&A sections throughout are filled with extra information and interesting commentary 1-Minute Drills--Quick self-assessment sections to check your progress Annotated Syntax--Example code annotated with commentary that points to the particular technique illustrated Projects--Exercises contained in each module show how to apply what you are learning Mastery Checks--End-of-module reviews that test your knowledge using short-answer, multiple-choice, fill-in-the-blank, and simple coding questions

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

Best Practices from Oracle Experts

Find Undocumented, Expert Advice Inside

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

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

From the official Oracle Press comes a comprehensive guide to tuning SQL statements for optimal execution. This expert resource explains how to view the internal execution plan of any SQL statement and change it to improve the performance of the statement. Youll get details on Oracles optimizer modes, SQL extensions, the STATSPACK utility, and a wealth of methods for tuning Oracle SQL statements.

Don't Let the Real Test Be Your First Test!

Practice Makes Perfect--Score Higher With The Most Effective Self-Test & Quick Review Program

More Questions--More ContentBased on Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition Exam (70-228) Coverage features quick review of all technology objectives and realistic exam questions to build your knowledge Exclusive "Exam Watch" features point out the most frequently missed questions--and how to answer them correctly

Enterprise systems supporting business processes in large companies and organizations, are critical for their business survival, and expensive to build and run. This book describes successful approaches to designing, and tuning for performance, large enterprise systems. In contrast to earlier mainframes, the modern distributed systems contain large numbers of components and simple capacity planning methods, applicable to mainframes, cannot be used for design or tuning of complex distributed systems. Methods that have proven to be successful are based on building predictive models that take into account key characteristics of hardware, software, data and communications.

Your Professional Resource for Developing with ColdFusion 5

Master ColdFusion--the premier environment for developing flexible, powerful Web applications--with the authoritative information in this professional-level resource. From installing and optimizing your development operating system, to mastering advanced practices like advanced application security and using Web Distributed Data Exchange (WDDX), "ColdFusion 5 Developer's Guide delivers the accurate, thorough instruction required to design and deploy a wide range of useful Web applications. ColdFusion developer and e-commerce guru Michael Buffington will help you discover--and master--the tools you'll need to excel in ColdFusion Web application development.Properly serve ColdFusion applications Deploy applications using development methods and code standards Get the most from conventions, adaptations, and portable code Work easily within all major operating systems and server platforms Develop ColdFusion applications using variables, forms, and imported tools Plan, design, administer, and monitor databases Understand Third Normal Form and other database structures Master security and automation techniques Prevent lost data, orphaning, and corruption Transfer platform-independent data with WDDX

Secure and enhance network performance with ISA Server 2000 Administration.

The Ultimate Resource for Developing Error-Free SQL Operations

Create a functional debugging environment to develop Structured Query Language solutions efficiently and troubleshoot SQL statements effectively. Use best practices to help perform maintenance, and to find and fix bugs when they do occur. Explore and familiarize yourself with SQL programming problems, learn to write code that's portable across databases, and realize efficiencies by expressing data in a variety of types. Develop the skills you need to debug SQL, and learn to move deftly and creatively around almost every limitation that SQL imposes on your operating environment.Write trouble-free SQL statements and procedures Optimize SQL statements and avoid problem areas Join and aggregate data and other SQL Select statements Debug and use practical regions and sequences Use and debug arrays, sets, and graphs Understand tree structures and hierarchies Secure data and protect response time Examine the appropriate use of data types Select, insert, update, and delete data using SQL syntax Recognize and mitigate fatal and logical errors Format SQL for single queries or extensive procedures using best practices

This text has been written for the new and experienced OneWorld professionals who need to use and get the most from the Object Management Workbench (OMW). It provides the fundamentals and details behind the business and technical information about OMW, alongside practical advice and special sections containing proven tips and recommendations for successful usage of OMW.

Microsoft's flagship ISA Server delivers the Internet to your customers
As the demand for Internet connectivity reaches a fever pitch, system administrators are being challenged to connect more and more systems to the Internet without compromising security or network performance. ISA Server 2000 provides system administrators with a revolutionary management infrastructure that addresses the two greatest needs of Enterprise-wide Internet connectivity: Security and speed.
Written by best-selling author of several MCSE 2000 study guides, this book will provide the system administrators with an in depth understanding of all the critiacl features of Microsoft's flag ship Internet Server. Configuring ISA Server 2000 shows network administrators how to connect a network to the Internet, maintain the connection, and troubleshoot remote users' hardware and software configuration problems.
* Up-to-date coverage of new products specific to Windows 2000
* Shows network administrators how to supply e-mail whilst maintaining network security
* Focuses on providing secure remote access to a network

Design, deploy, and manage stored procedures in enterprise data applications

SQL Server 2000 Stored Procedure Programming shows you how to use Transact-SQL to design, debug, and manage custom stored procedures, functions, and triggers. You'll learn to manage SQL Server resources using new features of Enterprise Manager, Query analyzer, Visual Basic, and Visual Studio, implement robust error handling, and establish the professional habits you need to become an expert SQL Server developer. This guide contains simple explanations for developers who are just starting to work with stored procedures and advanced recommendations and techniques for experienced DBAs. SQL Server stored procedures and advanced recommendations and techniques for experienced DBAs. SQL Server experts provide concise explanations, design recommendations, many examples, and a real-world case study.Design user-defined, system, temporary, global temporary, extended, remote, and nested stored proceduresAdopt tips and tricks using identity, timestamp, sql_variant, uniqueidentifier, optimistic locking, dynamically constructed queries, temporary tables, and cursorsWrite code to interact with COM, mai, executables, the Registry, jobs, and securityManage application securityLocate and fix semantic errors using TSQL Debugger in Query Analyzer, Visual Basic, or Visual Studio, and using manual debugging techniquesCreate user-defined, table-valued, and in-line functionsDesign instead-of triggers and after triggersManage transactions and locksDevelop dynamic, Web-based applications using SQL Server's XML capabilities

The ultimate beginning-to-end guide for SQL developers building Web-enabled database applications. Contains data tools to help make building Web applications easier for developers. Includes coverage of security issues and building N-tier Web solutions, an important topic in web development today.

This book shows PeopleSoft developers and administrators how to integrate PeopleSoft ERP systems with third party software.

The definitive book on Oracle's Rdb database.
Written by a team of bestselling database experts, including a principal product architect, this is unquestionably the definitive book on Oracle's Rdb8, the latest version of the powerful database for advanced enterprise applications. Rdb: A Comprehensive Guide, Third Edition teaches administrators, programmers, database designers and IT managers the critical components and functions of the new version 8 and explains how to develop powerful Rdb8 programs. The book specifically addresses new Rdb8 management, tuning and scalability tools and describes the new Rdb/NT Workbench for Windows NT. No other source gives readers the authoritative and timely information provided by Rdb: A Comprehensive Guide, Third Edition.

Only book on Rdb8
Written by Rdb8 experts from Oracle, including the principal product architect
Explains how to use Rdb8 on both Windows NT and OpenVMS

Understanding dBASE5 for Windows is a good tutor for anyone interested in the new Windows version.

From this systematic and comprehensive book, you can learn the basics and features of dBASE as well as the advanced techniques that will make you an expert.

The book presents the basic concepts of using a database, and instructs you to build sophisticated database systems step by step. It is full of valuable tips, tricks and timesaving techniques.