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

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.

Prerequisite
None

Expected Duration
109 minutes

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.

Objective

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

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.