SQL Querying Fundamentals - Part 1 Virtual Classroom Live July 29, 2025

Price: $495

This course runs for a duration of 1 Day.

The class will run daily from 8 AM CT to 4 PM CT.

Class Location: Virtual LIVE Instructor Led - Virtual Live Classroom.

Enroll today to reserve your spot!

Space is limited. Enroll today.

Enroll Now

Description

Over 70% of business decision-makers say their teams struggle with data access—most don’t know how to use SQL effectively. This one-day beginner-level training course provides a hands-on introduction to SQL fundamentals using Microsoft SQL Server.

You’ll learn SQL from the ground up, gaining the skills to write queries, filter and sort results, combine data from multiple tables, and manipulate output for analysis or reporting. Real-world exercises guide you through every step so you can confidently retrieve information from a relational database.

Objectives

After completing this course, you’ll be equipped to use SQL to extract and manipulate data from relational databases. You'll gain practical experience writing queries, formatting results, and applying functions using SQL Server.

Run basic SQL statements to retrieve data
Apply conditions and logical filters using WHERE clauses
Use string, numeric, and date functions for calculated results
Organize and group query output
Join tables and identify missing or unmatched records

Target Student:

Individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases.

Course Overview

Module 1: Executing Basic SQL Statements

Connect to a SQL Server database
Create, modify, and execute queries
Save and reopen query files

Module 2: Filtering with Conditional Logic

Limit results using comparison operators
Combine multiple conditions
Search for ranges, NULL values, and patterns

Module 3: Using Built-In SQL Functions

Perform date and time calculations
Manipulate strings and text fields
Calculate summaries with aggregate functions

Module 4: Structuring and Summarizing Output

Sort results and apply custom rankings
Group data and filter grouped rows
Pivot and unpivot results for advanced formatting

Module 5: Working Across Tables

Merge data with inner and outer joins
Identify records without matches
Compare and combine multiple result sets

Module 6: Exporting Results and Creating Reports

Format and save query results
Generate basic XML output
Review common reporting use cases

Prerequisites

Basic computer literacy

Basic PC operating system navigation skills

Basic Internet usage skills

Course Comments

This course is the starting point for those who are new to SQL or a good refresher for those who have some knowledge but would like to fine tune their skills.

The SQL information is ANSI standards and can be applied to any RDBMS, including DB2, Oracle, SQL/Server, Sybase, etc.

You may also be interested in our Microsoft Querying Class: Writing Analytical Queries for Business Intelligence- Course 55232