|
Samay Live | |
|
EBooks » Database
 One of
the driving forces that stimulated the emergence of database technology
was the need to guarantee the quality of the data stored. The software
design is impacted by the properties of the data. Data properties
should be seen from a point of view as independently as possible from
the representation model. In the database world, quality of data means
that all those properties are adequately represented and preserved.
Efficient maintenance of data integrity has become a critical problem
since testing the validity of a large number of constraints in a large
database, after each transaction is an expensive task. Geared toward
designers and professionals interested in the conceptual aspects of
integrity problems in different paradigms, Database Integrity: Challenges and Solutions successfully addresses these and a variety of other issues.Name: MCDBA, MCSE, MCSD, MCAD Training Guide (70-229): SQL Server 2000 Database Design and Implementation Author: Thomas Moore, Ed Tittel Format: Paperback Publisher: Que ISBN: 0789729970 Cover Price: $59.99 Front Page:   Designed in the highly regarded O'Reilly Cookbook format, ADO.NET Cookbook is strikingly different from other books on the subject. It isn't bogged down with pages of didactic theory. The ADO.NET Cookbook focuses exclusively on providing developers with easy-to-find coding solutions to real problems. ADO.NET Cookbook
is a comprehensive collection of over 150 solutions and best practices
for everyday dilemmas. For each problem addressed in the book, there's
a solution--a short, focused piece of code that programmers can insert
directly into their applications. And ADO.NET Cookbook is more than just a handy compilation of cut-and-paste C# and VB.NET code. ADO.NET Cookbook
offers clear explanations of how and why the code works, warns of
potential pitfalls, and directs you to sources of additional
information, so you can learn to adapt the problem-solving techniques
to different situations. This is a painless way for developers who
prefer to learn by doing to expand their skills and productivity, while
solving the pressing problems they face every day.  In Advanced Transact-SQL for SQL Server 2000,
authors Itzik Ben-Gan and Thomas Moreau explore the powerful
capabilities of Transact-SQL (T-SQL). Ben-Gan and Moreau offer
solutions to common problems encountered using all versions of SQL
Server, with a focus on the latest version, SQL Server 2000.
Expert
tips and real code examples teach advanced database programmers to
write more efficient and better-performing code that takes full
advantage of T-SQL. The authors offer practical solutions to the
everyday problems programmers face and include in-depth information on
advanced T-SQL topics such as joins, subqueries, stored procedures,
triggers, user-defined functions (UDFs), indexed views, cascading
actions, federated views, hierarchical structures, cursors, and more.  * With more than three million users, MySQL is the most popular open-source database server in the world, providing an extremely fast, reliable, and inexpensive alternative to commercial database management systems * Gives corporate users a complete guide to building enterprise-level database applications with MySQL * Covers the pros and cons of adopting MySQL and installing, testing, and configuring the MySQL server * Written by one of the lead programmers of the MySQL product and reviewed by Monty Widenius, the creator of MySQL * Companion Web site includes all code examples as well as links to useful online resources |
| |
|
