Database

Program Code: SAC.CISDB.CERT

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.

Learning Outcome(s):

1. 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
2. Manage, update and retrievedata from DBMS (Database Management System) using the SQL Language commands
3. Design database by applying normalization rules and create E-R (Entity Relationship) and UML (Unified Modeling Language) diagrams for a given database scenario
4. Create applications using appropriate Visual Basic or Java programming language to update database table data