|
|
|||
|
||||
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: In Print This item will be ordered in for you from one of our suppliers. Upon receipt, we will promptly dispatch it out to you. For in store availability, please contact us. 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 |