Certificate of Proficiency (Untranscripted): Database

Below is a sample academic plan that shows you how you can complete your Certificate in a timely manner. Your path may look different depending on your circumstances?for example, if you attend part-time, choose to take Intersession or Summer courses, or have earned prior credit (Credit for Prior Learning, Dual Enrollment, Transfer Credit). You are required to meet with a counselor to set up a comprehensive education plan that is tailored to your individual circumstances and goals.

Databases are essentially central to all businesses. They are the means by which large quantities of information can be stored, organized and retrieved, and are used to support an organization's operations, such as payroll and time sheets, project management, inventory and health records. This certificate is designed to prepare students in the career as an entry-level database analyst/administrator or those information technology professionals who would like to concentrate in developing and supporting database management systems. This certificate provides training in creating and maintaining databases based on fundamentals of relational database and Structured Query Language (SQL), and training in generating queries for ad-hoc reporting, stored procedures and functions using the latest database management system (DBMS) software such as Microsoft SQL Server, Oracle and MS Access.

Use Microsoft Access to create a professional and user-friendly working database, to create effective queries in retrieving data, to create effective reports based on given criteria, andto create useful and professional mainform/subforms

Manage, update and retrievedata from DBMS (Database Management System) using the SQL Language commands

Design database by applying normalization rules and create E-R (Entity Relationship) and UML (Unified Modeling Language) diagrams for a given database scenario

Create applications using appropriate Visual Basic or Java programming language to update database table data

Program Map

GE General Education Course
M Major Course
E Elective Course
SI Summer/Intersession Course *
* Course is appropriate for Summer and Intersession, which are accelerated terms.

Getting Started

Comprehensive Education Plan: You are required to meet with a counselor for a comprehensive educational plan that is tailored to your individual circumstances and goals. Please schedule an appointment with a counselor in your first semester.

First Semester

9 units
CMPR 112
Java Programming
This is an introduction Java programming course. Students will learn the Java programming language and syntax for solving problems, and utilize an integrated development environment (IDE) for developing Java applications, and Java virtual machine (JVM) to execute Java programs. The course emphasizes computer science concepts: data types, mathematical operations, I/O (input/output) operations, conditions, iterations, and functions. In addition, software design principles, practices, and utilizing structured methodologies will be covered.
    CMPR 167
    Microsoft Access
    Relational Database Management using Microsoft Access. Includes design, creation and maintenance of a RDBMS, reports and form generation, queries, importing and exporting data, macros and modules using Access Basic.
      CMPR 168
      MS SQL Database Development
      Provides an introduction to relational database fundamentals and SQL programming skills in the Microsoft environment. Topics covered include relational database architecture, database design techniques, and simple and complex query skills. This course is a continuation of CMPR-167 in utilizing Microsoft Access to analyze large amounts of information and manage related data.

        Second Semester

        6 units
        CMPR 113
        Advanced Java
        This advanced Java programming course is project-oriented. Students will get reinforced with advanced Java techniques to solve more complex problems. The course highlights the computer science object-oriented (OOP) paradigm: advanced class design, encapsulation, aggregation, inheritance and development.In addition, GUI (Graphical User Interface) programming, recursion exception and database programming will be covered.
        • Prerequisite: CMPR 112
        CMPR 169
        Structured Query Language (SQL)
        This course covers database concepts and the use of SQL (Structured Query Language). Topics include writing SQL scripts, designing databases, and importing / exporting data across different platforms. Completion of Computer Science 167 or equivalent is recommended.