SQL
A simple, straightforward guide to start writing SQL statements
-
Why Learn SQL
-
Basic SQL Topics
-
Write Your First SQL Query
-
Understanding Your First SQL Query
-
Adding On To Your First SQL Query
-
More on the WHERE Clause
-
Using the IN keyword
-
Using the LIKE keyword
-
Using the DISTINCT keyword
-
The AND Keyword
-
The OR Keyword
-
Nuances with the AND and OR keywords
-
Aggregations Part 1 — AVG()
-
Aggregations Part 2 — COUNT()
-
Aggregations Part 3 — SUM()
-
Aggregations Part 4 — MIN()
-
Aggregations Part 5 — MAX()
-
Aggregations Part 6 — Combining Multiple Aggregations In 1 SQL Query
-
Performing Calculations on SQL Columns
-
Renaming SQL Columns
-
Renaming SQL Columns With Spaces
-
Selecting the Top 5 Rows from a Database Table
-
Selecting the Top 10% of Rows
-
Dealing with Huge Numbers
-
The Not Equal Operators: != Vs <>
-
The Not In Operator
-
Rounding Data
-
GETDATE()
-
GETDATE() Part 2
-
GETDATE() Part 3
-
GETDATE() Part 4
-
-
Advanced SQL Topics
Retake this course?
Retaking this course from the beginning will reset all of your tracked progress.