Skip Navigation

Live Online help Real-time discussions with your instructor and fellow students via technology

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

Live Online help Real-time discussions with your instructor and fellow students via technology

$1,495.00

Introduction to SQL

3/30/2026 - 4/15/2026 M W 5:30PM-9:00PM
18 Seats Open

Selected Course

Dates: 3/30/2026 - 4/15/2026 M W

Course type: Data Management

Times: 5:30PM-9:00PM

Location: Live Online Campus Map

Contact Hours: 21.0

Other Details

Course Code: SQL-002-43

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 Data Analytics Workshop
Live Online help Real-time discussions with your instructor and fellow students via technology
Data Analytics Workshop Session start date: Feb 23
12.0 contact hours $1,495.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: Mar 17
18.0 contact hours $2,295.00
Egyptology image Introduction to Hieratic
Live Online help Real-time discussions with your instructor and fellow students via technology
Introduction to Hieratic Session start date: Feb 4
8.0 contact hours $89.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: Apr 4
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: Jan 27
21.0 contact hours $1,495.00
Microsoft Office image Excel Fundamentals
In Person help Traditional, instructor-led and offered in a classroom at JCCC
Excel Fundamentals Session start date: Feb 13
7.0 contact hours $199.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: Mar 2
15.0 contact hours $149.00
Motorcycle Training image Introduction to Motorcycling - The New Rider
In Person help Traditional, instructor-led and offered in a classroom at JCCC
Introduction to Motorcycling - The New Rider Session start date: Mar 5
2.0 contact hours $29.00
Aviation image Introduction to Aviation
In Person help Traditional, instructor-led and offered in a classroom at JCCC
Introduction to Aviation Session start date: Mar 14
3.0 contact hours $49.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: Mar 10
12.0 contact hours $950.00
Aviation image Private Pilot Ground School
In Person help Traditional, instructor-led and offered in a classroom at JCCC
Private Pilot Ground School Session start date: Feb 2
48.0 contact hours $399.00
Mediation image Civil Mediation Training
In Person help Traditional, instructor-led and offered in a classroom at JCCC
Civil Mediation Training Session start date: Mar 12
24.0 contact hours $549.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: May 5
14.0 contact hours $699.00
Data Management image Python Programming for Data Analysis
Live Online help Real-time discussions with your instructor and fellow students via technology
Python Programming for Data Analysis Session start date: Mar 10
14.0 contact hours $1,295.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: Mar 4
16.0 contact hours $499.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: Mar 10
30.0 contact hours $2,995.00
Music image Harmonica for Beginners
In Person help Traditional, instructor-led and offered in a classroom at JCCC
Harmonica for Beginners Session start date: Mar 23
8.0 contact hours $99.00
Web image Javascript in the Browser Context
In Person help Traditional, instructor-led and offered in a classroom at JCCC
Javascript in the Browser Context Session start date: Feb 10
36.0 contact hours $1,599.00
Sign Language image Sign Language I
In Person help Traditional, instructor-led and offered in a classroom at JCCC
Sign Language I Session start date: Feb 10
16.0 contact hours $129.00
Security image Application Security
Live Online help Real-time discussions with your instructor and fellow students via technology
Application Security Session start date: Feb 9
12.0 contact hours $950.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

Live Online help Real-time discussions with your instructor and fellow students via technology

Introduction to SQL

DATE TIME DAY PRICE AVAILABILITY LOCATION  
3/30/2026 - 4/15/2026 5:30PM-9:00PM M W $1,495.00 18 Seats Open Live Online Campus Map Register
Close Modal Window

Live Online help Real-time discussions with your instructor and fellow students via technology

$1,495.00

Introduction to SQL

3/30/2026 - 4/15/2026 M W 5:30PM-9:00PM
18 Seats Open

Selected Course

Dates: 3/30/2026 - 4/15/2026 M W

Course type: Data Management

Times: 5:30PM-9:00PM

Location: Live Online Campus Map

Contact Hours: 21.0

Other Details

Course Code: SQL-002-43

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.

Back to Top