Breadcrumb
  1. Training
  2. Education & Training Catalog
  3. Intellectual Point
  4. Oracle PL/SQL - Oracle Certified Associate

Oracle PL/SQL - Oracle Certified Associate

For individuals who develop database-centric Internet applications for Oracle. Oracle Certified Associates - PL/SQL demonstrate expertise in building database-centric Internet applications for both Oracle9i and Oracle Database 10g.

Provider Information

More courses from this provider:
Contact Information

Intellectual Point
46175 Westlake Drive
Suite 250
Sterling, VA 20165

Course Overview

Overall Proficiency Level
1 - Basic
Course Catalog Number
Oracle
Course Prerequisites

Prior to OCA courses the applicants have to know how to use the Microsoft Windows. General knowledge of computer programming and databases is also helpful but not required.

Training Purpose
Skill Development
Specific Audience
All
Delivery Method
Classroom
Online, Instructor-Led
Course Location

46175 Westlake Drive, Suite 250
Sterling, VA 20165

  • Classroom
  • Online, Instructor-Led

Learning Objectives

  • Create reports of sorted and restricted data
  • Employ SQL functions to generate and retrieve customized data
  • Display data from multiple tables using the ANSI SQL 99 JOIN syntax
  • Create reports of aggregated data
  • Use the SET operators to create subsets of data
  • Run data manipulation statements (DML) to update data in the Oracle Database 11g
  • Run data definition language (DDL) statements to create and manage schema objects
  • Identify the major structural components of the Oracle Database 11g

Framework Connections

The materials within this course focus on the NICE Framework Task, Knowledge, and Skill statements identified within the indicated NICE Framework component(s):

Specialty Areas

  • Data Administration
  • Systems Administration
  • Test and Evaluation

Specialty Areas have been removed from the NICE Framework. With the recent release of the new NICE Framework data, updates to courses are underway. Until this course can be updated, this historical information is provided to give better context as to how it can help you with your cybersecurity goals.

Feedback

If you would like to provide feedback on this course, please e-mail the NICCS team at NICCS@mail.cisa.dhs.gov(link sends email). Please keep in mind that NICCS does not own this course or accept payment for course entry. If you have questions related to the details of this course, such as cost, prerequisites, how to register, etc., please contact the course training provider directly. You can find course training provider contact information by following the link that says “Visit course page for more information...” on this page.

Last Published Date:

You have been selected to participate in a brief survey about your experience today with National Initiative for Cybersecurity Careers and Studies.

Would you like to participate in our survey?

If you accept you will be leaving the National Initiative for Cybersecurity Careers and Studies website and going to a third party site.
That site may have different privacy, security and accessibility policies than the National Initiative for Cybersecurity Careers and Studies site.
National Initiative for Cybersecurity Careers and Studies does not endorse any commercial products, services, programs or content on the third party website.
Thank you for visiting our site. We hope your visit was informative and enjoyable.