Fundamentals of SQL Querying

Master the art of SQL querying to empower your data analysis skills and elevate your business decision-making abilities with our targeted, hands-on Fundamentals of SQL Querying course designed for budding data professionals.

Course Thumbnail

Essential Skills Gained

Checkmark

Connect to SQL Server databases to execute queries.

Checkmark

Implement effective search conditions in queries.

Checkmark

Utilize functions to perform calculations and manipulate data.

Checkmark

Organize and present data efficiently for business needs.

Format

  • Instructor-led
  • 2 days with lectures and hands-on labs.

Audience

  • Database administrators
  • Data analysts
  • IT professionals
  • Business analysts

Description

In this 2-day instructor led course students will learn what SQL is and how it can help them query a database to answer business questions. This course will combine instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities. Students will learn how to use SQL statements to query a database. Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning.

Calendar icon

Upcoming Course Dates

July 7-8, 2025

9:00 AM - 4:30 PM

Virtual: Online - US/Eastern

Guaranteed to Run

Enroll

$995

August 28-29, 2025

9:00 AM - 4:30 PM

Virtual: Online - US/Eastern

Enroll

$995

October 13-14, 2025

9:00 AM - 4:30 PM

Virtual: Online - US/Eastern

Enroll

$995

Course Outline

Download PDF

Lesson 1: Executing a Simple Query

  1. Connect to the SQL Database

  2. Query a Database

  3. Save a Query

  4. Modify a Query

  5. Execute a Saved Query

Lesson 2: Performing a Conditional Search

  1. Search Using a Simple Condition

  2. Compare Column Values

  3. Search Using Multiple Conditions

  4. Search for a Range of Values and Null Values

  5. Retrieve Data Based on Patterns

Lesson 3: Working with Functions

  1. Perform Date Calculations

  2. Calculate Data Using Aggregate Functions

  3. Manipulate String Values

Lesson 4: Organizing Data

  1. Sort Data

  2. Rank Data

  3. Group Data

  4. Filter Grouped Data

  5. Summarize Grouped Data

  6. Use PIVOT and UNPIVOT Operators

Lesson 5: Retrieving Data from Tables

  1. Combine Results of Two Queries

  2. Compare the Results of Two Queries

  3. Retrieve Data by Joining Tables

  4. Check for Unmatched Records

  5. Retrieve Information from a Single Table Using Joins

Lesson 6: Presenting Query Results

  1. Save the Query Result

  2. Generate an XML Report

Your Team has Unique Training Needs.

Your team deserves training as unique as they are.

Let us tailor the course to your needs at no extra cost.