Order By Display Density

SQL and SQL Server

XCDS 1000 - SQL Fundamentals

This course introduces the fundamental concepts of SQL. Work with tables, keys, viewing data and functions. This class can be taken as part of the Access Developer Certificate. Class textbook included in course fee. Textbooks distributed in first course meeting. Prerequisite: Access Advanced or Crystal Reports 2011 Fundamentals or comparable knowledge. Programming Fundamentals is recommended but not required.

CEU Hours: 1.4

Contact Hours: 14

Course Outline:

 1.  Relational database definition, integrity, security

 2.  Design methodology

 3.  Data modeling

 4.  Normalization

 5.  Discuss data warehousing concepts

 6.  Overview of distributed databases

 7.  User views

 8.  SQL data types

 9.  SQL commands (create table, alter table, insert into, etc.)

10.  Types and use of keys 

11.  Joining tables (inner joins, outer joins, self-joins)

12.  Shared update considerations

13.  Privileges and security
 
CRN Days Time Date Location Instructor Seats Open
23329 008 MT----- 08:00-03:59 PM 12/19/16-12/20/16 RC 234 Tuck L 10 of 14

XCDS 1006 - SQL Server Integration Services

The SQL Server Business Intelligence Development Suite (BIDS) complements the SQL Server database with several add-on services. One of the main services in the SQL Server BI Platform is SSIS. SQL Server Integration Services (SSIS) is the component of Microsoft SQL Server that replaces Data Transformation Services from earlier versions. In this two-day, instructor-led course, students learn to use SSIS, including transforming data, creating workflows, or maintaining your SQL Server. Major topics include Import and Export Wizard, SSIS Control Flow, SSIS Data Flow, SSIS Workflow, and deploying SSIS Packages. This 2-day, hands-on course is delivered using SQL Server Integration Services 2012. This class can be taken as part of the SQL Server Developer Certificate. Class textbook included in course fee. Textbooks distributed in first course meeting. Prerequisites: Introduction to SQL Server or comparable knowledge.

CEU Hours: 1.4

Contact Hours: 14

•	Introduction to SSIS
•	The SSIS Tools
•	SSIS Tasks
•	Containers
•	The Data Flow
•	Using Variables, Parameters, and Expressions
•	Joining Data
•	Creating and End-to End Package
•	Scripting in SSIS
•	Loading a Data Warehouse
•	Advanced Data Cleansing in SSIS
•	Using the Relational Engine
•	Accessing Heterogeneous Data
•	Reliability and Scalability
•	Understanding and Tuning the Data Flow Engine
•	SSIS Software Development Life Cycle
•	Error and Event Handling
•	Programming and Extending SSIS
•	Adding a User Interface to Your Component
•	External Management and WMI Task Implementation
•	Using SSIS with External Applications
•	Administering SSIS
 
CRN Days Time Date Location Instructor Seats Open
23335 004 MT----- 06:00-09:29 PM 11/28/16-12/06/16 RC 232 Faculty 8 of 14

XCDS 5000 - Web-Based Introduction to SQL

Learn the key concepts of Structured Query Language (SQL) and gain a solid working knowledge of this powerful and universal database programming language. You'll learn the basic structure of relational databases, how to read and write simple and complex SQL statements, and advanced data manipulation techniques. To enroll or for more information about this online class and/or additional start dates, visit http://www.jccc.edu/continuing-education/ways-to-register/ed2go-registration-instructions.html

CEU Hours: 2.4

Contact Hours: 24

 
CRN Days Time Date Location Instructor Seats Open
24315 512 CEONL ------- - 12/14/16-02/03/17 Online Faculty 14 of 15

SQL and SQL Server

XCDS 1000 - SQL Fundamentals

This course introduces the fundamental concepts of SQL. Work with tables, keys, viewing data and functions. This class can be taken as part of the Access Developer Certificate. Class textbook included in course fee. Textbooks distributed in first course meeting. Prerequisite: Access Advanced or Crystal Reports 2011 Fundamentals or comparable knowledge. Programming Fundamentals is recommended but not required.

CEU Hours: 1.4

Contact Hours: 14

Course Outline:

 1.  Relational database definition, integrity, security

 2.  Design methodology

 3.  Data modeling

 4.  Normalization

 5.  Discuss data warehousing concepts

 6.  Overview of distributed databases

 7.  User views

 8.  SQL data types

 9.  SQL commands (create table, alter table, insert into, etc.)

10.  Types and use of keys 

11.  Joining tables (inner joins, outer joins, self-joins)

