|
Microsoft SQL Server 2005: Applied Techniques Step by Step
Learn more-advanced skills to design, build, test, deploy, and maintain SQL Server databases - one step at a time. Ideal for developers who understand database essentials, this learn-by-doing tutorial offers practical guidance, code samples, and a collection of techniques to help you solve real-world business problems. Discover how to: *Manage data
access with server logins and user and server roles *Implement a disaster recovery strategy *Use aggregate functions to compute totals and complex statistical values *Optimize query performance by managing IO statistics and designing indexes *Work with remote data sources - including third-party databases *Provide remote access through the Internet or a middle-tier service interface *Manage transactions, implement error handlers, and define isolation levels *Go further and work with SQL Server Reporting Services and Notification Services Includes a CD featuring: *All practice exercises *Code samples
FEATURES:
Discover how to:
*Manage data access with server logins and user and server roles
*Implement a disaster recovery strategy
*Use aggregate functions to compute totals and complex statistical values
*Optimize query performance by managing IO statistics and designing indexes
*Work with remote data sources - including third-party databases
*Provide remote access through the Internet or a middle-tier service interface
*Manage transactions, implement error handlers, and define isolation levels
*Go further and work with SQL Server Reporting Services and Notification Services
Includes a CD featuring:
*All practice exercises
*Code samples
CONTENTS:
Part 1 - How to create a SQL Server Database to store your application data
1 - Choosing which Application Data to store in your Database
2 - Basic Database Security Principles
3 - Disaster Recovery Techniques to protect your Database
4 - Transferrinfyour Database to other systems
Part 2 - How to Query Data from SQL Server
5 - Computing Aggregates
6 - Improving Query Performance
7 - Building Queries Dynamically
8 - Working with Data from Remote Data Sources
9 - Reading SQL Server Data from the Internet
Part 3 - How to Modify Data in SQL Server
10 - Using Transactions to provide Safe Database Concurrency
11 - Keeping History Data
12 - Introduction to Reporting Services
13 - Introduction to Notification Services
Index
|
