Table of contents for SQL server 2005 bible / Paul Nielsen.

Bibliographic record and links to related information available from the Library of Congress catalog.

Note: Contents data are machine generated based on pre-publication provided by the publisher. Contents may have variations from the printed book or be incomplete or contain other coding.


Counter
Contents
SQL SERVER 2005 BIBLE by Paul Nielsen
TOC
Introduction
I
Laying the Foundation
1
The Information Architecture Principle
2
Relational Database Modeling
3
Exploring SQL Server Architecture
4
Installing SQL Server 2005
5
Client Software Connectivity
6
Using Management Studio
II
Manipulating Data with Select
7
Understanding Basic Query Flow
8
Using Expressions and Scalar Functions
9
Merging Data with Joins and Unions
10
Including Subqueries and CTEs
11
Aggregating Data
12
Navigating Hierarchial Data
13
Using Full Text Search
14
Selecting Data through Views
15
Working with Distributed Queries
16
Modifying Data
III
Developing with SQL Server
17
Creating the Physical Database Schema
18
Programming with T-SQL
19
Performing Bulk Operations
20
Kill the Cursor!
21
Developing Stored Procedures
22
Building User-Defined Functions
23
Creating DML Triggers
24
Exploring Advanced T-SQL Techniques
25
Hardening the Database with a Data Abstraction Layer
26
Developing for SQL Server Mobile
27
Programming CLR Assemblies within SQL Server
28
Queueing with Service Broker
29
Persisting Custom Data Types 
30
Programming with ADO.Net 2.0
31
Using XML, Xpath and Xquery
32
Building an SOA Data Store with Web Services
33
INfoPath and SQL Server 2005
IV
Enterprise Data Management
34
Configuring SQL Server 
35
Transferring Databases
36
Recovery Planning
37
Maintaining the Database
38
Automating Database Maintenance with SQL Server Agent
39
Replicating Data
40
Securing Databases
41
Administering SQL Server Express
V
Business Intelligence
42
ETL with Integration Services
43
Business Intelligence with Analysis Services
44
Data Mining with Analysis Services
45
Programming MDX Queries
46
Authoring Reports with Reporting Services
47
Administering Reporting Services
48
Analyzing Data with Excel & Data Analyzer
VI
Optimization Strategies
49
Measuring Performance
50
Query Analysis and Index Tuning 
51
Managing Transactions, Locking, and Blocking
52
Providing High Availability
53
Scaling Very Large Databases
54
Designing High Performance Data Access Providers
VII
Appendices
AppA
SQL Server Specs
AppB
Sample Databases

Library of Congress Subject Headings for this publication:

SQL server.
Client/server computing.
Database management.