Beginning Transact-SQL With SQL Server 2000 and 2005 - page 1
- 1
- 2
- Table of Contents
- Table of Contents
- Back Cover
- Beginning Transact-SQL with SQL Server 2000 and 2005
- Foreword
- Chapter 1: Introducing Transact-SQL and Data Management Systems
- Transact-Structured Query Language
- SQL Server as a Relational Database Management System
- SQL Server and Other Products
- Summary
- Chapter 2: SQL Server Fundamentals
- Who Uses SQL Server?
- SQL Server Editions and Features
- Semantics
- Normalization Rules
- Applying Normalization Rules
- ClientServer Processes
- The Mechanics of Query Processing
- The Adventure Works Cycles Database
- Summary
- Chapter 3: Tools for Accessing SQL Server
- Tools for SQL Server 2000
- Tools for SQL Server 2005
- Summary
- Exercises
- Chapter 4: Introducing Transact-SQL Language
- The Nature of SQL
- Where to Begin
- Data Manipulation Language (DML)
- Data Definition Language
- Data Control Language
- Summary
- Exercises
- Chapter 5: Data Retrieval
- The SELECT Statement
- Summary
- Exercises
- Chapter 6: SQL Functions
- The Anatomy of a Function
- Aggregate Functions
- Configuration Variables
- Conversion Functions
- Summary
- Exercises
- Chapter 7: Aggregation and Grouping
- Using Aggregate Functions
- Understanding Statistical Functions
- Grouping Data
- Summary
- Exercises
- Chapter 8: Multi-Table Queries
- Understanding Subqueries and Joins
- Summary
- Exercises
- Chapter 9: Data Transactions
- Introducing Transactions
- Let s Do CRUD with Data
- Explicit Transactions
- Summary
- Exercises
- Chapter 10: Advanced Queries and Scripting
- Subqueries
- Cursors
- Summary
- Exercises
- Chapter 11: Full-Text Index Queries
- Microsoft Search Ser vice
- Managing and Populating Catalogs
- Summary
- Chapter 12: Creating and Managing Database Objects
- Data Definition Language
- Securing Database Objects
- Summary
- Exercise
- Chapter 13: Transact-SQL Programming Objects
- Views
- Stored Procedures
- User-Defined Functions
- Transaction Management
- Summary
- 1
- 2
