D81142 – Oracle Database 12c: Introduction for Experienced SQL Users

Course Overview 

• Course Objectives, Course Agenda and Class Account Information
• Describe the Human Resources (HR) Schema
• Identify the Appendices Used in this Course

Understanding the Oracle Database Environment 

• Understanding the Oracle Database Environment
• Understanding the Oracle Instance
• Processing a SQL Statement
• Understanding Data Flow During SQL Statement Processing
• Understanding Read Consistency

Using SQL Developer 

• SQL Developer

Getting Started with Oracle SQL 

• Basic SQL statements
• How Oracle SQL treats NULLs
• Using Pseudocolumns
• Using Operators, Expressions and Functions
• Understanding Data Types and Date Format

Combining Tables by Using Advanced Queries 

• Subqueries
• Update and delete rows by using correlated subqueries
• Perform joins in Oracle SQ
• Create a tree-structured report
• Exclude branches from the tree structure

Creating and Managing Tables 

• Using CREATE, ALTER, DROP, RENAME, COMMENT, and TRUNCATE statement
• Create and maintain integrity constraints
• Use the data dictionary to view and maintain information about tables

Creating and Managing Other Oracle Database Objects 

• Create and maintain indexes
• Create and maintain a view
• Create, maintain, and use sequences
• Create private and public synonyms

Oracle Database Extensions to DML and DDL Statements 

• Describe the features of multitable INSERT statements
• Merge rows by using the MERGE statement
• Create and use external tables
• Describe transaction processing

Controlling User Access 

• Discuss the concepts of users, roles, and privileges
• Create users
• Create roles
• Grant and revoke object privileges
• Create and access database links