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
Learning Python Networking - Second Edition
Achieve improved network programmability and automation by leveraging powerful network programming concepts, algorithms, and tools Key …
book
T-SQL Fundamentals, Third Edition
Effectively query and modify data using Transact-SQL Master T-SQL fundamentals and write robust code for Microsoft …
book
SQL Server 2017 Administration Inside Out, First Edition
Conquer SQL Server 2017 administration—from the inside out Dive into SQL Server 2017 administration—and really put …
book
Professional Microsoft SQL Server 2014 Administration
Learn to take advantage of the opportunities offered by SQL Server 2014 Microsoft's SQL Server 2014 …