Databases (Access, SQL Server ...) SQL SERVER 2005

 Microsoft SQL Server 2005: Applied Techniques Step by Step Book/CD Package

Published by: MICROSOFT PRESS
Author: Solid Quality Learning
Group: SQL SERVER 2005
ISBN: 0735623163
ISBN 13: 9780735623163
Number of pages: 348
User level: Intermediate/Advance
Objective: Tutorial Date Published: Jul 2006
 RRP £31.49 Save 35%
 Online Price £20.46

 Book Information

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
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

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