T-SQL Fundamentals

Amazon.com Price: $43.49 (as of 17/09/2021 17:48 PST- Details)

Categories: , , , , , , , , , ,

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

Additional information

Author

Binding

Brand

EAN

EANList

Edition

IsAdultProduct

ISBN

IsEligibleForTradeIn

ItemDimensions

Label

Languages

Manufacturer

MPN

NumberOfItems

NumberOfPages

PackageDimensions

PartNumber

ProductGroup

ProductTypeName

PublicationDate

Publisher

ReleaseDate

Studio

TradeInValue

Related products