Instructor-led training

Intermediate SQL for Microsoft SQL Server Training in Menomonie, Wisconsin

Data training from Hartmann Software Group, delivered onsite in Menomonie, Wisconsin or live online.

Request a Training Proposal View Course Outline

What you'll learn

The Intermediate SQL for Microsoft SQL Server course is intended for SQL users in programming roles who have taken an Introduction to SQL course. This course covers creating CTEs, using a Windows function, creating and using Global Variables, and pivoting data. This course is applicable to Microsoft SQL Server. Some topics may be applicable to other Database Management Systems, but most topics will not be supported in other DBMSs.

This course use data from the Adventureworks and OGCBOOKS databases.

Prerequisites

Before attending this course, you need to be able to do the following: -Write simple SQL queries using the SELECT statement. -Sort data using an ORDER BY clause. -Filter data using the WHERE clause. -Use the IN operator on a WHERE clause to select multiple values. -Create aggregates using a summary function and a GROUP BY clause.

Course Outline

Review
- Review common functionality from Introduction to SQL course.
Creating Totals and Subtotals
- Create grand totals.
- Specify a label on the total line.
- Create subtotals and labels.
Creating Common Table Expression
- Define why to create Common Table Expression (CTE).
- Define the difference between a CTE and a view.
- Create and use a CTE.
- Use an in-line view as an alternative to a CTE.
Performing Pattern Matching
- Use the LIKE operator for pattern matching in a WHERE clause.
- Use the PATINDEX function for pattern matching in a SELECT statement.
Creating Cross-tabular Results
- Pivot the data in a table.
Ranking Results
- Use ranking to determine top values using the Windows Function of RANK.
- Display an absolute number of rows or percentage of rows based on the sorted data.
Using Global Variables
- Create variables to be used for code substitution.
Creating Loops
- Create loops to repetitively execute code.

Training locations

Intermediate SQL for Microsoft SQL Server training across the U.S. and beyond.

We provide Intermediate SQL for Microsoft SQL Server training onsite and live online for organizations throughout the United States and internationally.

View all Intermediate SQL for Microsoft SQL Server training locations

Ready to train your team?

Let's customize this training for your organization.

Tell us about your employees, your goals, and your preferred schedule. We'll prepare a training proposal covering scope, delivery format, and pricing.

Request a Training Proposal

or call 303.377.6176