T-SQL Fundamentals, 3rd edition
Title overview
Students will master the fundamentals of Transact-SQL—and develop their own code for querying and modifying data in Microsoft SQL Server 2016. Led by a SQL Server expert, readers learn the concepts behind T-SQL querying and programming, and then apply their knowledge with exercises in each chapter. Once students understand the logic behind T-SQL, they'll quickly learn how to write effective code.
- Explains the why's, not just the how's, of T-SQL to vastly improve learners' understanding.
- Up to date with SQL Server 2016 and Microsoft Azure SQL Database.
- Written by an acknowledged master in the T-SQL and SQL Server field.
Key features
What is a VitalSource eTextbook?
The full text downloaded to your computer.
With VitalSource eTextbooks you can:
- search for key concepts, words and phrases
- make highlights and notes as you study
- share your notes with friends
eTextbooks are downloaded to your computer and accessible either offline through the Bookshelf (available as a free download), available online and also via the iPad and Android apps.
Upon purchase, you'll gain instant access.
Table of contents
CHAPTER 1 Background to T-SQL querying and programming
CHAPTER 2 Single-table queries
CHAPTER 3 Joins
CHAPTER 4 Subqueries
CHAPTER 5 Table expressions
CHAPTER 6 Set operators
CHAPTER 7 Beyond the fundamentals of querying
CHAPTER 8 Data modification
CHAPTER 9 Temporal tables
CHAPTER 10 Transactions and concurrency
CHAPTER 11 Programmable objects
Appendix: Getting started
Index
Author bios
TZIK BEN-GAN is a mentor with and co-founder of SolidQ. A Microsoft Data Platform MVP since 1999, Itzik has taught numerous training events around the world focused on T-SQL querying, query tuning, and programming. Itzik is the author of several books about T-SQL. He has written many articles for SQL Server Pro as well as articles and white papers for MSDN and The SolidQ Journal. Itzik’s speaking engagements include Tech-Ed, SQL PASS, SQL Server Connections, presentations to various SQL Server user groups, and SolidQ events.
Itzik is a subject-matter expert within SolidQ for its T-SQL related activities. He authored SolidQ’s Advanced T-SQL and T-SQL Fundamentals courses and delivers them regularly worldwide. You can learn more about Itzik at http://tsql.solidq.com/.