T-SQL Fundamentals, 3rd edition

Published by Microsoft Press (July 29, 2016) © 2017

  • Itzik Ben-Gan
Products list
$47.99
Buy nowOpens in a new tab
Sold by InformIT and ebook resellers
  • Available for purchase from all major ebook resellers, including InformIT.com
Products list
$39.99

Price Reduced From: $49.99

Details

  • A print text
  • Free shipping
  • Also available for purchase as an ebook from all major ebook resellers, including InformIT.com

Students will master the fundamentals of Transact-SQL—and develop their own code for querying and modifying data in Microsoft SQL Server 2016. Led by a SQL Server expert, readers learn the concepts behind T-SQL querying and programming, and then apply their knowledge with exercises in each chapter. Once students understand the logic behind T-SQL, they'll quickly learn how to write effective code.

Contents at a Glance

Introduction

CHAPTER 1 Background to T-SQL querying and programming 

CHAPTER 2 Single-table queries 

CHAPTER 3 Joins

CHAPTER 4 Subqueries

CHAPTER 5 Table expressions

CHAPTER 6 Set operators

CHAPTER 7 Beyond the fundamentals of querying

CHAPTER 8 Data modification

CHAPTER 9 Temporal tables

CHAPTER 10 Transactions and concurrency

CHAPTER 11 Programmable objects

Appendix: Getting started

Index

Need help? Get in touch