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: 12/15/2026 - 12/17/2026 Tu W Th

Course type: Data Management

Times: 8:00AM-4:00PM

Location: Live Online Campus Map

Contact Hours: 21.0

Other Details

Course Code: SQL-002-46

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

Online On Demand
Online help Learning at your own pace, or facilitated by an instructor
Introduction to SQL Session start date: Oct 14
24.0 contact hours $169.00
Live Online
Live Online help Real-time discussions with your instructor and fellow students via technology
Data Analytics Workshop Session start date: Nov 3
12.0 contact hours $1,495.00
Online On Demand
Online help Learning at your own pace, or facilitated by an instructor
Introduction to Artificial Intelligence Session start date: Oct 14
24.0 contact hours $169.00
Online On Demand
Online help Learning at your own pace, or facilitated by an instructor
Introduction to Machine Learning Session start date: Nov 11
24.0 contact hours $169.00
Online On Demand
Online help Learning at your own pace, or facilitated by an instructor
Introduction to Microsoft Excel 365 Session start date: Oct 14
24.0 contact hours $169.00
Online On Demand
Online help Learning at your own pace, or facilitated by an instructor
Introduction to QuickBooks Online Session start date: Oct 14
24.0 contact hours $169.00
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
Live Online
Live Online help Real-time discussions with your instructor and fellow students via technology
Advanced Data Visualization with Tableau Session start date: Dec 8
14.0 contact hours $899.00
Live Online
Live Online help Real-time discussions with your instructor and fellow students via technology
Smart Sheets Introduction Session start date: Jan 27
3.0 contact hours $149.00
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
Live Online
Live Online help Real-time discussions with your instructor and fellow students via technology
Revit Design Integration Session start date: Nov 3
21.0 contact hours $599.00
Live Online
Live Online help Real-time discussions with your instructor and fellow students via technology
Security+ Exam Prep Session start date: Nov 3
35.0 contact hours $2,199.00
Live Online
Live Online help Real-time discussions with your instructor and fellow students via technology
Security Architecture and Design Session start date: Oct 20
14.0 contact hours $899.00
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
In Person
In Person help Traditional, instructor-led and offered in a classroom at JCCC
Spanish Immersion Program II Session start date: Jan 26
20.0 contact hours $159.00
Live Online
Live Online help Real-time discussions with your instructor and fellow students via technology
Python Programming for Data Analysis Session start date: Oct 26
14.0 contact hours $1,295.00
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: Nov 9
35.0 contact hours $1,999.00
In Person
In Person help Traditional, instructor-led and offered in a classroom at JCCC
MSF Adventure Bike RiderCourse Session start date: Oct 24
5.0 contact hours $174.00
In Person
In Person help Traditional, instructor-led and offered in a classroom at JCCC
Introduction to Motorcycling - The New Rider Session start date: Feb 19
2.0 contact hours $29.00
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: 12/15/2026 - 12/17/2026 Tu W Th

Course type: Data Management

Times: 8:00AM-4:00PM

Location: Live Online Campus Map

Contact Hours: 21.0

Other Details

Course Code: SQL-002-46

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