Close-up of server cooling fans in a vibrant data center.
Microsoft & Data

Microsoft SQL Server 2019 – Querying SQL Server

Duration10 Hours
LevelProfessional development
Access12 months online access
Course content16 modules
One-time payment Get complete course access

Original price was: £119.00.Current price is: £71.00. inc VAT

Save£48.00
  • Instant online access
  • Study at your own pace
  • Secure checkout
About this course

What the Microsoft SQL Server 2019 – Querying SQL Server course covers

Everything in Microsoft SQL Server 2019 – Querying SQL Server is delivered online and on demand - no classroom, no cohort, no waiting list. There are 16 modules to work through, and most people give it 10 hours in total. The 12 months of access matter more than they sound: refresher reading before an inspection or an appraisal is free.

Expect to cover Query Tools, Introduction to T-SQL Querying, Basic SELECT Queries and Querying Multiple Tables. 12 more modules follow those, all named on the Modules tab.

Nothing is required to enrol, and the content is aimed at the job rather than at a syllabus. We list 18 Microsoft & Data courses, of which 12 sit at Professional development. Its study time is about mid-range for the subject. This is training rather than a regulated qualification, so treat it as evidence that you have covered the subject.

What this course is not: The provider has not stated what the certificate looks like for this one, so ask us first if the certificate is the reason you are buying.

Buyer guide

Is this the right course for you?

Best fit

Microsoft SQL Server 2019 – Querying SQL Server is a sensible shortlist choice when you want a structured route through the published syllabus rather than a general overview of the whole subject. Its 16-module plan starts with Query Tools and Introduction to T-SQL Querying, which gives you a clear indication of the assumed starting point. That shape is likely to be most useful for analysts, administrators and office staff who live in spreadsheets whose training need matches those topics. It is a weaker fit if you only need one isolated skill, or if an employer has specified a different standard, awarding body or practical assessment. Before buying, compare that requirement with the final modules on Implementing Error Handling and Managing Transactions as well as the course title.

How to use the syllabus

Treat the module list as a study plan, not just a contents page. Begin with Query Tools and Introduction to T-SQL Querying and note any terms or processes you need to revisit. Around the middle, Using Built-In Functions acts as a useful checkpoint: if you can explain that material without looking back, move on; if not, repeat the preceding section before adding more. The later work on Implementing Error Handling and Managing Transactions is where you can test whether the earlier ideas connect. After each block, write a short example from your own work or a realistic scenario. That simple retrieval step makes self-paced learning more useful than clicking straight through to completion.

Check before enrolling

The listed study time is 10 hours; reserve more time if the subject is new to you or you plan to make detailed notes. Access is listed for 12 months, so set a completion date comfortably before the login ends. The provider has not supplied reliable certificate details for this course, so confirm them with us if certification is your main reason for enrolling. No CPD accreditation is stated. That is fine for skills development, but not when a workplace policy specifically requires accredited training.

Full course details from the training provider

This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server.  You will learn how to write queries that return data from tables as well as create, update, or delete data in a database.  These queries will allow filtering and sorting and effectively use the various data types provided by SQL Server. 

This course also covers the use of dynamic tables of various sorts which can allow a more sophisticated SQL user to hide implementation details from other end users accessing data from reporting tools. Finally, the course will provide details on the what and how of error handling and transaction management.

This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. The primary target audience for this course is: Database Administrators, Database Developers and BI professionals.

In this course, you will learn how to: 

  • Understand the similarities and differences between Transact-SQL and other computer languages.
  • Write SELECT queries
  • Query multiple tables
  • Sort and filter data
  • Describe the use of data types in SQL Server
  • Modify data using Transact-SQL
  • Use built-in functions
  • Group and aggregate data
  • Use subqueries
  • Use table expressions
  • Use set operators
  • Use window ranking, offset and aggregate functions
  • Implement pivoting and grouping sets
  • Execute stored procedures
  • Program with T-SQL
  • Implement error handling
  • Implement transactions

Instructor: James Ring-Howell

Course Video Content: 10 Hours 5 Minutes
Test Questions: 75

Microsoft SQL Server 2019 – Querying SQL Server course content

Module 1 – Query Tools
1.1 Course Introduction
1.2 Module 1 Introduction
1.3 Intro to Management Studio
1.4 Intro to command-line query tools

