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 timesheets, project management, inventory and health records. This certificate is designed to prepare students for a career as an entry-level database analyst/administrator or an information technology professional who would like to concentrate on 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.

Learning Outcome(s):

✓ 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, and to create useful and professional mainform/subforms

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

✓ Design database by applying normalization rules and creating 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