T-SQL Queries Introduction (1 day)

Introduction

Much data today is stored in databases. To retrieve and use this data in Power BI, you need a query language. In Microsoft SQL Server, this language is known as T-SQL.

After completing this training, you will be able to independently write simple queries and combine data from multiple tables into a report. You will also learn which formulas to apply to Text, Numbers, and Date values to transform and/or filter the data as desired.

Topics

• Introduction to databases: tables, columns + relationships
• Selecting columns: SELECT + FROM
• Numeric expressions: ROUND, FLOOR, CEILING
• Date expressions: GETDATE, DATEPART, DATEADD, YEAR, MONTH
• Text expressions: TRIM, LEFT, RIGHT, SUBSTRING
• Sorting: ORDER BY
• Filtering data: WHERE
• Linking multiple tables: JOINS, INNER v.s. OUTER
• Grouping and aggregating: GROUP BY + HAVING

Target Audience

The target audience for this T-SQL training are professionals working with Microsoft SQL Server, such as database administrators, data analysts, business intelligence analysts, and data scientists. They often use T-SQL queries to gather, analyze, and visualize data from a SQL Server database.

Prerequisites

Basic knowledge of relational databases: understanding of tables, rows, columns, primary and foreign keys.

Information

Interested in this training? Click here for more information.