Sql server® 2012 t-sql fundamentals

Theoretical Background

SQL stands for Structured Query Language. SQL is a standard language that was designed to query 

and manage data in relational database management systems (RDBMSs). An RDBMS is a database 

management system based on the relational model (a semantic model for representing data), which 

in turn is based on two mathematical branches: set theory and predicate logic. Many other program-

ming languages and various aspects of computing evolved pretty much as a result of intuition. In 

contrast, to the degree that SQL is based on the relational model, it is based on a firm foundation—

applied mathematics. T-SQL thus sits on wide and solid shoulders. Microsoft provides T-SQL as a 

dialect of, or extension to, SQL in Microsoft SQL Server data management software, its RDBMS. 

www.it-ebooks.info

---

2  

Microsoft SQL Server 2012 T-SQL Fundamentals

This section provides a brief theoretical background about SQL, set theory and predicate logic, 

the relational model, and the data life cycle. Because this book is neither a mathematics book nor a 

design/data modeling book, the theoretical information provided here is informal and by no means 

complete. The goals are to give you a context for the T-SQL language and to deliver the key points 

that are integral to correctly understanding T-SQL later in the book.