{"id":4665,"date":"2022-02-10T20:01:05","date_gmt":"2022-02-11T02:01:05","guid":{"rendered":"https:\/\/gsb.lat\/?p=4665"},"modified":"2023-03-24T14:04:09","modified_gmt":"2023-03-24T14:04:09","slug":"20761-c-querying-data-with-transact-sql","status":"publish","type":"post","link":"https:\/\/gsb.lat\/en\/20761-c-querying-data-with-transact-sql\/","title":{"rendered":"20761-C: Querying Data with Transact-SQL"},"content":{"rendered":"\r\n<div class=\"cust-template\"><!-- Informacion 1 -->\r\n<div class=\"dp-flex-desk\">\r\n<div class=\"w-60-desk padding-10\">\r\n<h2>Description<\/h2>\r\n<p>This program has as its main objective to give students a good understanding of the Transact-SQL language that is used in all disciplines related to SQL Server; namely, database administration, database development, and business intelligence.<\/p>\r\n<\/div>\r\n<div class=\"w-40-desk padding-10 dp-flex-res\">\r\n<div class=\"mr-30\">\r\n<h2>Addressed to<\/h2>\r\n<ul>\r\n<li><i class=\"fas fa-check\"><\/i>Database administrators<\/li>\r\n<li><i class=\"fas fa-check\"><\/i>Database developers<\/li>\r\n<li><i class=\"fas fa-check\"><\/i>BI professionals.<\/li>\r\n<\/ul>\r\n<\/div>\r\n<div>\r\n<h2>Duration<\/h2>\r\n<p><i class=\"fas fa-clock\"><\/i> 35 hours<\/p>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<!-- Informacion 2 -->\r\n<div class=\"dp-flex-desk cus-mt-40\">\r\n<div class=\"blue-box\">\r\n<h2>Modalities<\/h2>\r\n<ul class=\"color-white\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"color-white\">\r\n<li><i class=\"fas fa-check mr-5\"><\/i>Face-to-face<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-light-hr\" \/>\r\n<ul class=\"color-white\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"color-white\">\r\n<li><i class=\"fas fa-check mr-5\"><\/i>Virtual live through digital platforms<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-light-hr\" \/>\r\n<ul class=\"color-white\">\r\n<li><i class=\"fas fa-check mr-5\"><\/i>on site<\/li>\r\n<\/ul>\r\n<\/div>\r\n<div class=\"blue-box\">\r\n<h2>Related Courses<\/h2>\r\n<ul class=\"color-white\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"color-white\">\r\n<li><i class=\"fas fa-check mr-5\"><\/i> 20764-C: Administering a SQL Database Infrastructure<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-light-hr\" \/>\r\n<ul class=\"color-white\">\r\n<li><i class=\"fas fa-check mr-5\"><\/i>20762-C: Developing SQL Databases<\/li>\r\n<\/ul>\r\n<\/div>\r\n<div class=\"blue-box\">\r\n<h2>It includes<\/h2>\r\n<ul class=\"color-white\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"color-white\">\r\n<li><i class=\"fas fa-check mr-5\"><\/i> 35 hours of training<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-light-hr\" \/>\r\n<ul class=\"color-white\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"color-white\">\r\n<li><i class=\"fas fa-check mr-5\"><\/i>Trained instructors<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-light-hr\" \/>\r\n<ul class=\"color-white\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"color-white\">\r\n<li><i class=\"fas fa-check mr-5\"><\/i>Participant manual in digital format<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-light-hr\" \/>\r\n<ul class=\"color-white\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"color-white\">\r\n<li><i class=\"fas fa-check mr-5\"><\/i>Proof of participation<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-light-hr\" \/>\r\n<ul class=\"color-white\">\r\n<li>\u00a0<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<!-- Temario -->\r\n<div class=\"padding-img\"><img decoding=\"async\" class=\"tam-img\" src=\"https:\/\/gsb.lat\/wp-content\/uploads\/2022\/01\/isotipo.png\" \/>\r\n<div class=\"flex-center\"><hr class=\"cust-w-100\" \/>\r\n<h3>Temary<\/h3>\r\n<hr class=\"cust-w-100\" \/><\/div>\r\n<\/div>\r\n<div class=\"dp-flex-desk flex-wrap-desk cus-mt-20\">\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Lesson 1: Introduction to Microsoft SQL Server<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>The basic architecture of SQL Server<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>SQL Server editions and versions<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Introduction to SQL Server Management Studio<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Lab : Working with SQL Server tools<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Work with SQL Server Management Studio<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Creating and organizing T-SQL scripts<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Use books online<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Lesson 2: Introduction to T-SQL Queries<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Presentation of T-SQL<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Set comprehension<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Understanding Predicate Logic<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Understanding the logical order of operations in SELECT statements<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Lab: Introduction to T-SQL Queries<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Execution of basic SELECT statements<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Running queries that filter data using predicates<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Running queries that order data using ORDER BY<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Lesson 3: Writing SELECT Queries<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Write simple SELECT statements<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Removing duplicates with DISTINCT<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Use column and table aliases<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Write simple CASE expressions<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Lab: Writing Basic SELECT Statements<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Write simple SELECT statements<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Eliminate duplicates with DISTINCT<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Use column and table aliases<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Use a simple CASE expression<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Lesson 4: Querying Multiple Tables<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Understanding joins<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Query with inner joins<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Query with outer joins<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Consultation with Cross Joins and Self Joins<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Lab : Query Multiple Tables<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Writing Queries That Use Inner Joins<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Writing queries that use inner joins of multiple tables<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Writing queries that use self-joins<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Writing queries that use outer joins<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Writing queries that use cross joins<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Lesson 5: Data Classification and Filtering<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>data classification<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Filter data with predicates<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Data filtering with TOP and OFFSET-FETCH<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Work with unknown values<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Lab: Data Classification and Filtering<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Writing queries that filter data using a WHERE clause<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Writing queries that order data using an ORDER BY clause<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Writing queries that filter data with the TOP option<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Writing queries that filter data using the OFFSET-FETCH clause<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Lesson 6: Working with SQL Server Data Types<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Introduction to SQL Server data types<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Work with character data<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Work with date and time data<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Lab : Working with SQL Server Data Types<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Write queries that return date and time data<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Write queries that use date and time functions<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Write queries that return character data<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Write queries that return character functions<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Lesson 7: Using DML to modify data<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Add data to tables<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Modify and delete data<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Generating automatic column values<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Lab : Using DML to Modify Data<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Insert records with DML<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Updating and deleting records using DML<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Lesson 8: Using built-in functions<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Write queries with built-in functions<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Use conversion functions<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Use logic functions<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Using functions to work with NULL<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Lab : Using Built-in Features<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Write queries that use conversion functions<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Write queries that use logical functions<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Write queries that test nullability<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Lesson 9: Data Grouping and Aggregation<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Use added functions<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Using the GROUP BY clause<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Filter groups with HAVING<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Lab: Data Grouping and Aggregation<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Writing queries that use the GROUP BY clause<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Write queries that use aggregate functions<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Writing queries that use different aggregate functions<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Writing queries that filter groups with the HAVING clause<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Lesson 10: Using Subqueries<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Write stand-alone subqueries<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Write correlated subqueries<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Using the EXISTS predicate with subqueries<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Lab : Using Subqueries<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Write queries that use separate subqueries<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Writing queries that use scalar and multiple-result subqueries<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Writing queries that use correlated subqueries and an EXISTS clause<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Lesson 11: Using Table Expressions<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>use views<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Using table-valued functions online<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Use derived tables<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Use common table expressions<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Lab : Using Table Expressions<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Write queries that use views<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Write queries that use derived tables<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Write queries that use common table expressions (CTEs)<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Writing queries that use inline table-valued expressions (TVFs)<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Lesson 12: Using Set Operators<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Writing queries with the UNION operator<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Using EXCEPT and INTERSECT<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Using APPLY<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Lab: Using Set Operators<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Writing queries that use UNION and UNION ALL set operators<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Writing queries that use CROSS APPLY and OUTER APPLY operators<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Write queries that use the EXCEPT and INTERSECT operators<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Lesson 13: Using the Windows Sorting, Compensation, and Aggregation Features<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Creating Windows with OVER<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Exploring Window Features<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Lab : Using Windows Ranking, Compensation, and Aggregation Features<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Write queries that use sort functions<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Write queries that use compensation functions<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Writing queries that use window aggregation functions<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Lesson 14: Grouping and Pivoting Sets<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Writing queries with PIVOT and UNPIVOT<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Work with grouping sets<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Lab: Pooling and Pivoting Sets<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Write queries that use the PIVOT operator<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Writing queries that use the UNPIVOT operator<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Writing queries that use the GROUPING SETS CUBE and ROLLUP subclauses<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Lesson 15: Executing Stored Procedures<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Query data with stored procedures<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Pass parameters to stored procedures<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Creating simple stored procedures<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Work with dynamic SQL<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div class=\"w-33-desk\">\r\n<div class=\"white-card\">\r\n<div class=\"dp-flex jc-between\">\r\n<h4>Lab : Running Stored Procedures<\/h4>\r\n<i class=\"show_btn fas fa-chevron-down ml-10 text-blue\"><\/i><\/div>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Using the EXECUTE statement to call stored procedures<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li style=\"list-style-type: none;\">\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Pass parameters to stored procedures<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<hr class=\"cus-dark-hr\" \/>\r\n<ul class=\"icon-tm dp-none\">\r\n<li><i class=\"fas fa-circle\"><\/i>Execution of stored procedures in the system<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<!-- Script -->\r\n<p><script src='https:\/\/ajax.googleapis.com\/ajax\/libs\/jquery\/3.5.1\/jquery.min.js'><\/script><script type='text\/javascript'>$(function() {'use strict';$('.show_btn').click(function() {if ($(this).hasClass('fa-chevron-down')) {$(this).parent().parent().children('ul').removeClass('dp-none');$(this).removeClass('fa-chevron-down');$(this).addClass('fa-chevron-up');} else {$(this).parent().parent().children('ul').addClass('dp-none');$(this).addClass('fa-chevron-down');$(this).removeClass('fa-chevron-up');}});});<\/script><\/p>\r\n","protected":false},"excerpt":{"rendered":"<p>Description This program has as its main objective to give students a good understanding of the Transact-SQL language that is used in all disciplines related to SQL Server; namely, database administration, database development, and business intelligence. Addressed to Database administrators Database developers BI professionals. Duration 35 hours Modalities Face-to-face Virtual live through digital platforms on&hellip;<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-4665","post","type-post","status-publish","format-standard","hentry","category-uncategorized","category-1","description-off"],"_links":{"self":[{"href":"https:\/\/gsb.lat\/en\/wp-json\/wp\/v2\/posts\/4665","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gsb.lat\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gsb.lat\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gsb.lat\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/gsb.lat\/en\/wp-json\/wp\/v2\/comments?post=4665"}],"version-history":[{"count":1,"href":"https:\/\/gsb.lat\/en\/wp-json\/wp\/v2\/posts\/4665\/revisions"}],"predecessor-version":[{"id":10484,"href":"https:\/\/gsb.lat\/en\/wp-json\/wp\/v2\/posts\/4665\/revisions\/10484"}],"wp:attachment":[{"href":"https:\/\/gsb.lat\/en\/wp-json\/wp\/v2\/media?parent=4665"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gsb.lat\/en\/wp-json\/wp\/v2\/categories?post=4665"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gsb.lat\/en\/wp-json\/wp\/v2\/tags?post=4665"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}