Live Online
help
Real-time discussions with your instructor and fellow students via technology
Introduction to SQL
What You Will Learn
In this course students learn to use Management Studio and build basic and advanced Structured Query Language (SQL) statements to retrieve and update data in a database. Topics include how to use Management Studio, retrieving data from one or more tables, Joins, Subqueries, Insert, Update and Delete, Data Types, and SQL Server Functions. SQL DDL commands for creating databases, tables, indexes and views are also covered. Special emphasis is given to Functions, Joins, and Subqueries. Management Studio and its capabilities and tools are also explored.
This course is not eligible for the Take 3 Discount.
This course is offered in collaboration with partners SLU Workforce Center and Johnson County Community College Continuing Education.
This course is a component of the Data Analyst I Professional Certificate.
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
- Excel for Data Analytics
- Tableau: Data Visualization Essentials
- Data Analytics Workshop
- Intro to SQL
- Power BI
Certificate
Live Online
help
Real-time discussions with your instructor and fellow students via technology
$1,695.00
Introduction to SQL
Selected Course
Dates: 7/7/2025 - 7/23/2025 M W
Course type: Data Management
Times: 5:30PM-8:30PM
Location: Live Online Campus Map 
Contact Hours:
Course Code: SLUSQL-100-12
Category: Data Management
Contact Hours: 18.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
1. SQL Server Introduction
1. Terminology
2. What is SQL Server
2. How to use the Management Studio
3. SQL Basics, retrieving data from one table
1. Basic SELECT Statements
2. SELECT list
3. FROM clause
4. WHERE clause
5. ORDER BY clause
4. Summary Queries
1. GROUP BY and HAVING clause
5. Joins, retrieving data from two or more tables
6. Subqueries
7. Manipulating Data
1. Insert
2. Update
3. Delete
8. SQL Data Types
9. Functions
1. DDL Commands
2. Creating Tables
1. CREATE TABLE
2. Constraints
3. Indexes
4. ALTER TABLE
3. Creating Views
Live Online
help
Real-time discussions with your instructor and fellow students via technology
Introduction to SQL
| DATE | TIME | DAY | PRICE | AVAILABILITY | LOCATION | |
| 7/7/2025 - 7/23/2025 | 5:30PM-8:30PM | M W | $1,695.00 | 20 Seats Open | Live Online Campus Map |
Register |
| 8/12/2025 - 8/28/2025 | 5:30PM-8:30PM | Tu Th | $1,695.00 | 20 Seats Open | Live Online Campus Map |
Register |
Live Online
help
Real-time discussions with your instructor and fellow students via technology
$1,695.00
Introduction to SQL
Selected Course
Dates: 7/7/2025 - 7/23/2025 M W
Course type: Data Management
Times: 5:30PM-8:30PM
Location: Live Online Campus Map
Contact Hours:
Course Code: SLUSQL-100-12
Category: Data Management
Contact Hours: 18.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.
Canvas Continuing Education
Join Our Email List 
