Home Page Icon
Home Page
Table of Contents for
Title Page
Close
Title Page
by Dan Wood, Paul Turley
Beginning Transact-SQL with SQL Server 2000 and 2005
Cover Page
Title Page
Copyright
About the Authors
Credits
Dedication
Contents
Acknowledgments
Foreword
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
2: SQL Server Fundamentals
Who Uses SQL Server?
SQL Server Editions and Features
Semantics
Normalization Rules
Applying Normalization Rules
Client/Server Processes
The Mechanics of Query Processing
The Adventure Works Cycles Database
Summary
3: Tools for Accessing SQL Server
Tools for SQL Server 2000
Tools for SQL Server 2005
Summary
Exercises
4: Introducing Transact-SQL Language
The Nature of SQL
Where to Begin
Data Manipulation Language (DML)
Data Definition Language
Data Control Language
Summary
Exercises
5: Data Retrieval
Storage and Retrieval
The SELECT Statement
Summary
Exercises
6: SQL Functions
The Anatomy of a Function
Aggregate Functions
Configuration Variables
Conversion Functions
Summary
Exercises
7: Aggregation and Grouping
Using Aggregate Functions
Understanding Statistical Functions
Grouping Data
Summary
Exercises
8: Multi-Table Queries
Understanding Subqueries and Joins
Summary
Exercises
9: Data Transactions
Introducing Transactions
Let's Do CRUD with Data
Explicit Transactions
Summary
Exercises
10: Advanced Queries and Scripting
Subqueries
Cursors
Summary
Exercises
11: Full-Text Index Queries
Microsoft Search Service
Managing and Populating Catalogs
Summary
12: Creating and Managing Database Objects
Data Definition Language
Securing Database Objects
Summary
Exercises
13: Transact-SQL Programming Objects
Views
Stored Procedures
User-Defined Functions
Transaction Management
Summary
Exercises
14: Transact-SQL in Applications and Reporting
Application Programming Models
Selecting a Model
SQL Server Reporting Services
Summary
A: Command Syntax Reference
Transact-SQL Commands, Clauses, and Predicates
B: System Variables and Functions Reference
System Global Variables
C: System Stored Procedure Reference
D: Information Schema Views Reference
E: Answers to Exercises
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
Cover Page
Next
Next Chapter
Copyright
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset