{"id":38409,"date":"2025-07-12T05:52:02","date_gmt":"2025-07-12T05:52:02","guid":{"rendered":"https:\/\/www.eccentrix.ca\/?post_type=formation&#038;p=38409"},"modified":"2026-05-21T09:27:56","modified_gmt":"2026-05-21T09:27:56","slug":"querying-data-with-microsoft-transact-sql-dp-080t00","status":"publish","type":"formation","link":"https:\/\/www.eccentrix.ca\/en\/courses\/microsoft\/azure\/querying-data-with-microsoft-transact-sql-dp-080t00\/","title":{"rendered":"Query and modify data with Transact-SQL (DP-080T00)"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"38409\" class=\"elementor elementor-38409 elementor-38405\" data-elementor-post-type=\"formation\">\n\t\t\t\t<div class=\"elementor-element elementor-element-58008eeb e-flex e-con-boxed e-con e-parent\" data-id=\"58008eeb\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-27f31009 e-con-full e-flex e-con e-child\" data-id=\"27f31009\" data-element_type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-45103e40 elementor-widget elementor-widget-heading\" data-id=\"45103e40\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Query and modify data with Transact-SQL DP-080T00 Training Plan: Detailed Modules<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-71633ea7 elementor-widget elementor-widget-accordion\" data-id=\"71633ea7\" data-element_type=\"widget\" data-widget_type=\"accordion.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-accordion\">\n\t\t\t\t\t\t\t<div class=\"elementor-accordion-item\">\n\t\t\t\t\t<h6 id=\"elementor-tab-title-1901\" class=\"elementor-tab-title\" data-tab=\"1\" role=\"button\" aria-controls=\"elementor-tab-content-1901\" aria-expanded=\"false\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon elementor-accordion-icon-left\" aria-hidden=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-closed\"><svg class=\"e-font-icon-svg e-fas-plus\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M416 208H272V64c0-17.67-14.33-32-32-32h-32c-17.67 0-32 14.33-32 32v144H32c-17.67 0-32 14.33-32 32v32c0 17.67 14.33 32 32 32h144v144c0 17.67 14.33 32 32 32h32c17.67 0 32-14.33 32-32V304h144c17.67 0 32-14.33 32-32v-32c0-17.67-14.33-32-32-32z\"><\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-opened\"><svg class=\"e-font-icon-svg e-fas-minus\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M416 208H32c-17.67 0-32 14.33-32 32v32c0 17.67 14.33 32 32 32h384c17.67 0 32-14.33 32-32v-32c0-17.67-14.33-32-32-32z\"><\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-accordion-title\" tabindex=\"0\">Module 1: Introduction to Transact-SQL<\/a>\n\t\t\t\t\t<\/h6>\n\t\t\t\t\t<div id=\"elementor-tab-content-1901\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"1\" role=\"region\" aria-labelledby=\"elementor-tab-title-1901\"><ul class=\"margin-left-none\"><li class=\"module-unit is-unstyled font-size-md position-relative padding-block-xxs completable\" data-progress-uid=\"learn.wwl.intro-to-transact-sql.work-with-schemas\"><div class=\"barLink is-unit-list-item margin-none columns\"><div class=\"column is-11 padding-none has-content-margin-right-xxs\">Work with schemas<\/div><\/div><\/li><li class=\"module-unit is-unstyled font-size-md position-relative padding-block-xxs completable\" data-progress-uid=\"learn.wwl.intro-to-transact-sql.explore-structure-sql-statements\"><div class=\"barLink is-unit-list-item margin-none columns\"><div class=\"column is-11 padding-none has-content-margin-right-xxs\">Explore the structure of SQL statements<\/div><\/div><\/li><li class=\"module-unit is-unstyled font-size-md position-relative padding-block-xxs completable\" data-progress-uid=\"learn.wwl.intro-to-transact-sql.examine-select-statement\"><div class=\"barLink is-unit-list-item margin-none columns\"><div class=\"column is-11 padding-none has-content-margin-right-xxs\">Examine the SELECT statement<\/div><\/div><\/li><li class=\"module-unit is-unstyled font-size-md position-relative padding-block-xxs completable\" data-progress-uid=\"learn.wwl.intro-to-transact-sql.work-with-data-types\"><div class=\"barLink is-unit-list-item margin-none columns\"><div class=\"column is-11 padding-none has-content-margin-right-xxs\">Work with data types<\/div><\/div><\/li><li class=\"module-unit is-unstyled font-size-md position-relative padding-block-xxs completable\" data-progress-uid=\"learn.wwl.intro-to-transact-sql.handle-nulls\"><div class=\"barLink is-unit-list-item margin-none columns\"><div class=\"column is-11 padding-none has-content-margin-right-xxs\">Handle NULLs<\/div><\/div><\/li><li class=\"module-unit is-unstyled font-size-md position-relative padding-block-xxs completable\" data-progress-uid=\"learn.wwl.intro-to-transact-sql.exercise-work-with-select-statements\"><div class=\"barLink is-unit-list-item margin-none columns\"><div class=\"column is-11 padding-none has-content-margin-right-xxs\">Exercise &#8211; Work with SELECT statements<\/div><\/div><\/li><\/ul><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class=\"elementor-accordion-item\">\n\t\t\t\t\t<h6 id=\"elementor-tab-title-1902\" class=\"elementor-tab-title\" data-tab=\"2\" role=\"button\" aria-controls=\"elementor-tab-content-1902\" aria-expanded=\"false\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon elementor-accordion-icon-left\" aria-hidden=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-closed\"><svg class=\"e-font-icon-svg e-fas-plus\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M416 208H272V64c0-17.67-14.33-32-32-32h-32c-17.67 0-32 14.33-32 32v144H32c-17.67 0-32 14.33-32 32v32c0 17.67 14.33 32 32 32h144v144c0 17.67 14.33 32 32 32h32c17.67 0 32-14.33 32-32V304h144c17.67 0 32-14.33 32-32v-32c0-17.67-14.33-32-32-32z\"><\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-opened\"><svg class=\"e-font-icon-svg e-fas-minus\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M416 208H32c-17.67 0-32 14.33-32 32v32c0 17.67 14.33 32 32 32h384c17.67 0 32-14.33 32-32v-32c0-17.67-14.33-32-32-32z\"><\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-accordion-title\" tabindex=\"0\">Module 2: Sort and filter results in T-SQL<\/a>\n\t\t\t\t\t<\/h6>\n\t\t\t\t\t<div id=\"elementor-tab-content-1902\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"2\" role=\"region\" aria-labelledby=\"elementor-tab-title-1902\"><ul class=\"margin-left-none\"><li class=\"module-unit is-unstyled font-size-md position-relative padding-block-xxs completable\" data-progress-uid=\"learn.wwl.sort-and-filter-queries.sort-your-data-as-its-returned\"><div class=\"barLink is-unit-list-item margin-none columns\"><div class=\"column is-11 padding-none has-content-margin-right-xxs\">Sort your results<\/div><\/div><\/li><li class=\"module-unit is-unstyled font-size-md position-relative padding-block-xxs completable\" data-progress-uid=\"learn.wwl.sort-and-filter-queries.use-top-offset-fetch-with-sorted-data\"><div class=\"barLink is-unit-list-item margin-none columns\"><div class=\"column is-11 padding-none has-content-margin-right-xxs\">Limit the sorted results<\/div><\/div><\/li><li class=\"module-unit is-unstyled font-size-md position-relative padding-block-xxs completable\" data-progress-uid=\"learn.wwl.sort-and-filter-queries.page-results\"><div class=\"barLink is-unit-list-item margin-none columns\"><div class=\"column is-11 padding-none has-content-margin-right-xxs\">Page results<\/div><\/div><\/li><li class=\"module-unit is-unstyled font-size-md position-relative padding-block-xxs completable\" data-progress-uid=\"learn.wwl.sort-and-filter-queries.remove-duplicates\"><div class=\"barLink is-unit-list-item margin-none columns\"><div class=\"column is-11 padding-none has-content-margin-right-xxs\">Remove duplicates<\/div><\/div><\/li><li class=\"module-unit is-unstyled font-size-md position-relative padding-block-xxs completable\" data-progress-uid=\"learn.wwl.sort-and-filter-queries.filter-data\"><div class=\"barLink is-unit-list-item margin-none columns\"><div class=\"column is-11 padding-none has-content-margin-right-xxs\">Filter data with predicates<\/div><\/div><\/li><li class=\"module-unit is-unstyled font-size-md position-relative padding-block-xxs completable\" data-progress-uid=\"learn.wwl.sort-and-filter-queries.exercise-sort-filter-query-results\"><div class=\"barLink is-unit-list-item margin-none columns\"><div class=\"column is-11 padding-none has-content-margin-right-xxs\">Exercise &#8211; Sort and filter query results<\/div><\/div><\/li><\/ul><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class=\"elementor-accordion-item\">\n\t\t\t\t\t<h6 id=\"elementor-tab-title-1903\" class=\"elementor-tab-title\" data-tab=\"3\" role=\"button\" aria-controls=\"elementor-tab-content-1903\" aria-expanded=\"false\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon elementor-accordion-icon-left\" aria-hidden=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-closed\"><svg class=\"e-font-icon-svg e-fas-plus\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M416 208H272V64c0-17.67-14.33-32-32-32h-32c-17.67 0-32 14.33-32 32v144H32c-17.67 0-32 14.33-32 32v32c0 17.67 14.33 32 32 32h144v144c0 17.67 14.33 32 32 32h32c17.67 0 32-14.33 32-32V304h144c17.67 0 32-14.33 32-32v-32c0-17.67-14.33-32-32-32z\"><\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-opened\"><svg class=\"e-font-icon-svg e-fas-minus\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M416 208H32c-17.67 0-32 14.33-32 32v32c0 17.67 14.33 32 32 32h384c17.67 0 32-14.33 32-32v-32c0-17.67-14.33-32-32-32z\"><\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-accordion-title\" tabindex=\"0\">Module 3: Combine multiple tables with JOINs in T-SQL<\/a>\n\t\t\t\t\t<\/h6>\n\t\t\t\t\t<div id=\"elementor-tab-content-1903\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"3\" role=\"region\" aria-labelledby=\"elementor-tab-title-1903\"><ul class=\"margin-left-none\"><li class=\"module-unit is-unstyled font-size-md position-relative padding-block-xxs completable\" data-progress-uid=\"learn.wwl.query-multiple-tables-with-joins.join-concepts\"><div class=\"barLink is-unit-list-item margin-none columns\"><div class=\"column is-11 padding-none has-content-margin-right-xxs\">Understand joins concepts and syntax<\/div><\/div><\/li><li class=\"module-unit is-unstyled font-size-md position-relative padding-block-xxs completable\" data-progress-uid=\"learn.wwl.query-multiple-tables-with-joins.inner-joins\"><div class=\"barLink is-unit-list-item margin-none columns\"><div class=\"column is-11 padding-none has-content-margin-right-xxs\">Use inner joins<\/div><\/div><\/li><li class=\"module-unit is-unstyled font-size-md position-relative padding-block-xxs completable\" data-progress-uid=\"learn.wwl.query-multiple-tables-with-joins.outer-joins\"><div class=\"barLink is-unit-list-item margin-none columns\"><div class=\"column is-11 padding-none has-content-margin-right-xxs\">Use outer joins<\/div><\/div><\/li><li class=\"module-unit is-unstyled font-size-md position-relative padding-block-xxs completable\" data-progress-uid=\"learn.wwl.query-multiple-tables-with-joins.explore-cross-joins\"><div class=\"barLink is-unit-list-item margin-none columns\"><div class=\"column is-11 padding-none has-content-margin-right-xxs\">Use cross joins<\/div><\/div><\/li><li class=\"module-unit is-unstyled font-size-md position-relative padding-block-xxs completable\" data-progress-uid=\"learn.wwl.query-multiple-tables-with-joins.self-joins\"><div class=\"barLink is-unit-list-item margin-none columns\"><div class=\"column is-11 padding-none has-content-margin-right-xxs\">Use self joins<\/div><\/div><\/li><li class=\"module-unit is-unstyled font-size-md position-relative padding-block-xxs completable\" data-progress-uid=\"learn.wwl.query-multiple-tables-with-joins.exercise-query-with-joins\"><div class=\"barLink is-unit-list-item margin-none columns\"><div class=\"column is-11 padding-none has-content-margin-right-xxs\">Exercise &#8211; Query multiple tables with joins<\/div><\/div><\/li><\/ul><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class=\"elementor-accordion-item\">\n\t\t\t\t\t<h6 id=\"elementor-tab-title-1904\" class=\"elementor-tab-title\" data-tab=\"4\" role=\"button\" aria-controls=\"elementor-tab-content-1904\" aria-expanded=\"false\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon elementor-accordion-icon-left\" aria-hidden=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-closed\"><svg class=\"e-font-icon-svg e-fas-plus\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M416 208H272V64c0-17.67-14.33-32-32-32h-32c-17.67 0-32 14.33-32 32v144H32c-17.67 0-32 14.33-32 32v32c0 17.67 14.33 32 32 32h144v144c0 17.67 14.33 32 32 32h32c17.67 0 32-14.33 32-32V304h144c17.67 0 32-14.33 32-32v-32c0-17.67-14.33-32-32-32z\"><\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-opened\"><svg class=\"e-font-icon-svg e-fas-minus\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M416 208H32c-17.67 0-32 14.33-32 32v32c0 17.67 14.33 32 32 32h384c17.67 0 32-14.33 32-32v-32c0-17.67-14.33-32-32-32z\"><\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-accordion-title\" tabindex=\"0\">Module 4: Write Subqueries in T-SQL<\/a>\n\t\t\t\t\t<\/h6>\n\t\t\t\t\t<div id=\"elementor-tab-content-1904\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"4\" role=\"region\" aria-labelledby=\"elementor-tab-title-1904\"><ul class=\"margin-left-none\"><li class=\"module-unit is-unstyled font-size-md position-relative padding-block-xxs completable\" data-progress-uid=\"learn.wwl.write-subqueries.understand-subqueries\"><div class=\"barLink is-unit-list-item margin-none columns\"><div class=\"column is-11 padding-none has-content-margin-right-xxs\">Understand subqueries<\/div><\/div><\/li><li class=\"module-unit is-unstyled font-size-md position-relative padding-block-xxs completable\" data-progress-uid=\"learn.wwl.write-subqueries.scalar-or-multi-values-subqueries\"><div class=\"barLink is-unit-list-item margin-none columns\"><div class=\"column is-11 padding-none has-content-margin-right-xxs\">Use scalar or multi-valued subqueries<\/div><\/div><\/li><li class=\"module-unit is-unstyled font-size-md position-relative padding-block-xxs completable\" data-progress-uid=\"learn.wwl.write-subqueries.self-contained-or-correlated-subqueries\"><div class=\"barLink is-unit-list-item margin-none columns\"><div class=\"column is-11 padding-none has-content-margin-right-xxs\">Use self-contained or correlated subqueries<\/div><\/div><\/li><li class=\"module-unit is-unstyled font-size-md position-relative padding-block-xxs completable\" data-progress-uid=\"learn.wwl.write-subqueries.exercise-subqueries\"><div class=\"barLink is-unit-list-item margin-none columns\"><div class=\"column is-11 padding-none has-content-margin-right-xxs\">Exercise &#8211; Use subqueries<\/div><\/div><\/li><\/ul><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class=\"elementor-accordion-item\">\n\t\t\t\t\t<h6 id=\"elementor-tab-title-1905\" class=\"elementor-tab-title\" data-tab=\"5\" role=\"button\" aria-controls=\"elementor-tab-content-1905\" aria-expanded=\"false\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon elementor-accordion-icon-left\" aria-hidden=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-closed\"><svg class=\"e-font-icon-svg e-fas-plus\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M416 208H272V64c0-17.67-14.33-32-32-32h-32c-17.67 0-32 14.33-32 32v144H32c-17.67 0-32 14.33-32 32v32c0 17.67 14.33 32 32 32h144v144c0 17.67 14.33 32 32 32h32c17.67 0 32-14.33 32-32V304h144c17.67 0 32-14.33 32-32v-32c0-17.67-14.33-32-32-32z\"><\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-opened\"><svg class=\"e-font-icon-svg e-fas-minus\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M416 208H32c-17.67 0-32 14.33-32 32v32c0 17.67 14.33 32 32 32h384c17.67 0 32-14.33 32-32v-32c0-17.67-14.33-32-32-32z\"><\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-accordion-title\" tabindex=\"0\">Module 5:Use built-in functions and GROUP BY in Transact-SQL<\/a>\n\t\t\t\t\t<\/h6>\n\t\t\t\t\t<div id=\"elementor-tab-content-1905\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"5\" role=\"region\" aria-labelledby=\"elementor-tab-title-1905\"><ul class=\"margin-left-none\"><li class=\"module-unit is-unstyled font-size-md position-relative padding-block-xxs completable\" data-progress-uid=\"learn.wwl.use-built-functions-transact-sql.categorize-functions\"><div class=\"barLink is-unit-list-item margin-none columns\"><div class=\"column is-11 padding-none has-content-margin-right-xxs\">Categorize built-in functions<\/div><\/div><\/li><li class=\"module-unit is-unstyled font-size-md position-relative padding-block-xxs completable\" data-progress-uid=\"learn.wwl.use-built-functions-transact-sql.scalar-functions\"><div class=\"barLink is-unit-list-item margin-none columns\"><div class=\"column is-11 padding-none has-content-margin-right-xxs\">Use scalar functions<\/div><\/div><\/li><li class=\"module-unit is-unstyled font-size-md position-relative padding-block-xxs completable\" data-progress-uid=\"learn.wwl.use-built-functions-transact-sql.ranking-rowset-functions\"><div class=\"barLink is-unit-list-item margin-none columns\"><div class=\"column is-11 padding-none has-content-margin-right-xxs\">Use ranking and rowset functions<\/div><\/div><\/li><li class=\"module-unit is-unstyled font-size-md position-relative padding-block-xxs completable\" data-progress-uid=\"learn.wwl.use-built-functions-transact-sql.aggregate-functions\"><div class=\"barLink is-unit-list-item margin-none columns\"><div class=\"column is-11 padding-none has-content-margin-right-xxs\">Use aggregate functions<\/div><\/div><\/li><li class=\"module-unit is-unstyled font-size-md position-relative padding-block-xxs completable\" data-progress-uid=\"learn.wwl.use-built-functions-transact-sql.summarize-group-by\"><div class=\"barLink is-unit-list-item margin-none columns\"><div class=\"column is-11 padding-none has-content-margin-right-xxs\">Summarize data with GROUP BY<\/div><\/div><\/li><li class=\"module-unit is-unstyled font-size-md position-relative padding-block-xxs completable\" data-progress-uid=\"learn.wwl.use-built-functions-transact-sql.filter-groups\"><div class=\"barLink is-unit-list-item margin-none columns\"><div class=\"column is-11 padding-none has-content-margin-right-xxs\">Filter groups with HAVING<\/div><\/div><\/li><li class=\"module-unit is-unstyled font-size-md position-relative padding-block-xxs completable\" data-progress-uid=\"learn.wwl.use-built-functions-transact-sql.exercise-built-in-functions\"><div class=\"barLink is-unit-list-item margin-none columns\"><div class=\"column is-11 padding-none has-content-margin-right-xxs\">Exercise &#8211; Use built-in functions<\/div><\/div><\/li><\/ul><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class=\"elementor-accordion-item\">\n\t\t\t\t\t<h6 id=\"elementor-tab-title-1906\" class=\"elementor-tab-title\" data-tab=\"6\" role=\"button\" aria-controls=\"elementor-tab-content-1906\" aria-expanded=\"false\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon elementor-accordion-icon-left\" aria-hidden=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-closed\"><svg class=\"e-font-icon-svg e-fas-plus\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M416 208H272V64c0-17.67-14.33-32-32-32h-32c-17.67 0-32 14.33-32 32v144H32c-17.67 0-32 14.33-32 32v32c0 17.67 14.33 32 32 32h144v144c0 17.67 14.33 32 32 32h32c17.67 0 32-14.33 32-32V304h144c17.67 0 32-14.33 32-32v-32c0-17.67-14.33-32-32-32z\"><\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-opened\"><svg class=\"e-font-icon-svg e-fas-minus\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M416 208H32c-17.67 0-32 14.33-32 32v32c0 17.67 14.33 32 32 32h384c17.67 0 32-14.33 32-32v-32c0-17.67-14.33-32-32-32z\"><\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-accordion-title\" tabindex=\"0\">Module 6: Modify data with T-SQL<\/a>\n\t\t\t\t\t<\/h6>\n\t\t\t\t\t<div id=\"elementor-tab-content-1906\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"6\" role=\"region\" aria-labelledby=\"elementor-tab-title-1906\"><ul class=\"margin-left-none\"><li class=\"module-unit is-unstyled font-size-md position-relative padding-block-xxs completable\" data-progress-uid=\"learn.wwl.modify-data-with-transact-sql.insert-data\"><div class=\"barLink is-unit-list-item margin-none columns\"><div class=\"column is-11 padding-none has-content-margin-right-xxs\">Insert data<\/div><\/div><\/li><li class=\"module-unit is-unstyled font-size-md position-relative padding-block-xxs completable\" data-progress-uid=\"learn.wwl.modify-data-with-transact-sql.automatic-values\"><div class=\"barLink is-unit-list-item margin-none columns\"><div class=\"column is-11 padding-none has-content-margin-right-xxs\">Generate automatic values<\/div><\/div><\/li><li class=\"module-unit is-unstyled font-size-md position-relative padding-block-xxs completable\" data-progress-uid=\"learn.wwl.modify-data-with-transact-sql.update-data\"><div class=\"barLink is-unit-list-item margin-none columns\"><div class=\"column is-11 padding-none has-content-margin-right-xxs\">Update data<\/div><\/div><\/li><li class=\"module-unit is-unstyled font-size-md position-relative padding-block-xxs completable\" data-progress-uid=\"learn.wwl.modify-data-with-transact-sql.delete-data\"><div class=\"barLink is-unit-list-item margin-none columns\"><div class=\"column is-11 padding-none has-content-margin-right-xxs\">Delete data<\/div><\/div><\/li><li class=\"module-unit is-unstyled font-size-md position-relative padding-block-xxs completable\" data-progress-uid=\"learn.wwl.modify-data-with-transact-sql.merge-data\"><div class=\"barLink is-unit-list-item margin-none columns\"><div class=\"column is-11 padding-none has-content-margin-right-xxs\">Merge data based on multiple tables<\/div><\/div><\/li><li class=\"module-unit is-unstyled font-size-md position-relative padding-block-xxs completable\" data-progress-uid=\"learn.wwl.modify-data-with-transact-sql.exercise-modify-data\"><div class=\"barLink is-unit-list-item margin-none columns\"><div class=\"column is-11 padding-none has-content-margin-right-xxs\">Exercise &#8211; Modify data<\/div><\/div><\/li><\/ul><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-4ed0870f e-con-full e-flex e-con e-child\" data-id=\"4ed0870f\" data-element_type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-7d89a99 elementor-widget elementor-widget-heading\" data-id=\"7d89a99\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Recommended prerequisite knowledge<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5a2f452f elementor-widget elementor-widget-text-editor\" data-id=\"5a2f452f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ul><li>Familiarity with working with tables of data, for example in a spreadsheet.<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-8fe5e15 e-flex e-con-boxed e-con e-parent\" data-id=\"8fe5e15\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-311b57e0 elementor-widget elementor-widget-heading\" data-id=\"311b57e0\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Eccentrix Corner Articles: Query and modify data with Transact-SQL DP-080T00 Resources<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7786919 elementor-widget elementor-widget-text-editor\" data-id=\"7786919\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Explore our technical articles on Query and modify data with Transact-SQL DP-080T00 published on Eccentrix Corner. These resources dive deeper into key concepts, share best practices, and provide practical guides to maximize your learning and success. Our experts share real-world insights to help you master querying data with Microsoft Transact-SQL.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6cbabcc elementor-grid-2 elementor-posts--thumbnail-left elementor-grid-tablet-1 elementor-posts--align-left elementor-grid-mobile-1 load-more-align-center elementor-widget elementor-widget-posts\" data-id=\"6cbabcc\" data-element_type=\"widget\" data-settings=\"{&quot;classic_columns&quot;:&quot;2&quot;,&quot;classic_row_gap&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:25,&quot;sizes&quot;:[]},&quot;pagination_type&quot;:&quot;load_more_on_click&quot;,&quot;classic_columns_tablet&quot;:&quot;1&quot;,&quot;classic_columns_mobile&quot;:&quot;1&quot;,&quot;classic_row_gap_tablet&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;classic_row_gap_mobile&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;load_more_spinner&quot;:{&quot;value&quot;:&quot;fas fa-spinner&quot;,&quot;library&quot;:&quot;fa-solid&quot;}}\" data-widget_type=\"posts.classic\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-posts-container elementor-posts elementor-posts--skin-classic elementor-grid\">\n\t\t\t\t<article class=\"elementor-post elementor-grid-item post-12500 post type-post status-publish format-standard has-post-thumbnail hentry category-eccentrix-corner tag-computer-networks\">\n\t\t\t\t<a class=\"elementor-post__thumbnail__link\" href=\"https:\/\/www.eccentrix.ca\/en\/eccentrix-corner\/how-to-ensure-reliable-data-storage\/\" tabindex=\"-1\" >\n\t\t\t<div class=\"elementor-post__thumbnail\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"72\" src=\"https:\/\/www.eccentrix.ca\/wp-content\/uploads\/2024\/09\/how_to_ensure_a_reliable_data_storage-300x72.png\" class=\"attachment-medium size-medium wp-image-12495\" alt=\"An illustration of folder storage - Eccentrix\" srcset=\"https:\/\/www.eccentrix.ca\/wp-content\/uploads\/2024\/09\/how_to_ensure_a_reliable_data_storage-300x72.png 300w, https:\/\/www.eccentrix.ca\/wp-content\/uploads\/2024\/09\/how_to_ensure_a_reliable_data_storage-1024x245.png 1024w, https:\/\/www.eccentrix.ca\/wp-content\/uploads\/2024\/09\/how_to_ensure_a_reliable_data_storage-768x184.png 768w, https:\/\/www.eccentrix.ca\/wp-content\/uploads\/2024\/09\/how_to_ensure_a_reliable_data_storage-1536x368.png 1536w, https:\/\/www.eccentrix.ca\/wp-content\/uploads\/2024\/09\/how_to_ensure_a_reliable_data_storage.png 1922w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/div>\n\t\t<\/a>\n\t\t\t\t<div class=\"elementor-post__text\">\n\t\t\t\t<h5 class=\"elementor-post__title\">\n\t\t\t<a href=\"https:\/\/www.eccentrix.ca\/en\/eccentrix-corner\/how-to-ensure-reliable-data-storage\/\" >\n\t\t\t\tHow to Ensure Reliable Data Storage\t\t\t<\/a>\n\t\t<\/h5>\n\t\t\t\t<\/div>\n\t\t\t\t<\/article>\n\t\t\t\t<article class=\"elementor-post elementor-grid-item post-2057 post type-post status-publish format-standard has-post-thumbnail hentry category-eccentrix-corner tag-cloud tag-microsoft-azure\">\n\t\t\t\t<a class=\"elementor-post__thumbnail__link\" href=\"https:\/\/www.eccentrix.ca\/en\/eccentrix-corner\/azure-storage-solutions-understanding-blob-file-table-and-queue-storage\/\" tabindex=\"-1\" >\n\t\t\t<div class=\"elementor-post__thumbnail\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"72\" src=\"https:\/\/www.eccentrix.ca\/wp-content\/uploads\/2024\/06\/solutions_de_stockage_azure_-_blobs_de_fichiers_de_tables_et_de_files_dattente-300x72.png\" class=\"attachment-medium size-medium wp-image-1861\" alt=\"An image representing a cloud storage device, in relation to storage types in Azure - Eccentrix\" srcset=\"https:\/\/www.eccentrix.ca\/wp-content\/uploads\/2024\/06\/solutions_de_stockage_azure_-_blobs_de_fichiers_de_tables_et_de_files_dattente-300x72.png 300w, https:\/\/www.eccentrix.ca\/wp-content\/uploads\/2024\/06\/solutions_de_stockage_azure_-_blobs_de_fichiers_de_tables_et_de_files_dattente-1024x245.png 1024w, https:\/\/www.eccentrix.ca\/wp-content\/uploads\/2024\/06\/solutions_de_stockage_azure_-_blobs_de_fichiers_de_tables_et_de_files_dattente-768x184.png 768w, https:\/\/www.eccentrix.ca\/wp-content\/uploads\/2024\/06\/solutions_de_stockage_azure_-_blobs_de_fichiers_de_tables_et_de_files_dattente-1536x368.png 1536w, https:\/\/www.eccentrix.ca\/wp-content\/uploads\/2024\/06\/solutions_de_stockage_azure_-_blobs_de_fichiers_de_tables_et_de_files_dattente.png 1922w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/div>\n\t\t<\/a>\n\t\t\t\t<div class=\"elementor-post__text\">\n\t\t\t\t<h5 class=\"elementor-post__title\">\n\t\t\t<a href=\"https:\/\/www.eccentrix.ca\/en\/eccentrix-corner\/azure-storage-solutions-understanding-blob-file-table-and-queue-storage\/\" >\n\t\t\t\tAzure Storage Solutions: Understanding Blob, File, Table, and Queue Storage\u202f\t\t\t<\/a>\n\t\t<\/h5>\n\t\t\t\t<\/div>\n\t\t\t\t<\/article>\n\t\t\t\t<article class=\"elementor-post elementor-grid-item post-2062 post type-post status-publish format-standard has-post-thumbnail hentry category-eccentrix-corner tag-cloud tag-microsoft-azure\">\n\t\t\t\t<a class=\"elementor-post__thumbnail__link\" href=\"https:\/\/www.eccentrix.ca\/en\/eccentrix-corner\/understanding-the-landscape-of-ai-machine-learning-deep-learning-and-data-science-applications-and-distinctions\/\" tabindex=\"-1\" >\n\t\t\t<div class=\"elementor-post__thumbnail\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"72\" src=\"https:\/\/www.eccentrix.ca\/wp-content\/uploads\/2024\/06\/understanding_the_landscape_of_ai_machine_learning_deep_learning_and_data_science_applications_and_distinctions-300x72.png\" class=\"attachment-medium size-medium wp-image-1856\" alt=\"A visual depiction of technologies such as AI, Machine Learning, Deep Learning, and Data Science - Eccentrix\" srcset=\"https:\/\/www.eccentrix.ca\/wp-content\/uploads\/2024\/06\/understanding_the_landscape_of_ai_machine_learning_deep_learning_and_data_science_applications_and_distinctions-300x72.png 300w, https:\/\/www.eccentrix.ca\/wp-content\/uploads\/2024\/06\/understanding_the_landscape_of_ai_machine_learning_deep_learning_and_data_science_applications_and_distinctions-1024x245.png 1024w, https:\/\/www.eccentrix.ca\/wp-content\/uploads\/2024\/06\/understanding_the_landscape_of_ai_machine_learning_deep_learning_and_data_science_applications_and_distinctions-768x184.png 768w, https:\/\/www.eccentrix.ca\/wp-content\/uploads\/2024\/06\/understanding_the_landscape_of_ai_machine_learning_deep_learning_and_data_science_applications_and_distinctions-1536x368.png 1536w, https:\/\/www.eccentrix.ca\/wp-content\/uploads\/2024\/06\/understanding_the_landscape_of_ai_machine_learning_deep_learning_and_data_science_applications_and_distinctions.png 1922w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/div>\n\t\t<\/a>\n\t\t\t\t<div class=\"elementor-post__text\">\n\t\t\t\t<h5 class=\"elementor-post__title\">\n\t\t\t<a href=\"https:\/\/www.eccentrix.ca\/en\/eccentrix-corner\/understanding-the-landscape-of-ai-machine-learning-deep-learning-and-data-science-applications-and-distinctions\/\" >\n\t\t\t\tUnderstanding the Landscape of AI, Machine Learning, Deep Learning, and Data Science: Applications and Distinctions\t\t\t<\/a>\n\t\t<\/h5>\n\t\t\t\t<\/div>\n\t\t\t\t<\/article>\n\t\t\t\t<article class=\"elementor-post elementor-grid-item post-2072 post type-post status-publish format-standard has-post-thumbnail hentry category-eccentrix-corner tag-cloud tag-microsoft-365 tag-microsoft-azure\">\n\t\t\t\t<a class=\"elementor-post__thumbnail__link\" href=\"https:\/\/www.eccentrix.ca\/en\/eccentrix-corner\/exploring-unusual-types-of-cloud-hosting-services-beyond-the-basics\/\" tabindex=\"-1\" >\n\t\t\t<div class=\"elementor-post__thumbnail\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"72\" src=\"https:\/\/www.eccentrix.ca\/wp-content\/uploads\/2024\/06\/blog_and_web_publications_covers_0-300x72.png\" class=\"attachment-medium size-medium wp-image-1845\" alt=\"A visual representation of virtual folders related to the types of cloud services - Eccentrix\" srcset=\"https:\/\/www.eccentrix.ca\/wp-content\/uploads\/2024\/06\/blog_and_web_publications_covers_0-300x72.png 300w, https:\/\/www.eccentrix.ca\/wp-content\/uploads\/2024\/06\/blog_and_web_publications_covers_0-1024x245.png 1024w, https:\/\/www.eccentrix.ca\/wp-content\/uploads\/2024\/06\/blog_and_web_publications_covers_0-768x184.png 768w, https:\/\/www.eccentrix.ca\/wp-content\/uploads\/2024\/06\/blog_and_web_publications_covers_0-1536x368.png 1536w, https:\/\/www.eccentrix.ca\/wp-content\/uploads\/2024\/06\/blog_and_web_publications_covers_0.png 1922w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/div>\n\t\t<\/a>\n\t\t\t\t<div class=\"elementor-post__text\">\n\t\t\t\t<h5 class=\"elementor-post__title\">\n\t\t\t<a href=\"https:\/\/www.eccentrix.ca\/en\/eccentrix-corner\/exploring-unusual-types-of-cloud-hosting-services-beyond-the-basics\/\" >\n\t\t\t\tExploring Unusual Types of Cloud Hosting Services: Beyond the Basics\t\t\t<\/a>\n\t\t<\/h5>\n\t\t\t\t<\/div>\n\t\t\t\t<\/article>\n\t\t\t\t<\/div>\n\t\t\t\t\t<span class=\"e-load-more-spinner\">\n\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fas-spinner\" viewBox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M304 48c0 26.51-21.49 48-48 48s-48-21.49-48-48 21.49-48 48-48 48 21.49 48 48zm-48 368c-26.51 0-48 21.49-48 48s21.49 48 48 48 48-21.49 48-48-21.49-48-48-48zm208-208c-26.51 0-48 21.49-48 48s21.49 48 48 48 48-21.49 48-48-21.49-48-48-48zM96 256c0-26.51-21.49-48-48-48S0 229.49 0 256s21.49 48 48 48 48-21.49 48-48zm12.922 99.078c-26.51 0-48 21.49-48 48s21.49 48 48 48 48-21.49 48-48c0-26.509-21.491-48-48-48zm294.156 0c-26.51 0-48 21.49-48 48s21.49 48 48 48 48-21.49 48-48c0-26.509-21.49-48-48-48zM108.922 60.922c-26.51 0-48 21.49-48 48s21.49 48 48 48 48-21.49 48-48-21.491-48-48-48z\"><\/path><\/svg>\t\t\t<\/span>\n\t\t\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-1157da4 e-flex e-con-boxed e-con e-parent\" data-id=\"1157da4\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-376f9d6 elementor-widget elementor-widget-heading\" data-id=\"376f9d6\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Transact SQL Querying Training<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-51e8ace elementor-widget elementor-widget-text-editor\" data-id=\"51e8ace\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>The Transact SQL Querying training is designed to empower IT professionals with the knowledge and skills needed to implement robust querying solutions with Microsoft Transact-SQL. This course provides an in-depth understanding of Transact-SQL capabilities, including setting up complex queries, creating stored procedures, and analyzing data to optimize the performance and reliability of Microsoft SQL databases.<\/p>\n<p>By mastering Transact-SQL, participants can ensure proactive management of their database environments, enabling efficient data extraction and manipulation.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ffc9bd3 elementor-widget elementor-widget-heading\" data-id=\"ffc9bd3\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Why Take This Training?<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d3070af elementor-widget elementor-widget-text-editor\" data-id=\"d3070af\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Effectively querying database resources is critical to maintaining performance and data availability. Transact-SQL is a comprehensive solution for tracking, diagnosing, and optimizing Microsoft database resources. This training provides the expertise to configure and utilize Transact-SQL for advanced insights and operational efficiency.<\/p><p>Participants will learn how to set up automated queries, customize database solutions, and leverage analytics to improve the resilience of their data infrastructure.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d3a515f elementor-widget elementor-widget-heading\" data-id=\"d3a515f\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Skills Developed During the Training<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f68a1de elementor-widget elementor-widget-text-editor\" data-id=\"f68a1de\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol><li>Setting Up Transact-SQL<br \/>Learn how to deploy Transact-SQL to oversee the performance and health of your database resources.<\/li><li>Customizing Queries and Notifications<br \/>Master the creation of queries for key metrics and events to enable proactive data issue management.<\/li><li>Utilizing Data Analytics<br \/>Explore how to analyze telemetry data and logs for actionable insights using Transact-SQL&#8217;s powerful tools.<\/li><li>Building Custom Views<br \/>Design views that consolidate critical information and provide real-time insights into database performance.<\/li><li>Integrating with Microsoft SQL Services<br \/>Discover how to integrate Transact-SQL with other Microsoft services like SQL Server, Azure SQL Database, and Azure Synapse Analytics.<\/li><li>Implementing Best Practices in Data Querying<br \/>Gain expertise in optimizing configurations to ensure cost-effective and reliable database querying.<\/li><\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c6f5c1c elementor-widget elementor-widget-heading\" data-id=\"c6f5c1c\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Interactive, Practice-Oriented Training<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-709bec8 elementor-widget elementor-widget-text-editor\" data-id=\"709bec8\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Led by certified Microsoft experts, this course combines theoretical knowledge with practical exercises. Participants will work on real-world scenarios to apply Transact-SQL features effectively, ensuring readiness for professional challenges.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0970637 elementor-widget elementor-widget-heading\" data-id=\"0970637\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Who Should Attend?<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1f9b00c elementor-widget elementor-widget-text-editor\" data-id=\"1f9b00c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ul><li>Database developers managing Microsoft SQL resources<\/li><li>IT professionals responsible for data querying and diagnostics<\/li><li>Systems architects designing scalable and reliable database solutions<\/li><li>Anyone interested in learning advanced querying techniques for Microsoft SQL<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-00795e2 elementor-widget elementor-widget-heading\" data-id=\"00795e2\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Enhance Your Microsoft SQL Management with Transact-SQL Expertise<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ffaefbc elementor-widget elementor-widget-text-editor\" data-id=\"ffaefbc\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>The Query and modify data with Transact-SQL (DP-080T00) training equips you with the skills needed to leverage Transact-SQL for optimizing your database operations. Enroll now to master advanced querying techniques and ensure the resilience and efficiency of your Microsoft SQL environment.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-3514517 e-flex e-con-boxed e-con e-parent\" data-id=\"3514517\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-368130e elementor-widget elementor-widget-heading\" data-id=\"368130e\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Frequently Asked Questions - Transact-SQL Training (FAQ)<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-bdfffd7 elementor-widget elementor-widget-accordion\" data-id=\"bdfffd7\" data-element_type=\"widget\" data-widget_type=\"accordion.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-accordion\">\n\t\t\t\t\t\t\t<div class=\"elementor-accordion-item\">\n\t\t\t\t\t<div id=\"elementor-tab-title-1991\" class=\"elementor-tab-title\" data-tab=\"1\" role=\"button\" aria-controls=\"elementor-tab-content-1991\" aria-expanded=\"false\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon elementor-accordion-icon-left\" aria-hidden=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-closed\"><svg class=\"e-font-icon-svg e-fas-plus\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M416 208H272V64c0-17.67-14.33-32-32-32h-32c-17.67 0-32 14.33-32 32v144H32c-17.67 0-32 14.33-32 32v32c0 17.67 14.33 32 32 32h144v144c0 17.67 14.33 32 32 32h32c17.67 0 32-14.33 32-32V304h144c17.67 0 32-14.33 32-32v-32c0-17.67-14.33-32-32-32z\"><\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-opened\"><svg class=\"e-font-icon-svg e-fas-minus\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M416 208H32c-17.67 0-32 14.33-32 32v32c0 17.67 14.33 32 32 32h384c17.67 0 32-14.33 32-32v-32c0-17.67-14.33-32-32-32z\"><\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-accordion-title\" tabindex=\"0\">What does this training cover?<\/a>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t<div id=\"elementor-tab-content-1991\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"1\" role=\"region\" aria-labelledby=\"elementor-tab-title-1991\"><p>It covers deployment, configuration, queries, views, data analytics, and integration with other Microsoft SQL services.<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class=\"elementor-accordion-item\">\n\t\t\t\t\t<div id=\"elementor-tab-title-1992\" class=\"elementor-tab-title\" data-tab=\"2\" role=\"button\" aria-controls=\"elementor-tab-content-1992\" aria-expanded=\"false\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon elementor-accordion-icon-left\" aria-hidden=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-closed\"><svg class=\"e-font-icon-svg e-fas-plus\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M416 208H272V64c0-17.67-14.33-32-32-32h-32c-17.67 0-32 14.33-32 32v144H32c-17.67 0-32 14.33-32 32v32c0 17.67 14.33 32 32 32h144v144c0 17.67 14.33 32 32 32h32c17.67 0 32-14.33 32-32V304h144c17.67 0 32-14.33 32-32v-32c0-17.67-14.33-32-32-32z\"><\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-opened\"><svg class=\"e-font-icon-svg e-fas-minus\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M416 208H32c-17.67 0-32 14.33-32 32v32c0 17.67 14.33 32 32 32h384c17.67 0 32-14.33 32-32v-32c0-17.67-14.33-32-32-32z\"><\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-accordion-title\" tabindex=\"0\">Is prior experience with Microsoft SQL required?<\/a>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t<div id=\"elementor-tab-content-1992\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"2\" role=\"region\" aria-labelledby=\"elementor-tab-title-1992\"><p>Basic understanding of Microsoft SQL and database concepts is recommended but not mandatory.<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class=\"elementor-accordion-item\">\n\t\t\t\t\t<div id=\"elementor-tab-title-1993\" class=\"elementor-tab-title\" data-tab=\"3\" role=\"button\" aria-controls=\"elementor-tab-content-1993\" aria-expanded=\"false\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon elementor-accordion-icon-left\" aria-hidden=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-closed\"><svg class=\"e-font-icon-svg e-fas-plus\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M416 208H272V64c0-17.67-14.33-32-32-32h-32c-17.67 0-32 14.33-32 32v144H32c-17.67 0-32 14.33-32 32v32c0 17.67 14.33 32 32 32h144v144c0 17.67 14.33 32 32 32h32c17.67 0 32-14.33 32-32V304h144c17.67 0 32-14.33 32-32v-32c0-17.67-14.33-32-32-32z\"><\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-opened\"><svg class=\"e-font-icon-svg e-fas-minus\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M416 208H32c-17.67 0-32 14.33-32 32v32c0 17.67 14.33 32 32 32h384c17.67 0 32-14.33 32-32v-32c0-17.67-14.33-32-32-32z\"><\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-accordion-title\" tabindex=\"0\">Are hands-on exercises included?<\/a>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t<div id=\"elementor-tab-content-1993\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"3\" role=\"region\" aria-labelledby=\"elementor-tab-title-1993\"><p>Yes, the course features practical labs and real-world scenarios for applying Transact-SQL skills.<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class=\"elementor-accordion-item\">\n\t\t\t\t\t<div id=\"elementor-tab-title-1994\" class=\"elementor-tab-title\" data-tab=\"4\" role=\"button\" aria-controls=\"elementor-tab-content-1994\" aria-expanded=\"false\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon elementor-accordion-icon-left\" aria-hidden=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-closed\"><svg class=\"e-font-icon-svg e-fas-plus\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M416 208H272V64c0-17.67-14.33-32-32-32h-32c-17.67 0-32 14.33-32 32v144H32c-17.67 0-32 14.33-32 32v32c0 17.67 14.33 32 32 32h144v144c0 17.67 14.33 32 32 32h32c17.67 0 32-14.33 32-32V304h144c17.67 0 32-14.33 32-32v-32c0-17.67-14.33-32-32-32z\"><\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-opened\"><svg class=\"e-font-icon-svg e-fas-minus\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M416 208H32c-17.67 0-32 14.33-32 32v32c0 17.67 14.33 32 32 32h384c17.67 0 32-14.33 32-32v-32c0-17.67-14.33-32-32-32z\"><\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-accordion-title\" tabindex=\"0\">How does Transact-SQL improve database management?<\/a>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t<div id=\"elementor-tab-content-1994\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"4\" role=\"region\" aria-labelledby=\"elementor-tab-title-1994\"><p>It enables proactive data management, continuous performance monitoring, and advanced protection of database resources.<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class=\"elementor-accordion-item\">\n\t\t\t\t\t<div id=\"elementor-tab-title-1995\" class=\"elementor-tab-title\" data-tab=\"5\" role=\"button\" aria-controls=\"elementor-tab-content-1995\" aria-expanded=\"false\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon elementor-accordion-icon-left\" aria-hidden=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-closed\"><svg class=\"e-font-icon-svg e-fas-plus\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M416 208H272V64c0-17.67-14.33-32-32-32h-32c-17.67 0-32 14.33-32 32v144H32c-17.67 0-32 14.33-32 32v32c0 17.67 14.33 32 32 32h144v144c0 17.67 14.33 32 32 32h32c17.67 0 32-14.33 32-32V304h144c17.67 0 32-14.33 32-32v-32c0-17.67-14.33-32-32-32z\"><\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-opened\"><svg class=\"e-font-icon-svg e-fas-minus\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M416 208H32c-17.67 0-32 14.33-32 32v32c0 17.67 14.33 32 32 32h384c17.67 0 32-14.33 32-32v-32c0-17.67-14.33-32-32-32z\"><\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-accordion-title\" tabindex=\"0\">Can Transact-SQL be integrated with other tools?<\/a>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t<div id=\"elementor-tab-content-1995\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"5\" role=\"region\" aria-labelledby=\"elementor-tab-title-1995\"><p>Yes, it integrates seamlessly with SQL Server, Azure SQL Database, Azure Synapse Analytics, and other Microsoft services.<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class=\"elementor-accordion-item\">\n\t\t\t\t\t<div id=\"elementor-tab-title-1996\" class=\"elementor-tab-title\" data-tab=\"6\" role=\"button\" aria-controls=\"elementor-tab-content-1996\" aria-expanded=\"false\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon elementor-accordion-icon-left\" aria-hidden=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-closed\"><svg class=\"e-font-icon-svg e-fas-plus\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M416 208H272V64c0-17.67-14.33-32-32-32h-32c-17.67 0-32 14.33-32 32v144H32c-17.67 0-32 14.33-32 32v32c0 17.67 14.33 32 32 32h144v144c0 17.67 14.33 32 32 32h32c17.67 0 32-14.33 32-32V304h144c17.67 0 32-14.33 32-32v-32c0-17.67-14.33-32-32-32z\"><\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-opened\"><svg class=\"e-font-icon-svg e-fas-minus\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M416 208H32c-17.67 0-32 14.33-32 32v32c0 17.67 14.33 32 32 32h384c17.67 0 32-14.33 32-32v-32c0-17.67-14.33-32-32-32z\"><\/path><\/svg><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-accordion-title\" tabindex=\"0\">Does this course include best practices for data querying?<\/a>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t<div id=\"elementor-tab-content-1996\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"6\" role=\"region\" aria-labelledby=\"elementor-tab-title-1996\"><p>Absolutely, the training covers optimization strategies and best practices for effective data querying.<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t<script type=\"application\/ld+json\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@type\":\"FAQPage\",\"mainEntity\":[{\"@type\":\"Question\",\"name\":\"What does this training cover?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"<p>It covers deployment, configuration, queries, views, data analytics, and integration with other Microsoft SQL services.<\\\/p>\"}},{\"@type\":\"Question\",\"name\":\"Is prior experience with Microsoft SQL required?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"<p>Basic understanding of Microsoft SQL and database concepts is recommended but not mandatory.<\\\/p>\"}},{\"@type\":\"Question\",\"name\":\"Are hands-on exercises included?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"<p>Yes, the course features practical labs and real-world scenarios for applying Transact-SQL skills.<\\\/p>\"}},{\"@type\":\"Question\",\"name\":\"How does Transact-SQL improve database management?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"<p>It enables proactive data management, continuous performance monitoring, and advanced protection of database resources.<\\\/p>\"}},{\"@type\":\"Question\",\"name\":\"Can Transact-SQL be integrated with other tools?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"<p>Yes, it integrates seamlessly with SQL Server, Azure SQL Database, Azure Synapse Analytics, and other Microsoft services.<\\\/p>\"}},{\"@type\":\"Question\",\"name\":\"Does this course include best practices for data querying?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"<p>Absolutely, the training covers optimization strategies and best practices for effective data querying.<\\\/p>\"}}]}<\/script>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"template":"","role":[129,136],"formations":[115,114],"class_list":["post-38409","formation","type-formation","status-publish","hentry","role-cloud-administrator","role-data-specialist","formations-azure","formations-microsoft"],"_links":{"self":[{"href":"https:\/\/www.eccentrix.ca\/en\/wp-json\/wp\/v2\/formation\/38409","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.eccentrix.ca\/en\/wp-json\/wp\/v2\/formation"}],"about":[{"href":"https:\/\/www.eccentrix.ca\/en\/wp-json\/wp\/v2\/types\/formation"}],"version-history":[{"count":29,"href":"https:\/\/www.eccentrix.ca\/en\/wp-json\/wp\/v2\/formation\/38409\/revisions"}],"predecessor-version":[{"id":58545,"href":"https:\/\/www.eccentrix.ca\/en\/wp-json\/wp\/v2\/formation\/38409\/revisions\/58545"}],"wp:attachment":[{"href":"https:\/\/www.eccentrix.ca\/en\/wp-json\/wp\/v2\/media?parent=38409"}],"wp:term":[{"taxonomy":"role","embeddable":true,"href":"https:\/\/www.eccentrix.ca\/en\/wp-json\/wp\/v2\/role?post=38409"},{"taxonomy":"formations","embeddable":true,"href":"https:\/\/www.eccentrix.ca\/en\/wp-json\/wp\/v2\/formations?post=38409"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}