Module 2 – Introduction to T-SQL Querying
2.1 Module 2 Introduction
2.2 Introducing T-SQL
2.3 Understanding Sets
2.4 Understanding the Logical Order of Operations in SELECT statements

Module 3 – Basic SELECT Queries
3.1 Module 3 Introduction
3.2 Writing Simple SELECT Statements
3.3 Eliminate Duplicates with DISTINCT
3.4 Using Column and Table Aliases
3.5 Write Simple CASE Expressions

Module 4 – Querying Multiple Tables
4.1 Module 4 Introduction
4.2 Understanding Joins
4.3 Querying with Inner Joins
4.4 Querying with Outer Joins
4.5 Querying with Cross Joins and Self Joins

Module 5 – Sorting and Filtering Data
5.1 Module 5 Introduction
5.2 Sorting Data
5.3 Filtering Data with Predicates
5.4 Filtering with the TOP and OFFSET-FETCH
5.5 Working with Unknown Values

Module 6 – Working with SQL Server Data Types
6.1 Module 6 Introduction
6.2 Writing Queries that return Date and Time Data
6.3 Writing Queries that use Date and Time Functions
6.4 Writing Queries that return Character Data
6.5 Writing Queries that use Character Functions

Module 7 – Using DML to Modify Data
7.1 Module 7 Introduction
7.2 Inserting Records with DML
7.3 Updating Records Using DML
7.4 Deleting Records Using DML

Module 8 – Using Built-In Functions
8.1 Module 8 Introduction
8.2 Writing Queries with Built-In Functions
8.3 Using Conversion Functions
8.4 Using Logical Functions
8.5 Using Functions to Work with NULL

Module 9 – Grouping and Aggregating Data
9.1 Module 9 Introduction
9.2 Using Aggregate Functions
9.3 Using the GROUP BY Clause
9.4 Filtering Groups with HAVING

Module 10 – Using Subqueries
10.1 Module 10 Introduction
10.2 Writing Self-Contained Subqueries
10.3 Writing Correlated Subqueries
10.4 Using the EXISTS Predicate with Subqueries

Module 11 – Using Table Expressions
11.1 Module 11 Introduction
11.2 Using Views
11.3 Using Inline Table-Valued Functions
11.4 Using Derived Tables
11.5 Using Common Table Expressions

Module 12 – Using Set Operators
12.1 Module 12 Introduction
12.2 Writing Queries with the UNION operator
12.3 Using EXCEPT and INTERSECT
12.4 Using APPLY

Module 13 – Using Window Ranking, Offset, and Aggregate Functions
13.1 Module 13 Introduction
13.2 Creating Windows with OVER
13.3 Exploring Window Functions

Module 14 – Pivoting and Grouping Sets
14.1 Module 14 Introduction
14.2 Writing Queries with PIVOT and UNPIVOT
14.3 Working with Grouping Sets

Module 15 – Implementing Error Handling
15.1 Module Introduction
15.2 Implementing T-SQL error handling
15.3 Implementing structured exception handling

Module 16 – Managing Transactions
16.1 Module 16 Introduction
16.2 Transactions and the Database Engine
16.3 Controlling Transactions
16.4 Course Wrap Up

 

What you will learn

Learning outcomes

  • Module 1 - Query Tools
  • Module 2 - Introduction to T-SQL Querying
  • Module 3 - Basic SELECT Queries
  • Module 4 - Querying Multiple Tables
  • Module 5 - Sorting and Filtering Data
  • Module 6 - Working with SQL Server Data Types
  • Module 7 - Using DML to Modify Data
  • Module 8 - Using Built-In Functions
  • Module 9 - Grouping and Aggregating Data
  • Module 10 - Using Subqueries
  • Module 11 - Using Table Expressions
  • Module 12 - Using Set Operators
  • Module 13 - Using Window Ranking, Offset, and Aggregate Functions
  • Module 14 - Pivoting and Grouping Sets
  • Module 15 - Implementing Error Handling
  • Module 16 - Managing Transactions
Ready when you are

Get instant access and start learning today.

Enrol now
women's black sleeveless dress
Better value

SQL Server Master Training Bundle

£144.00 £576.00 Save 75%

That works out at about £9.00 per course.

Includes 16 courses
Grab this bundle instead

Continue your learning