Master the fundamentals of Transact-SQL—and develop your own code for querying and modifying data in Microsoft SQL Server 2012. 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

About the Author

Itzik Ben-Gan is a principal mentor and a founder of SolidQ. A Microsoft MVP for SQL Server since 1999, Itzik teaches and consults internationally on T-SQL querying, programming, and query tuning. He has written numerous articles for SQL Server Magazine and MSDN, and speaks at industry events such as Microsoft TechEd, DevWeek, PASS, and SQL Server Connections.

"About this title" may belong to another edition of this title.

Store Description

About Us: Coas Books is New Mexico?s largest second-hand bookstore with more than 500,000 books in stock! We have an incredible selection of new and used books ? including regional and out-of-print books ?, CDs, DVDs, Vinyl, VHS, audio books, and games. Coas Books is family owned and operated, with two stores located in Las Cruces, New Mexico. We receive hundreds of books every day, so our inventory is constantly changing and full of hidden gems! Our History: Coas Books was founded in 1983 by archaeologist Pat Beckett. It started out as an archaeological publishing company specializing in anthropology books. As Pat's vast collection of books continued to grow, he purchased a local paperback exchange, and with that Coas Books was born. The name Coas has its roots in archaeology, coming from the Nahuatl term ?coa? ? meaning digging stick ?, and the acronym for "Center of Anthropological Studies". Today, Coas Books is run and operated by Mike and Veronica Beckett as they continue to proudly serve the community in the heart of Las Cruces.

Visit Seller's Storefront

Seller's business information

Coas Books, Inc.
317 N. Main, Las Cruces, NM, 88001, U.S.A.

Sale & Shipping Terms

Terms of Sale

We accept most major credit cards and Paypal. Coas Books, Inc. Las Cruces NM 88001
email coas@coasbooks.com (575)636-1371 Michael Beckett, President

Right of cancellation

Shipping Terms

100% Guarantee on all aspects of the order. We have happily made customer service our first priority for our 30-year history. All books are professionally wrapped and shipped within 1 business day. All orders within the United States also include delivery confirmation. Our hours are 9:00am-5:00pm Mon-Fri. (all times Mountain). All inquiries are answered within 1 business day.

Please call us (1-575-647-1435) if you have any questions or E-mail us: coas@coasbooks.com. Books are returnable within 7 days of receipt for exchange or refund.

Shipping rates from U.S.A. to United Kingdom

Shipping rates from U.S.A. to United Kingdom
Order quantity	21 to 42 business days	21 to 42 business days
First item	� 44.63	� 44.63

Delivery times are set by sellers and vary by carrier and location. Orders passing through Customs may face delays and buyers are responsible for any associated duties or fees. Sellers may contact you regarding additional charges to cover any increased costs to ship your items.