Workforce Development
Computer Tech Business Skills Development Careers and Trades Healthcare Small Business DevelopmentLife and Leisure
Leisure Life SkillsYouth Programs
Youth Programs
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 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.
Live Online
help
Real-time discussions with your instructor and fellow students via technology
$1,695.00
Introduction to SQL
Selected Course
Dates: 5/21/2024 - 6/6/2024 TuTh
Course type: Data Management
Times: 5:30PM-8:30PM
Location: Live Online Campus Map 
Contact Hours:
Course Code: SLUSQL-100-7
Category: Data Management
Contact Hours: 18.0
Format: Classroom
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 | |
| 5/21/2024 - 6/6/2024 | 5:30PM-8:30PM | TuTh | $1,695.00 | 20 Seats Open | Live Online Campus Map |
Register |
| 8/13/2024 - 8/29/2024 | 5:30PM-8:30PM | TuTh | $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: 5/21/2024 - 6/6/2024 TuTh
Course type: Data Management
Times: 5:30PM-8:30PM
Location: Live Online Campus Map
Contact Hours:
Course Code: SLUSQL-100-7
Category: Data Management
Contact Hours: 18.0
Format: Classroom
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.
need help registering? please contact us at ceregistration@jccc.edu or call 913-469-2323.
Canvas Continuing Education
Join Our Email List 
