Description
Effectively question and adjust Knowledge the use of Transact-SQL
Master T-SQL basics and write powerful code for Microsoft SQL Server and Azure SQL Database. Itzik Ben-Gan explains key T-SQL ideas and is helping you observe your wisdom with arms-on workout routines. The e-book first introduces T-SQL’s roots and underlying common sense. Subsequent, it walks you thru center subjects similar to unmarried-desk queries, joins, subqueries, desk expressions, and set operators. Then the e-book covers extra-complicated Knowledge-question subjects similar to window purposes, pivoting, and grouping units. The e-book additionally explains the way to adjust Knowledge, paintings with temporal tables, and deal with transactions, and offers an outline of programmable items.
Microsoft Knowledge Platform MVP Itzik Ben-Gan presentations you the way to:
- Review center SQL ideas and its mathematical roots
- Create tables and put into effect Knowledge integrity
- Perform efficient unmarried-desk queries by way of the use of the SELECT statement
- Query a couple of tables by way of the use of joins, subqueries, desk expressions, and set operators
- Use complicated question tactics similar to window purposes, pivoting, and grouping sets
- Insert, replace, delete, and merge data
- Use transactions in a concurrent environment
- Get began with programmable items–from variables and batches to consumer-outlined purposes, saved strategies, triggers, and dynamic SQL
