All orders are dispatched within one working day from our UK warehouse. We've been selling books online since 2004! We have over 750,000 books in stock. No quibble refund if not completely satisfied.

N� de ref. del art�culo mon0006040311

Contactar al vendedor

Denunciar este art�culo

Detalles bibliogr�ficos

T�tulo: T-SQL Fundamentals
Editor: Microsoft Press
Fecha de publicaci�n: 2016
Idioma: Ingl�s
ISBN 10: 150930200X
ISBN 13: 9781509302000
Encuadernaci�n: Paperback
Edici�n: 3� Edici�n
Estado: Good

Acerca de

Sinopsis

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

Acerca del autor

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/.

"Sobre este t�tulo" puede pertenecer a otra edici�n de este libro.

Descripci�n de la librer�a

We are a family run online bookshop based in Wales at the western edge of the Brecon Beacons National park and have been selling books online since October 2004. I have always had a love of books and it eventually got to the stage where my own book collection began to take over the family home! I reluctantly decided to sell a few of my own books on Amazon and was astonished at how quickly they sold. I was hooked and decided to start buying and selling books as a small part-time business from my spare bedroom. The business rapidly expanded, taking over the spare bedroom and my garage, swiftly followed by a spare bedroom in my mother's house and her garage! I acquired a small industrial unit in February 2007 and took the plunge to go full-time in March 2007, closely followed by my wife in September 2007. In October 2007 we moved in to larger premises and also took on our first members of staff to assist with the ever increasing workload. Our aim is to ensure that the people who buy our books enjoy the same service that we would hope for when purchasing a book ourselves. To that end, we endeavour to give all our books accurate descriptions, price them accordingly and dispatch swiftly and safely. All orders are dispatched within one working day, Monday to Friday. We will endeavour to answer all queries by email within 24 hours.

Ver la p�gina web de la librer�a

Informaci�n empresarial del vendedor

Goldstone Books
Castle House, High Street, Ammanford, SA18 2NB, United Kingdom

Condiciones de venta y env�o

Condiciones de venta

Goldstone Books Limited
Cilyrychen Industrial Estate, Llandybie, Carmarthenshire, SA18 3GY.
Email: customerservices@goldstonebooks.co.uk - Phone: 01269 267070
Company registration number: 06817864. VAT registration number: 920299721
Managing Director: Ashley Stamford-Plows

Condiciones de env�o

All orders are shipped within 1 working day. We offer a no quibble returns service. If you would like to return your item for any reason please email us in the first instance within 7 days of receipt. If there is a fault with your item that is not described in the listing, you may return your item for a refund within 30 days of purchase. All returns must be returned in their original packaging.