{"product_id":"querying-data-with-microsoft-transact-sql-training-dp-080","title":"Query and modify data with Transact-SQL Training (DP-080)","description":"\u003cdiv\u003e\n\u003cp\u003eThis 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, Azure Synapse Analytics, and Microsoft Fabric.\u003c\/p\u003e\r\n\u003cp\u003eThis course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers.\u003c\/p\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eQuery and modify data with Transact-SQL Training (DP-080) Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eIn this course, you will learn how to:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eUse SQL Server query tools.\u003c\/li\u003e\n\u003cli\u003eWrite SELECT statements to retrieve columns from one or more tables.\u003c\/li\u003e\n\u003cli\u003eSort and filter selected data.\u003c\/li\u003e\n\u003cli\u003eUse built-in functions to returned data values.\u003c\/li\u003e\n\u003cli\u003eCreate groups of data and aggregate the results.\u003c\/li\u003e\n\u003cli\u003eModify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003ePrerequisites\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eNone.\u003c\/p\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003eQuery and modify data with Transact-SQL Training (DP-080) Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 1: Introduction to Transact-SQL\u003c\/h4\u003e\n\u003cp\u003eThis module provides an introduction to relational databases, the SQL language and Transact-SQL. You'll learn what kinds of statements make up the SQL language and look at the SELECT statement in detail. \u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eAfter completing this module, you'll be able to: \u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eUnderstand what SQL is for \u003c\/li\u003e\n\u003cli\u003eIdentify database objects in schemas \u003c\/li\u003e\n\u003cli\u003eIdentify SQL statement types \u003c\/li\u003e\n\u003cli\u003eUse the SELECT statement \u003c\/li\u003e\n\u003cli\u003eWork with data types \u003c\/li\u003e\n\u003cli\u003eHandle NULLs \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 2: Sort and filter results in T-SQL \u003c\/h4\u003e\n\u003cp\u003eLearn how to sort and filter query results \u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eAfter completing this module, you will be able to: \u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eSort your results \u003c\/li\u003e\n\u003cli\u003eLimit the sorted results \u003c\/li\u003e\n\u003cli\u003eReturn paged results \u003c\/li\u003e\n\u003cli\u003eRemove duplicates \u003c\/li\u003e\n\u003cli\u003eFilter data with predicates \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 3: Combine multiple tables with JOINs in T-SQL \u003c\/h4\u003e\n\u003cp\u003eExplore T-SQL queries accessing data from multiple tables with various kinds of JOIN operations. \u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eAfter completing this module, you will be able to: \u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDescribe join concepts and syntax \u003c\/li\u003e\n\u003cli\u003eWrite queries that use inner and outer joins \u003c\/li\u003e\n\u003cli\u003eWrite queries that use cross joins \u003c\/li\u003e\n\u003cli\u003eWrite queries that use self joins \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 4: Write Subqueries in T-SQL \u003c\/h4\u003e\n\u003cp\u003eLearn how to use subqueries to combine multiple SELECT statements and compose nested queries. \u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eAfter completing this module, you will be able to: \u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eUnderstand what subqueries are \u003c\/li\u003e\n\u003cli\u003eUse scalar or multi-valued subqueries \u003c\/li\u003e\n\u003cli\u003eUse self-contained or correlated subqueries \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 5: Use built-in functions and GROUP BY in Transact-SQL \u003c\/h4\u003e\n\u003cp\u003eLearn how to use functions in Transact-SQL, and how to group aggregated results. \u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eAfter completing this module, you will be able to: \u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eCategorize built-in functions \u003c\/li\u003e\n\u003cli\u003eUse scalar functions \u003c\/li\u003e\n\u003cli\u003eUse ranking and rowset functions \u003c\/li\u003e\n\u003cli\u003eUse aggregate functions \u003c\/li\u003e\n\u003cli\u003eSummarize data with GROUP BY \u003c\/li\u003e\n\u003cli\u003eFilter groups with HAVING \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 6: Modify data with T-SQL \u003c\/h4\u003e\n\u003cp\u003eLearn how to use Transact-SQL to insert, update, and delete data in a database. \u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eAfter completing this module, you will be able to: \u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eInsert data into a table \u003c\/li\u003e\n\u003cli\u003eGenerate automatic values \u003c\/li\u003e\n\u003cli\u003eUpdate data in a table \u003c\/li\u003e\n\u003cli\u003eDelete data from a table \u003c\/li\u003e\n\u003cli\u003eMerge data based on multiple tables\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e","brand":"Microsoft","offers":[{"title":"267C44US \/ 2026-07-27T09:00:00 \/ Herndon, VA","offer_id":47534205993179,"sku":"US-8597-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"26AB35US \/ 2026-10-19T09:00:00 \/ Herndon, VA","offer_id":48216588615899,"sku":"US-8597-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"271B54US \/ 2027-01-25T09:00:00 \/ Herndon, VA","offer_id":48216588648667,"sku":"US-8597-IL","price":1640.0,"currency_code":"USD","in_stock":true},{"title":"274B18US \/ 2027-04-26T09:00:00 \/ Herndon, VA","offer_id":48669331718363,"sku":"US-8597-IL","price":1640.0,"currency_code":"USD","in_stock":true}],"url":"https:\/\/learningtreeinternational-dirinfosec-hhs.myshopify.com\/products\/querying-data-with-microsoft-transact-sql-training-dp-080","provider":"Learning Tree International","version":"1.0","type":"link"}