Oracle Database Administration
Description
This course provides participants with essential knowledge in Oracle SQL and Oracle Database Administration. It covers SQL fundamentals, advanced SQL features, and Oracle 19c administration, including installation, database creation, security, backup, and performance management.
Course Content
• 120h total length
Introduction to Oracle Database
Retrieving Data Using the SQL SELECT Statement
Restricting and Sorting Data
Using Single-Row Functions
Displaying Data from Multiple Tables
Aggregating Data Using Group Functions
Subqueries
Manipulating Data
Creating Database Objects
Review of SQL Workshop I concepts
Advanced SELECT Statements
Advanced Subqueries
Manipulating Data with Advanced Features
Managing Schema Objects
Data Dictionary Views
Controlling User Access
Advanced SQL Functions
Performance Considerations
Introduction
Installing Oracle Grid Infrastructure
Creating Oracle Database
Oracle Database Instance Management
Configuring the Oracle Network Environment
Oracle Database Storage Structures
Administering User Security
Managing Schema Objects
Managing Data Concurrency
Managing Undo Data
Database Maintenance
Performance Management
Backup and Recovery
Moving Data
Working with Oracle Support
Latest Courses
