Skip To Content

SQL Database Concepts, Design & Application (CPD 226)

Term: 2014-2015 - Spring Term

Faculty

Karen A Christy
E-mail address is hidden, click here to e-mail
 

Schedule

Mon-Tue-Wed-Thu-Fri, 8:00 AM - 10:00 AM (3/16/2015 - 5/15/2015) Location: EMP FHTC M113

Description

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