This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL.Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics. Module 1: Query and modify data with Transact-SQLIntroduction to Transact-SQLSort and filter results in T-SQLCombine multiple tables with JOINs in T-SQLWrite Subqueries in T-SQLUse built-in functions and GROUP BY in Transact-SQLModify data with T-SQL