|
Books > Computing & IT > Computer software packages > Database software
|
Buy Now
T-SQL Fundamentals (Paperback, 3rd edition)
Loot Price: R853
Discovery Miles 8 530
You Save: R204
(19%)
|
|
|
T-SQL Fundamentals (Paperback, 3rd edition)
Series: Developer Reference
Expected to ship within 10 - 15 working days
|
Effectively query and modify data using Transact-SQL Master T-SQL
fundamentals and write robust code for Microsoft SQL Server and
Azure SQL Database. Itzik Ben-Gan explains key T-SQL concepts and
helps you apply your knowledge with hands-on exercises. The book
first introduces T-SQL's roots and underlying logic. Next, it walks
you through core topics such as single-table queries, joins,
subqueries, table expressions, and set operators. Then the book
covers more-advanced data-query topics such as window functions,
pivoting, and grouping sets. The book also explains how to modify
data, work with temporal tables, and handle transactions, and
provides an overview of programmable objects. Microsoft Data
Platform MVP Itzik Ben-Gan shows you how to: Review core SQL
concepts and its mathematical roots Create tables and enforce data
integrity Perform effective single-table queries by using the
SELECT statement Query multiple tables by using joins, subqueries,
table expressions, and set operators Use advanced query techniques
such as window functions, pivoting, and grouping sets Insert,
update, delete, and merge data Use transactions in a concurrent
environment Get started with programmable objects-from variables
and batches to user-defined functions, stored procedures, triggers,
and dynamic SQL
General
Is the information for this product incomplete, wrong or inappropriate?
Let us know about it.
Does this product have an incorrect or missing image?
Send us a new image.
Is this product missing categories?
Add more categories.
Review This Product
No reviews yet - be the first to create one!
|
You might also like..
|
Email address subscribed successfully.
A activation email has been sent to you.
Please click the link in that email to activate your subscription.
Welcome to Loot.co.za!
Sign in / Register |Wishlists & Gift Vouchers |Help | Advanced search
