T SQL Fundamentals

Students will master the fundamentals of Transact-SQL--and develop their own code for querying and modifying data in Microsoft SQL Server 2016.

Author: Itzik Ben-Gan

Publisher: Microsoft Press

ISBN: 150930200X

Category: Computers

Page: 464

View: 989

Download →

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 "

Related Books

T-SQL Fundamentals
Language: en
Pages: 464
Authors: Itzik Ben-Gan
Categories: Computers
Type: BOOK - Published: 2016-08-13 - Publisher: Microsoft Press

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
Microsoft SQL Server 2012 T-SQL Fundamentals
Language: en
Pages: 448
Authors: Itzik Ben-Gan
Categories: Computers
Type: BOOK - Published: 2012-07-15 - Publisher: Pearson Education

Gain a solid understanding of T-SQL—and write better queries Master the fundamentals of Transact-SQL—and develop your own code for querying and modifying data in Microsoft SQL Server 2012. Led by a SQL Server expert, you’ll learn the concepts behind T-SQL querying and programming, and then apply your knowledge with exercises
T-SQL Window Functions
Language: en
Pages: 352
Authors: Itzik Ben-Gan
Categories: Client/server computing
Type: BOOK - Published: 2019-11-04 - Publisher: Microsoft Press

"Most T-SQL developers recognize the value of window functions for data analysis calculations. But they can do far more, and recent optimizations make them even more powerful. In T-SQL Window Functions, renowned T-SQL expert Itzik Ben-Gan introduces breakthrough techniques for using them to handle many common T-SQL querying tasks with
Microsoft Sql Server 2008 T-Sql Fundamentals
Language: en
Pages:
Authors: Itzik Ben-Gan
Categories: Client/server computing
Type: BOOK - Published: 2005* - Publisher:

Learn T-SQL, write better code and queries, and extend your SQL Server knowledge Master the foundations of T-SQL with the right balance of conceptual and practical content. Get hands-on guidance including exercises and code samples that show you how to develop code to query and modify data. You ll gain
Exam Ref 70-761 Querying Data with Transact-SQL
Language: en
Pages: 352
Authors: Itzik Ben-Gan
Categories: Computers
Type: BOOK - Published: 2017-04-04 - Publisher: Microsoft Press

Prepare for Microsoft Exam 70-761–and help demonstrate your real-world mastery of SQL Server 2016 Transact-SQL data management, queries, and database programming. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSA level. Focus on the