Autoplay
Autocomplete
Previous Lecture
Complete and Continue
SQL for Power BI Users
Introduction
Course Overview
Let's get started
Resource Pack
Course Introduction (4:50)
SQL for Power BI Users
Download and Install SQL and SSMS (15:47)
Query Folding and Connecting to SQL Server (11:16)
SELECT, TOP and ORDER BY (11:33)
Filter using WHERE (9:58)
Filter using IN, NOT IN, LIKE, NOT LIKE (9:20)
Basic SQL function (11:33)
CASE and ISNULL (10:37)
Subquery (6:35)
JOIN Types and Inner JOIN (14:41)
LEFT JOIN and FULL OUTER JOIN (12:18)
Aggregate Functions and Group By (13:21)
Filtering on Aggregate-HAVING (7:17)
Common Table Expressions(CTE) (10:23)
Basic Table Operations (9:38)
Temporary Tables and Views (11:30)
Stored Procedures (12:10)
OFFFSET and FETCH (4:18)
Window Function - Solve Complex Data Problems (15:50)
Your Feedback
Course Survey
Certification
Certificate & Badge
Common Table Expressions(CTE)
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock