|
![]() |
|||
|
||||
OverviewStudents 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. Full Product DetailsAuthor: Itzik Ben-GanPublisher: Microsoft Press,U.S. Imprint: Microsoft Press Edition: 3rd edition Dimensions: Width: 18.80cm , Height: 2.50cm , Length: 22.90cm Weight: 0.760kg ISBN: 9781509302000ISBN 10: 150930200 Pages: 464 Publication Date: 04 October 2016 Audience: Professional and scholarly , Professional & Vocational Replaced By: 9780138102104 Format: Paperback Publisher's Status: Active Availability: Available To Order ![]() We have confirmation that this item is in stock with the supplier. It will be ordered in for you and dispatched immediately. Table of ContentsContents at a Glance Introduction 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 IndexReviewsAuthor InformationTZIK 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/. Tab Content 6Author Website:Countries AvailableAll regions |