HARTMANN software group

Intermediate SQL for Microsoft SQL Server Training in Denver

Enroll in or hire us to teach our Intermediate SQL for Microsoft SQL Server class in Denver, Colorado by calling us @303.377.6176. Like all HSG classes, Intermediate SQL for Microsoft SQL Server may be offered either onsite or via instructor led virtual training. Consider looking at our public training schedule to see if it is scheduled: Public Training Classes
Provided there are enough attendees, Intermediate SQL for Microsoft SQL Server may be taught at one of our local training facilities.
We offer private customized training for groups of 3 or more attendees.
get pricing information

Course Description

  
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.
Course Length: 1 Days
Course Tuition: $290 (US)

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. 

Course Directory [training on all levels]

Technical Training Courses
Software engineer/architect, System Admin ... Welcome!
Business Training Courses
Project Managers, Business Analysts, Paralegals ... Welcome!
Upcoming Classes
Gain insight and ideas from students with different perspectives and experiences.

Interesting Reads Take a class with us and receive a book of your choosing for 50% off MSRP.