We Need Diverse Ya Sale
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Visit our stores


    Recently Viewed clear list


    Original Essays | June 10, 2015

    Rob Hart: IMG The End of Apocalypse



    My plan here is to write about how New York City disappears out from under your feet. So I wanted to include a picture of Apocalypse Lounge, a bar... Continue »
    1. $10.47 Sale Trade Paper add to wish list

      New Yorked (Ash McKenna)

      Rob Hart 9781940610405

    spacer
Qualifying orders ship free.
$49.99
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Qty Store Section
1 Beaverton COMP- DATA SQL
1 Burnside Database- Applications
13 Local Warehouse Computer Languages- SQL
13 Remote Warehouse Computer Languages- SQL

Microsoft SQL Server 2012 T-SQL Fundamentals

by

Microsoft SQL Server 2012 T-SQL Fundamentals Cover

ISBN13: 9780735658141
ISBN10: 0735658145
All Product Details

 

Synopses & Reviews

Publisher Comments:

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

Synopsis:

Get started with the fundamentals of Transact-SQL and learn how to write efficient and powerful database queries. With this hands-on guide, youll gain a solid understanding of T-SQL and good programming practices through the right balance of conceptual and practical content. Learn the steps required to develop T-SQL code for retrieving and modifying data, with exercises to help you apply what youve learned—ideal for T-SQL programmers, DBAs, BI practitioners, report writers, analysts, and architects.

Discover how to:

  • Apply T-SQL fundamentals, create tables, and define data integrity
  • Understand logical query processing
  • Query multiple tables using joins and subqueries
  • Simplify code and improve maintainability with table expressions
  • Write code to insert, update, delete, and merge data
  • Go beyond the fundamentals with pivoting techniques and set grouping
  • Isolate inconsistent data and address deadlock and blocking scenarios

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.

What Our Readers Are Saying

Add a comment for a chance to win!
Average customer rating based on 1 comment:

SideTalk, August 25, 2012 (view all comments by SideTalk)
When you think Sql Server Book Online (BOL) is great, reading this book may change your opinion.
Even with "Fundamentals" title on it, this book will teach you more than just basic T-SQL.
Was this comment helpful? | Yes | No

Product Details

ISBN:
9780735658141
Author:
Ben Gan, Itzik
Publisher:
Microsoft Press
Author:
Ben-Gan, Itzik
Subject:
Programming Languages - SQL
Subject:
Computers-Reference - General
Subject:
Computer Languages-SQL
Subject:
database development;programming;querying;sql server;t-sql
Subject:
Database Management - General
Copyright:
Edition Description:
Trade Paper
Series:
Developer Reference
Publication Date:
20120731
Binding:
TRADE PAPER
Language:
English
Pages:
448
Dimensions:
9 x 7.38 in

Other books you might like

  1. The Kimball Group Reader:... New Trade Paper $56.95
  2. Building Integrated Business... New Trade Paper $50.00
  3. Visual Explanations
    Used Hardcover $19.95
  4. Show Me the Numbers: Designing... New Hardcover $45.00
  5. Microsoft SQL Server 2012 Master... New Trade Paper $50.00
  6. Beautiful Visualization: Looking at... Used Trade Paper $29.00

Related Subjects

Children's » General
Computers and Internet » Computer Languages » SQL
Computers and Internet » Computers Reference » General
Computers and Internet » Database » Applications
Computers and Internet » Database » SQL
Science and Mathematics » Mathematics » General

Microsoft SQL Server 2012 T-SQL Fundamentals New Trade Paper
0 stars - 0 reviews
$49.99 In Stock
Product details 448 pages Microsoft Press - English 9780735658141 Reviews:
"Synopsis" by ,

Get started with the fundamentals of Transact-SQL and learn how to write efficient and powerful database queries. With this hands-on guide, youll gain a solid understanding of T-SQL and good programming practices through the right balance of conceptual and practical content. Learn the steps required to develop T-SQL code for retrieving and modifying data, with exercises to help you apply what youve learned—ideal for T-SQL programmers, DBAs, BI practitioners, report writers, analysts, and architects.

Discover how to:

  • Apply T-SQL fundamentals, create tables, and define data integrity
  • Understand logical query processing
  • Query multiple tables using joins and subqueries
  • Simplify code and improve maintainability with table expressions
  • Write code to insert, update, delete, and merge data
  • Go beyond the fundamentals with pivoting techniques and set grouping
  • Isolate inconsistent data and address deadlock and blocking scenarios

spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.