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: 7/20/2026 - 8/5/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-44

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 Online On Demand
Online help Learning at your own pace, or facilitated by an instructor
Introduction to SQL Session start date: Jul 15
24.0 contact hours $169.00
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
Artificial Intelligence image Online On Demand
Online help Learning at your own pace, or facilitated by an instructor
Introduction to Machine Learning Session start date: Jul 15
24.0 contact hours $169.00
Microsoft Office image Online On Demand
Online help Learning at your own pace, or facilitated by an instructor
Introduction to Microsoft Excel 365 Session start date: Jul 15
24.0 contact hours $169.00
Web image Live Online
Live Online help Real-time discussions with your instructor and fellow students via technology
Introduction to DevSecOps Session start date: Jul 7
18.0 contact hours $2,295.00
Aviation image In Person
In Person help Traditional, instructor-led and offered in a classroom at JCCC
Introduction to Aviation Session start date: Jul 11
3.0 contact hours $49.00
QuickBooks image Online On Demand
Online help Learning at your own pace, or facilitated by an instructor
Introduction to QuickBooks Online Session start date: Jul 15
24.0 contact hours $169.00
Personal Development image Online On Demand
Online help Learning at your own pace, or facilitated by an instructor
Introduction to Artificial Intelligence Session start date: Jul 15
24.0 contact hours $169.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
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: Jul 6
20.0 contact hours $159.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
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
Security image Live Online
Live Online help Real-time discussions with your instructor and fellow students via technology
Security Architecture and Design Session start date: Jul 7
14.0 contact hours $899.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: Jul 14
7.0 contact hours $199.00
Security image Live Online
Live Online help Real-time discussions with your instructor and fellow students via technology
Security+ Exam Prep Session start date: Jul 21
35.0 contact hours $2,199.00
Sign Language image Online On Demand
Online help Learning at your own pace, or facilitated by an instructor
Discover Sign Language Session start date: Jul 15
24.0 contact hours $169.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
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
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
 
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  
7/20/2026 - 8/5/2026 5:30PM-9:00PM M W $1,495.00 20 Seats Open Live Online Campus Map Register
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: 7/20/2026 - 8/5/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-44

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