Singapore University of Social Sciences

Oracle Certified Associate

Oracle Certified Associate (ICT255)

Synopsis

The Oracle Certified Associate has two modules: SQL Fundamentals I introduces students to the fundamentals of SQL using Oracle Database 11g database technology. In this course students learn the concepts of relational databases and the powerful SQL programming language. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects. The students also learn to use single row functions to customize output, use conversion functions and conditional expressions and use group functions to report aggregated data. Demonstrations and hands-on practice reinforce the fundamental concepts. Administration Workshop I is designed to give students a firm foundation in basic administration of Oracle Database 11g. In this class, students learn how to install and maintain Oracle Database 11g. Students gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Students learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. The lesson topics are reinforced with structured hands-on practices. Each module will have a certification examination. This course does not carry a Grade Point Value (GPV), but it will count towards fulfilling the credit requirements of the degree.

Level: 2
Credit Units: 10
Presentation Pattern: Every semester

Topics

  • Lab 1

Learning Outcome

  • Learn the concepts of relational databases and the powerful SQL programming language
  • Learn how to install and maintain Oracle Database 11g.
Back to top
Back to top