Live Online
help
Real-time discussions with your instructor and fellow students via technology
Introduction to SQL Server
What You Will Learn
Learn to use the SQL Server Management Studio to build basic and advanced Structured Query Language (SQL) statements to retrieve and update data in a database. Topics include: Management Studio, retrieving data from one or more tables, joins, subqueries, insert, update and delete, data types, and SQL Server functions. Using SQL DDL commands for creating databases, tables, and views are also discussed. Special emphasis is given to Functions, Joins, and Subqueries.
Course content applies to SQL Server 2019.
Course content applies to SQL Server 2012, 2016 & 2019.
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
SQL Server Developer Certificate
As one of the most popular relational database management systems, Microsoft SQL Server's use in large enterprises is continuously growing.
Today, it has become a significant competitor to other relational database products. This certificate provides the foundation for its use, including SQL, T-SQL, application development and integration and reporting services. In this certificate, learn how to define, build and deploy relational databases using SQL Server and how to create and implement advanced reporting solutions. Complete all courses within one year and receive the SQL Server Developer Certificate.
Prerequisite: Basic understanding of relational databases and some limited exposure to simple SQL SELECT statements.
See individual courses for detailed descriptions, outlines and online registration.
Required Courses
- Introduction to SQL Server
- SQL Server Transact-SQL (T-SQL) Programming
- SQL Server Reporting Services (SSRS)
- SQL Server Integration Services (SSIS)
Live Online
help
Real-time discussions with your instructor and fellow students via technology
$1,495.00
Introduction to SQL Server
Selected Course
Dates: 12/2/2024 - 12/18/2024 MW
Course type: Data Management
Times: 5:30PM-9:00PM
Location: Live Online Campus Map 
Contact Hours:
Course Code: SQL-002-40
Category: Data Management
Contact Hours: 21.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
- SQL Server Introduction
a. Terminology
b. What is SQL Server - How to use the Management Studio
- SQL Basics, retrieving data from one table
a. Basic SELECT Statements
b. SELECT list
c. FROM clause
d. WHERE clause
e. ORDER BY clause - Summary Queries
a. GROUP BY and HAVING clause - Joins, retrieving data from two or more tables
- Subqueries
- Manipulating Data
a. Insert
b. Update
c. Delete - SQL Data Types
- Functions
- DDL Commands
a. Creating Tables
b. CREATE TABLE
c. Constraints
d. Indexes
e. ALTER TABLE
f. Creating Views
Live Online
help
Real-time discussions with your instructor and fellow students via technology
Introduction to SQL Server
| DATE | TIME | DAY | PRICE | AVAILABILITY | LOCATION | |
| 12/2/2024 - 12/18/2024 | 5:30PM-9:00PM | MW | $1,495.00 | 17 Seats Open | Live Online Campus Map |
Register |
Live Online
help
Real-time discussions with your instructor and fellow students via technology
$1,495.00
Introduction to SQL Server
Selected Course
Dates: 12/2/2024 - 12/18/2024 MW
Course type: Data Management
Times: 5:30PM-9:00PM
Location: Live Online Campus Map
Contact Hours:
Course Code: SQL-002-40
Category: Data Management
Contact Hours: 21.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.
Canvas Continuing Education
Join Our Email List 
