FB

Introduction to SQL Server

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

  1. Welcome and Setup
  2. Viewing Data with SELECT
  3. Operators and Sorting
  4. Set Operators
  5. Functions and Grouping
  6. Joins
  7. 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.

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.