Beginning Transact-SQL With SQL Server 2000 and 2005
Beginning Transact-SQL With SQL Server 2000 and 2005
ISBN: 076457955X
EAN: 2147483647
EAN: 2147483647
Year: 2006
Pages: 131
Pages: 131
Authors: Paul Turley
- 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
Beginning Transact-SQL With SQL Server 2000 and 2005
ISBN: 076457955X
EAN: 2147483647
EAN: 2147483647
Year: 2006
Pages: 131
Pages: 131
Authors: Paul Turley