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 write basic to advanced Structured Query Language (SQL) Data Manipulation Language (DML) statements to query or update data in a database. Topics include: querying data from one or more tables, joins, subqueries, insert, update and delete, data types, and using functions. SQL Data Definition Language (DDL) commands for creating databases, tables, and views are also introduced. Special emphasis is given to Single Table Queries and Multiple Table Queries (Joins).

The course uses SQL Server as the Database Management System and SQL Server Management Studio as the query tool.


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.

Certification

Data Analyst I Professional Certificate

This certificate is designed for those who are new to the Data Analyst I Role or for those who would like to pursue this role. A data analyst collects and stores data on sales numbers, market research, logistics, linguistics, or other behaviors. They bring technical expertise to ensure the quality and accuracy of the data and then process, design and present it in ways to help people, businesses and organizations make better decisions.

Required Courses.

You must take Excel for Data Analytics first to earn this certificate.

  • Excel for Data Analytics
  • Tableau: Data Visualization Essentials
  • Data Analytics Workshop
  • Intro to SQL
  • Microsoft Power BI: Data Analysis Professional
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
3/30/2026 - 4/15/2026 M W 5:30PM-9:00PM
19 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: Dec 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: Nov 4
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: Nov 12
24.0 contact hours $189.00
Data Management image Advanced Data Visualization with Tableau
Live Online help Real-time discussions with your instructor and fellow students via technology
Advanced Data Visualization with Tableau Session start date: Nov 10
14.0 contact hours $699.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: Nov 12
24.0 contact hours $169.00
 image Introduction to Machine Learning
 
Introduction to Machine Learning Session start date: Jan 14
contact hours $169.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: Nov 12
24.0 contact hours $189.00
Garden image Beekeeping Basics: A Sweet Introduction
In Person help Traditional, instructor-led and offered in a classroom at JCCC
Beekeeping Basics: A Sweet Introduction Session start date: Nov 5
1.5 contact hours $29.00
Motorcycle Training image Introduction to Motorcycle Maintenance
In Person help Traditional, instructor-led and offered in a classroom at JCCC
Introduction to Motorcycle Maintenance Session start date: Nov 17
15.0 contact hours $149.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: Nov 12
24.0 contact hours $169.00
Security image Introduction to Hacking, Defense and Response
Live Online help Real-time discussions with your instructor and fellow students via technology
Introduction to Hacking, Defense and Response Session start date: Nov 10
12.0 contact hours $950.00
Graphic Design image Introduction to Photoshop
In Person help Traditional, instructor-led and offered in a classroom at JCCC
Introduction to Photoshop Session start date: Feb 2
10.0 contact hours $399.00
Web image Programming in C# and .NET
Live Online help Real-time discussions with your instructor and fellow students via technology
Programming in C# and .NET Session start date: Nov 3
30.0 contact hours $2,995.00
Web image Introduction to C# Programming
Online help Learning at your own pace, or facilitated by an instructor
Introduction to C# Programming Session start date: Nov 12
24.0 contact hours $189.00
Web image Introduction to JavaScript
Online help Learning at your own pace, or facilitated by an instructor
Introduction to JavaScript Session start date: Nov 12
24.0 contact hours $189.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: Nov 12
24.0 contact hours $149.00
Personal Development image Introduction to Criminal Law
Online help Learning at your own pace, or facilitated by an instructor
Introduction to Criminal Law Session start date: Nov 12
24.0 contact hours $169.00
Microsoft Office image Introduction to Microsoft Excel 2019/Office 365
Online help Learning at your own pace, or facilitated by an instructor
Introduction to Microsoft Excel 2019/Office 365 Session start date: Nov 12
24.0 contact hours $159.00
Career Planning image Introduction to the Medical Laboratory
Online help Learning at your own pace, or facilitated by an instructor
Introduction to the Medical Laboratory Session start date: Dec 17
24.0 contact hours $149.00
Web image Introduction to DevSecOps
Live Online help Real-time discussions with your instructor and fellow students via technology
Introduction to DevSecOps Session start date: Jan 13
18.0 contact hours $2,295.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
3/30/2026 - 4/15/2026 5:30PM-9:00PM M W $1,495.00 19 Seats Open Live Online 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
3/30/2026 - 4/15/2026 M W 5:30PM-9:00PM
19 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.