SQL Querying Fundamentals - Part 1
Skip to Scheduled Dates
Course Overview
In this course, students will compose SQL queries to retrieve desired information from a database.
Who Should Attend
Individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases.
Course Objectives
- connect to the SQL Server database and execute a simple query.
- include a search condition in a simple query.
- use various functions to perform calculations on data.
- organize data obtained from a query before it is displayed on-screen.
- retrieve data from tables.
- format an output, save a result, and generate a report.
Course Outline
1 - Executing a Simple Query
- Connect to the SQL Database
- Query a Database
- Save a Query
- Modify a Query
- Execute a Saved Query
2 - Performing a Conditional Search
- Search Using a Simple Condition
- Compare Column Values
- Search Using Multiple Conditions
- Search for a Range of Values and Null Values
- Retrieve Data Based on Patterns
3 - Working with Functions
- Perform Date Calculations
- Calculate Data Using Aggregate Functions
- Manipulate String Values
4 - Organizing Data
- Sort Data
- Rank Data
- Group Data
- Filter Grouped Data
- Summarize Grouped Data
- Use PIVOT and UNPIVOT Operators
5 - Retrieving Data from Tables
- Combine Results of Two Queries
- Compare the Results of Two Queries
- Retrieve Data by Joining Tables
- Check for Unmatched Records
- Retrieve Information from a Single Table Using Joins
6 - Presenting Query Results
- Save the Query Result
- Generate an XML Report
< Back to Course Search
Class times are listed Mountain time
This is a 1-day class
Register |
When |
Time |
Where |
How |
Register
|
12/24/2024 |
7:00AM - 3:00PM |
Online |
VILT |
Register
|
01/07/2025 |
7:00AM - 3:00PM |
Online |
VILT |
Register
|
01/20/2025 |
7:00AM - 3:00PM |
Online |
VILT |
Register
|
01/29/2025 |
7:00AM - 3:00PM |
Online |
VILT |
Register
|
02/11/2025 |
7:00AM - 3:00PM |
Online |
VILT |
Register
|
02/24/2025 |
7:00AM - 3:00PM |
Online |
VILT |
Register
|
03/06/2025 |
7:00AM - 3:00PM |
Online |
VILT |
Register
|
03/20/2025 |
7:00AM - 3:00PM |
Online |
VILT |
Register
|
04/02/2025 |
7:00AM - 3:00PM |
Online |
VILT |
Register
|
04/16/2025 |
7:00AM - 3:00PM |
Online |
VILT |
Register
|
04/29/2025 |
7:00AM - 3:00PM |
Online |
VILT |
Register
|
05/12/2025 |
7:00AM - 3:00PM |
Online |
VILT |
Register
|
05/22/2025 |
7:00AM - 3:00PM |
Online |
VILT |
Register
|
06/05/2025 |
7:00AM - 3:00PM |
Online |
VILT |
Register
|
06/20/2025 |
7:00AM - 3:00PM |
Online |
VILT |