Загрузка...
Please enter username and password to log in.
Login using:
Beginning T-SQL
Год: 2014
Автор: Kathi Kellenberger, Scott Shaw
Издательство: Apress
ISBN: 978-1-4842-0046-9
Серия: The Expert's Voice in SQL Server
Язык: Английский
Формат: PDF
Качество: Изначально компьютерное (eBook)
Интерактивное оглавление: Да
Количество страниц: 480
Описание: Beginning T-SQL is a performance-oriented introduction to the T-SQL language underlying the Microsoft SQL Server database engine. T-SQL is essential in writing SQL statements to get data into and out of a database. T-SQL is the foundation for business logic embedded in the database in the form of stored procedures and functions. Beginning T-SQL starts you on the path to mastering T-SQL, with an emphasis on best-practices and sound coding techniques leading to excellent performance. This new edition is updated to cover the essential features of T-SQL found in SQL Server 2014, 2012, and 2008.
Примеры страниц Оглавление
Доп. информация: 3rd edition
Опубликовано группой
Год: 2014
Автор: Kathi Kellenberger, Scott Shaw
Издательство: Apress
ISBN: 978-1-4842-0046-9
Серия: The Expert's Voice in SQL Server
Язык: Английский
Формат: PDF
Качество: Изначально компьютерное (eBook)
Интерактивное оглавление: Да
Количество страниц: 480
Описание: Beginning T-SQL is a performance-oriented introduction to the T-SQL language underlying the Microsoft SQL Server database engine. T-SQL is essential in writing SQL statements to get data into and out of a database. T-SQL is the foundation for business logic embedded in the database in the form of stored procedures and functions. Beginning T-SQL starts you on the path to mastering T-SQL, with an emphasis on best-practices and sound coding techniques leading to excellent performance. This new edition is updated to cover the essential features of T-SQL found in SQL Server 2014, 2012, and 2008.
Примеры страниц Оглавление
About the Authors xxiii
About the Technical Reviewer xxv
Acknowledgments xxvii
Foreword xxix
Chapter 1: Getting Started 1
Chapter 2: Exploring Database Concepts 19
Chapter 3: Writing Simple SELECT Queries 31
Chapter 4: Using Built-In Functions and Expressions 59
Chapter 5: Joining Tables 101
Chapter 6: Building on Subqueries, Common Table Expressions, and Unions 127
Chapter 7: Grouping and Summarizing Data 147
Chapter 8: Discovering Windowing Functions 169
Chapter 9: Advanced WHERE Clauses 193
Chapter 10: Manipulating Data 211
Chapter 11: Writing Advanced Queries 241
Chapter 12: Understanding T-SQL Programming Logic 275
Chapter 13: Managing Transactions 309
Chapter 14: Implementing Logic in the Database 325
Chapter 15: Working with XML 379
Chapter 16: Expanding on Data Type Concepts 403
Chapter 17: Running SQL Server in the Cloud 433
Chapter 18: Where to Go Next? 449
Index 453
About the Technical Reviewer xxv
Acknowledgments xxvii
Foreword xxix
Chapter 1: Getting Started 1
Chapter 2: Exploring Database Concepts 19
Chapter 3: Writing Simple SELECT Queries 31
Chapter 4: Using Built-In Functions and Expressions 59
Chapter 5: Joining Tables 101
Chapter 6: Building on Subqueries, Common Table Expressions, and Unions 127
Chapter 7: Grouping and Summarizing Data 147
Chapter 8: Discovering Windowing Functions 169
Chapter 9: Advanced WHERE Clauses 193
Chapter 10: Manipulating Data 211
Chapter 11: Writing Advanced Queries 241
Chapter 12: Understanding T-SQL Programming Logic 275
Chapter 13: Managing Transactions 309
Chapter 14: Implementing Logic in the Database 325
Chapter 15: Working with XML 379
Chapter 16: Expanding on Data Type Concepts 403
Chapter 17: Running SQL Server in the Cloud 433
Chapter 18: Where to Go Next? 449
Index 453
Опубликовано группой
If you like the topic, please click share to help develop our site.
Current time is: 21-Feb 17:01 :: All times are UTC + 3
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum