Database Design Graduate Certificate
Begin Your Journey Take the Next Step
The database design graduate certificate will help prepare the IT professional for a career as a database specialist or aid the newcomer in obtaining a job in this field. It will also prepare someone for one of many other information systems careers in which knowledge of database concepts, the design and implementation of databases, and data warehousing are important. One of the courses available in this program will include project development using Visual.NET enabled databases or web-enabled databases.
The program requires the student to complete a minimum of twelve (12) semester credit hours of course work with a minimum cumulative GPA of 3.0. Regular program prerequisites still apply (CS 500 & CS 501). Courses earned toward a multimedia certificate may be applied to the master's program.
Prerequisite Courses
If required
This is an introductory course in computer programming using a structured programming language. Representative topics include iteration, selection, procedures, functions, arrays, and classes.
A continuation of CS 500, utilizing a structured programming language and classes to further implement multidimensional arrays and other data structures including linked lists, stacks, queues, trees, and more. This course also provides introduction to recursion and data abstraction.
Prerequisite: Take CS-500
Required Courses
CS 603 will be a prerequisite for CS 631, CS 632 and CS 633
This course discusses goals and techniques in the design, implementation, and maintenance of large database management systems: physical and logical organization; file structures; indexing; entity relationship models; hierarchical, network, and relational models; normalization; query languages; and database logic.
This course provides a comprehensive review of data warehousing technology. Areas of study include the evolution of the modern day data warehouse; analysis and collection of business data requirements; dimensional modeling; the loading of data using extraction, transformation, and loading (ETL) processes; data quality issues; and reporting from the data warehouse using SQL and online analytical processing (OLAP) techniques. Several Oracle lab experiments are conducted to provide hands-on experience in the areas of data warehouse design, construction, data loading, and essential reporting techniques.
Prerequisite: TAKE CS-603
This course provides students with an advanced understanding of database technology. In addition to the entity relationship model, alternate database models (such as EAV and OOD) are investigated. Possible topics include indexing, optimization, XML, online analytic processing (OLAP), embedded SQL, locking techniques, and parallel and distributed systems. The focus and specific topics covered in this course change to reflect modern trends and the latest technology.
Prerequisite: Take CS-603
This course provides students with a thorough understanding of database programming. Students use the latest technology to create front-end applications to hit large-scale backend databases. SQL and stored procedures are used to retrieve data from various data stores. Emphasis is placed on a layered approach to programming. User-friendly design principles and business logic are used to teach students how to implement large-scale windows and/or web applications. The specific technology used will vary to reflect current trends in database programming technology.
Prerequisite: TAKE CS-603