Login       My Wishlist
  My Cart
$0.00 / 0 items
 
EMS Linux
Utilizing the Best Tools With Linux
 
International Access
Global Shipping Options Available
  Our Catalog   Microsoft Programming   SQL Server

T-SQL Fundamentals (3rd Edition)


Huge Savings Item! Save 18% on the T-SQL Fundamentals (3rd Edition) by Microsoft Press at EMS Linux. Hurry! Limited time offer. Offer valid only while supplies last. Effectively query and modify data using Transact-SQL Master T-SQL fundamentals and write robust code for Microsoft SQL Server and Azure SQL


Product Description

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

Additional Information

Manufacturer:Microsoft Press
Brand:Microsoft Press
Publisher:Microsoft Press
Studio:Microsoft Press
EAN:9781509302000
Item Weight:0 pounds
Item Size:1.1 x 8.9 x 8.9 inches
Package Weight:1.68 pounds
Package Size:7.24 x 1.02 x 1.02 inches

T-SQL Fundamentals (3rd Edition) by Microsoft Press

Buy Now:
T-SQL Fundamentals (3rd Edition)

Brand: Microsoft Press
4.7 out of 5 stars with 29 reviews
Condition: New
Lead Time: 1 - 2 Business Days
Availability: In Stock
$49.99
$41.07
You Save: 18%


Quantity:  

 


View More In SQL Server.

 


Have questions about this item, or would like to inquire about a custom or bulk order?


If you have any questions about this product by Microsoft Press, contact us by completing and submitting the form below. If you are looking for a specif part number, please include it with your message.

First Name:
Last Last:
Email Address:
Your Message:

Related Best Sellers


By Microsoft Press
mpn: 41781923, ean: 9780735698352, isbn: 073569835X,
This comprehensive and authoritative guide will teach you the DAX language for business intelligence, data modeling, and analytics. Leading Microsoft BI consultants Marco Russo and Alberto Ferrari help you master everything from table functions throu...



Privacy Policy / Terms of Service
© 2018 - emslinux.com. All Rights Reserved.