T-SQL Fundamentals

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

Get the book

Amazon.com

Search the book

eBay.com

Search the book

Other editions

• 

  T-SQL Fundamentals

  • 2016
  • - pages
  • Paperback
  • Microsoft Press

Similar books

• 

  T-SQL Querying

  By Adam Machanic, Dejan Sarka, Itzik Ben-Gan

  Write faster, more efficient T-SQL code: Move from procedural programming to the language of sets and logic Master an efficient top-down tuning methodology Assess algorithmic complexity to predict performance Compare data aggregation ...

• 

  Microsoft SQL Server 2012 T-SQL Fundamentals

  By Itzik Ben-Gan

  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.

• 

  T-SQL Window Functions: For data analysis and beyond

  By Itzik Ben-Gan

  Microsoft MVP Itzik Ben-Gan shows how to: • Use window functions to improve queries you previously built with predicates • Master essential SQL windowing concepts, and efficiently design window functions • Effectively utilize ...

• 

  Exam Ref 70-761 Querying Data with Transact-SQL

  By Itzik Ben-Gan

  Focus on the expertise measured by these objectives: • Filter, sort, join, aggregate, and modify data • Use subqueries, table expressions, grouping sets, and pivoting • Query temporal and non-relational data, and output XML or JSON ...

• 

  Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions

  By Itzik Ben-Gan

  Ideal whether you’re a database administrator or developer, this practical guide demonstrates ways to use more than a dozen T-SQL querying solutions to address common business tasks.

• 

  Learn T-SQL Querying: A guide to developing efficient and elegant T-SQL code

  By Pedro Lopes, Pam Lahoud

  This book will be a useful guide to learning the art of writing efficient T-SQL code in modern SQL Server versions, as well as the Azure SQL Database.

• 

  Microsoft SQL Server 2008 T-SQL Fundamentals

  By Itzik Ben-Gan

  Master the foundations of T-SQL with the right balance of conceptual and practical content.

• 

  Inside Microsoft SQL Server 2008: T-SQL Querying

  By Itzik Ben-Gan

  Tackle the toughest set-based querying and query tuning problems--guided by an author team with in-depth, inside knowledge of T-SQL. Deepen your understanding of architecture and internals--and gain practical approaches and...

• 

  SQL Fundamentals

  By John J. Patrick

  A comprehensive tutorial covering the fundamental concepts and ideas of SQL, and showing how these are implemented in both Oracle 9I and Access 2000 databases. John Patrick discusses how to...

• 

  Learn T-SQL From Scratch: An Easy-to-Follow Guide for Designing, Developing, and Deploying Databases in the SQL Server and Writing T-SQL...

  By Brahmanand Shukla

  DESCRIPTION This book will teach you the fundamentals of SQL, SQL Server, databases, and how to write queries and programs using T-SQL. After reading this book, you will be able to create, modify, and delete databases, tables, and indexes.