Special Edition Using SQL Server

by Bob Branchek, Peter Hazlehurst, Stephen Wynkoop, Scott L. Warner

Table of Contents

Welcome!

Introduction

Detailed Table of Contents

• Part I: Understanding SQL Server Fundamentals and Background Information
• 01 - Introducing Microsoft SQL Server
• 02 - Data Modeling and Database Design
• 03 - Understanding the Underlying Operating System Windows NT
• Part II: Defining and Manipulating Data and Data Storage Units
• 04 - Creating Devices, Databases, and Transaction Logs
• 05 - Creating Database Tables and Using Datatypes
• 06 - Retrieving Data with Transact-SQL
• 07 - Performing Operations on Tables
• 08 - Using Functions
• Part III: Defining Retrieval Structures
• 09 - Managing and Using Views
• 10 - Using and Managing Indexes and Keys
• 11 - Managing and Using Rules and Defaults
• Part IV: Defining and Using Advanced Data Definition and Retrieval Structures
• 12 - Understanding Transactions and Locking
• 13 - Managing Stored Procedures and Using Flow Control Statements
• 14 - Creating and Managing Triggers
• 15 - Creating and Using Cursors
• Part V: Performing Administrative Operations
• 16 - Understanding Server, Database, and Query Options
• 17 - Optimizing Performance
• 18 - SQL Server Administration
• 19 - SQL Server Security
• 20 - Setting up & Managing Replication
• 21 - Communicating with SQL Server
• 22 - Accessing SQL Server Databases Through Front-End Products
• Appendix A - Installing and Setup of the Client and Server Software
• Appendix B - Using the Web Page Wizard
• Appendix C - Using SQL Trace
• Appendix D - Redundant Arrays Of Inexpensive Drives (RAID)
• Appendix E - Case Study: New York Metropolitan Museum of Art
• Appendix F - What's on the CD?