Ultimate T-SQL for SQL Server Professionals

Name: Ultimate T-SQL for SQL Server Professionals
Price: 68.54 AUD
Availability: OutOfStock
ISBN: 9789349887893

Alula Mekonnen Kassa

$80.95 $68.54

Paperback

Not in-store but you can order this
How long will it take?

Availability Information

We source books from suppliers in Australia and overseas. For books we don't currently have in stock, the time it takes to get them from our suppliers can vary widely - from a few days to a few months - so we check each book with each supplier to determine the expected time it will take to be supplied to us.

We will update you on expected arrival time to us. If this delay is too long, please let us know within 2 business days and we can give you options regarding cancelling or adjusting your order. More details on cancelling your order can be found in our Terms of Trade.

To find out the anticipated arrival time for specific items prior to ordering, please contact us by phone or email:

Phone +61 2 9264 3111, or 1800 4 BOOKS (1800 4 26657) if outside Sydney:
option 1 Abbey's Bookshop (Crime, History, Science, Kids & more) • info@abbeys.com.au
option 2 Language Book Centre (ESL & Foreign Languages) • language@abbeys.com.au
option 3 Galaxy Bookshop (Sci-fi, Fantasy, Romance, Graphic Novels) • sf@galaxybooks.com.au

QTY:

English

Orange Education Pvt Ltd
29 April 2026

Microsoft programming; Programming & scripting languages: general; Databases

Summary
Details

Unlock the Power of T-SQL for Efficient Data Management

Book Description

T-SQL is the backbone of Microsoft SQL Server, powering the queries, analytics, and enterprise systems that drive today's data-driven world. Ultimate T-SQL for SQL Server Professionals takes you on a complete learning journey-from foundational query writing to advanced performance tuning and enterprise-level database development.

You begin by building a strong core by understanding data types, mastering SELECT statements, filtering data with precision, and writing efficient joins and subqueries. From there, the book guides you into advanced territory-Common Table Expressions (CTEs), MERGE operations, PIVOT queries, dynamic SQL, and working with JSON and XML. You will learn how to analyze execution plans, leverage Query Store, and apply indexing and performance tuning strategies to optimize real-world workloads.

What you will learn

● Write efficient, production-ready T-SQL queries using advanced SELECT logic, joins, and subqueries.

● Develop and manage views, stored procedures, functions, triggers, and table-valued functions.

● Implement CTEs, MERGE, PIVOT, JSON, XML, and dynamic SQL for complex data transformations.

● Analyze execution plans and apply performance tuning and indexing strategies.

● Manage transactions, concurrency, and isolation levels in high-performance environments.

● Secure, automate, and test SQL Server solutions for scalable, enterprise-grade systems.

Table of Contents

1. Getting Started with T-SQL

2. Data Types, NULLs and Conversions

3. SELECT Statements and Filtering Logic

4. Joins, Set Operations, and Subqueries

5. Views, Functions, and Stored Procedures

6. CTEs, MERGE, Pivoting, JSON, and XML

7. Dynamic SQL, Triggers, and Table-Valued Functions (TVFs)

8. Query Optimization and Performance Tuning

9. Execution Plans and Query Store

10. Transactions, Concurrency, and Isolation Levels

11. Automation with SSIS, SQL Agent, and PowerShell

12. Azure SQL and Synapse Integration

13. Security, Permissions, and Auditing

14. Unit Testing T-SQL with tSQLt

15. Case Studies and the Future of T-SQL

16. Best Practices for T-SQL Development and Database Design

Index

By: Alula Mekonnen Kassa
Imprint: Orange Education Pvt Ltd
Dimensions: Height: 279mm, Width: 216mm, Spine: 25mm
Weight: 1.134kg
ISBN: 9789349887893
ISBN 10: 9349887894
Pages: 494
Publication Date: 29 April 2026
Audience: General/trade , ELT Advanced
Format: Paperback
Publisher's Status: Active