SQL Querying Fundamentals – Part 1

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.

Course Details

Price:

$695.00

Days:

Location:

Course Overview

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

Basic computer literacy Basic PC operating system navigation skills Basic Internet usage skills

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

Class Dates & Times


05/27/2026 Virtual 09:00:00 to 17:00:00 EST Enroll Now $695.00
06/18/2026 Virtual 09:00:00 to 17:00:00 EST Enroll Now $695.00
07/13/2026 Virtual 09:00:00 to 17:00:00 EST Enroll Now $695.00
07/31/2026 Virtual 09:00:00 to 17:00:00 EST Enroll Now $695.00
08/20/2026 Virtual 09:00:00 to 17:00:00 EST Enroll Now $695.00
09/09/2026 Virtual 09:00:00 to 17:00:00 EST Enroll Now $695.00
09/28/2026 Virtual 09:00:00 to 17:00:00 EST Enroll Now $695.00
10/15/2026 Virtual 09:00:00 to 17:00:00 EST Enroll Now $695.00
11/04/2026 Virtual 08:00:00 to 16:00:00 EST Enroll Now $695.00
11/24/2026 Virtual 09:00:00 to 17:00:00 EST Enroll Now $695.00

— Questions?

Information Request

— Empower Change

Invest in Skills & Equality

Support Diversity, Equity, and Inclusion with Every Purchase.

Great Horizons is a North Carolina Certified HUB Vendor and WOSB. By becoming a patron of our organization, you are not only supporting a historically underutilized business, but a woman-owned small business as well.

Student? Switch to our Career Center Site →