Microsoft SQL Server 2008 T-SQL Fundamentals
- ISBN-10
- 0735638128
- ISBN-13
- 9780735638129
- Category
- Computers
- Pages
- 416
- Language
- English
- Published
- 2008-10-22
- Publisher
- Microsoft Press
- Author
- Itzik Ben-Gan
Description
Master the foundations of T-SQL with the right balance of conceptual and practical content. Get hands-on guidance—including exercises and code samples—that show you how to develop code to query and modify data. You’ll gain a solid understanding of the T-SQL language and good programming practices, and learn to write more efficient and powerful queries. 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 Explore pivoting techniques and how to handle grouping sets Write code that modifies data Isolate inconsistent data and address deadlock and blocking scenarios
Get the book
Similar books
-
Microsoft SQL Server 2012 T-SQL Fundamentals
By Itzik Ben-GanGain 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.
-
Inside Microsoft SQL Server 2008 T-SQL Querying: T-SQL Querying
By Dejan Sarka, Itzik Ben-Gan, Lubor KollarTackle the toughest set-based querying and query tuning problems—guided by an author team with in-depth, inside knowledge of T-SQL.
-
T-SQL Querying
By Adam Machanic, Dejan Sarka, Itzik Ben-GanWrite faster, more efficient T-SQL code: Move from procedural programming to the language of sets and logic Master an efficient top-down tuning methodology Assess algorithmic complexity to predict performance Compare data aggregation ...
-
Inside Microsoft SQL Server 2008: T-SQL Querying
By Itzik Ben-GanTackle the toughest set-based querying and query tuning problems--guided by an author team with in-depth, inside knowledge of T-SQL. Deepen your understanding of architecture and internals--and gain practical approaches and...
-
Microsoft SQL Server 2008 Step by Step
By Mike HotekTeach yourself SQL Server 2008—one step at a time.
-
T-SQL Fundamentals
By Itzik Ben-GanItzik 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.
-
Beginning T-SQL with Microsoft SQL Server 2005 and 2008
By Paul Turley, Dan Wood... varchar(25) NULL ,FirstName varchar(25) NULL ,Position varchar(25)NULL); INSERT SlateGravel VALUES ('Flintstone', ... is stored in a casesensitive collation searching for “flint%” will not return strings beginning with “Flint.
-
Programming Microsoft SQL Server 2008
By Andrew Brust, Leonard G. Lobel, Stephen ForteThis is a must-read for Microsoft .NET and SQL Server developers who work with data access—at the database, business logic, or presentation levels.
-
Inside Microsoft SQL Server 2008: T-SQL Programming
By Itzik Ben-GanGet a detailed look at the internal architecture of T-SQL with this comprehensive programming reference. Database developers and administrators get best practices, expert techniques, and code samples to master the...
-
Beginning Microsoft SQL Server 2008 Programming
By Robert VieiraWith this book, you will conquer the many changes and challenges of Microsoft SQL Server 2008.