12.  Shared update considerations

13.  Privileges and security
 
CRN Days Time Date Location Instructor Seats Open
50105 001 --WR--- 06:00-09:29 PM 04/05/17-04/13/17 RC 238 Snyder B 14 of 14
50106 002 MT----- 08:00-03:59 PM 05/15/17-05/16/17 RC 254 Tuck L 14 of 14

XCDS 1001 - SQL Reporting Services

The SQL Server Business Intelligence Development Suite (BIDS) complements the SQL Server database with several add-on services. One of the main services in the SQL Server BI Platform is SSRS. It provides an enterprise-level reporting platform that allows the creation of reports and BI solutions. In this course students learn to author, deploy and manage reports using Microsoft SSRS. This class can be taken as part of the SQL Server Developer Certificate. Class textbook included in course fee. Textbooks distributed in first course meeting. Prerequisites: Introduction to SQL Server or comparable knowledge.

CEU Hours: 1.4

Contact Hours: 14

•	Introducing the Reporting Services Architecture
•	Report Authoring: Designing Efficient Queries
•	Introduction to Reporting Services Design with SQL Server Data Tools
•	Laying out a Report
•	Implementing Dashboard-Style Report Objects
•	Building Reports
•	Using Custom .NET Code with Reports
•	Deploying Reports
•	Rendering Reports from .NET Applications
•	Managing Reports
•	Securing Reports
•	Delivering Business Intelligence with SSRS
•	Creating Reports Using Report Builder 1.0, 2.0, and 3.0
 
CRN Days Time Date Location Instructor Seats Open
50107 001 ---RF-- 08:00-03:59 PM 03/09/17-03/10/17 RC 250 Faculty 14 of 14
50108 002 --WR--- 06:00-09:29 PM 04/19/17-04/27/17 RC 232 Faculty 14 of 14

XCDS 1004 - Introduction to SQL Server

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 class can be taken as part of the SQL Server Developer Certificate. Class textbook included in course fee. Textbooks distributed in first course meeting. Prerequisites: Students should have a basic understanding of relational databases and some limited exposure to simple SQLSELECT statements.

CEU Hours: 2.1

Contact Hours: 21

Outline:

SQL Server Introduction
--Terminology
--What is SQL Server
How to use the Management Studio
SQL Basics, retrieving data from one table
--Basic SELECT Statements
--SELECT list
--FROM clause
--WHERE clause
--ORDER BY clause
Summary Queries
--GROUP BY and HAVING clause
Joins, retrieving data from two or more tables
Subqueries
Manipulating Data
--Insert
--Update
--Delete
SQL Data Types
Functions
DDL Commands
--Creating Tables
---CREATE TABLE
---Constraints
---Indexes
---ALTER TABLE
--Creating Views

 
CRN Days Time Date Location Instructor Seats Open
50109 001 -TWR--- 08:00-03:59 PM 01/24/17-01/26/17 RC 232 Faculty 14 of 14
50110 002 -TWR--- 06:00-09:29 PM 02/28/17-03/09/17 RC 234 Faculty 13 of 14

XCDS 1006 - SQL Server Integration Services

The SQL Server Business Intelligence Development Suite (BIDS) complements the SQL Server database with several add-on services. One of the main services in the SQL Server BI Platform is SSIS. SQL Server Integration Services (SSIS) is the component of Microsoft SQL Server that replaces Data Transformation Services from earlier versions. In this two-day, instructor-led course, students learn to use SSIS, including transforming data, creating workflows, or maintaining your SQL Server. Major topics include Import and Export Wizard, SSIS Control Flow, SSIS Data Flow, SSIS Workflow, and deploying SSIS Packages. This 2-day, hands-on course is delivered using SQL Server Integration Services 2012. This class can be taken as part of the SQL Server Developer Certificate. Class textbook included in course fee. Textbooks distributed in first course meeting. Prerequisites: Introduction to SQL Server or comparable knowledge.

CEU Hours: 1.4

Contact Hours: 14

•	Introduction to SSIS
•	The SSIS Tools
•	SSIS Tasks
•	Containers
•	The Data Flow
•	Using Variables, Parameters, and Expressions
•	Joining Data
•	Creating and End-to End Package
•	Scripting in SSIS
•	Loading a Data Warehouse
•	Advanced Data Cleansing in SSIS
•	Using the Relational Engine
•	Accessing Heterogeneous Data
•	Reliability and Scalability
•	Understanding and Tuning the Data Flow Engine
•	SSIS Software Development Life Cycle
•	Error and Event Handling
•	Programming and Extending SSIS
•	Adding a User Interface to Your Component
•	External Management and WMI Task Implementation
•	Using SSIS with External Applications
•	Administering SSIS
 
