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 programmer or database administrator.

Key Features:-

  • Work with programming practices unique to T-SQL
  • Create database tables and define data integrity
  • Query multiple tables using joins and sub queries
  • 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

More Details about Microsoft Sql Server 2012 T-Sql Fundamentals

General Information  
Author(s)Itzik Ben Gan
PublisherJohn Wiley
Publish YearJanuary 2012