This book describes how you can use multiple databases and both Oracle8 and Oracle7 distributed system features to best advantage. It covers design, configuration of SQL*Net/Net8, security, and Oracle’s distributed options (advanced replication, snapshots, multi-master replication, updateable snapshots, procedural replication, and conflict resolution). Includes a complete API reference for built-in packages and a diskette with many helpful scripts and utilities.

Any organization that uses the Oracle relational database management system (RDBMS) these days needs to use multiple databases. In a distributed database environment, data in two or more databases is accessible as if it were in a single database. Usually, the different databases are on different servers, which may be located at the same site or a continent away. Communication between the servers takes place via SQL*Net (for Oracle7) or Net8 (for Oracle8).

This book describes how you can use multiple databases and the distributed features of Oracle to best advantage

This is the second edition of Kofler’s acclaimed MySQL book, updated and expanded to cover MySQL 4.0, the most recent production release of the popular Open Source database, which boasts more than four million users worldwide.
Like the first edition, this revision, which has been renamed as The Definitive Guide to MySQL, Second Edition to reflect the breadth and depth of Kofler’s coverage of the topic, provides a thorough introduction to the installation, configuration, implementation, and administration of MySQL. In addition, Kofler also demonstrates how MySQL can be used in conjunction with various other technologies to create database-driven Web sites, and gives practical advice on database design. Kofler also shows what’s coming up next in MySQL 4.1.
The Definitive Guide to MySQL, Second Edition, is an irreplaceable resource for MySQL novices and experts alike

See How To

• Create databases more efficiently using a new results-oriented interface
• Use tools for building a database that makes information easier to find and use
• Import data from other programs, HTML, XML files, and other databases
• Use forms, filters, queries, and reports to capture and analyze data
• Discover ways to prevent data corruption and unauthorized access
• Share your data with others through interactive web pages
• Put your newly acquired skills to work using the online workshops
• Organize information and add impact with clip art, SmartArt diagrams, tables, and charts
• Use Groove and SharePoint Team Services to collaborate and share documents and information
• Prepare for the Microsoft Certified Application Specialist (MCAS) exam

The second edition of the best-selling Inside Relational Databases is revised and updated to bring you the most reader-friendly explanation of the relational model and its importance to database designers and builders. Clear explanations make use of examples rather than equations to show you how an understanding of the relational model can make your databases faster, more flexible and thoroughly fit for their purpose.

Pro T-SQL 2005 Programmer’s Guide provides comprehensive and detailed coverage of all the major features and facilities of T-SQL for SQL Server 2005. It is designed for all users of T-SQL, database administrators, systems administrators, application developers, and end-users, who want to learn how to exploit the power of T-SQL. Whatever you need to do with T-SQL, you’ll find it described clearly here.

Stored procedures, triggers, and user-defined functions are only part of the story. Dynamic SQL, the new XML data type, and SQLCLR programming are also covered, as well as accessing SQL Server with ADO.NET. Exception handling and performance are fully covered, too. This book is truly a complete programmer’s guide to T-SQL and SQL Server 2005.

This book examines SQL Server 2005 T-SQL from a developer’s perspective. It covers a wide range of developer-specific topics in SQL Server 2005, from an introduction to new developer tools such as SQLCMD and SQL Server Management Studio to new T-SQL functionality such as the xml data type, XQuery support, and T-SQL encryption.