T-SQL Fundamentals

Autor Itzik Ben-Gan
en Limba Engleză Paperback – 4 aug 2016
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 2016. Led by a SQL Server expert, you ll learn the concepts behind T-SQL querying and programming, and then apply your knowledge with exercises in each chapter. Once you understand the logic behind T-SQL, you ll quickly learn how to write effective code whether you re a programmer or database administrator. Discover how to:
  • Work with programming practices unique to T-SQL
  • Create database tables and define data integrity
  • Query multiple tables using joins and subqueries
  • Simplify code and improve maintainability with table expressions
  • Implement insert, update, delete, and merge data modification strategies
  • Tackle advanced techniques such as window functions, pivoting and grouping sets
  • Control data consistency using isolation levels, and mitigate deadlocks and blocking
  • Take T-SQL to the next level with programmable objects
Citește tot Restrânge

Preț: 26060 lei

Preț vechi: 32575 lei

Puncte Express: 391

Preț estimativ în valută:
4991 5477$ 4319£


Livrare economică 18-23 decembrie
Livrare express 12-16 decembrie pentru 3502 lei

Preluare comenzi: 021 569.72.76


ISBN-13: 9781509302000
ISBN-10: 150930200X
Pagini: 512
Dimensiuni: 185 x 224 x 28 mm
Greutate: 0.87 kg
Editura: Microsoft Press

Notă biografică

TZIK BEN-GAN is a mentor with and co-founder of SolidQ. A Microsoft Data Platform MVP since 1999, Itzik has taught numerous training events around the world focused on T-SQL querying, query tuning, and programming. Itzik is the author of several books about T-SQL. He has written many articles for SQL Server Pro as well as articles and white papers for MSDN and The SolidQ Journal. Itzik's speaking engagements include Tech-Ed, SQL PASS, SQL Server Connections, presentations to various SQL Server user groups, and SolidQ events.

Itzik is a subject-matter expert within SolidQ for its T-SQL related activities. He authored SolidQ's Advanced T-SQL and T-SQL Fundamentals courses and delivers them regularly worldwide. You can learn more about Itzik at


Contents at a Glance

CHAPTER 1 Background to T-SQL querying and programming

CHAPTER 2 Single-table queries


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