Oracle SQL for Administrators Training Course

Fundamentals of Oracle

• Database architecture overview
• The relational database model
• Management of users, schemas, and sessions
• Essential tools for database interaction

Mastering the SELECT Statement

• Data selection and filtering via the WHERE clause
• Sorting query outputs
• Data types, operators, and NULL value handling
• Application of built-in scalar functions
• Date manipulation and operations
• SQL national and regional setting considerations

Applying Regular Expressions in SQL

• Pattern matching using regular expressions

Aggregated Data Analysis

• Employing grouping functions
• Use of the DISTINCT clause
• Utilization of GROUP BY and HAVING clauses

Multi-Table Data Retrieval

• Inner and outer joins (INNER JOIN, OUTER JOIN)
• ANSI SQL standards and alternative join methods (SELF JOIN, NATURAL JOIN)
• Set operators (UNION, UNION ALL, INTERSECT, MINUS)

Working with Subqueries

• Basic subquery structures
• Correlated subquery techniques
• Use of EXISTS and NOT EXISTS operators
• Advanced subquery types

Hierarchical Queries and Data Sampling

• Building hierarchical queries with CONNECT BY PRIOR and START WITH
• Path construction using the SYS_CONNECT_BY_PATH function
• Data sampling techniques using the SAMPLE clause

Data Manipulation (DML)

• INSERT, UPDATE, and DELETE statement execution
• Handling large datasets (INSERT FIRST, INSERT ALL, MERGE)

Concurrent User Access Management

• Transaction management concepts
• Locking mechanisms
• Implementation of FLASHBACK technology

Schema Object Overview

• Views
• Sequences
• Private and public synonyms
• Indexes

Course Summary and Future Directions