Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Getting Started in Power BI with SQL Server
Getting Started
Download and Installing SQL Server on the Windows Server environment (9:02)
Using SQL Server Management Studio (5:01)
Setup and creating test data - VERY IMPORTANT (1:09)
How to create a database and table a SQL Server Database
What is a database (1:31)
What is a table (1:02)
Setup and creating test data (1:09)
Using T-SQL
USE Command - Switching Between Databases (1:26)
SELECT (4:04)
UNION (1:28)
DATE Functions (5:08)
CASE Statements (3:10)
Joining tables using JOIN Statements
JOINS : INNER, LEFT AND RIGHT JOINS (11:36)
Which JOIN is better? PART 1 (4:20)
Which JOIN is better? PART 2
Aggregation Functions
COUNT Statement (3:23)
SUM Statement (2:39)
AVG (Average) Statement (3:29)
Filter GROUP BY Statement using HAVING Statements
Filter GROUP BY Statement using HAVING Statements (4:27)
Insert Statements
Insert Statements (2:57)
Further Reading
Update Statements
Update Statements (2:52)
Update - Further Reading
Delete Statements
Delete Statements (2:26)
Delete - Further Reading
Condition Statements
IF / ELSE (4:53)
Further Reading
Introduction to Power BI
Installing Power BI
Connecting to SQL Server (4:39)
Visualizations (2:49)
Formatting Dates (2:28)
Formatting Columns and Conditional Formatting (2:29)
SQL Server Training Path
SQL Server Training Path
Teach online with
What is a table
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock