Cover of Microsoft SQL Server 2008: T-SQL Fundamentals

Microsoft SQL Server 2008: T-SQL Fundamentals

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.

Read more

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

Audience
adult
Length
long · 418 pages

Click a tag to see books like this one that share it. Point at it (on a phone, tap it) for less of it instead.

Read it? Sign in to help tag it.

Liked Microsoft SQL Server 2008: T-SQL Fundamentals? Here’s where I’d start.

These suit anyone who liked Microsoft SQL Server 2008: T-SQL Fundamentals. Sign in and mark a few books for picks shaped around your own taste.

  1. Microsoft SQL Server 2008 Internals Shares sql, technical
  2. SQL Server Execution Plans Shares sql, technical
  3. MCTS Self-Paced Training Kit (Exam 70-432): Microsoft SQL Server 2008 - Implementation and Maintenance Shares sql, technical
  4. MCTS Self-Paced Training Kit (Exam 70-433): Microsoft SQL Server 2008 - Database Development Shares sql, technical

“If you want more of the same, start with these.”

  1. Public Administration: An Action Orientation
  2. Semiconductor Device Fundamentals
  3. The Novel 100: A Ranking Of The Greatest Novels Of All Time
  4. ACSM's Guidelines for Exercise Testing and Prescription

“If it was the sql that hooked you, try one of these.”

  1. SQL Server MVP Deep Dives
  2. Joe Celko's Trees and Hierarchies in SQL for Smarties
  3. SQL Pocket Guide
  4. The Art of SQL

“These start from a similar idea, even if they go somewhere else with it.”

  1. The Guru's Guide to Transact-SQL
  2. Graph Databases
  3. Learning SPARQL
  4. Head First Programming: A Learner's Guide to Programming Using the Python Language