Course Details

Previous Page

Oracle Database 12c - Introduction to SQL: Relational Database and SQL Developer

Target Audience
Expected Duration
Lesson Objectives
Course Number

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.

Target Audience
Functional Implementer, Forms Developer, System Analysts, Application Developers, PL/SQL Developer and learners looking to obtain the Oracle Database 12c Administrator Certified Associated designation or to become an OPN Certified Specialist.


Expected Duration (hours)

Lesson Objectives

Oracle Database 12c - Introduction to SQL: Relational Database and SQL Developer

  • start the course
  • describe the features of Oracle Database 12c
  • describe the salient features of Oracle Cloud 12c
  • 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
  • use SQL to query a database and its development environments
  • describe sample schemas in Oracle Database
  • 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
  • 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
  • connect to the database and browse the tables in the HR schema using SQL Developer
  • Course Number: