• Online, Self-Paced
Course Description

Since Oracle Database 12c is an object-relational database management system, an in-depth understanding of the theoretical and physical aspects of a relational database is a fundamental requirement for a skilled database administrator and developer. This course will teach you about data models, the Entity Relationship Model, the Oracle (HR) sample schema, and the features of SQL Developer – Oracle's free integration development environment. This course is one of a series in the Skillsoft learning path that cover the objectives for the Oracle Database 12c: SQL Fundamentals exam (1ZO-061). The exam is part of the Oracle Certified Associate certification.

Learning Objectives

12c Database and Cloud Features

  • start the course
  • describe the features of Oracle Database 12c
  • describe the salient features of Oracle Cloud 12c

 

Relational Database Management Concepts

  • describe relational and object relational database management systems
  • define the concepts of a relational database
  • describe the data model
  • describe the Entity Relationship Model
  • use the primary and foreign keys to relate multiple tables
  • recognize the relational database terminology

 

Implementation of RDBMS and ORDMS

  • use SQL to query a database and its development environments
  • describe sample schemas in Oracle Database

 

Using SQL Developer

  • list the key features of Oracle SQL Developer
  • create a database connection within SQL Developer
  • browse through the database objects and structures within SQL Developer
  • create a new schema object using SQL Developer
  • use SQL Worksheet to execute SQL and PL/SQL statements and format SQL code
  • work with SQL statements and scripts using SQL Developer
  • execute saved script files using various methods in SQL Developer

 

Additional Features of SQL Developer

  • use snippets in SQL Developer
  • use the Recycle Bin in SQL Developer to recover or purge dropped objects
  • debug procedures and functions
  • display built-in database reports in SQL Developer
  • create a user-defined report in SQL Developer and organize them in folders
  • configure links to external tools and search engines within SQL Developer
  • customize the SQL Developer interface and environment
  • use the Data Modeler in SQL Developer

 

Practice: Working with the HR Schema

  • connect to the database and browse the tables in the HR schema using SQL Developer

 

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.