CRN Days Time Date Location Instructor Seats Open
50111 001 --WR--- 08:00-03:59 PM 04/05/17-04/06/17 RC 250 Faculty 14 of 14
50112 002 --WR--- 06:00-09:29 PM 05/10/17-05/18/17 RC 232 Faculty 14 of 14

XCDS 1007 - SQL Server T-SQL Programming

Transact-SQL (T-SQL) is a full-featured programming language that extends the power of SQL. In this course students learn to use T-SQL syntax and statements to write effective code for querying and modifying data in SQL Server. Topics include how to code Scripts, as well as T-SQL modules including Stored Procedures, Functions, and Triggers. Other topics include cursors, transactions and locking. This course is designed for developers or database administrators. This 2-day hands-on course is delivered using SQL Server 2012. This class can be taken as part of the SQL Server Developer Certificate. Class textbook included in course fee. Textbooks distributed in first course meeting. Prerequisites: Introduction to SQL Server or comparable knowledge.

CEU Hours: 2.1

Contact Hours: 21

•	T-SQL Statements for Script Processing
•	A Comparison of the Five Types of T-SQL
•	Procedural Programming Options in T-SQL
•	How to code T-SQL Cursors for Use by an Application Program
 
CRN Days Time Date Location Instructor Seats Open
50113 001 MTW---- 08:00-03:59 PM 02/27/17-03/01/17 RC 250 Faculty 14 of 14
50114 002 MTW---- 06:00-09:29 PM 03/27/17-04/05/17 RC 232 Faculty 13 of 14
Clinic Courses (CLI) provide practical application and are offered on or off campus. Instructors supervise/direct student in a simulated or on-site setting.
Face-to-Face Courses (F2F) take place in a classroom. Based on JCCC's Statement of General Education. Students in all classes, including face-to-face classes, are expected to use technology appropriate to the course content and as needed to access web-based course materials. Face-to-face classes typically require access to computer equipment (either at home or in college labs provided for student use) and computing skills utilizing standard office, business and web browsing applications.
Hybrid Courses (HYB) combine face-to-face classroom instruction and the convenience of online web-based learning, resulting in a reduction of the amount of time spent in the face-to-face classroom and a significant increase of time spent studying online materials. Students registered in hybrid courses must attend class meetings as listed in the JCCC Schedule of Classes.
Internships (INT) provide experience to students for on-the-job training with cooperating businesses, agencies, and organizations. The number of hours for each internship varies.
Lab Courses (LAB) are face-to-face classes where students perform tasks as directed by faculty. Faculty members monitor the activity and provide individual and/or group instruction/assistance
Media Courses (MED) deliver all or a portion of instruction through either cable broadcast or pre-recorded video lessons. The videos are available in DVD format from the Billington Library.
Online Courses (ONLNE) use the Internet and a Learning Management System (D2L) to deliver course materials and to facilitate student-instructor, student-content, and student to student interaction. To participate in online courses, the student should have a good understanding of computer hardware and software applications and the Internet.
Continuing Education Online Courses (CEONL) and materials are delivered via the Internet. To participate in online courses, the student should have a good understanding of computer applications and Internet navigation. For more information about this course and other online learning options visit CE Online.
Private (PLV) lessons for credit are available from beginning to advanced in voice, piano, guitar, brass, woodwind and percussion. Lessons are scheduled by arrangement with private music instructors.
Self-Paced Courses (SEL) and Self-Paced Online (SPO) are offered on a schedule of study that allows students more flexible scheduling options. Course interaction is based upon a contract between student - instructor and in some cases can take up to one calendar year to complete. Some courses may use online delivery to facilitate the learning experience.
Self-Paced Courses (SEL) and Self-Paced Online (SPO) are offered on a schedule of study that allows students more flexible scheduling options. Course interaction is based upon a contract between student - instructor and in some cases can take up to one calendar year to complete. Some courses may use online delivery to facilitate the learning experience.
Travel Courses (TRV) may require in-class activities as well as traveling to a destination. Students will be responsible for the cost of the travel as well as the course costs.
Seats Open is an approximation of the number of seats available and may not represent the actual number of seats open at the time of registration.
This course is approved by the Kansas Board of Regents for guaranteed transfer among all Kansas public postsecondary institutions. Additional courses may also be eligible for transfer. Please visit the JCCC Registrar to learn more.