{"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-11-12T12:50:11","modified_gmt":"2026-11-12T12:50:11","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 cours-body reveal 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\">Training plan<\/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 cours-body reveal e-flex e-con-boxed e-con e-parent\" data-id=\"8fe5e15\" data-element_type=\"container\" id=\"toc-exclude-en\">\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 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=\"(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\/\" tabindex=\"-1\" >\n\t\t\t<div class=\"elementor-post__thumbnail\"><img 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=\"(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\/\" >\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 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=\"(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=\"(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 cours-body e-flex e-con-boxed e-con e-parent\" data-id=\"1157da4\" data-element_type=\"container\" id=\"toc-exclude-en\">\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-bcca783 elementor-widget elementor-widget-heading\" data-id=\"bcca783\" 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\">Laboratory environment (overview)<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f028785 elementor-widget elementor-widget-text-editor\" data-id=\"f028785\" 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>You will practice in a structured lab environment with guided steps to validate your progress throughout the exercises. Depending on the lab, it is usually possible to save your progress and resume the steps later, making it easier to practice between sessions.<\/p><p>To ensure a complete experience, a Microsoft 365\/Azure <i>tenant<\/i> environment may be provided to access the features required for the course scenarios (depending on the module requirements and lab conditions).<\/p><p>After the training, access to the lab remains available for a defined period. <b>Tenant access may be time-limited<\/b>, while<b> access to the virtual machines and guided steps<\/b> remains available for up to <b>180 days<\/b>.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-87f3a18 e-grid e-con-full e-con e-child\" data-id=\"87f3a18\" data-element_type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-f9d69f6 elementor-widget elementor-widget-theme-post-featured-image elementor-widget-image\" data-id=\"f9d69f6\" data-element_type=\"widget\" data-widget_type=\"theme-post-featured-image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/www.eccentrix.ca\/wp-content\/uploads\/2024\/06\/blog_and_web_publications_covers_0.png\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"A visual representation of virtual folders related to the types of cloud services - Eccentrix\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTg0NSwidXJsIjoiaHR0cHM6XC9cL3d3dy5lY2NlbnRyaXguY2FcL3dwLWNvbnRlbnRcL3VwbG9hZHNcLzIwMjRcLzA2XC9ibG9nX2FuZF93ZWJfcHVibGljYXRpb25zX2NvdmVyc18wLnBuZyJ9\">\n\t\t\t\t\t\t\t<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=\"(max-width: 300px) 100vw, 300px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">Laboratory description<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\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-0233a6f elementor-widget elementor-widget-theme-post-featured-image elementor-widget-image\" data-id=\"0233a6f\" data-element_type=\"widget\" data-widget_type=\"theme-post-featured-image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/www.eccentrix.ca\/wp-content\/uploads\/2024\/06\/blog_and_web_publications_covers_0.png\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"A visual representation of virtual folders related to the types of cloud services - Eccentrix\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTg0NSwidXJsIjoiaHR0cHM6XC9cL3d3dy5lY2NlbnRyaXguY2FcL3dwLWNvbnRlbnRcL3VwbG9hZHNcLzIwMjRcLzA2XC9ibG9nX2FuZF93ZWJfcHVibGljYXRpb25zX2NvdmVyc18wLnBuZyJ9\">\n\t\t\t\t\t\t\t<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=\"(max-width: 300px) 100vw, 300px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">Remote session opening<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\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-59fc729 elementor-widget elementor-widget-theme-post-featured-image elementor-widget-image\" data-id=\"59fc729\" data-element_type=\"widget\" data-widget_type=\"theme-post-featured-image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/www.eccentrix.ca\/wp-content\/uploads\/2024\/06\/blog_and_web_publications_covers_0.png\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"A visual representation of virtual folders related to the types of cloud services - Eccentrix\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTg0NSwidXJsIjoiaHR0cHM6XC9cL3d3dy5lY2NlbnRyaXguY2FcL3dwLWNvbnRlbnRcL3VwbG9hZHNcLzIwMjRcLzA2XC9ibG9nX2FuZF93ZWJfcHVibGljYXRpb25zX2NvdmVyc18wLnBuZyJ9\">\n\t\t\t\t\t\t\t<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=\"(max-width: 300px) 100vw, 300px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">Execution of steps<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\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<div class=\"elementor-element elementor-element-78c745c elementor-widget elementor-widget-text-editor\" data-id=\"78c745c\" 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 screenshots above are provided as examples and may vary depending on the lab version and updates.<\/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 cours-body reveal 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<\/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"],"permalink_manager":null,"_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":2,"href":"https:\/\/www.eccentrix.ca\/en\/wp-json\/wp\/v2\/formation\/38409\/revisions"}],"predecessor-version":[{"id":70408,"href":"https:\/\/www.eccentrix.ca\/en\/wp-json\/wp\/v2\/formation\/38409\/revisions\/70408"}],"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}]}}