Tampilkan postingan dengan label database. Tampilkan semua postingan
Tampilkan postingan dengan label database. Tampilkan semua postingan

Sabtu, 31 Januari 2009

MCITP SQL Server 2005 Database Developer All in One Exam Guide


All-in-One is All You Need
Get complete coverage of all three Microsoft Certified IT Professional database developer exams for SQL Server 2005 in this comprehensive volume. Written by a SQL Server expert and MCITP, this definitive exam guide features learning objectives at the beginning of each chapter, exam tips, practice questions, and in-depth explanations. Detailed and authoritative, the book serves as both a complete certification study guide and an essential on-the-job reference.
Get full details on all exam topics including how to:
Install and configure SQL Server 2005
Manage database design
Use Transact-SQL and XML
Work with functions, triggers, and CLR integration
Optimize, monitor, and secure databases
Create stored procedures
Handle disaster recovery
Work with Service Broker, Web Services, and MARS.
Size : 23 Mb

http://rapidshare.com/files/165204622/MCITP.rar.html

Use SQL Server Reporting Services and Notification Services
Manage locks, deadlocks, and cursors
Transfer data using Replication and SQL Server Integration Services
The CD-ROM (not included) features:

Six full practice exams-two for each exam: 70-431, 70-441, & 70-442
Scripts from the step-by-step exercises in the book
Video training clips from the author
Complete electronic book

Jumat, 30 Januari 2009

Relational Database Design Clearly Explained 2nd Edition


Fully revised and updated, Relational Database Design, Second Edition is the most lucid and effective introduction to relational database design available. Here, you'll find the conceptual and practical information you need to develop a design that ensures data accuracy and user satisfaction while optimizing performance, regardless of your experience level or choice of DBMS.

Supporting the book's step-by-step instruction are three case studies illustrating the planning, analysis, and design steps involved in arriving at a sound design. These real-world examples include object-relational design techniques, which are addressed in greater detail in a new chapter devoted entirely to this timely subject.

* Concepts you need to master to put the book's practical instruction to work.
* Methods for tailoring your design to the environment in which the database will run and the uses to which it will be put.
* Design approaches that ensure data accuracy and consistency.
* Examples of how design can inhibit or boost database application performance.
* Object-relational design techniques, benefits, and examples.
* Instructions on how to choose and use a normalization technique.
* Guidelines for understanding and applying Codd's rules.
* Tools to implement a relational design using SQL.
* Techniques for using CASE tools for database design.

http://www.easy-share.com/1903432271/Relational_DB_Design_Clearly_Explained.rar