Skip to main content

Learn SQL Server 2019 – Querying SQL Server

Beginner10 Hours 5 Minutes67 Course Videos75 Test Questions

$179.00

Learn to write T-SQL queries in Microsoft SQL Server 2019, from simple SELECT statements to joins, subqueries and window functions. 10 hours 5 minutes of self-paced video across 67 lessons.

  • Login details sent straight after payment
  • Self-paced. Study on any device
  • StemBoss Certificate of Completion
  • 14-day refund promise

Secure checkout. Pay by card, Apple Pay or Google Pay.

Download the course outline (PDF)

Learn SQL Server 2019: Querying SQL Server is a self-paced course that teaches you to read and write T-SQL, the query language of Microsoft SQL Server. It suits new data analysts, developers and junior database staff who need to pull, change and summarise data. The course runs for 10 hours 5 minutes across 67 videos, with 75 practice questions.

What you will learn

  • Use SQL Server Management Studio and command-line tools to run queries
  • Understand how SQL Server processes a SELECT statement, step by step
  • Write SELECT queries with aliases, DISTINCT and CASE expressions
  • Combine tables with inner, outer, cross and self joins
  • Sort and filter results with predicates, TOP and OFFSET-FETCH, and handle NULL values
  • Insert, update and delete records with DML
  • Group and total data with aggregate functions, GROUP BY and HAVING
  • Build subqueries, views, derived tables and common table expressions
  • Use UNION, EXCEPT, INTERSECT, APPLY, PIVOT and window functions
  • Handle errors and control transactions in T-SQL

Course outline

  1. Query Tools: Management Studio and command-line tools.
  2. Introduction to T-SQL Querying: sets and the logical order of a SELECT.
  3. Basic SELECT Queries: DISTINCT, aliases and simple CASE.
  4. Querying Multiple Tables: the main join types.
  5. Sorting and Filtering Data: predicates, TOP, OFFSET-FETCH and unknown values.
  6. Working with SQL Server Data Types: date, time and character data.
  7. Using DML to Modify Data: insert, update and delete.
  8. Using Built-In Functions: conversion, logical and NULL functions.
  9. Grouping and Aggregating Data: GROUP BY and HAVING.
  10. Using Subqueries: self-contained, correlated and EXISTS.
  11. Using Table Expressions: views, inline functions, derived tables and CTEs.
  12. Using Set Operators: UNION, EXCEPT, INTERSECT and APPLY.
  13. Window Functions: ranking, offset and aggregate windows with OVER.
  14. Pivoting and Grouping Sets: PIVOT, UNPIVOT and grouping sets.
  15. Implementing Error Handling: structured exception handling.
  16. Managing Transactions: how the engine handles and controls transactions.

Who this course is for

  • Data analysts and business intelligence staff who need to query data themselves
  • Software developers whose apps talk to SQL Server
  • Database administrators who want stronger query skills
  • IT staff adding database work to their role
  • Students and graduates starting out in data or database work

Before you start

You do not need to know SQL before you begin. It helps to be at ease with a computer and to know what a table of rows and columns looks like. Having SQL Server and Management Studio installed lets you follow along with the demos.

Jobs this course supports

  • SQL Developer
  • Data Analyst
  • Database Administrator
  • Business Intelligence Developer
  • Data Engineer
  • Software Developer

Skill level

Beginner
Duration

10 Hours 5 Minutes
Videos

67 Course Videos
Questions

75 Test Questions
Prerequisites

Basic computer skills. No past SQL experience is needed.
Best for

Data analysts, database administrators, software developers, BI developers, students
Topics covered

SQL Server Management Studio, SELECT queries, joins, filtering and sorting, DML, aggregates and GROUP BY, subqueries, window functions
Format

Online video lessons, self-paced
Language

English
Closed captions

Yes
Certificate

StemBoss Certificate of Completion

What is inside this course

16 modules and 67 lessons. Here is the full outline.

Module 1 - Query Tools4 lessons
  1. 1.1 Course Introduction
  2. 1.2 Module 1 Introduction
  3. 1.3 Intro to Management Studio
  4. 1.4 Intro to command-line query tools
Module 2 - Introduction to T-SQL Querying4 lessons
  1. 2.1 Module 2 Introduction
  2. 2.2 Introducing T-SQL
  3. 2.3 Understanding Sets
  4. 2.4 Understanding the Logical Order of Operations in SELECT statements
Module 3 - Basic SELECT Queries5 lessons
  1. 3.1 Module 3 Introduction
  2. 3.2 Writing Simple SELECT Statements
  3. 3.3 Eliminate Duplicates with DISTINCT
  4. 3.4 Using Column and Table Aliases
  5. 3.5 Write Simple CASE Expressions
