SQL Fundamentals: Introduction to Database Querying
Intended Organizations
Intended Organizations
Organizational type shows which workplace or sector each group training program best aligns with. Most courses adapt across settings to support unique goals and outcomes.
Corporate & Business GroupsProfessional development for small groups, large business teams, and enterprises across industries focused on building valuable skills.
Federal GovernmentCreated for federal agencies and employees, with practical training that helps build job-relevant skills for the federal workplace.Course pricing is available for federal agencies through the GSA Schedule.
State & Local GovernmentTraining for state, county, municipal, and other public-sector teams, focused on building skills that support government and public service work.
Intended Organizations
Organizational type shows which workplace or sector each group training program best aligns with. Most courses adapt across settings to support unique goals and outcomes.
Federal GovernmentCreated for federal agencies and employees, with practical training that helps build job-relevant skills for the federal workplace.Course pricing is available for federal agencies through the GSA Schedule.
State & Local GovernmentTraining for state, county, municipal, and other public-sector teams, focused on building skills that support government and public service work.
Corporate & Business GroupsProfessional development for small groups, large business teams, and enterprises across industries focused on building valuable skills.
Intended Organizations
Organizational type shows which workplace or sector each group training program best aligns with. Most courses adapt across settings to support unique goals and outcomes.
State & Local GovernmentTraining for state, county, municipal, and other public-sector teams, focused on building skills that support government and public service work.
Federal GovernmentCreated for federal agencies and employees, with practical training that helps build job-relevant skills for the federal workplace.Course pricing is available for federal agencies through the GSA Schedule.
Corporate & Business GroupsProfessional development for small groups, large business teams, and enterprises across industries focused on building valuable skills.
Skill LevelFundamentals
Virtual | Live Trainer4 hours/day, 1 Day
In-Person | Onsite6 hours/day, 1 Day
Skill Level & Progression
Skill level reflects the recommended course experience and helps match training to your team's needs. Most training courses support all learning levels.
General WorkforceDevelops team-ready capabilities across business roles and experience levels while strengthening skills and organizational results.
Fundamentals(this course)Builds introductory proficiency in essential terminology, core concepts, and workplace best practices for real-world application.
IntermediateStrengthens existing knowledge through advanced functions, skill strategies, and deeper exploration of core concepts.
AdvancedDeepens expertise through complex subject matter, specialized skills, advanced analysis, and higher-level instruction.
Course Formats
Train on your terms. Choose virtual or onsite delivery, schedule sessions around your team’s availability, and align course content with your objectives and real-world challenges.
Virtual Training4 hours/day, 1 DayLive, interactive, instructor-led training delivered through a secure videoconferencing platform.
Onsite Training6 hours/day, 1 DayEngaging, instructor-led training delivered in person at the location of your choice.
Course Duration
Course duration varies by training format and time needed to effectively cover the material, with hours per day and total days listed.
Generates a branded PDF — downloads directly to your device
Course Overview
The ability to write SQL is an essential job skill for those who need to manage large volumes of data, produce reports, mine data, or combine data from multiple sources. Even if someone else on your team creates reports for you, having a fundamental understanding of SQL querying will help you ask the right questions and know what you’re looking for in your data analysis tools.
Organize the data obtained from a query before it is
displayed onscreen
Retrieve data from multiple tables
Export the results of a query
Who It's For
Beginners seeking to learn SQL querying and database fundamentals.
Data analysts looking to retrieve, filter, and organize data efficiently.
Professionals who need to generate reports from large volumes of data.
IT staff aiming to combine data from multiple tables and sources.
Employees preparing to advance their skills through intermediate or advanced SQL training.
Course Agenda
Six modules · 21 topics
1Executing a Simple QueryTopics 1–4
Connect to the SQL Database
Query a Database
Save a Query
Modify and Execute a Saved Query
2Performing a Conditional SearchTopics 5–7
Search Using One or More Conditions
Range of Values and NULL Values
Search Data Based on String Patterns
3Working with FunctionsTopics 8–10
Perform Date Calculations
Calculate Data Using Aggregate Functions
Manipulate String Values
4Organizing DataTopics 11–16
Sort Data
Rank Data
Group Data
Filter Grouped Data
Summarize Grouped Data
Use PIVOT and UNPIVOT Operators
5Retrieving Data from Multiple TablesTopics 17–19
Combine the Results of Two Queries
Compare the Results of Two Queries
Retrieve Data by Joining Tables
6Exporting Query ResultsTopics 20–21
Generate a Text File
Generate an XML File
About our Trainers
Our Mission
Our facilitators are committed to delivering the latest industry trends, job-specific best practices, and the essential soft and hard skills needed in today’s workforce. PTR offers small and large organizations the choice between onsite and virtual training. Collaborate with our specialists to address challenges, bridge skill gaps, and tailor the learning experience to meet your company’s goals.
What is the SQL Fundamentals: Introduction to Database Querying course about?
This course introduces SQL querying techniques for retrieving, filtering, organizing, and analyzing database information. Participants learn to execute queries, use functions, combine data from multiple tables, and export query results.
Who should attend the SQL Fundamentals course?
The course is suitable for beginners, data analysts, IT professionals, reporting specialists, and employees who work with databases or need to understand how data is retrieved and analyzed.
What will I learn in this SQL training course?
You will learn to connect to a database, write and save queries, apply search conditions, use functions and calculations, sort and group data, retrieve information from multiple tables, and export results.
Will I learn how to filter and search database records?
Yes. You will learn to apply one or more search conditions, work with ranges and NULL values, and search for data using string patterns.
Does the course cover SQL functions and calculations?
Yes. The course covers date calculations, aggregate functions, and string manipulation to help you perform calculations and analyze database information.
Will I learn how to sort, group, and summarize data?
Yes. You will learn to sort and rank records, group data, filter grouped results, summarize information, and use PIVOT and UNPIVOT operators.
Can I learn how to retrieve data from multiple tables?
Yes. The course covers combining and comparing query results and joining tables to retrieve related information from multiple database sources.
SQL Fundamentals: Introduction to Database Querying
Request a Training Quote
Share your team’s goals, and we’ll recommend the right skills training.
PTR Training uses 'cookies' to improve your website experience. View our Privacy Policy for details. By continuing, you agree to accept and adhere to our Terms of Use.
