( CPD 226 ) SQL Database Concepts, Design & Application

Students learn how to create and maintain database objects in CPD 226 and how to store, retrieve, and manipulate the data. Students also create SQL blocks of application code that will be shared by multiple forms, reports, and data management in many different applications. Students learn many different types of query development using aggregate functions, sorting options, subqueries, grouping, having, nulls, joins, set operations, views, indexes, and security. Students learn how to apply this to high-end databases like MYSQL, Oracle and SQL Server and to incorporate SQL into computer programs. Prerequisite: CPD 210 Access Database Concepts, Design & Application

3.00 Credit Hours

2016-2017 - Fall Term

No Sections Offered for this Term.

2016-2017 - Spring Term

  Section: A

Seats Available: 15 of 24  

Online Location Dates Time Meeting Days Instructor
  DWN DC305 03/13/2017 - 05/19/2017 08:00 AM - 10:00 AM M T W R F Karen Christy

  Section: E

Seats Available: 24 of 24  

Online Location Dates Time Meeting Days Instructor
  DWN DC305 01/09/2017 - 05/18/2017 05:30 PM - 09:00 PM T R IT Staff

Flint Hills Technical College does not discriminate on the basis of sex including pregnant and parenting students, sexual orientation, handicap, race, color, age, religion, marital status, or national or ethnic origin in educational programs, admissions policies, employment policies, financial aid or other College-administered programs. For questions or concerns regarding non-discrimination contact the Director of Human Resources at 620.343.4600.

Flint Hills Technical College 3301 West 18th Avenue Emporia, KS 66801 620.343.4600
© 2016 - 2017 Flint Hills Technical College

Apply Now