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

Selected Course

Dates: 10/20/2026 - 11/5/2026 Tu Th

Course type: Data Management

Times: 5:30PM-9:00PM

Location: Live Online Campus Map

Contact Hours: 21.0

Other Details

Course Code: SQL-002-45

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 Live Online
Live Online help Real-time discussions with your instructor and fellow students via technology
Data Analytics Workshop Session start date: Sep 15
12.0 contact hours $1,495.00
Data Management image Live Online
Live Online help Real-time discussions with your instructor and fellow students via technology
Introduction to Python Programming Session start date: Sep 14
21.0 contact hours $1,495.00
Garden image In Person
In Person help Traditional, instructor-led and offered in a classroom at JCCC
Beekeeping Basics: A Sweet Introduction Session start date: Sep 30
1.5 contact hours $29.00
Foreign Language image In Person
In Person help Traditional, instructor-led and offered in a classroom at JCCC
Spanish Immersion Program II Session start date: Sep 12
20.0 contact hours $159.00
Data Management image Live Online
Live Online help Real-time discussions with your instructor and fellow students via technology
Advanced Data Visualization with Tableau Session start date: Aug 31
14.0 contact hours $699.00
Garden image In Person
In Person help Traditional, instructor-led and offered in a classroom at JCCC
Beekeeping: Fundamentals of Hive Management Session start date: Oct 7
8.0 contact hours $129.00
Microsoft Office image Live Online
Live Online help Real-time discussions with your instructor and fellow students via technology
Excel Fundamentals Session start date: Oct 26
7.0 contact hours $199.00
Foreign Language image In Person
In Person help Traditional, instructor-led and offered in a classroom at JCCC
Spanish Immersion Program I Session start date: Oct 14
20.0 contact hours $159.00
Project Management image Live Online
Live Online help Real-time discussions with your instructor and fellow students via technology
PMP® Exam Prep Session start date: Sep 1
35.0 contact hours $1,499.00
Data Management image Live Online
Live Online help Real-time discussions with your instructor and fellow students via technology
Python Programming for Data Analysis Session start date: Aug 4
14.0 contact hours $1,295.00
Music image In Person
In Person help Traditional, instructor-led and offered in a classroom at JCCC
Guitar for Beginners Session start date: Aug 24
8.0 contact hours $129.00
Security image Live Online
Live Online help Real-time discussions with your instructor and fellow students via technology
Artificial Intelligence and Machine Learning for Cybersecurity Operations Session start date: Sep 15
18.0 contact hours $1,995.00
Foreign Language image In Person
In Person help Traditional, instructor-led and offered in a classroom at JCCC
French for Travelers Session start date: Aug 22
20.0 contact hours $139.00
Arts and Crafts image In Person
In Person help Traditional, instructor-led and offered in a classroom at JCCC
Tunisian Crochet Fundamentals: From Basics to Projects Session start date: Sep 1
16.0 contact hours $129.00
Networking image Live Online
Live Online help Real-time discussions with your instructor and fellow students via technology
AWS Academy Cloud Foundations (AWS Certified Cloud Practitioner) Session start date: Sep 22
18.0 contact hours $1,995.00
Data Management image Live Online
Live Online help Real-time discussions with your instructor and fellow students via technology
Certified Entry-Level Python Programmer (PCEP) Certification Prep Session start date: Jul 27
35.0 contact hours $1,999.00
Mediation image In Person
In Person help Traditional, instructor-led and offered in a classroom at JCCC
Civil Mediation Training Session start date: Oct 15
24.0 contact hours $549.00
Security image Live Online
Live Online help Real-time discussions with your instructor and fellow students via technology
Information Security Essentials Session start date: Sep 29
21.0 contact hours $1,299.00
Aviation image In Person
In Person help Traditional, instructor-led and offered in a classroom at JCCC
Private Pilot Ground School Session start date: Aug 17
48.0 contact hours $399.00
Design and Modeling image Live Online
Live Online help Real-time discussions with your instructor and fellow students via technology
Bluebeam Session start date: Dec 1
12.0 contact hours $399.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  
10/20/2026 - 11/5/2026 5:30PM-9:00PM Tu Th $1,495.00 20 Seats Open Live Online Campus Map Register
12/15/2026 - 12/17/2026 8:00AM-4:00PM Tu W Th $1,495.00 20 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

Selected Course

Dates: 10/20/2026 - 11/5/2026 Tu Th

Course type: Data Management

Times: 5:30PM-9:00PM

Location: Live Online Campus Map

Contact Hours: 21.0

Other Details

Course Code: SQL-002-45

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