Table of contents for SQL Server 2005 for developers / Robert Ericsson and Jason Cline.

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
 
Table of Contents
Chapter 1
	What is SQL Server
SQL Server History
	What is in this book
		Chapter 2 ¿ Database Design
		Chapter 3 ¿ Database Security
		Chapter 4 ¿ Transact SQL
		Chapter 5 - Programmability
		Chapter 6 ¿ ADO.NET
		Chapter 7 ¿ Notification Services
		Chapter 8 ¿ XML in SQL Server 2005
		Chapter 9 ¿ Service Broker
		Chapter 10 ¿ Performance Analysis and Tuning
		Chapter 11 ¿ Business Intelligence
		Chapter 12 ¿ Data Warehousing
		Chapter 13 ¿ SQL Server Integration Services
		Chapter 14 ¿ SQL Server Reporting Services
		Chapter 15 - OLAP
		Chapter 16 ¿ Data Mining
Chapter 2 Database Design
	Design Meaningful Tables
	Design Separate Columns for Independently Accessed Data
	Each Cell Holds Only One Piece of Data
	Every Table Needs a Primary Key
	Tables Related with Foreign Keys
	Avoid Redundant Data
	Minimize Empty Cells
	First Normal Form 
	Second Normal Form
	Third Normal Form
	Identify Database Requirements
	Identify Entities
	Assign Attributes to Entities
	Refine
	
Chapter 3 ¿ Database Security
	Access Control
	Security Analysis
	SQL Server Security Design Principles
	SQL Server 2005 Security Model
	SQL Server 2005 Security Features
	Authentication Modes
	Encryption
	User and Schema Separation
	Execution Context
	Signed Modules
	Password Policy Enforcement
	Row-level Security
	Granular Permissions
	Catalog Security
	SQL Server 2005 Security Best Practices
Chapter 4 ¿ Transact-SQL for Developers
	Syntax Elements
	Additional Transact-SQL Language Enhancements 
Chapter 5 ¿ Programmability
	Assemblies
	User-Defined Types
	Stored Procedures
	User-Defined Functions
	Triggers
	Aggregates
Chapter 6 ¿ ADO.NET 2.0
	New ADO.NET 2.0 Features
	Multiple Active Result Sets (MARS)
	User Defined Types
	Bulk Copy
	Batching
	Paging
	Large Data Types
	Schema Discovery 
	Statistics
	Client Failover
	Dependencies
	Change Password on Connect
	Conclusion
Chapter 7 ¿ Notification Services
	Introducing Notifications
	Notification Applications 
	Notification Services Architecture
	Subscription Management
	Event Collection
	File System Event Provider 
	SQL Server Event Provider
	Analysis Services Event Provider
	Custom Event Provider
	Notification Formatting
	Notification Delivery
	Building a Notification Application
	Instance Configuration File
	Application Definition File
	Event Definition
	Subscription Definition
	Notification Definition
	Provider Definition
	Generator Definition
	Distributor Definition
	Deployment 
	Adding Subscription Data
	Generating an Event
	Management and Operations
	Administration
	Updating an Instance or Application
	Removing an Instance
	Summary
Chapter 8 ¿ XML in SQL Server 2005
	XML Basics
	Native Storage for XML
	XML Data Type 
	Validation Checks
 Methods on XML Data Type
	XML Index
	XML Query 
	XQuery Language
	XPath Expressions
	FLOWR Statement
	XML Data Modification Language
	insert
	delete
	replace value of
	XML Schema Support
	User Defined Schemas 
	Schema Management
	Using Schemas with XML Data
	SQL Server Native Web Services
	Conclusion
Chapter 9 ¿ Service Broker
	Asynchronous Queuing 
	Message Ordering and Coordination
	Transactions
	Multi-Threading and Multi-Reader Queues
	Message Fragmentation
	Load Distribution
	Programming Model
	Message Types
	Contracts	
	Queues
	Services
	Dialog Conversations
	Routes
	Service Broker Security
	Dialog Security
	Transport Security
	Conclusion
Chapter 10 ¿ Performance Analysis and Tuning
	A Journey Not a Destination
	Performance Factors 
		Hardware
		Storage System
		Network System
		Memory
		Processor
	SQL Server Configuration
		Quantity of data
		Database and Query Design
	Tools 
		System Monitor (PerfMon)
		Dynamic Management Views
		SQL Server Profiler
		Database Tuning Advisor
	Conclusion
Chapter 11 ¿ Business Intelligence
	Challenges
		Functional orientation
		No single version of the truth
		Usage levels are low
		Poor data quality
		Solution is too static 
		Costly operations
		Lack business context 
	Providing Value
		Operate on business processes
		Drive analysis to decision makers
		Encourage usage
		Meaningful ownership
		
	
		Support change
		Reduce workloads
	Delivering value
		Linkage of solutions to strategies 
		Consolidate infrastructure and data 
		Establish relevancy
		Provide appropriate analysis tools
		Share the Results
		Enable Action
	SQL Server 2005 Business Intelligence Features
		Extract, Transform and Load
		Relational Data Warehouse
		Multidimensional Database
		Reporting
		Data Mining
		Metadata Repository
		Database Design Tools
		Database Management Tools
		Data Quality Tools
		Portals
	Conclusion
		
Chapter 12 - Data Warehouse
	Top-down vs. Bottom-up
		Hybrid Approach
	Data warehouse vs. transactional systems
	Performance Impact
	Different Uptime Requirements
		Operational Data Store
	Dimensional modeling
		Star Schema
		Slowly Changing Dimensions
		Shared Dimensions
		Sizing of a Data Warehouse
	Extraction, transformation and loading
		Metadata
		Data preparation and cleansing
		Loading Data
	Conclusion
Chapter 13 ¿ SQL Server Integration Services
	DTS Packages
	Containers
	Workflow
	Event Handlers
	Data Flow
		
	Variables
	Expressions
	Logging
	SQL Server Import/Export Wizard
	Designer
	Conclusion
Chapter 14 ¿ SQL Server Reporting Services
	Reporting 
	Report Design
	Reporting Services Architecture
		Web Services
		URL Access
		.NET API
		Report Definition Language
	Conclusion
	
Chapter 15 ¿ OLAP
	Introduction to Analysis Services
	OLAP Basics
	The Unified Dimensional Model
	Analysis Services Architecture
		Analysis Services Server
		OLE DB for OLAP
		ADMOD.NET
		AMO
		XML for Analysis
	MDX
	MDX Scripts
	Example
	Conclusion
Chapter 16 ¿ Introduction to Data Mining in SSAS 2005
	
	Data Mining Fundamentals
		Data Mining and OLAP
		Data Mining and Statistical Analysis
		Data Mining Goals
		Algorithms
		SSAS 2005 Data Mining Architecture
	Data management
	Mining models
		Data Mining Structures
		A Data Mining Process
		Example
Conclusion
References
	

Library of Congress Subject Headings for this publication:

SQL server.
Client/server computing.
Relational databases.