Intermediate SQL for Microsoft SQL Server Course Overview

Target Audience for Intermediate SQL for Microsoft SQL Server

The Intermediate SQL for Microsoft SQL Server course is designed for SQL users in programming roles looking to enhance their SQL skills for complex operations including CTEs, Windows functions, and data pivoting.

• SQL Developers
• Database Administrators
• Data Analysts
• Report Analysts
• Data Scientists
• Business Intelligence Analysts
• Application Developers
• System Analysts
• Software Engineers
• Backend Developers
• IT Professionals in Database Management

Learning Objectives - What you will Learn in this Intermediate SQL for Microsoft SQL Server?

Intermediate SQL for Microsoft SQL Server - Learning Objectives and Outcomes

Introduction: The Intermediate SQL for Microsoft SQL Server course enhances your SQL skills by diving into advanced concepts such as creating CTEs, pattern matching, pivoting data, and using global variables.

Learning Objectives and Outcomes:

• Review SQL Basics

  • Reinforce common functionalities from the introductory SQL course.

• Creating Totals and Subtotals

  • Create grand totals.
  • Specify labels on total lines.
  • Generate subtotals and their corresponding labels.

• Creating Common Table Expressions (CTEs)

  • Understand why CTEs are useful.
  • Distinguish between a CTE and a view.
  • Create and utilize CTEs.
  • Apply in-line views as alternatives to CTEs.

• Performing Pattern Matching

  • Use the LIKE operator for pattern matching in a WHERE clause.
  • Utilize the PATINDEX function for pattern matching in SELECT statements.

• Creating Cross-tabular Results

  • Pivot data in a table to get cross-tabular results.

• Ranking Results

  • Use the Windows function RANK to determine top values.
  • Display specific rows or percentage of rows based on