T-SQL fundamentals

By:

Ben-Gan, Itzik

Material type: Text

TextPublication details: New Delhi PHI 2017Edition: 3rd EdDescription: xxiv, 430p. 23 cm ; PbkISBN:

978-8120352964

Subject(s):

SQL -Computer program language

DDC classification:

005.7585 BEN

Online resources:

Click here to access online

Summary: 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.

Tags from this library: No tags from this library for this title. Log in to add tags.

Holdings
Item type	Current library	Collection	Call number	Status	Date due	Barcode
Books	H.T. Parekh Library	GSB Collection	005.7585 BEN (Browse shelf(Opens below))	Available		B2351

Browsing H.T. Parekh Library shelves, Collection: GSB Collection Close shelf browser (Hides shelf browser)

Previous			No cover image available					Next
Previous	005.74 WHI Hadoop :	005.74068 OHI MongoDB and Python	005.7565 ALE Microsoft access data analysis	005.7585 BEN T-SQL fundamentals	005.8 CAL International IT governance: an executive guide to ISO 17799/ISO 27001	005.8 HAN Handbook on cyber security	005.8 PIR Threat forecasting : leveraging big data for predictive analysis	Next

Rs.595/-

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.

There are no comments on this title.

to post a comment.