SQL Server 2005 From Beginner to Master -(Applied Technology Basics)

Author: SolidQualityLearning
Publisher:
Publish Date: 2006-09-01
Features: SQL Server 2005 is Microsoft's next-generation data management and analysis solution, providing enhanced scalability, availability, and security for enterprise-level data and analytical applications. Focusing on SQL Server 2005, this book improves readers' skills in designing, testing, deploying, and maintaining SQL Server databases through a step-by-step, easy-to-learn approach. The book consists of 13 chapters, introducing how to create SQL Server databases to store application data, how to query data using SQL Server, and how to modify data in SQL Server. The explanations are thorough, and with the help of exercises, readers can master SQL Server application techniques. It is an ideal reference book for beginners and intermediate users, suitable for database application and development personnel. For developers with a basic understanding of databases, this hands-on tutorial provides practical guidelines, sample code, and a wealth of technical solutions to help readers quickly master efficient techniques for designing, testing, deploying, and maintaining SQL Server databases.
Key Features:
· ★ Manage data access using server logins and user/server roles
· Implement a disaster recovery strategy
· Use aggregate functions to calculate sums and complex statistics
· Optimize query performance by managing I/O statistics and designing indexes
· Use remote data sources—including third-party databases
· Provide remote access via the Internet or middle-tier service interfaces
· Manage transactions, implement error handlers, and define isolation levels
· Explore SQL Server Reporting Services and Notification Services
All exercises and sample code can be downloaded from www.tup.com.cn or www.wenyuan.com.cn.
SQL Server 2005 is Microsoft's next-generation data management and analysis solution, providing enhanced scalability, availability, and security for enterprise-level data and analytical applications. Focusing on SQL Server 2005...