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.
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.
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