---

Beginning Transact-SQL With SQL Server 2000 and 2005

ISBN: 076457955X
EAN: 2147483647

Year: 2006
Pages: 131

Authors: Paul Turley

BUY ON AMAZON

• 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
• Exercises
• Chapter 14: Transact-SQL in Applications and Reporting
• Application Programming Models
• Selecting a Model
• SQL Server Reporting Services
• Summary
• Appendix A: Command Syntax Reference
• Transact-SQL Commands, Clauses, and Predicates
• Appendix B: System Variables and Functions Reference
• Appendix C: System Stored Procedure Reference
• Appendix D: Information Schema Views Reference
• Appendix E: Answers to Exercises
• Chapter 4 Exercises
• Chapter 5 Exercises
• Chapter 6 Exercises
• Chapter 7 Exercises
• Chapter 8 Exercises
• Chapter 9 Exercises
• Chapter 10 Exercises
• Chapter 12 Exercises
• Chapter 13 Exercises
• Index
• A
• B
• C
• D
• E
• F
• G
• H
• I
• J
• K
• L
• M
• N
• O
• P
• Q
• R
• S
• T
• U
• V
• W
• X
• Y
• Z
• List of Figures
• List of Tables
• List of Try It Outs