SQL Reporting – Beginner
SQL Course Introduction
2 Topics
What is SQL?
Installing SQL Server Management Studio (SSMS)
Accessing the Database
3 Topics
Connecting to the Server/Database
Connection Information
Quick Tour – Viewing Tables and Columns
SQL Basics
9 Topics
What We’re Building – The Question
SELECT & FROM
WHERE
ORDER BY
GROUP BY
HAVING
JOIN
TOP
DISTINCT
Beginner Tips
5 Topics
Column and Table Aliases
Multi-word Columns
Schemas
Calculated Columns
Comments
Filtering Keywords
4 Topics
IN
LIKE & Wildcards
BETWEEN
NOT
GROUP BY and Aggregation Functions
3 Topics
COUNT
SUM
MIN, MAX, AVG
JOINs
4 Topics
INNER JOIN
LEFT JOIN
RIGHT JOIN
FULL JOIN
Putting It All Together
2 Topics
Reminder of the Challenge
Writing the Final Query
Congratulations and Next Steps
1 Topic
Extra Databases for Students
Next Lesson
SQL Course Introduction
SQL Reporting – Beginner
SQL Course Introduction
Lesson Content
0% Complete
0/2 Steps
What is SQL?
Installing SQL Server Management Studio (SSMS)
Back to Course
Next Lesson
Login
Accessing this course requires a login. Please enter your credentials below!
Username or Email Address
Password
Remember Me
Lost Your Password?