[et_pb_section fb_built=”1″ admin_label=”Course Hero” _builder_version=”4.16″ use_background_color_gradient=”on” background_color_gradient_stops=”#474ab6 0%|#9271f6 100%” background_color_gradient_start=”#474ab6″ background_color_gradient_end=”#9271f6″ background_image=”https:\/\/it.tct.al\/wp-content\/uploads\/2025\/04\/coding-background-texture.jpg” background_blend=”overlay” custom_padding=”100px|0px|180px|0px” animation_style=”slide” animation_direction=”top” animation_intensity_slide=”2%” locked=”off” global_colors_info=”{}”][et_pb_row column_structure=”1_2,1_2″ _builder_version=”4.16″ custom_margin=”|||” custom_width_px=”1280px” global_colors_info=”{}”][et_pb_column type=”1_2″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”4.22.2″ header_font=”|on|||” header_font_size=”42px” header_line_height=”1.3em” background_layout=”dark” custom_padding=”|||” header_font_size_tablet=”” header_font_size_phone=”” header_font_size_last_edited=”on|desktop” locked=”off” global_colors_info=”{}”]<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.22.2″ text_text_color=”#d4ccff” text_font_size=”16px” text_line_height=”1.9em” locked=”off” global_colors_info=”{}”]<\/p>\n
This course is identical to the Microsoft course and the content of this page is taken from Microsoft\u2019s official course. This course is designed to introduce students to Transact-SQL and learn by doing in practice. This course is taught 100% \u201cHands On\u201d and will make students ready for a database developer junior position. At the end of course students will attain the skills required to take Microsoft SQL Server exam 70-761.<\/span><\/p>\n [\/et_pb_text][et_pb_button button_url=”@ET-DC@eyJkeW5hbWljIjp0cnVlLCJjb250ZW50IjoicG9zdF9saW5rX3VybF9wYWdlIiwic2V0dGluZ3MiOnsicG9zdF9pZCI6Ijg0OCJ9fQ==@” button_text=”Register Now” _builder_version=”4.22.2″ _dynamic_attributes=”button_url” custom_button=”on” button_text_size=”16px” button_text_color=”#ffffff” button_bg_color=”#09e1c0″ button_border_width=”10px” button_border_color=”#09e1c0″ button_border_radius=”100px” button_letter_spacing=”1px” button_font=”|on||on|” button_icon=”E||divi||400″ button_on_hover=”off” custom_margin=”20px|||” animation_style=”zoom” animation_delay=”100ms” animation_intensity_zoom=”10%” box_shadow_style=”preset1″ box_shadow_vertical=”10px” box_shadow_blur=”50px” box_shadow_spread=”5px” box_shadow_color=”rgba(0,188,160,0.6)” button_letter_spacing_hover=”2px” saved_tabs=”all” locked=”off” global_colors_info=”{}” button_text_size__hover_enabled=”off” button_text_size__hover=”null” button_one_text_size__hover_enabled=”off” button_one_text_size__hover=”null” button_two_text_size__hover_enabled=”off” button_two_text_size__hover=”null” button_text_color__hover_enabled=”off” button_text_color__hover=”null” button_one_text_color__hover_enabled=”off” button_one_text_color__hover=”null” button_two_text_color__hover_enabled=”off” button_two_text_color__hover=”null” button_border_width__hover_enabled=”off” button_border_width__hover=”null” button_one_border_width__hover_enabled=”off” button_one_border_width__hover=”null” button_two_border_width__hover_enabled=”off” button_two_border_width__hover=”null” button_border_color__hover_enabled=”off” button_border_color__hover=”null” button_one_border_color__hover_enabled=”off” button_one_border_color__hover=”null” button_two_border_color__hover_enabled=”off” button_two_border_color__hover=”null” button_border_radius__hover_enabled=”off” button_border_radius__hover=”null” button_one_border_radius__hover_enabled=”off” button_one_border_radius__hover=”null” button_two_border_radius__hover_enabled=”off” button_two_border_radius__hover=”null” button_letter_spacing__hover_enabled=”on” button_letter_spacing__hover=”2px” button_one_letter_spacing__hover_enabled=”off” button_one_letter_spacing__hover=”null” button_two_letter_spacing__hover_enabled=”off” button_two_letter_spacing__hover=”null” button_bg_color__hover_enabled=”off” button_bg_color__hover=”null” button_one_bg_color__hover_enabled=”off” button_one_bg_color__hover=”null” button_two_bg_color__hover_enabled=”off” button_two_bg_color__hover=”null”][\/et_pb_button][\/et_pb_column][et_pb_column type=”1_2″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_image src=”https:\/\/it.tct.al\/wp-content\/uploads\/2025\/05\/coding-isometric-11.png” align_tablet=”center” align_phone=”center” align_last_edited=”on|desktop” _builder_version=”4.16″ animation_style=”zoom” animation_direction=”left” animation_intensity_zoom=”20%” global_colors_info=”{}”][\/et_pb_image][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}”][et_pb_row column_structure=”1_2,1_2″ _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” custom_padding=”0px|0px|100px|0px” global_colors_info=”{}”][et_pb_column type=”1_2″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_blurb title=”Course Details” url=”#” image=”https:\/\/it.tct.al\/wp-content\/uploads\/2025\/05\/coding-icon_12.jpg” icon_placement=”left” image_icon_width=”64px” content_max_width=”1100px” _builder_version=”4.22.2″ header_font=”|on|||” header_text_color=”#7272ff” header_line_height=”1.5em” body_text_color=”#8585bd” body_line_height=”1.9em” background_color=”#ffffff” custom_margin=”-80px|||” custom_padding=”30px|40px|30px|40px” animation_style=”zoom” animation_direction=”bottom” animation_intensity_zoom=”20%” animation_starting_opacity=”100%” box_shadow_style=”preset2″ box_shadow_horizontal=”0px” box_shadow_vertical=”0px” box_shadow_blur=”60px” box_shadow_color=”rgba(71,74,182,0.12)” image_max_width=”64px” locked=”off” global_colors_info=”{}”]<\/p>\n \ud83d\udd52 Schedule:<\/strong> Twice a week, evenings only<\/p>\n<\/li>\n \u23f1\ufe0f Duration:<\/strong> 45 hours over 9 weeks<\/p>\n<\/li>\n \ud83d\udcb6 Price:<\/strong> \u20ac300<\/p>\n<\/li>\n \ud83d\udc68\u200d\ud83c\udfeb Format:<\/strong> Instructor-led, hands-on training<\/p>\n<\/li>\n \ud83d\udce6 Includes:<\/strong> Practical exercises, course materials, and expert feedback<\/p>\n<\/li>\n<\/ul>\n [\/et_pb_blurb][\/et_pb_column][et_pb_column type=”1_2″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_blurb title=”Course Requirements” url=”#” image=”https:\/\/it.tct.al\/wp-content\/uploads\/2025\/05\/coding-icon_16.jpg” icon_placement=”left” image_icon_width=”64px” content_max_width=”1100px” _builder_version=”4.22.2″ header_font=”|on|||” header_text_color=”#7272ff” header_line_height=”1.5em” body_text_color=”#8585bd” body_line_height=”1.9em” background_color=”#ffffff” custom_margin=”-80px|||” custom_margin_tablet=”0px|||” custom_margin_phone=”” custom_margin_last_edited=”on|phone” custom_padding=”30px|40px|30px|40px” animation_style=”zoom” animation_direction=”bottom” animation_delay=”100ms” animation_intensity_zoom=”20%” animation_starting_opacity=”100%” box_shadow_style=”preset2″ box_shadow_horizontal=”0px” box_shadow_vertical=”0px” box_shadow_blur=”60px” box_shadow_color=”rgba(71,74,182,0.12)” image_max_width=”64px” locked=”off” global_colors_info=”{}”]<\/p>\n \ud83d\udcc8 Level:<\/strong> Intermediate<\/p>\n<\/li>\n \ud83e\udde0 Prerequisites:<\/strong> Basic knowledge of Microsoft Excel<\/strong> is required<\/p>\n<\/li>\n \ud83d\udc68\u200d\ud83c\udf93 Recommended for:<\/strong> Students or professionals with prior experience in data entry and spreadsheets.<\/p>\n<\/li>\n<\/ul>\n [\/et_pb_blurb][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}”][et_pb_row _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” custom_padding=”0px|0px|100px|0px” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_blurb title=”About the course” url=”#” image=”https:\/\/it.tct.al\/wp-content\/uploads\/2025\/05\/coding-icon_12.jpg” icon_placement=”left” image_icon_width=”64px” content_max_width=”1100px” _builder_version=”4.22.2″ header_font=”|on|||” header_text_color=”#7272ff” header_line_height=”1.5em” body_text_color=”#8585bd” body_line_height=”1.9em” background_color=”#ffffff” custom_margin=”-80px|||” custom_padding=”30px|40px|30px|40px” animation_style=”zoom” animation_direction=”bottom” animation_intensity_zoom=”20%” animation_starting_opacity=”100%” box_shadow_style=”preset2″ box_shadow_horizontal=”0px” box_shadow_vertical=”0px” box_shadow_blur=”60px” box_shadow_color=”rgba(71,74,182,0.12)” image_max_width=”64px” locked=”off” global_colors_info=”{}”]<\/p>\n This course is identical to the Microsoft course and the content of this page is taken from Microsoft\u2019s official course. This course is designed to introduce students to Transact-SQL and learn by doing in practice. This course is taught 100% \u201cHands On\u201d and will make students ready for a database developer junior position. At the end of course students will attain the skills required to take Microsoft SQL Server exam 70-761.<\/span><\/p>\n [\/et_pb_blurb][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ specialty=”on” padding_top_2=”0px” admin_label=”Course Chapters” _builder_version=”4.16″ custom_margin=”|||” custom_padding=”0px||120px|” hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″][et_pb_column type=”2_3″ specialty_columns=”2″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” parallax__hover=”off” parallax_method__hover=”on” custom_padding__hover=”|||”][et_pb_row_inner use_custom_gutter=”on” gutter_width=”4″ _builder_version=”4.16″ custom_margin=”-80px|||” custom_padding=”0px|||” global_colors_info=”{}”][et_pb_column_inner saved_specialty_column_type=”2_3″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” parallax__hover=”off” parallax_method__hover=”on” custom_padding__hover=”|||”][et_pb_blurb title=”Module 1: Introduction to Microsoft SQL Server” url=”#” image=”https:\/\/it.tct.al\/wp-content\/uploads\/2025\/04\/coding-icon_4.jpg” icon_placement=”left” image_icon_width=”64px” content_max_width=”1100px” admin_label=”Chapter” _builder_version=”4.16″ header_font=”|on|||” header_text_color=”#2e2545″ header_line_height=”1.5em” body_text_color=”#8585bd” body_font_size=”16px” body_line_height=”1.9em” background_color=”#ffffff” custom_margin=”|||” custom_padding=”30px|40px|30px|40px” animation_style=”zoom” animation_direction=”bottom” animation_intensity_zoom=”20%” animation_starting_opacity=”100%” box_shadow_style=”preset2″ box_shadow_horizontal=”0px” box_shadow_vertical=”0px” box_shadow_blur=”60px” box_shadow_color=”rgba(71,74,182,0.12)” image_max_width=”64px” locked=”off” global_colors_info=”{}”]<\/p>\n This module introduces SQL Server, the versions of SQL Server, including cloud versions, and how to connect to SQL Server using SQL Server Management Studio.<\/p>\n Lessons<\/strong><\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 The Basic Architecture of SQL Server<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SQL Server Editions and Versions<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Getting Started with SQL Server Management Studio<\/p>\n Lab : Working with SQL Server Tools<\/strong><\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Working with SQL Server Management Studio<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Creating and Organizing T-SQL Scripts<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Using Books Online<\/p>\n After completing this module, you will be able to:<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Describe relational databases and Transact-SQL queries.<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Describe the on-premise and cloud-based editions and versions of SQL Server.<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Describe how to use SQL Server Management Studio (SSMS) to connect to an instance of SQL Server, explore the databases contained in the instance, and work with script files that contain T-SQL queries.<\/p>\n [\/et_pb_blurb][et_pb_blurb title=”Module 2: Introduction to T-SQL Querying” url=”#” image=”https:\/\/it.tct.al\/wp-content\/uploads\/2025\/05\/coding-icon_12.jpg” icon_placement=”left” image_icon_width=”64px” content_max_width=”1100px” admin_label=”Chapter” _builder_version=”4.16″ header_font=”|on|||” header_text_color=”#2e2545″ header_line_height=”1.5em” body_text_color=”#8585bd” body_font_size=”16px” body_line_height=”1.9em” background_color=”#ffffff” custom_margin=”|||” custom_padding=”30px|40px|30px|40px” animation_style=”zoom” animation_direction=”bottom” animation_intensity_zoom=”20%” animation_starting_opacity=”100%” box_shadow_style=”preset2″ box_shadow_horizontal=”0px” box_shadow_vertical=”0px” box_shadow_blur=”60px” box_shadow_color=”rgba(71,74,182,0.12)” image_max_width=”64px” locked=”off” global_colors_info=”{}”]<\/p>\n This module describes the elements of T-SQL and their role in writing queries. Describe the use of sets in SQL Server. Describe the use of predicate logic in SQL Server. Describe the logical order of operations in SELECT statements.<\/p>\n Lessons<\/strong><\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Introducing T-SQL<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Understanding Sets<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Understanding Predicate Logic<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Understanding the Logical Order of Operations in SELECT statements<\/p>\n Lab : Introduction to T-SQL Querying<\/strong><\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Executing Basic SELECT Statements<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Executing Queries that Filter Data using Predicates<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Executing Queries That Sort Data Using ORDER BY<\/p>\n After completing this module, you will be able to:<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Describe the role of T-SQL in writing SELECT statements.<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Describe the elements of the T-SQL language and which elements will be useful in writing queries.<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Describe the concepts of the set theory, one of the mathematical underpinnings of relational databases, and to help you apply it to how you think about querying SQL Server<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Describe predicate logic and examine its application to querying SQL Server.<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Explain the elements of a SELECT statement, delineate the order in which the elements are evaluated, and then apply this understanding to a practical approach to writing queries.<\/p>\n [\/et_pb_blurb][et_pb_blurb title=”Module 3: Writing SELECT Queries ” url=”#” image=”https:\/\/it.tct.al\/wp-content\/uploads\/2025\/04\/coding-iconArtboard-19-copy-9.jpg” icon_placement=”left” image_icon_width=”64px” content_max_width=”1100px” admin_label=”Chapter” _builder_version=”4.16″ header_font=”|on|||” header_text_color=”#2e2545″ header_line_height=”1.5em” body_text_color=”#8585bd” body_font_size=”16px” body_line_height=”1.9em” background_color=”#ffffff” custom_margin=”|||” custom_padding=”30px|40px|30px|40px” animation_style=”zoom” animation_direction=”bottom” animation_intensity_zoom=”20%” animation_starting_opacity=”100%” box_shadow_style=”preset2″ box_shadow_horizontal=”0px” box_shadow_vertical=”0px” box_shadow_blur=”60px” box_shadow_color=”rgba(71,74,182,0.12)” image_max_width=”64px” locked=”off” global_colors_info=”{}”]<\/p>\n This module introduces the fundamentals of the SELECT statement, focusing on queries against a single table.<\/p>\n Lessons<\/strong><\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Writing Simple SELECT Statements<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Eliminating Duplicates with DISTINCT<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Using Column and Table Aliases<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Writing Simple CASE Expressions<\/p>\n Lab : Writing Basic SELECT Statements<\/strong><\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Writing Simple SELECT Statements<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Eliminating Duplicates Using DISTINCT<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Using Column and Table Aliases<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Using a Simple CASE Expression<\/p>\n After completing this module, you will be able to:<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Describe the structure and format of the SELECT statement, as well as enhancements that will add functionality and readability to your queries<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Describe how to eliminate duplicates using the DISTINCT clause<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Describe the use of column and table aliases<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Understand and use CASE expressions<\/p>\n [\/et_pb_blurb][et_pb_blurb title=”Module 4: Querying Multiple Tables” url=”#” image=”https:\/\/it.tct.al\/wp-content\/uploads\/2025\/05\/coding-icon_16.jpg” icon_placement=”left” image_icon_width=”64px” content_max_width=”1100px” admin_label=”Chapter” _builder_version=”4.22.2″ header_font=”|on|||” header_text_color=”#2e2545″ header_line_height=”1.5em” body_text_color=”#8585bd” body_font_size=”16px” body_line_height=”1.9em” background_color=”#ffffff” custom_margin=”|||” custom_padding=”30px|40px|30px|40px” animation_style=”zoom” animation_direction=”bottom” animation_intensity_zoom=”20%” animation_starting_opacity=”100%” box_shadow_style=”preset2″ box_shadow_horizontal=”0px” box_shadow_vertical=”0px” box_shadow_blur=”60px” box_shadow_color=”rgba(71,74,182,0.12)” image_max_width=”64px” locked=”off” global_colors_info=”{}”]<\/p>\n This module describes how to write queries that combine data from multiple sources in Microsoft SQL Server.<\/p>\n Lessons<\/strong><\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Understanding Joins<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Querying with Inner Joins<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Querying with Outer Joins<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Querying with Cross Joins and Self Joins<\/p>\n Lab : Querying Multiple Tables<\/strong><\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Writing Queries that use Inner Joins<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Writing Queries that use Multiple-Table Inner Joins<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Writing Queries that use Self-Joins<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Writing Queries that use Outer Joins<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Writing Queries that use Cross Joins<\/p>\n After completing this module, you will be able to:<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Explain the fundamentals of joins in SQL Server<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Write inner join queries<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Write queries that use outer joins<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Use additional join types<\/p>\n [\/et_pb_blurb][et_pb_blurb title=”Module 5: Sorting and Filtering Data” url=”#” image=”https:\/\/it.tct.al\/wp-content\/uploads\/2025\/04\/coding-iconArtboard-19-copy-8.jpg” icon_placement=”left” image_icon_width=”64px” content_max_width=”1100px” admin_label=”Chapter” _builder_version=”4.16″ header_font=”|on|||” header_text_color=”#2e2545″ header_line_height=”1.5em” body_text_color=”#8585bd” body_font_size=”16px” body_line_height=”1.9em” background_color=”#ffffff” custom_margin=”|||” custom_padding=”30px|40px|30px|40px” animation_style=”zoom” animation_direction=”bottom” animation_intensity_zoom=”20%” animation_starting_opacity=”100%” box_shadow_style=”preset2″ box_shadow_horizontal=”0px” box_shadow_vertical=”0px” box_shadow_blur=”60px” box_shadow_color=”rgba(71,74,182,0.12)” image_max_width=”64px” locked=”off” global_colors_info=”{}”]<\/p>\n This module describes how to implement sorting and filtering.<\/p>\n Lessons<\/strong><\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Sorting Data<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Filtering Data with Predicates<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Filtering Data with TOP and OFFSET-FETCH<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Working with Unknown Values<\/p>\n Lab : Sorting and Filtering Data<\/strong><\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Writing Queries that Filter Data using a WHERE Clause<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Writing Queries that Sort Data Using an ORDER BY Clause<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Writing Queries that Filter Data Using the TOP Option<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Write Queries that filter data using the OFFSET-FETCH clause<\/p>\n After completing this module, you will be able to:<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Explain how to add an ORDER BY clause to your queries to control the order of rows displayed in your query\u2019s output<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Explain how to construct WHERE clauses to filter out rows that do not match the predicate.<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Explain how to limit ranges of rows in the SELECT clause using a TOP option.<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Explain how to limit ranges of rows using the OFFSET-FETCH option of an ORDER BY clause.<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Explain how three-valued logic accounts for unknown and missing values, how SQL Server uses NULL to mark missing values, and how to test for NULL in your queries.<\/p>\n [\/et_pb_blurb][et_pb_blurb title=”Module 6: Working with SQL Server Data Types” url=”#” image=”https:\/\/it.tct.al\/wp-content\/uploads\/2025\/04\/coding-iconArtboard-19-copy-8.jpg” icon_placement=”left” image_icon_width=”64px” content_max_width=”1100px” admin_label=”Chapter” _builder_version=”4.22.2″ header_font=”|on|||” header_text_color=”#2e2545″ header_line_height=”1.5em” body_text_color=”#8585bd” body_font_size=”16px” body_line_height=”1.9em” background_color=”#ffffff” custom_margin=”|||” custom_padding=”30px|40px|30px|40px” animation_style=”zoom” animation_direction=”bottom” animation_intensity_zoom=”20%” animation_starting_opacity=”100%” hover_enabled=”0″ box_shadow_style=”preset2″ box_shadow_horizontal=”0px” box_shadow_vertical=”0px” box_shadow_blur=”60px” box_shadow_color=”rgba(71,74,182,0.12)” image_max_width=”64px” locked=”off” global_colors_info=”{}” sticky_enabled=”0″]<\/p>\n This module introduces the data types SQL Server uses to store data.<\/p>\n Lessons<\/strong><\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Introducing SQL Server Data Types<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Working with Character Data<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Working with Date and Time Data<\/p>\n Lab : Working with SQL Server Data Types<\/strong><\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Writing Queries that Return Date and Time Data<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Writing Queries that use Date and Time Functions<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Writing Queries That Return Character Data<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Writing Queries That Return Character Functions<\/p>\n After completing this module, you will be able to:<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Explore many of the data types SQL Server uses to store data and how data types are converted between types<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Explain the SQL Server character-based data types, how character comparisons work, and some common functions you may find useful in your queries<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Describe data types that are used to store temporal data, how to enter dates and times so they will be properly parsed by SQL Server, and how to manipulate dates and times with built-in functions.<\/p>\n [\/et_pb_blurb][et_pb_blurb title=”Module 7: Using DML to Modify Data” url=”#” image=”https:\/\/it.tct.al\/wp-content\/uploads\/2025\/04\/coding-iconArtboard-19-copy-8.jpg” icon_placement=”left” image_icon_width=”64px” content_max_width=”1100px” admin_label=”Chapter” _builder_version=”4.22.2″ header_font=”|on|||” header_text_color=”#2e2545″ header_line_height=”1.5em” body_text_color=”#8585bd” body_font_size=”16px” body_line_height=”1.9em” background_color=”#ffffff” custom_margin=”|||” custom_padding=”30px|40px|30px|40px” animation_style=”zoom” animation_direction=”bottom” animation_intensity_zoom=”20%” animation_starting_opacity=”100%” hover_enabled=”0″ box_shadow_style=”preset2″ box_shadow_horizontal=”0px” box_shadow_vertical=”0px” box_shadow_blur=”60px” box_shadow_color=”rgba(71,74,182,0.12)” image_max_width=”64px” locked=”off” global_colors_info=”{}” sticky_enabled=”0″]<\/p>\n This module describes how to create DML queries, and why you would want to.<\/p>\n Lessons<\/strong><\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Adding Data to Tables<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Modifying and Removing Data<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Generating automatic column values<\/p>\n Lab : Using DML to Modify Data<\/strong><\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Inserting Records with DML<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Updating and Deleting Records Using DML<\/p>\n After completing this module, you will be able to:<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Use INSERT and SELECT INTO statements<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Use UPDATE, MERGE, DELETE, and TRUNCATE.<\/p>\n [\/et_pb_blurb][et_pb_blurb title=”Module 8: Using Built-In Function” url=”#” image=”https:\/\/it.tct.al\/wp-content\/uploads\/2025\/04\/coding-iconArtboard-19-copy-8.jpg” icon_placement=”left” image_icon_width=”64px” content_max_width=”1100px” admin_label=”Chapter” _builder_version=”4.22.2″ header_font=”|on|||” header_text_color=”#2e2545″ header_line_height=”1.5em” body_text_color=”#8585bd” body_font_size=”16px” body_line_height=”1.9em” background_color=”#ffffff” custom_margin=”|||” custom_padding=”30px|40px|30px|40px” animation_style=”zoom” animation_direction=”bottom” animation_intensity_zoom=”20%” animation_starting_opacity=”100%” hover_enabled=”0″ box_shadow_style=”preset2″ box_shadow_horizontal=”0px” box_shadow_vertical=”0px” box_shadow_blur=”60px” box_shadow_color=”rgba(71,74,182,0.12)” image_max_width=”64px” locked=”off” global_colors_info=”{}” sticky_enabled=”0″]<\/p>\n This module introduces some of the many built in functions in SQL Server.<\/p>\n Lessons<\/strong><\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Writing Queries with Built-In Functions<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Using Conversion Functions<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Using Logical Functions<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Using Functions to Work with NULL<\/p>\n Lab : Using Built-In Functions<\/strong><\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Writing Queries That Use Conversion Functions<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Writing Queries that use Logical Functions<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Writing Queries that Test for Nullability<\/p>\n After completing this module, you will be able to:<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Describe the types of functions provided by SQL Server, and then focus on working with scalar functions<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Explain how to explicitly convert data between types using several SQL Server functions<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Describe how to use logical functions that evaluate an expression and return a scalar result.<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Describe additional functions for working with NULL<\/p>\n [\/et_pb_blurb][et_pb_blurb title=”Module 9: Grouping and Aggregating Data” url=”#” image=”https:\/\/it.tct.al\/wp-content\/uploads\/2025\/04\/coding-iconArtboard-19-copy-8.jpg” icon_placement=”left” image_icon_width=”64px” content_max_width=”1100px” admin_label=”Chapter” _builder_version=”4.22.2″ header_font=”|on|||” header_text_color=”#2e2545″ header_line_height=”1.5em” body_text_color=”#8585bd” body_font_size=”16px” body_line_height=”1.9em” background_color=”#ffffff” custom_margin=”|||” custom_padding=”30px|40px|30px|40px” animation_style=”zoom” animation_direction=”bottom” animation_intensity_zoom=”20%” animation_starting_opacity=”100%” hover_enabled=”0″ box_shadow_style=”preset2″ box_shadow_horizontal=”0px” box_shadow_vertical=”0px” box_shadow_blur=”60px” box_shadow_color=”rgba(71,74,182,0.12)” image_max_width=”64px” locked=”off” global_colors_info=”{}” sticky_enabled=”0″]<\/p>\n This module describes how to use aggregate functions.<\/p>\n Lessons<\/strong><\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Using Aggregate Functions<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Using the GROUP BY Clause<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Filtering Groups with HAVING<\/p>\n Lab : Grouping and Aggregating Data<\/strong><\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Writing Queries That Use the GROUP BY Clause<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Writing Queries that Use Aggregate Functions<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Writing Queries that Use Distinct Aggregate Functions<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Writing Queries that Filter Groups with the HAVING Clause<\/p>\n After completing this module, you will be able to:<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Describe the built-in aggregate function in SQL Server and write queries using it.<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Write queries that separate rows using the GROUP BY clause.<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Write queries that use the HAVING clause to filter groups.<\/p>\n [\/et_pb_blurb][et_pb_blurb title=”Module 10: Using Sub-Queries” url=”#” image=”https:\/\/it.tct.al\/wp-content\/uploads\/2025\/04\/coding-iconArtboard-19-copy-8.jpg” icon_placement=”left” image_icon_width=”64px” content_max_width=”1100px” admin_label=”Chapter” _builder_version=”4.22.2″ header_font=”|on|||” header_text_color=”#2e2545″ header_line_height=”1.5em” body_text_color=”#8585bd” body_font_size=”16px” body_line_height=”1.9em” background_color=”#ffffff” custom_margin=”|||” custom_padding=”30px|40px|30px|40px” animation_style=”zoom” animation_direction=”bottom” animation_intensity_zoom=”20%” animation_starting_opacity=”100%” hover_enabled=”0″ box_shadow_style=”preset2″ box_shadow_horizontal=”0px” box_shadow_vertical=”0px” box_shadow_blur=”60px” box_shadow_color=”rgba(71,74,182,0.12)” image_max_width=”64px” locked=”off” global_colors_info=”{}” sticky_enabled=”0″]<\/p>\n This module describes several types of subquery and how and when to use them.<\/p>\n Lessons<\/strong><\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Writing Self-Contained Subqueries<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Writing Correlated Subqueries<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Using the EXISTS Predicate with Subqueries<\/p>\n Lab : Using Subqueries<\/strong><\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Writing Queries That Use Self-Contained Subqueries<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Writing Queries That Use Scalar and Multi-Result Subqueries<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Writing Queries That Use Correlated Subqueries and an EXISTS Clause<\/p>\n After completing this module, you will be able to:<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Describe where subqueries may be used in a SELECT statement.<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Write queries that use correlated subqueries in a SELECT statement<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Write queries that use EXISTS predicates in a WHERE clause to test for the existence of qualifying rows<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Use the EXISTS predicate to efficiently check for the existence of rows in a subquery.<\/p>\n [\/et_pb_blurb][et_pb_blurb title=”Module 11: Using Table Expressions” url=”#” image=”https:\/\/it.tct.al\/wp-content\/uploads\/2025\/04\/coding-iconArtboard-19-copy-8.jpg” icon_placement=”left” image_icon_width=”64px” content_max_width=”1100px” admin_label=”Chapter” _builder_version=”4.22.2″ header_font=”|on|||” header_text_color=”#2e2545″ header_line_height=”1.5em” body_text_color=”#8585bd” body_font_size=”16px” body_line_height=”1.9em” background_color=”#ffffff” custom_margin=”|||” custom_padding=”30px|40px|30px|40px” animation_style=”zoom” animation_direction=”bottom” animation_intensity_zoom=”20%” animation_starting_opacity=”100%” hover_enabled=”0″ box_shadow_style=”preset2″ box_shadow_horizontal=”0px” box_shadow_vertical=”0px” box_shadow_blur=”60px” box_shadow_color=”rgba(71,74,182,0.12)” image_max_width=”64px” locked=”off” global_colors_info=”{}” sticky_enabled=”0″]<\/p>\n Previously in this course, you learned about using subqueries as an expression that returned results to an outer calling query. Like subqueries, table expressions are query expressions, but table expressions extend this idea by allowing you to name them and to work with their results as you would work with data in any valid relational table. Microsoft SQL Server supports four types of table expressions: derived tables, common table expression (CTEs), views, and inline table-valued functions (TVFs). In this module, you will learn to work with these forms of table expressions and learn how to use them to help create a modular approach to writing queries.<\/p>\n Lessons<\/strong><\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Using Views<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Using Inline Table-Valued Functions<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Using Derived Tables<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Using Common Table Expressions<\/p>\n Lab : Using Table Expressions<\/strong><\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Writing Queries That Use Views<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Writing Queries That Use Derived Tables<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Writing Queries That Use Common Table Expressions (CTEs)<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Writing Queries That Use Inline Table-Valued Expressions (TVFs)<\/p>\n After completing this module, you will be able to:<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Write queries that return results from views.<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Use the CREATE FUNCTION statement to create simple inline TVFs.<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Write queries that create and retrieve results from derived tables.<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Write queries that create CTEs and return results from the table expression.<\/p>\n [\/et_pb_blurb][et_pb_blurb title=”Module 12: Using Set Operators” url=”#” image=”https:\/\/it.tct.al\/wp-content\/uploads\/2025\/04\/coding-iconArtboard-19-copy-8.jpg” icon_placement=”left” image_icon_width=”64px” content_max_width=”1100px” admin_label=”Chapter” _builder_version=”4.22.2″ header_font=”|on|||” header_text_color=”#2e2545″ header_line_height=”1.5em” body_text_color=”#8585bd” body_font_size=”16px” body_line_height=”1.9em” background_color=”#ffffff” custom_margin=”|||” custom_padding=”30px|40px|30px|40px” animation_style=”zoom” animation_direction=”bottom” animation_intensity_zoom=”20%” animation_starting_opacity=”100%” hover_enabled=”0″ box_shadow_style=”preset2″ box_shadow_horizontal=”0px” box_shadow_vertical=”0px” box_shadow_blur=”60px” box_shadow_color=”rgba(71,74,182,0.12)” image_max_width=”64px” locked=”off” global_colors_info=”{}” sticky_enabled=”0″]<\/p>\n This module introduces how to use the set operators UNION, INTERSECT, and EXCEPT to compare rows between two input sets.<\/p>\n Lessons<\/strong><\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Writing Queries with the UNION operator<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Using EXCEPT and INTERSECT<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Using APPLY<\/p>\n Lab : Using Set Operators<\/strong><\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Writing Queries That Use UNION Set Operators and UNION ALL<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Writing Queries That Use CROSS APPLY and OUTER APPLY Operators<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Writing Queries That Use the EXCEPT and INTERSECT Operators<\/p>\n After completing this module, students will be able to:<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Write queries that use UNION to combine input sets.<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Write queries that use UNION ALL to combine input sets<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Write queries that use the EXCEPT operator to return only rows in one set but not another.<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Write queries that use the INTERSECT operator to return only rows that are present in both sets<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Write queries using the CROSS APPLY operator.<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Write queries using the OUTER APPLY operator<\/p>\n [\/et_pb_blurb][et_pb_blurb title=”Module 12: Using Set Operators” url=”#” image=”https:\/\/it.tct.al\/wp-content\/uploads\/2025\/04\/coding-iconArtboard-19-copy-8.jpg” icon_placement=”left” image_icon_width=”64px” content_max_width=”1100px” admin_label=”Chapter” _builder_version=”4.22.2″ header_font=”|on|||” header_text_color=”#2e2545″ header_line_height=”1.5em” body_text_color=”#8585bd” body_font_size=”16px” body_line_height=”1.9em” background_color=”#ffffff” custom_margin=”|||” custom_padding=”30px|40px|30px|40px” animation_style=”zoom” animation_direction=”bottom” animation_intensity_zoom=”20%” animation_starting_opacity=”100%” hover_enabled=”0″ box_shadow_style=”preset2″ box_shadow_horizontal=”0px” box_shadow_vertical=”0px” box_shadow_blur=”60px” box_shadow_color=”rgba(71,74,182,0.12)” image_max_width=”64px” locked=”off” global_colors_info=”{}” sticky_enabled=”0″]<\/p>\n This module introduces how to use the set operators UNION, INTERSECT, and EXCEPT to compare rows between two input sets.<\/p>\n Lessons<\/strong><\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Writing Queries with the UNION operator<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Using EXCEPT and INTERSECT<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Using APPLY<\/p>\n Lab : Using Set Operators<\/strong><\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Writing Queries That Use UNION Set Operators and UNION ALL<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Writing Queries That Use CROSS APPLY and OUTER APPLY Operators<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Writing Queries That Use the EXCEPT and INTERSECT Operators<\/p>\n After completing this module, students will be able to:<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Write queries that use UNION to combine input sets.<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Write queries that use UNION ALL to combine input sets<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Write queries that use the EXCEPT operator to return only rows in one set but not another.<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Write queries that use the INTERSECT operator to return only rows that are present in both sets<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Write queries using the CROSS APPLY operator.<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Write queries using the OUTER APPLY operator<\/p>\n [\/et_pb_blurb][et_pb_blurb title=”Module 13: Using Windows Ranking, Offset, and Aggregate Functions” url=”#” image=”https:\/\/it.tct.al\/wp-content\/uploads\/2025\/04\/coding-iconArtboard-19-copy-8.jpg” icon_placement=”left” image_icon_width=”64px” content_max_width=”1100px” admin_label=”Chapter” _builder_version=”4.22.2″ header_font=”|on|||” header_text_color=”#2e2545″ header_line_height=”1.5em” body_text_color=”#8585bd” body_font_size=”16px” body_line_height=”1.9em” background_color=”#ffffff” custom_margin=”|||” custom_padding=”30px|40px|30px|40px” animation_style=”zoom” animation_direction=”bottom” animation_intensity_zoom=”20%” animation_starting_opacity=”100%” hover_enabled=”0″ box_shadow_style=”preset2″ box_shadow_horizontal=”0px” box_shadow_vertical=”0px” box_shadow_blur=”60px” box_shadow_color=”rgba(71,74,182,0.12)” image_max_width=”64px” locked=”off” global_colors_info=”{}” sticky_enabled=”0″]<\/p>\n This module describes the benefits to using window functions. Restrict window functions to rows defined in an OVER clause, including partitions and frames. Write queries that use window functions to operate on a window of rows and return ranking, aggregation, and offset comparison results.<\/p>\n Lessons<\/strong><\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Creating Windows with OVER<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Exploring Window Functions<\/p>\n Lab : Using Windows Ranking, Offset, and Aggregate Functions<\/strong><\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Writing Queries that use Ranking Functions<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Writing Queries that use Offset Functions<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Writing Queries that use Window Aggregate Functions<\/p>\n After completing this module, students will be able to:<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Describe the T-SQL components used to define windows, and the relationships between them.<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Write queries that use the OVER clause, with partitioning, ordering, and framing to define windows<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Write queries that use window aggregate functions.<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Write queries that use window ranking functions.<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Write queries that use window offset functions<\/p>\n [\/et_pb_blurb][et_pb_blurb title=”Module 14: Pivoting and Grouping Sets” url=”#” image=”https:\/\/it.tct.al\/wp-content\/uploads\/2025\/04\/coding-iconArtboard-19-copy-8.jpg” icon_placement=”left” image_icon_width=”64px” content_max_width=”1100px” admin_label=”Chapter” _builder_version=”4.22.2″ header_font=”|on|||” header_text_color=”#2e2545″ header_line_height=”1.5em” body_text_color=”#8585bd” body_font_size=”16px” body_line_height=”1.9em” background_color=”#ffffff” custom_margin=”|||” custom_padding=”30px|40px|30px|40px” animation_style=”zoom” animation_direction=”bottom” animation_intensity_zoom=”20%” animation_starting_opacity=”100%” hover_enabled=”0″ box_shadow_style=”preset2″ box_shadow_horizontal=”0px” box_shadow_vertical=”0px” box_shadow_blur=”60px” box_shadow_color=”rgba(71,74,182,0.12)” image_max_width=”64px” locked=”off” global_colors_info=”{}” sticky_enabled=”0″]<\/p>\n This module describes write queries that pivot and unpivot result sets. Write queries that specify multiple groupings with grouping sets<\/p>\n Lessons<\/strong><\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Writing Queries with PIVOT and UNPIVOT<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Working with Grouping Sets<\/p>\n Lab : Pivoting and Grouping Sets<\/strong><\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Writing Queries that use the PIVOT Operator<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Writing Queries that use the UNPIVOT Operator<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Writing Queries that use the GROUPING SETS CUBE and ROLLUP Subclauses<\/p>\n After completing this module, students will be able to:<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Describe how pivoting data can be used in T-SQL queries.<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Write queries that pivot data from rows to columns using the PIVOT operator.<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Write queries that unpivot data from columns back to rows using the UNPIVOT operator.<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Write queries using the GROUPING SETS subclause.<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Write queries that use ROLLUP AND CUBE.<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Write queries that use the GROUPING_ID function.<\/p>\n [\/et_pb_blurb][et_pb_blurb title=”Module 15: Executing Stored Procedures” url=”#” image=”https:\/\/it.tct.al\/wp-content\/uploads\/2025\/04\/coding-iconArtboard-19-copy-8.jpg” icon_placement=”left” image_icon_width=”64px” content_max_width=”1100px” admin_label=”Chapter” _builder_version=”4.22.2″ header_font=”|on|||” header_text_color=”#2e2545″ header_line_height=”1.5em” body_text_color=”#8585bd” body_font_size=”16px” body_line_height=”1.9em” background_color=”#ffffff” custom_margin=”|||” custom_padding=”30px|40px|30px|40px” animation_style=”zoom” animation_direction=”bottom” animation_intensity_zoom=”20%” animation_starting_opacity=”100%” hover_enabled=”0″ box_shadow_style=”preset2″ box_shadow_horizontal=”0px” box_shadow_vertical=”0px” box_shadow_blur=”60px” box_shadow_color=”rgba(71,74,182,0.12)” image_max_width=”64px” locked=”off” global_colors_info=”{}” sticky_enabled=”0″]<\/p>\n This module describes how to return results by executing stored procedures. Pass parameters to procedures. Create simple stored procedures that encapsulate a SELECT statement. Construct and execute dynamic SQL with EXEC and sp_executesql.<\/p>\n Lessons<\/strong><\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Querying Data with Stored Procedures<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Passing Parameters to Stored procedures<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Creating Simple Stored Procedures<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Working with Dynamic SQL<\/p>\n Lab : Executing Stored Procedures<\/strong><\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Using the EXECUTE statement to Invoke Stored Procedures<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Passing Parameters to Stored procedures<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Executing System Stored Procedures<\/p>\n After completing this module, students will be able to:<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Describe stored procedures and their use.<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Write T-SQL statements that execute stored procedures to return data.<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Write EXECUTE statements that pass input parameters to stored procedures.<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Write T-SQL batches that prepare output parameters and execute stored procedures.<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Use the CREATE PROCEDURE statement to write a stored procedure.<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Create a stored procedure that accepts input parameters.<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Describe how T-SQL can be dynamically constructed.<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Write queries that use dynamic SQL.<\/p>\n [\/et_pb_blurb][et_pb_blurb title=”Module 16: Programming with T-SQL” url=”#” image=”https:\/\/it.tct.al\/wp-content\/uploads\/2025\/04\/coding-iconArtboard-19-copy-8.jpg” icon_placement=”left” image_icon_width=”64px” content_max_width=”1100px” admin_label=”Chapter” _builder_version=”4.22.2″ header_font=”|on|||” header_text_color=”#2e2545″ header_line_height=”1.5em” body_text_color=”#8585bd” body_font_size=”16px” body_line_height=”1.9em” background_color=”#ffffff” custom_margin=”|||” custom_padding=”30px|40px|30px|40px” animation_style=”zoom” animation_direction=”bottom” animation_intensity_zoom=”20%” animation_starting_opacity=”100%” hover_enabled=”0″ box_shadow_style=”preset2″ box_shadow_horizontal=”0px” box_shadow_vertical=”0px” box_shadow_blur=”60px” box_shadow_color=”rgba(71,74,182,0.12)” image_max_width=”64px” locked=”off” global_colors_info=”{}” sticky_enabled=”0″]<\/p>\n This module describes how to enhance your T-SQL code with programming elements.<\/p>\n Lessons<\/strong><\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 T-SQL Programming Elements<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Controlling Program Flow<\/p>\n Lab : Programming with T-SQL<\/strong><\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Declaring Variables and Delimiting Batches<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Using Control-Of-Flow Elements<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Using Variables in a Dynamic SQL Statement<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Using Synonyms<\/p>\n After completing this module, students will be able to:<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Describe how Microsoft SQL Server treats collections of statements as batches.<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Create and submit batches of T-SQL code for execution by SQL Server.<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Describe how SQL Server stores temporary objects as variables.<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Write code that declares and assigns variables.<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Create and invoke synonyms<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Describe the control-of-flow elements in T-SQL.<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Write T-SQL code using IF\u2026ELSE blocks.<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Write T-SQL code that uses WHILE.<\/p>\n [\/et_pb_blurb][et_pb_blurb title=”Module 17: Implementing Error Handling” url=”#” image=”https:\/\/it.tct.al\/wp-content\/uploads\/2025\/04\/coding-iconArtboard-19-copy-8.jpg” icon_placement=”left” image_icon_width=”64px” content_max_width=”1100px” admin_label=”Chapter” _builder_version=”4.22.2″ header_font=”|on|||” header_text_color=”#2e2545″ header_line_height=”1.5em” body_text_color=”#8585bd” body_font_size=”16px” body_line_height=”1.9em” background_color=”#ffffff” custom_margin=”|||” custom_padding=”30px|40px|30px|40px” animation_style=”zoom” animation_direction=”bottom” animation_intensity_zoom=”20%” animation_starting_opacity=”100%” hover_enabled=”0″ box_shadow_style=”preset2″ box_shadow_horizontal=”0px” box_shadow_vertical=”0px” box_shadow_blur=”60px” box_shadow_color=”rgba(71,74,182,0.12)” image_max_width=”64px” locked=”off” global_colors_info=”{}” sticky_enabled=”0″]<\/p>\n This\u00a0module introduces error handling for T-SQL.<\/p>\n Lessons<\/strong><\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Implementing T-SQL error handling<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Implementing structured exception handling<\/p>\n Lab : Implementing Error Handling<\/strong><\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Redirecting errors with TRY\/CATCH<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Using THROW to pass an error message back to a client<\/p>\n After completing this module, students will be able to:<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Implement T-SQL error handling.<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Implement structured exception handling.<\/p>\n [\/et_pb_blurb][et_pb_blurb title=”Module 18: Implementing Transactions” url=”#” image=”https:\/\/it.tct.al\/wp-content\/uploads\/2025\/04\/coding-iconArtboard-19-copy-8.jpg” icon_placement=”left” image_icon_width=”64px” content_max_width=”1100px” admin_label=”Chapter” _builder_version=”4.22.2″ header_font=”|on|||” header_text_color=”#2e2545″ header_line_height=”1.5em” body_text_color=”#8585bd” body_font_size=”16px” body_line_height=”1.9em” background_color=”#ffffff” custom_margin=”|||” custom_padding=”30px|40px|30px|40px” animation_style=”zoom” animation_direction=”bottom” animation_intensity_zoom=”20%” animation_starting_opacity=”100%” hover_enabled=”0″ box_shadow_style=”preset2″ box_shadow_horizontal=”0px” box_shadow_vertical=”0px” box_shadow_blur=”60px” box_shadow_color=”rgba(71,74,182,0.12)” image_max_width=”64px” locked=”off” global_colors_info=”{}” sticky_enabled=”0″]<\/p>\n This module describes how to implement transactions.<\/p>\n Lessons<\/strong><\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Transactions and the database engines<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Controlling transactions<\/p>\n Lab : Implementing Transactions<\/strong><\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Controlling transactions with BEGIN, COMMIT, and ROLLBACK<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Adding error handling to a CATCH block<\/p>\n After completing this module, students will be able to:<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Describe transactions and the differences between batches and transactions.<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Describe batches and how they are handled by SQL Server.<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Create and manage transactions with transaction control language (TCL) statements.<\/p>\n \u25cf\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Use SET XACT_ABORT to define SQL Servers\u00a0<\/span><\/p>\n [\/et_pb_blurb][et_pb_button button_url=”@ET-DC@eyJkeW5hbWljIjp0cnVlLCJjb250ZW50IjoicG9zdF9saW5rX3VybF9wYWdlIiwic2V0dGluZ3MiOnsicG9zdF9pZCI6Ijc1MiJ9fQ==@” button_text=”Back to Course List” button_alignment=”left” _builder_version=”4.22.2″ _dynamic_attributes=”button_url” custom_button=”on” button_text_size=”16px” button_text_color=”#ffffff” button_bg_color=”#7272ff” button_border_width=”10px” button_border_color=”#7272ff” button_border_radius=”100px” button_letter_spacing=”1px” button_font=”|on||on|” button_icon=”D||divi||400″ button_icon_placement=”left” button_on_hover=”off” custom_margin=”20px|||” animation_style=”zoom” animation_delay=”100ms” animation_intensity_zoom=”6%” box_shadow_style=”preset1″ box_shadow_vertical=”10px” box_shadow_blur=”50px” box_shadow_spread=”5px” box_shadow_color=”rgba(114,114,255,0.4)” button_letter_spacing_hover=”2px” saved_tabs=”all” locked=”off” global_colors_info=”{}” button_text_size__hover_enabled=”off” button_text_size__hover=”null” button_one_text_size__hover_enabled=”off” button_one_text_size__hover=”null” button_two_text_size__hover_enabled=”off” button_two_text_size__hover=”null” button_text_color__hover_enabled=”off” button_text_color__hover=”null” button_one_text_color__hover_enabled=”off” button_one_text_color__hover=”null” button_two_text_color__hover_enabled=”off” button_two_text_color__hover=”null” button_border_width__hover_enabled=”off” button_border_width__hover=”null” button_one_border_width__hover_enabled=”off” button_one_border_width__hover=”null” button_two_border_width__hover_enabled=”off” button_two_border_width__hover=”null” button_border_color__hover_enabled=”off” button_border_color__hover=”null” button_one_border_color__hover_enabled=”off” button_one_border_color__hover=”null” button_two_border_color__hover_enabled=”off” button_two_border_color__hover=”null” button_border_radius__hover_enabled=”off” button_border_radius__hover=”null” button_one_border_radius__hover_enabled=”off” button_one_border_radius__hover=”null” button_two_border_radius__hover_enabled=”off” button_two_border_radius__hover=”null” button_letter_spacing__hover_enabled=”on” button_letter_spacing__hover=”2px” button_one_letter_spacing__hover_enabled=”off” button_one_letter_spacing__hover=”null” button_two_letter_spacing__hover_enabled=”off” button_two_letter_spacing__hover=”null” button_bg_color__hover_enabled=”off” button_bg_color__hover=”null” button_one_bg_color__hover_enabled=”off” button_one_bg_color__hover=”null” button_two_bg_color__hover_enabled=”off” button_two_bg_color__hover=”null”][\/et_pb_button][\/et_pb_column_inner][\/et_pb_row_inner][\/et_pb_column][et_pb_column type=”1_3″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” padding_top__hover=”0px” parallax__hover=”off” parallax_method__hover=”on” custom_padding__hover=”|||”][et_pb_blurb url=”#” image_icon_width=”100px” disabled_on=”off|off|off” admin_label=”Instructor” _builder_version=”4.22.2″ header_font=”|700|||||||” header_text_color=”#2e2545″ header_line_height=”1.5em” body_text_color=”#8585bd” body_font_size=”16px” body_line_height=”1.9em” background_color=”#ffffff” text_orientation=”center” custom_margin=”-80px|||” custom_padding=”30px|40px|30px|40px” animation_style=”zoom” animation_direction=”bottom” animation_intensity_zoom=”20%” animation_starting_opacity=”100%” box_shadow_style=”preset1″ box_shadow_vertical=”0px” box_shadow_blur=”60px” box_shadow_color=”rgba(71,74,182,0.12)” image_max_width=”100px” global_colors_info=”{}”]<\/p>\n Collecting data from different sources like MS Excel, databases etc, cleaning, transforming, modeling and visualizing the data on inteligent dashboards.<\/p>\n <\/p>\n [\/et_pb_blurb][et_pb_button button_url=”#” button_text=”Full Profile” button_alignment=”center” disabled_on=”on|on|on” _builder_version=”4.22.2″ custom_button=”on” button_text_size=”16px” button_text_color=”#ffffff” button_bg_color=”#7272ff” button_border_width=”10px” button_border_color=”#7272ff” button_border_radius=”100px” button_letter_spacing=”1px” button_font=”|on||on|” button_icon=”E||divi||400″ button_on_hover=”off” custom_margin=”20px|||” animation_style=”zoom” animation_delay=”100ms” animation_intensity_zoom=”6%” box_shadow_style=”preset1″ box_shadow_vertical=”10px” box_shadow_blur=”50px” box_shadow_spread=”5px” box_shadow_color=”rgba(114,114,255,0.4)” button_letter_spacing_hover=”2px” disabled=”on” saved_tabs=”all” locked=”off” global_colors_info=”{}” button_text_size__hover_enabled=”off” button_text_size__hover=”null” button_one_text_size__hover_enabled=”off” button_one_text_size__hover=”null” button_two_text_size__hover_enabled=”off” button_two_text_size__hover=”null” button_text_color__hover_enabled=”off” button_text_color__hover=”null” button_one_text_color__hover_enabled=”off” button_one_text_color__hover=”null” button_two_text_color__hover_enabled=”off” button_two_text_color__hover=”null” button_border_width__hover_enabled=”off” button_border_width__hover=”null” button_one_border_width__hover_enabled=”off” button_one_border_width__hover=”null” button_two_border_width__hover_enabled=”off” button_two_border_width__hover=”null” button_border_color__hover_enabled=”off” button_border_color__hover=”null” button_one_border_color__hover_enabled=”off” button_one_border_color__hover=”null” button_two_border_color__hover_enabled=”off” button_two_border_color__hover=”null” button_border_radius__hover_enabled=”off” button_border_radius__hover=”null” button_one_border_radius__hover_enabled=”off” button_one_border_radius__hover=”null” button_two_border_radius__hover_enabled=”off” button_two_border_radius__hover=”null” button_letter_spacing__hover_enabled=”on” button_letter_spacing__hover=”2px” button_one_letter_spacing__hover_enabled=”off” button_one_letter_spacing__hover=”null” button_two_letter_spacing__hover_enabled=”off” button_two_letter_spacing__hover=”null” button_bg_color__hover_enabled=”off” button_bg_color__hover=”null” button_one_bg_color__hover_enabled=”off” button_one_bg_color__hover=”null” button_two_bg_color__hover_enabled=”off” button_two_bg_color__hover=”null”][\/et_pb_button][et_pb_button _builder_version=”4.16″ global_colors_info=”{}” button_text_size__hover_enabled=”off” button_text_size__hover=”null” button_one_text_size__hover_enabled=”off” button_one_text_size__hover=”null” button_two_text_size__hover_enabled=”off” button_two_text_size__hover=”null” button_text_color__hover_enabled=”off” button_text_color__hover=”null” button_one_text_color__hover_enabled=”off” button_one_text_color__hover=”null” button_two_text_color__hover_enabled=”off” button_two_text_color__hover=”null” button_border_width__hover_enabled=”off” button_border_width__hover=”null” button_one_border_width__hover_enabled=”off” button_one_border_width__hover=”null” button_two_border_width__hover_enabled=”off” button_two_border_width__hover=”null” button_border_color__hover_enabled=”off” button_border_color__hover=”null” button_one_border_color__hover_enabled=”off” button_one_border_color__hover=”null” button_two_border_color__hover_enabled=”off” button_two_border_color__hover=”null” button_border_radius__hover_enabled=”off” button_border_radius__hover=”null” button_one_border_radius__hover_enabled=”off” button_one_border_radius__hover=”null” button_two_border_radius__hover_enabled=”off” button_two_border_radius__hover=”null” button_letter_spacing__hover_enabled=”off” button_letter_spacing__hover=”null” button_one_letter_spacing__hover_enabled=”off” button_one_letter_spacing__hover=”null” button_two_letter_spacing__hover_enabled=”off” button_two_letter_spacing__hover=”null” button_bg_color__hover_enabled=”off” button_bg_color__hover=”null” button_one_bg_color__hover_enabled=”off” button_one_bg_color__hover=”null” button_two_bg_color__hover_enabled=”off” button_two_bg_color__hover=”null”][\/et_pb_button][\/et_pb_column][\/et_pb_section][et_pb_section fb_built=”1″ admin_label=”Footer” _builder_version=”4.16″ background_color=”#f7f8fc” custom_padding=”0px|0px|100px|0px” animation_style=”zoom” animation_direction=”bottom” animation_intensity_zoom=”6%” animation_starting_opacity=”100%” saved_tabs=”all” locked=”off” global_colors_info=”{}”][et_pb_row column_structure=”1_2,1_4,1_4″ use_custom_gutter=”on” gutter_width=”2″ _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}”][et_pb_column type=”1_2″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”4.16″ text_font=”||||||||” header_font=”||||||||” header_2_font=”|700|||||||” header_2_text_color=”#7272ff” header_2_font_size=”36px” header_2_line_height=”1.3em” background_size=”initial” background_position=”top_left” background_repeat=”repeat” custom_margin=”||20px|” animation_style=”slide” animation_direction=”bottom” animation_intensity_slide=”10%” global_colors_info=”{}” header_font_size__hover=”30px” header_font_size__hover_enabled=”30px” header_letter_spacing__hover=”0px” header_letter_spacing__hover_enabled=”0px” header_text_shadow_style__hover=”none” header_text_shadow_style__hover_enabled=”none” header_text_shadow_color__hover=”rgba(0,0,0,0.4)” header_text_shadow_color__hover_enabled=”rgba(0,0,0,0.4)”]<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ text_text_color=”#8585bd” text_font_size=”22px” text_line_height=”1.9em” background_size=”initial” background_position=”top_left” background_repeat=”repeat” animation_style=”fade” locked=”off” global_colors_info=”{}”]<\/p>\n Get in touch, or create an account<\/p>\n [\/et_pb_text][\/et_pb_column][et_pb_column type=”1_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_button button_url=”#” button_text=”Create Account” button_alignment=”left” disabled_on=”on|on|on” _builder_version=”4.22.2″ custom_button=”on” button_text_size=”16px” button_text_color=”#ffffff” button_bg_color=”#7272ff” button_border_width=”10px” button_border_color=”#7272ff” button_border_radius=”100px” button_letter_spacing=”1px” button_font=”|on||on|” button_icon=”E||divi||400″ button_on_hover=”off” custom_margin=”|||” animation_style=”zoom” animation_delay=”100ms” animation_intensity_zoom=”6%” box_shadow_style=”preset1″ box_shadow_vertical=”10px” box_shadow_blur=”50px” box_shadow_spread=”5px” box_shadow_color=”rgba(114,114,255,0.4)” button_letter_spacing_hover=”2px” disabled=”on” locked=”off” global_colors_info=”{}” button_text_size__hover_enabled=”off” button_one_text_size__hover_enabled=”off” button_two_text_size__hover_enabled=”off” button_text_color__hover_enabled=”off” button_one_text_color__hover_enabled=”off” button_two_text_color__hover_enabled=”off” button_border_width__hover_enabled=”off” button_one_border_width__hover_enabled=”off” button_two_border_width__hover_enabled=”off” button_border_color__hover_enabled=”off” button_one_border_color__hover_enabled=”off” button_two_border_color__hover_enabled=”off” button_border_radius__hover_enabled=”off” button_one_border_radius__hover_enabled=”off” button_two_border_radius__hover_enabled=”off” button_letter_spacing__hover_enabled=”on” button_letter_spacing__hover=”2px” button_one_letter_spacing__hover_enabled=”off” button_two_letter_spacing__hover_enabled=”off” button_bg_color__hover_enabled=”off” button_one_bg_color__hover_enabled=”off” button_two_bg_color__hover_enabled=”off”][\/et_pb_button][\/et_pb_column][et_pb_column type=”1_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_button button_url=”@ET-DC@eyJkeW5hbWljIjp0cnVlLCJjb250ZW50IjoicG9zdF9saW5rX3VybF9wYWdlIiwic2V0dGluZ3MiOnsicG9zdF9pZCI6Ijg0OCJ9fQ==@” button_text=”Contact Us” button_alignment=”left” _builder_version=”4.22.2″ _dynamic_attributes=”button_url” custom_button=”on” button_text_size=”16px” button_text_color=”#7272ff” button_bg_color=”#ffffff” button_border_width=”10px” button_border_color=”#ffffff” button_border_radius=”100px” button_letter_spacing=”1px” button_font=”|on||on|” button_icon=”E||divi||400″ button_on_hover=”off” custom_margin=”|||” animation_style=”zoom” animation_intensity_zoom=”6%” box_shadow_style=”preset1″ box_shadow_vertical=”10px” box_shadow_blur=”50px” box_shadow_spread=”5px” box_shadow_color=”rgba(181,181,255,0.38)” button_letter_spacing_hover=”2px” locked=”off” global_colors_info=”{}” button_text_size__hover_enabled=”off” button_one_text_size__hover_enabled=”off” button_two_text_size__hover_enabled=”off” button_text_color__hover_enabled=”off” button_one_text_color__hover_enabled=”off” button_two_text_color__hover_enabled=”off” button_border_width__hover_enabled=”off” button_one_border_width__hover_enabled=”off” button_two_border_width__hover_enabled=”off” button_border_color__hover_enabled=”off” button_one_border_color__hover_enabled=”off” button_two_border_color__hover_enabled=”off” button_border_radius__hover_enabled=”off” button_one_border_radius__hover_enabled=”off” button_two_border_radius__hover_enabled=”off” button_letter_spacing__hover_enabled=”on” button_letter_spacing__hover=”2px” button_one_letter_spacing__hover_enabled=”off” button_two_letter_spacing__hover_enabled=”off” button_bg_color__hover_enabled=”off” button_one_bg_color__hover_enabled=”off” button_two_bg_color__hover_enabled=”off”][\/et_pb_button][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>",
"protected": false
},
"excerpt": {
"rendered": " SQL Server AdministrationThis course is identical to the Microsoft course and the content of this page is taken from Microsoft\u2019s official course. This course is designed to introduce students to Transact-SQL and learn by doing in practice. This course is taught 100% \u201cHands On\u201d and will make students ready for a database developer junior position. […]<\/p>",
"protected": false
},
"author": 10,
"featured_media": 0,
"parent": 0,
"menu_order": 0,
"comment_status": "closed",
"ping_status": "closed",
"template": "",
"meta": {
"_et_pb_use_builder": "on",
"_et_pb_old_content": "",
"_et_gb_content_width": "",
"om_disable_all_campaigns": false,
"_monsterinsights_skip_tracking": false,
"_monsterinsights_sitenote_active": false,
"_monsterinsights_sitenote_note": "",
"_monsterinsights_sitenote_category": 0,
"_uf_show_specific_survey": 0,
"_uf_disable_surveys": false,
"footnotes": ""
},
"class_list": [
"post-993",
"page",
"type-page",
"status-publish",
"hentry"
],
"aioseo_notices": [],
"_links": {
"self": [
{
"href": "https:\/\/it.tct.al\/en_us\/wp-json\/wp\/v2\/pages\/993",
"targetHints": {
"allow": [
"GET"
]
}
}
],
"collection": [
{
"href": "https:\/\/it.tct.al\/en_us\/wp-json\/wp\/v2\/pages"
}
],
"about": [
{
"href": "https:\/\/it.tct.al\/en_us\/wp-json\/wp\/v2\/types\/page"
}
],
"author": [
{
"embeddable": true,
"href": "https:\/\/it.tct.al\/en_us\/wp-json\/wp\/v2\/users\/10"
}
],
"replies": [
{
"embeddable": true,
"href": "https:\/\/it.tct.al\/en_us\/wp-json\/wp\/v2\/comments?post=993"
}
],
"version-history": [
{
"count": 6,
"href": "https:\/\/it.tct.al\/en_us\/wp-json\/wp\/v2\/pages\/993\/revisions"
}
],
"predecessor-version": [
{
"id": 1026,
"href": "https:\/\/it.tct.al\/en_us\/wp-json\/wp\/v2\/pages\/993\/revisions\/1026"
}
],
"wp:attachment": [
{
"href": "https:\/\/it.tct.al\/en_us\/wp-json\/wp\/v2\/media?parent=993"
}
],
"curies": [
{
"name": "wp",
"href": "https:\/\/api.w.org\/{rel}",
"templated": true
}
]
}
}\n
\n
Outcomes<\/strong><\/h4>\n
Prepare for a career as a Data Scientist<\/strong><\/h4>\n
\n
Ready to get started?<\/h2>\n