SQL Querying Fundamentals – Part 1
5 Based on 213 reviews- 336,588 Learners
- 287 Courses
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.
Request More InfoUpcoming Class Schedule
$695.00
Jul 31 - Jul 31, 2026
9:00 AM - 5:00 PM America/New_York- VILT
- Aug 20 - Aug 20, 2026
- 9:00 AM - 5:00 PM America/New_York
- VILT
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.
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
Upcoming Schedules
| Date | Time | Enroll |
|---|---|---|
| Jul 31 - Jul 31, 2026 | 9:00 AM - 5:00 PM America/New_York | Add To Cart |
| Aug 20 - Aug 20, 2026 | 9:00 AM - 5:00 PM America/New_York | Add To Cart |
| Sep 09 - Sep 09, 2026 | 9:00 AM - 5:00 PM America/New_York | Add To Cart |
| Sep 28 - Sep 28, 2026 | 9:00 AM - 5:00 PM America/New_York | Add To Cart |
| Oct 15 - Oct 15, 2026 | 9:00 AM - 5:00 PM America/New_York | Add To Cart |
| Nov 04 - Nov 04, 2026 | 8:00 AM - 4:00 PM America/New_York | Add To Cart |
| Nov 24 - Nov 24, 2026 | 9:00 AM - 5:00 PM America/New_York | Add To Cart |
| Dec 15 - Dec 15, 2026 | 9:00 AM - 5:00 PM America/New_York | Add To Cart |
Who should attend SQL Querying Fundamentals – Part 1 Course
Individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases.
Prerequisites for SQL Querying Fundamentals – Part 1 Course
SQL Querying Fundamentals – Part 1 Course Outline
- Connect to a SQL Server database
- Create, modify, and execute queries
- Save and reopen query files
- Limit results using comparison operators
- Combine multiple conditions
- Search for ranges, NULL values, and patterns
- Perform date and time calculations
- Manipulate strings and text fields
- Calculate summaries with aggregate functions
- Sort results and apply custom rankings
- Group data and filter grouped rows
- Pivot and unpivot results for advanced formatting
- Merge data with inner and outer joins
- Identify records without matches
- Compare and combine multiple result sets
- Format and save query results
- Generate basic XML output
- Review common reporting use cases
Resources
FAQs on SQL Querying Fundamentals – Part 1
This course is designed for individuals with basic computer skills who are familiar with database structure and terminology and want to learn how to use SQL to query databases.
Participants should have basic computer literacy, basic PC operating system navigation skills, and basic internet usage skills. No prior SQL experience is required.
You’ll learn to write basic SQL queries, apply WHERE clause filters, use string, numeric, and date functions, group and sort data, join tables, and identify unmatched records using SQL Server.
The course covers six modules: executing basic SQL statements, filtering with conditional logic, using built-in SQL functions, structuring and summarizing output, working across tables with joins, and exporting results and creating reports.
Yes, the course provides practical experience connecting to a SQL Server database, writing and executing queries, formatting results, and applying functions in real query scenarios.