Items related to T-SQL Fundamentals (Developer Reference)
Synopsis
Query and modify data effectively with the latest T-SQL features
Master Transact-SQL's fundamentals, and write correct, robust code for querying and modifying data with modern Microsoft data technologies, including SQL Server 2022, Azure SQL Database, and Azure SQL Managed Instance. Long-time Microsoft Data Platform MVP Itzik Ben-Gan explains key T-SQL concepts, helping you apply your knowledge with hands-on exercises. Ben-Gan first introduces T-SQL's theory and underlying logic, illuminating it...
About the Author
Itzik 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...
"About this title" may belong to another edition of this title.
- PublisherMicrosoft Press
- Publication date2023
- ISBN 10 0138102104
- ISBN 13 9780138102104
- BindingPaperback
- LanguageEnglish
- Edition number4
- Number of pages608
- Rating
Search results for T-SQL Fundamentals (Developer Reference)
Stock Image
T-SQL Fundamentals (Developer Reference)
Seller: SecondSale, Montgomery, IL, U.S.A.
Seller rating 4 out of 5 stars
Condition: Very Good. Item in very good condition! Textbooks may not include supplemental items i.e. CDs, access codes etc. Seller Inventory # 00087074023
Quantity: 2 available
Seller Image
T-sql Fundamentals
Seller: GreatBookPrices, Columbia, MD, U.S.A.
Seller rating 5 out of 5 stars
Condition: As New. Unread book in perfect condition. Seller Inventory # 44898057
Quantity: Over 20 available
Seller Image
T-sql Fundamentals
Seller: GreatBookPrices, Columbia, MD, U.S.A.
Seller rating 5 out of 5 stars
Condition: New. Seller Inventory # 44898057-n
Quantity: Over 20 available
Stock Image
T-SQL Fundamentals (Developer Reference)
Seller: INDOO, Avenel, NJ, U.S.A.
Seller rating 5 out of 5 stars
Condition: New. Seller Inventory # 9780138102104
Quantity: 20 available
Stock Image
T-SQL Fundamentals
Seller: PBShop.store US, Wood Dale, IL, U.S.A.
Seller rating 5 out of 5 stars
PAP. Condition: New. New Book. Shipped from UK. Established seller since 2000. Seller Inventory # PB-9780138102104
Quantity: 15 available
Stock Image
T-SQL Fundamentals
Seller: PBShop.store UK, Fairford, GLOS, United Kingdom
Seller rating 4 out of 5 stars
PAP. Condition: New. New Book. Shipped from UK. Established seller since 2000. Seller Inventory # PB-9780138102104
Quantity: 15 available
Seller Image
T-sql Fundamentals
Seller: GreatBookPricesUK, Woodford Green, United Kingdom
Seller rating 5 out of 5 stars
Condition: New. Seller Inventory # 44898057-n
Quantity: Over 20 available
Stock Image
T-SQL Fundamentals (Developer Reference)
Seller: Majestic Books, Hounslow, United Kingdom
Seller rating 5 out of 5 stars
Condition: New. Seller Inventory # 401482785
Quantity: 3 available
Seller Image
T-SQL Fundamentals (Paperback)
Published by
Pearson Education (US), Boston, 2023
ISBN 10: 0138102104
ISBN 13: 9780138102104
New
Paperback
Seller: Grand Eagle Retail, Fairfield, OH, U.S.A.
Seller rating 5 out of 5 stars
Paperback. Condition: new. Paperback. Query and modify data effectively with the latest T-SQL features Master Transact-SQL's fundamentals, and write correct, robust code for querying and modifying data with modern Microsoft data technologies, including SQL Server 2022, Azure SQL Database, and Azure SQL Managed Instance. Long-time Microsoft Data Platform MVP Itzik Ben-Gan explains key T-SQL concepts, helping you apply your knowledge with hands-on exercises. Ben-Gan first introduces T-SQL's theory and underlying logic, illuminating it as both a language and a way of thinking. Next, he walks through core topics, including logical query processing, single table queries, joins, subqueries, table expressions, set operators, data analysis, data modifications, temporal tables, and transactions and concurrency. Building on this foundation, you'll enhance your coding capabilities, from programmatic constructs to the powerful new SQL Graph. Throughout, Ben-Gan presents reusable T-SQL sample code that works in cloud, on-premises, and hybrid environments. Microsoft Data Platform MVP Itzik Ben-Gan helps you: Understand why T-SQL works as it does, so you can write better codeReview relational theory elements and modern SQL Server architectureCreate tables and defi ne data integrityBuild single-table SELECT queries, multiple-table joins, and subqueriesUtilize derived tables, Common Table Expressions, views, inline table-valued functions, and APPLYMake the most of UNION, INTERSECT, and EXCEPT set operatorsPerform data analysis with window functions, pivoting, grouping sets, and time seriesInsert, update, delete, and merge dataGet started with system-versioned temporal tablesUnderstand and apply transactions and concurrency, including concurrent user connections, locks, blocking, isolation levels, and moreUse SQL Graph to model, create, modify, and query graph-based dataExplore SQL Server programmable objects and programming capabilitiesSet up your environment, install sample databases, and fi nd even more help For IT Professionals and Consultants For T-SQL developers, DBAs, BI practitioners, data scientists, report writers, analysts, architects, and SQL Server power usersFor anyone else who needs to write queries or develop T-SQL code for SQL Server, Azure SQL Database, or Azure SQL Managed Instance Shipping may be from multiple locations in the US or from the UK, depending on stock availability. Seller Inventory # 9780138102104
Quantity: 1 available
Seller Image
T-sql Fundamentals
Seller: GreatBookPricesUK, Woodford Green, United Kingdom
Seller rating 5 out of 5 stars
Condition: As New. Unread book in perfect condition. Seller Inventory # 44898057
Quantity: Over 20 available