SQL Querying Fundamentals – Part 1

In this course, students will compose SQL queries to retrieve desired information from a database.

Course Details

Price:

$695.00

Days:

Location:

Virtual

Course Overview

In this course, students will compose SQL queries to retrieve desired information from a database.

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.

Basic computer literacy Basic PC operating system navigation skills Basic Internet usage skills Basic IP address knowledge

1. Using Subqueries to Perform Advanced Querying

Search Based on Unknown Values
Compare a Value with Unknown Values
Search Based on the Existence of Records
Generate Output Using Correlated Subqueries
Filter Grouped Data Within Subqueries
Perform Multiple-Level Subqueries

2. Manipulating Table Data

Insert Data
Modify and Delete Data

3. Manipulating the Table Structure

Create a Simple Table
Create a Table with Constraints
Add or Drop Table Columns
Add or Drop Constraints
Modify the Column Definition
Back Up Tables
Delete Tables

4. Working with Views

Create a View
Manipulate Data in Views
Create Aliases
Modify and Drop Views

5. Indexing Data

Create Indices
Drop Indices

6. Managing Transactions

Create Transactions
Commit Transactions

Class Dates & Times


01/12/2026 Virtual 09:00:00 to 17:00:00 EST Enroll Now $695.00
02/27/2026 Virtual 09:00:00 to 17:00:00 EST Enroll Now $695.00
02/04/2026 Virtual 11:00:00 to 19:00:00 PST Enroll Now $695.00
03/23/2026 Virtual 09:00:00 to 17:00:00 EST Enroll Now $695.00
04/13/2026 Virtual 09:00:00 to 17:00:00 EST Enroll Now $695.00
05/27/2026 Virtual 09:00:00 to 17:00:00 EST Enroll Now $695.00
05/04/2026 Virtual 11:00:00 to 19:00:00 PST Enroll Now $695.00
06/18/2026 Virtual 09:00:00 to 17:00:00 EST Enroll Now $695.00
10/27/2025 Virtual 09:00:00 to 17:00:00 EST Enroll Now $695.00
11/12/2025 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 →