Do you want to learn SQL?
You’ve come to the right place.
On this page, you’ll find videos, links, and information for the Introduction to SQL Server course. It covers the beginner level topics in my SQL Roadmap.
So, keep reading to see what you’ll learn and watch the videos in this course.
If you want to set up SQL Server on a Mac, then you can use Docker. I’ve described the process for doing that in this guide: How to Set Up a Database on Docker.
Table of Contents
- Welcome and Setup
- Viewing Data with SELECT
- Operators and Sorting
- Set Operators
- Functions and Grouping
- Joins
- Updating and Deleting Data and Tables
Note: You can click the square icon in the bottom right of a video to play it full screen.
Welcome and Setup
Welcome
An introduction to the course, what’s included, and what’s not included.
SQL Server Express Download
How to download SQL Server Express, the database we’ll be using in this course.
You can also read the post on this here: How to Install SQL Server Express (& SSMS)
SQL Server Express Install
How to install SQL Server Express.
Set Up a Connection in SSMS
How to set up a connection in SSMS (SQL Server Management Studio).
Create a Table
Learn how to create a basic table in SQL Server.
Create a Table with Multiple Columns
Learn how to create a table with multiple columns.
Add Data to a Table
How to add data to a table you have created.
Viewing Data with SELECT
Viewing Data with SELECT
How to use the SELECT query to see the data in a table
Select Individual Columns
How to use the SELECT query to see specific columns.
Filtering data with WHERE
Use the WHERE clause to specify which rows to see.
Comparison Operators
How to use comparison operators to compare columns and values.
Filtering on partial values with LIKE
Use the LIKE keyword to filter data based on a partial match.
Filtering on Date Values
How to filter your results based on date values.
Using two filters
Use two filters in a WHERE clause.
More than two filters
Use more than two filters in your WHERE clause.
What is NULL?
Understand what NULL is and how it can be used.
Getting Unique Records with DISTINCT
Use the DISTINCT keyword to show unique records in your results.
Operators and Sorting
IN and NOT IN
Use multiple conditions in your WHERE clause more effectively with IN and NOT IN.
BETWEEN and NOT BETWEEN
Filter on a range of values using BETWEEN.
Sorting Results with the ORDER BY Clause
Sort your results when they are displayed.
Ordering By Multiple Columns
Sort your results by more than one column.
Set Operators
Set Operators and UNION
Use the UNION keyword to combine multiple results into one.
UNION ALL Operator
Use the UNION ALL operator to combine results and see how it’s different to UNION.
INTERSECT Operator
See how to use the INTERSECT operator in your queries.
EXCEPT Operator
See how to use the EXCEPT operator in your queries.
Functions and Grouping
What are Functions?
Learn what functions are and how they can be used in SQL.
Table Aliases
Learn what table aliases are and how they can help your queries.
Column Aliases
Understand what column aliases are and how they can help your queries.
Counting Data
Learn how to count the number of records in your table.
Aggregate Functions (SUM, MAX, MIN, AVG)
Learn how to use the different aggregate functions that are available.
Counting Data Within Groups with GROUP BY
Use a combination of grouping and counting to get the results you want.
GROUP BY with WHERE and ORDER BY
Use the WHERE clause and the ORDER BY clause while grouping data.
GROUP BY with Multiple Columns
Learn how to use multiple columns with the GROUP BY feature.
GROUP BY with HAVING
Learn what the HAVING keyword is and how to use it with GROUP BY.
Date Functions
Learn how to use date functions in SQL Server.
Operators
Understand what operators are in SQL.
The CASE Statement
Learn what the CASE statement is and how to use it.
Joins
Inner Join
Learn how to use an inner join to join two tables together.
Outer Join
Learn how to use an outer join and how it’s different from an inner join.
Joining Many Tables
See how to join more than two tables together.
Updating and Deleting Data and Tables
Updating Data
Learn how to update data using the UPDATE statement.
Deleting Data
See how to delete data from your table.
Altering a Table
Learn how to change the table structure.
Dropping a Table
Learn how to delete or drop a table from the database.
Conclusion
The end of the course and what you can do next.