Computer Science: Relational Database Development Certificate (CSRD-CC)

This 2024-25 Curriculum Guide is intended as a reference for Fall 2024 registration. The complete 2024-25 Academic Catalog will be finalized on July 1, 2024.

This certificate program is designed for students who are preparing to enter the job market and want to earn a certificate on their way to earning an associate or bachelor’s degree. It also benefits students who already have college degrees and are seeking retraining in the technology. The program provides an understanding of client/server environment, relational database design and development, and Database Administration.

Learning Outcomes:

Upon successful completion of this certificate, the student will:

• Understand the art of data modeling, database design, and database implementation. 
• Identify the components of a database. 
• Utilize the normalization process and implement designs. 
• Understand the role of the data and database administrators. 
• Use Structured Query Language using elements of a popular and widely used relational database package like MS SQL.
• Identify and use appropriate programming constructs to fulfill application logic needs
• Manipulate database tables using SQL programming
• Build error trapping facilities within SQL programs
• Create SQL program units including: procedures, functions, triggers
• Use supplied packages in SQL program units
• Load data into tables from external files using the SQL utilities
• Identify uses of dynamic SQL and object technology
• Establish an in-depth understanding of Database Administration using the DBMS Interfaces.
• Apply the Relational Database Model to understand the Logical and Physical aspects of the DBMS architecture.
• Understand the functions of the Oracle Database Server and Oracle Database Client.
• Create, maintain and manipulate an Oracle Database.
• Understand and apply the Data Dictionary.
• Understand and apply database statistics in relation to performance and integrity of the database.
• Create and understand the application of user roles, privileges, and the security of the database.
• Discuss and understand the concepts of Backup and Recovery Procedures.