Book description
If you have never programmed with T-SQL but have some background programming knowledge and experience, Beginning T-SQL with Microsoft SQL Server 2005 and 2006 will provide you with an overview of SQL Server query operations and tools used with T-SQL, Microsoft's implementation of the SQL database query language. Review basic query language commands and syntax, learn how to design and build applications, and understand how to optimize query performance. Improve your skills with the most up-to-date T-SQL guide, which provides hands-on examples and instructions to guide you through the process.
Table of contents
- Copyright
- About the Authors
- Credits
- Acknowledgments
- Introduction
- 1. Introducing T-SQL and Data Management Systems
- 2. SQL Server Fundamentals
-
3. SQL Server Tools
- 3.1. Common SQL Server Tasks
-
3.2. SQL Server Management Studio
- 3.2.1. Tool Windows
-
3.2.2. Toolbars
- 3.2.2.1. Database Diagram Toolbar
- 3.2.2.2. Help Toolbar
- 3.2.2.3. Query Designer Toolbar
- 3.2.2.4. Source Control Toolbar
- 3.2.2.5. SQL Editor Toolbar
- 3.2.2.6. SQL Compact Edition Toolbar
- 3.2.2.7. SQL Server Analysis Services Editor Toolbar
- 3.2.2.8. Standard Toolbar
- 3.2.2.9. Table Designer Toolbar
- 3.2.2.10. Text Editor Toolbar
- 3.2.2.11. View Designer Toolbar
- 3.2.3. SQL Server Management Studio Configuration
- 3.3. SQL Server Business Intelligence Development Studio
- 3.4. SQL Server Profiler
- 3.5. Database Tuning Advisor
- 3.6. SQL Server Configuration Manager
- 3.7. Command-Line Tools
- 3.8. Writing Queries
- 3.9. Summary
- 3.10. Exercises
- 4. Introducing the T-SQL Language
- 5. Data Retrieval
-
6. SQL Functions
- 6.1. The Anatomy of a Function
- 6.2. Aggregate Functions
- 6.3. Configuration Variables
- 6.4. Conversion Functions
- 6.5. Cursor Functions and Variables
- 6.6. Date Functions
-
6.7. String Manipulation Functions
- 6.7.1. The ASCII(), CHAR(), UNICODE(), and NCHAR() Functions
- 6.7.2. The CHARINDEX() and PATINDEX() Functions
- 6.7.3. The LEN() Function
- 6.7.4. The LEFT() and RIGHT() Functions
- 6.7.5. The SUBSTRING() Function
- 6.7.6. The LOWER() and UPPER() Functions
- 6.7.7. The LTRIM() and RTRIM() Functions
- 6.7.8. The REPLACE() Function
- 6.7.9. The REPLICATE() and SPACE() Functions
- 6.7.10. The REVERSE() Function
- 6.7.11. The STUFF() Function
- 6.7.12. The QUOTENAME() Function
- 6.8. Mathematical Functions
- 6.9. Metadata Functions
- 6.10. Ranking Functions
- 6.11. Security Functions
- 6.12. System Functions and Variables
- 6.13. Global System Statistical Variables
- 6.14. Summary
- 6.15. Exercises
- 7. Aggregation and Grouping
-
8. Multi-Table Queries
- 8.1. Understanding Subqueries and Joins
- 8.2. Summary
- 8.3. Exercises
- 9. Advanced Queries and Scripting
-
10. Transactions
- 10.1. Introducing Transactions
-
10.2. Let's Do CRUD with Data
- 10.2.1. Adding Records
- 10.2.2. Modifying Records
- 10.2.3. Removing Records
- 10.2.4. Automating Inserts, Updates, and Deletes with the MERGE Command
- 10.3. Explicit Transactions
- 10.4. Summary
- 10.5. Exercises
- 11. Advanced Capabilities
-
12. T-SQL Programming Objects
- 12.1. Views
- 12.2. Stored Procedures
- 12.3. User-Defined Functions
- 12.4. Transaction Management
- 12.5. Summary
- 12.6. Exercises
-
13. Creating and Managing Database Objects
- 13.1. Data Definition Language
- 13.2. IF EXISTS
- 13.3. Securing Database Objects
- 13.4. Summary
- 13.5. Exercises
- 14. Analyzing and Optimizing Query Performance
-
15. T-SQL in Applications and Reporting
- 15.1. Application Programming Models
- 15.2. Selecting a Model
-
15.3. SQL Server 2008 Reporting Services
- 15.3.1. Reporting Services Architecture
-
15.3.2. SQL Server 2008 Report Design
- 15.3.2.1. Designing the Data Source and Dataset
- 15.3.2.2. Adding a Parameter to the Query
- 15.3.2.3. Adding a Parameter List Query
- 15.3.2.4. Designing the Report Layout
- 15.3.2.5. Adding Groups and Fields
- 15.3.2.6. Formatting a Number Field
- 15.3.2.7. Setting Up the Parameter Drop-Down List
- 15.3.2.8. Saving the Report
- 15.3.2.9. Adding Group Totals
- 15.3.3. Deploying the Report
- 15.3.4. Viewing the Report with Report Manager
- 15.3.5. Report Data Caching
- 15.3.6. Business Intelligence and Business Reporting
- 15.3.7. Report Application Integration
- 15.4. Summary
- A. Command Syntax Reference
-
B. System Variables and Functions Reference
- B.1. System Global Variables
-
B.2. System Functions
- B.2.1. Aggregation
- B.2.2. Checksum
- B.2.3. Conversion
- B.2.4. Cryptographic
- B.2.5. Cursor
- B.2.6. Date and Time
- B.2.7. Image/Text
- B.2.8. Error Handling
- B.2.9. Mathematical
- B.2.10. Metadata
- B.2.11. Ranking
- B.2.12. Rowset
- B.2.13. Security
- B.2.14. String Manipulation
- B.2.15. System
- B.2.16. System Statistical
-
C. System Stored Procedure Reference
- C.1. Active Directory
- C.2. Catalog
- C.3. Change Data Capture (2008)
- C.4. Cursor Management
- C.5. Database Engine
- C.6. Database Maintenance Plan
- C.7. Distributed Queries
- C.8. External Systems and Extended Procedures
- C.9. Full-Text Index/Search
- C.10. Log Shipping
- C.11. Database Mail
- C.12. OLE Automation
- C.13. SQL Server Profiler
- C.14. Security
- C.15. SQL Server Agent
- C.16. XML
-
D. Information Schema Views Reference
- D.1. CHECK_CONSTRAINTS
- D.2. COLUMN_DOMAIN_USAGE
- D.3. COLUMN_PRIVILEGES
- D.4. COLUMNS
- D.5. CONSTRAINT_COLUMN_USAGE
- D.6. CONSTRAINT_TABLE_USAGE
- D.7. DOMAIN_CONSTRAINTS
- D.8. DOMAINS
- D.9. KEY_COLUMN_USAGE
- D.10. PARAMETERS
- D.11. REFERENTIAL_CONSTRAINTS
- D.12. ROUTINE_COLUMNS
- D.13. ROUTINES
- D.14. SCHEMATA
- D.15. TABLE_CONSTRAINTS
- D.16. TABLE_PRIVILEGES
- D.17. TABLES
- D.18. VIEW_COLUMN_USAGE
- D.19. VIEW_TABLE_USAGE
- D.20. VIEWS
- E. FileStream Objects and Syntax
- F. Answers to Exercises
Product information
- Title: Beginning T-SQL with Microsoft® SQL Server® 2005 and 2008
- Author(s):
- Release date: December 2008
- Publisher(s): Wrox
- ISBN: 9780470257036
You might also like
book
Inside Microsoft® SQL Server® 2008: T-SQL Programming
Get a detailed look at the internal architecture of T-SQL with this comprehensive programming reference. Database …
book
Microsoft® SQL Server® 2008 T-SQL Fundamentals
Master the foundations of T-SQL with the right balance of conceptual and practical content. Get hands-on …
book
Programming Microsoft® SQL Server® 2012
Your essential guide to key programming features in Microsoft SQL Server 2012 Take your database programming …
book
Beginning Microsoft® SQL Server® 2012 Programming
Get up to speed on the extensive changes to the newest release of Microsoft SQL Server …