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