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