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