Microsoft SQL Server 2008: Основы T-SQL

by Itzik Ben-Gan, Ицик Бен-Ган

В книге изложены теоретические основы формирования запросов и программирования на языке T-SQL: однотабличные запросы, соединения, подзапросы, табличные выражения, операции над множествами, реорганизация данных и наборы группирования. Описываются различные аспекты извлечения и модификации данных, обсуждаются параллелизм и транзакции, приводится обзор программируемых объектов. Для дополнения теории практическими навыками в книгу включены упражнения, в том числе и повышенной сложности.

Genres: Reference, Programming

432 pages, Paperback

First published October 21, 2008

About the author

Itzik Ben-Gan is a Mentor and Co-Founder of SolidQ. A SQL Server Microsoft MVP (Most Valuable Professional) since 1999, Itzik has delivered numerous training events around the world focused on T-SQL Querying, Query Tuning and Programming. Itzik is the author of several books including Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions and Microsoft SQL Server 2012 T-SQL Fundamentals. He has written articles for SQL Server Pro, SolidQ Journal and MSDN. Itzik's speaking activities include TechEd, SQLPASS, SQLU, SQLTeach and various user groups around the world. Itzik is the author of SolidQ's Advanced T-SQL Querying, Programming and Tuning and T-SQL Fundamentals courses along with being a primary resource within the company for their T-SQL related activities.

Itzik Ben-Gan is a co-founder of Solid Quality Mentors, a technical education company, and is a Microsoft SQL Server MVP.

Reviews

[Marcus · Rating 5 out of 5]

I use SQL on daily basis, but my official training in this technology is a bit dated. I selected this book for a private refresher course and it turned out to be exactly what I was looking for. Lot of information in this volume was already familiar to me, but a lot of blanks were also filled. Furthermore, I also learned a lot of new stuff specific to SQL Server 2005/2008.

[Mark · Rating 2 out of 5]

Good for what it needed to be for me: a refresher on SQL.

[Volodymyr · Rating 4 out of 5]

Good introductory book to T-SQL, some advanced topics are revealed in other books, like "inside t-sql querying"