CPD226

CPD226

CPD226 SQL Database Concepts, Design &Application

3 Credit Hours

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 122 Program Logic & Design with Alice 3D; CPD 210 Access Database Concepts, Design, & Applications

2020 Spring Term

Section: O
Course Format: Online Seats Available: 19/20
Type Location Dates Time Meeting Days Instructor
Online 03/17/20 - 05/15/20 Russell Thrailkill
Type Online
Location
Dates 03/17/20 - 05/15/20
Times
Meeting Days
Instructor Russell Thrailkill
Section: A
Course Format: On-Campus Seats Available: 10/24
Type Location Dates Time Meeting Days Instructor
In-Person DWN DC305 03/18/20 - 05/15/20 9:00 AM - 11:00 AM M T W R F Russell Thrailkill
Type In-Person
Location DWN DC305
Dates 03/18/20 - 05/15/20
Times 9:00 AM - 11:00 AM
Meeting Days M T W R F
Instructor Russell Thrailkill