Sql server® 2012 t-sql fundamentals

Organization of This Book

This book starts with both a theoretical background to T-SQL querying and program-

ming in Chapter 1, laying the foundations for the rest of the book, and also coverage 

of creating tables and defining data integrity. The book moves on to various aspects of 

querying and modifying data in Chapters 2 through 8, then to a discussion of concur-

rency and transactions in Chapter 9, and finally provides an overview of programmable 

objects in Chapter 10. The following section lists the chapter titles along with a short 

description:

■

■

Chapter 1, “Background to T-SQL Querying and Programming,” provides a 

theoretical background of SQL, set theory, and predicate logic; examines the 

relational model and more; describes SQL Server’s architecture; and explains 

how to create tables and define data integrity.

■

■

Chapter 2, “Single-Table Queries,” covers various aspects of querying a single 

table by using the SELECT statement.

www.it-ebooks.info

---