Skip Navigation

In Person help Traditional, instructor-led and offered in a classroom at JCCC

Introduction to SQL

Instructor

Cheryl Roth

See Course Dates

What You Will Learn

Learn to use the SQL Server Management Studio to build basic and advanced Structured Query Language (SQL) statements to retrieve and update data in a database. Topics include: Management Studio, retrieving data from one or more tables, joins, subqueries, insert, update and delete, data types, and SQL Server functions. Using SQL DDL commands for creating databases, tables, and views are also discussed. Special emphasis is given to Functions, Joins, and Subqueries.

Course content applies to SQL Server 2019.


Course content applies to SQL Server 2012, 2016 & 2019.


This section is facilitated by an instructor online. Within 2 business days of the class start date, you will receive instructions about how to access the class online.

Introduction to SQL
Course Dates

In Person help Traditional, instructor-led and offered in a classroom at JCCC

$1,695.00

Introduction to SQL

11/3/2025 - 11/19/2025 M W 5:30PM-9:00PM
17 Seats Open
11/12/2025 - 11/14/2025 W Th F 8:00AM-4:00PM
20 Seats Open

Selected Course

Dates: 11/12/2025 - 11/14/2025 W Th F

Course type: Data Management

Times: 8:00AM-4:00PM

Location: RC, Regnier Center, 253 Campus Map

Contact Hours: 21.0

Other Details

Course Code: SQL-002-42

Category: Data Management

Contact Hours: 21.0

Format: Classroom

Schedule Details:

After registering for this course, you can come back to the catalog to register for more courses.

Issues with registering? Please contact us at CERegistration@jccc.edu or call 913-469-2323.

Similar Courses

Data Management image Introduction to SQL
Online help Learning at your own pace, or facilitated by an instructor
Introduction to SQL Session start date: Sep 17
24.0 contact hours $189.00
Data Management image Data Analytics Workshop
Live Online help Real-time discussions with your instructor and fellow students via technology
Data Analytics Workshop Session start date: Sep 16
12.0 contact hours $1,495.00
Data Management image Intermediate SQL
Online help Learning at your own pace, or facilitated by an instructor
Intermediate SQL Session start date: Sep 17
24.0 contact hours $189.00
Aviation image Drone Photography
In Person help Traditional, instructor-led and offered in a classroom at JCCC
Drone Photography Session start date: Sep 6
3.0 contact hours $49.00
Academic Review image Introduction to Algebra
Online help Learning at your own pace, or facilitated by an instructor
Introduction to Algebra Session start date: Sep 17
24.0 contact hours $169.00
Aviation image Introduction to UAV Drones
In Person help Traditional, instructor-led and offered in a classroom at JCCC
Introduction to UAV Drones Session start date: Sep 6
4.0 contact hours $89.00
Welding image Intro to Welding Short Course
In Person help Traditional, instructor-led and offered in a classroom at JCCC
Intro to Welding Short Course Session start date: Sep 25
16.0 contact hours $499.00
Data Management image Introduction to Python Programming
Live Online help Real-time discussions with your instructor and fellow students via technology
Introduction to Python Programming Session start date: Sep 16
21.0 contact hours $1,495.00
QuickBooks image Introduction to QuickBooks Online
Online help Learning at your own pace, or facilitated by an instructor
Introduction to QuickBooks Online Session start date: Sep 17
24.0 contact hours $159.00
Business and Leadership image Introduction to Nonprofit Management
Online help Learning at your own pace, or facilitated by an instructor
Introduction to Nonprofit Management Session start date: Sep 17
24.0 contact hours $169.00
Data Management image Advanced Data Visualization with Tableau
In Person help Traditional, instructor-led and offered in a classroom at JCCC
Advanced Data Visualization with Tableau Session start date: Nov 17
14.0 contact hours $699.00
Literature and Writing image Introduction to Journaling
Online help Learning at your own pace, or facilitated by an instructor
Introduction to Journaling Session start date: Sep 17
24.0 contact hours $149.00
Web image Introduction to JavaScript
Online help Learning at your own pace, or facilitated by an instructor
Introduction to JavaScript Session start date: Sep 17
24.0 contact hours $189.00
Academic Review image Introduction to Chemistry
Online help Learning at your own pace, or facilitated by an instructor
Introduction to Chemistry Session start date: Oct 15
24.0 contact hours $169.00
Foreign Language image Spanish Immersion Program II
In Person help Traditional, instructor-led and offered in a classroom at JCCC
Spanish Immersion Program II Session start date: Oct 13
20.0 contact hours $159.00
Data Management image Introduction to Python Programming
Live Online help Real-time discussions with your instructor and fellow students via technology
Introduction to Python Programming Session start date: Aug 26
18.0 contact hours $1,995.00
Web image Introduction to Java Programming
Online help Learning at your own pace, or facilitated by an instructor
Introduction to Java Programming Session start date: Sep 17
contact hours $189.00
Business and Leadership image Introduction to Business Analysis
Online help Learning at your own pace, or facilitated by an instructor
Introduction to Business Analysis Session start date: Sep 17
24.0 contact hours $169.00
Foreign Language image Spanish Immersion Program I
In Person help Traditional, instructor-led and offered in a classroom at JCCC
Spanish Immersion Program I Session start date: Sep 8
20.0 contact hours $159.00
Personal Development image Introduction to Artificial Intelligence
Online help Learning at your own pace, or facilitated by an instructor
Introduction to Artificial Intelligence Session start date: Oct 15
24.0 contact hours $169.00
 
