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


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/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.

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.

Prerequisites
None

Expected Duration (hours)
1.8

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:
    od_insq_a01_it_enus

    Expertise Level
    Beginner