Module 4 - Querying Multiple Tables5 lessons
  1. 4.1 Module 4 Introduction
  2. 4.2 Understanding Joins
  3. 4.3 Querying with Inner Joins
  4. 4.4 Querying with Outer Joins
  5. 4.5 Querying with Cross Joins and Self Joins
Module 5 - Sorting and Filtering Data5 lessons
  1. 5.1 Module 5 Introduction
  2. 5.2 Sorting Data
  3. 5.3 Filtering Data with Predicates
  4. 5.4 Filtering with the TOP and OFFSET-FETCH
  5. 5.5 Working with Unknown Values
Module 6 - Working with SQL Server Data Types5 lessons
  1. 6.1 Module 6 Introduction
  2. 6.2 Writing Queries that return Date and Time Data
  3. 6.3 Writing Queries that use Date and Time Functions
  4. 6.4 Writing Queries that return Character Data
  5. 6.5 Writing Queries that use Character Functions
Module 7 - Using DML to Modify Data4 lessons
  1. 7.1 Module 7 Introduction
  2. 7.2 Inserting Records with DML
  3. 7.3 Updating Records Using DML
  4. 7.4 Deleting Records Using DML
Module 8 - Using Built-In Functions5 lessons
  1. 8.1 Module 8 Introduction
  2. 8.2 Writing Queries with Built-In Functions
  3. 8.3 Using Conversion Functions
  4. 8.4 Using Logical Functions
  5. 8.5 Using Functions to Work with NULL
Module 9 - Grouping and Aggregating Data4 lessons
  1. 9.1 Module 9 Introduction
  2. 9.2 Using Aggregate Functions
  3. 9.3 Using the GROUP BY Clause
  4. 9.4 Filtering Groups with HAVING
Module 10 - Using Subqueries4 lessons
  1. 10.1 Module 10 Introduction
  2. 10.2 Writing Self-Contained Subqueries
  3. 10.3 Writing Correlated Subqueries
  4. 10.4 Using the EXISTS Predicate with Subqueries
Module 11 - Using Table Expressions5 lessons
  1. 11.1 Module 11 Introduction
  2. 11.2 Using Views
  3. 11.3 Using Inline Table-Valued Functions
  4. 11.4 Using Derived Tables
  5. 11.5 Using Common Table Expressions
Module 12 - Using Set Operators4 lessons
  1. 12.1 Module 12 Introduction
  2. 12.2 Writing Queries with the UNION operator
  3. 12.3 Using EXCEPT and INTERSECT
  4. 12.4 Using APPLY
Module 13 - Using Window Ranking, Offset, and Aggregate Functions3 lessons
  1. 13.1 Module 13 Introduction
  2. 13.2 Creating Windows with OVER
  3. 13.3 Exploring Window Functions
Module 14 - Pivoting and Grouping Sets3 lessons
  1. 14.1 Module 14 Introduction
  2. 14.2 Writing Queries with PIVOT and UNPIVOT
  3. 14.3 Working with Grouping Sets
Module 15 - Implementing Error Handling3 lessons
  1. 15.1 Module Introduction
  2. 15.2 Implementing T-SQL error handling
  3. 15.3 Implementing structured exception handling
Module 16 - Managing Transactions4 lessons
  1. 16.1 Module 16 Introduction
  2. 16.2 Transactions and the Database Engine
  3. 16.3 Controlling Transactions
  4. 16.4 Course Wrap Up

Your learning path

Where Learn SQL Server 2019 - Querying SQL Server fits. Build your skills one step at a time.

You are hereLearn SQL Server 2019 - Querying SQL Server
Next stepMicrosoft SQL Server 2019 Database DesignNext stepMicrosoft SQL Server Administration - 2019Next stepMicrosoft SQL Server Analysis Services (SSAS)

Frequently asked questions

Do I need to know SQL before taking this course?

No. The course starts with the query tools and the basics of T-SQL, then builds up to joins, subqueries and window functions.

What is T-SQL?

T-SQL (Transact-SQL) is Microsoft's version of SQL. It is the language you use to read, add, change and delete data in SQL Server.

Does the course cover changing data or only reading it?

Both. You learn SELECT queries for reading data and DML statements for inserting, updating and deleting records, plus how to wrap changes in transactions.

Which advanced query topics are included?

Later modules cover common table expressions, set operators such as UNION and INTERSECT, APPLY, PIVOT and UNPIVOT, grouping sets and window functions.

Is this course tied to a Microsoft exam?

No. It is a practical skills course on querying SQL Server 2019 and is not built around a specific exam code.

Do I get a certificate?

Yes. You get a StemBoss Certificate of Completion when you finish the course.

Can I get a refund?

Yes, within 14 days if you have completed less than 20% of the course. See our refund policy for details. Read the refund policy.

Related courses

$179.00
Buy course