Close Modal Window

Online Registration Temporarily Down

Please contact us at ceregistration@jccc.edu or call 913-469-2323 to register now or please visit us later.

Close
Close Modal Window
  1. SQL Server Introduction
    a. Terminology
    b. What is SQL Server
  2. How to use the Management Studio
  3. SQL Basics, retrieving data from one table
    a. Basic SELECT Statements
    b. SELECT list
    c. FROM clause
    d. WHERE clause
    e. ORDER BY clause
  4. Summary Queries
    a. GROUP BY and HAVING clause
  5. Joins, retrieving data from two or more tables
  6. Subqueries
  7. Manipulating Data
    a. Insert
    b. Update
    c. Delete
  8. SQL Data Types
  9. Functions
  10. DDL Commands
    a. Creating Tables
    b. CREATE TABLE
    c. Constraints
    d. Indexes
    e. ALTER TABLE
    f. Creating Views
Close Modal Window

In Person help Traditional, instructor-led and offered in a classroom at JCCC

Introduction to SQL

DATE TIME DAY PRICE AVAILABILITY LOCATION  
11/3/2025 - 11/19/2025 5:30PM-9:00PM M W $1,695.00 17 Seats Open Live Online Campus Map Register
11/12/2025 - 11/14/2025 8:00AM-4:00PM W Th F $1,695.00 20 Seats Open RC, Regnier Center, 253 Campus Map Register
Close Modal Window

In Person help Traditional, instructor-led and offered in a classroom at JCCC

$1,695.00

Introduction to SQL

11/3/2025 - 11/19/2025 M W 5:30PM-9:00PM
17 Seats Open
11/12/2025 - 11/14/2025 W Th F 8:00AM-4:00PM
20 Seats Open

Selected Course

Dates: 11/12/2025 - 11/14/2025 W Th F

Course type: Data Management

Times: 8:00AM-4:00PM

Location: RC, Regnier Center, 253 Campus Map

Contact Hours: 21.0

Other Details

Course Code: SQL-002-42

Category: Data Management

Contact Hours: 21.0

Format: Classroom

Schedule Details:

After registering for this course, you can come back to the catalog to register for more courses.

Issues with registering? Please contact us at CERegistration@jccc.edu or call 913-469-2323.