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

CT State Community College Catalog 2023-2024 New students enrolling for the first time in Fall 2023 will begin as students of Connecticut State Community College under this catalog.  Continuing students from one of the 12 community colleges will be transitioned into a CT State program in this catalog as of the start of the Fall 2023 term. The policies, courses and programs described are applicable as of the Fall 2023 term and may be updated as circumstances require.

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.