Cantitate/Preț
Produs
Total produse
Vezi coșul
T-SQL Fundamentals de Itzik Ben-Gan

T-SQL Fundamentals

Autor Itzik Ben-Gan
en Limba Engleză Paperback – 3 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

Toate formatele și edițiile

Toate formatele și edițiile Preț Express
Paperback (2) 23536 lei  3-5 săpt. +5060 lei  6-12 zile
  Pearson Education (US) – 8 iun 2023 23536 lei  3-5 săpt. +5060 lei  6-12 zile
  Microsoft Press – 3 aug 2016 25171 lei  3-5 săpt. +3758 lei  6-12 zile

Preț: 25171 lei

Preț vechi: 31464 lei
-20% Nou

Puncte Express: 378
Preț estimativ în valută:
4454€ • 5223$ • 3912£

Carte disponibilă

Livrare economică 23 ianuarie-06 februarie
Livrare express 08-14 ianuarie pentru 4757 lei

 Adaugă în coș

Wish list
Gift list
Am citit!
Adaugă în listă
Preluare comenzi: 021 569.72.76

Specificații

ISBN-13: 9781509302000
ISBN-10: 150930200X
Pagini: 464
Dimensiuni: 187 x 229 x 25 mm
Greutate: 0.82 kg
Ediția:3. Auflage
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 http://tsql.solidq.com/.

Cuprins

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