Oracle SQL for Administrators Training Course

Foundations of Oracle

• Database architectural components
• The relational database model
• Management of users, schemas, and sessions
• Essential tools for database engagement

The SELECT Statement: An Introduction

• Applying the WHERE clause for data selection and filtering
• Ordering query outputs
• Data types, operators, and the handling of NULL values
• Leveraging built-in scalar functions
• Date manipulation and operations
• Comprehending national and regional configurations within SQL

Utilizing Regular Expressions in SQL

• Employing regular expressions for advanced pattern matching

Analysis of Aggregated Data

• Application of grouping functions
• Use of the DISTINCT clause
• Implementation of GROUP BY and HAVING clauses

Data Retrieval Across Multiple Tables

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

Working with Subqueries

• Simple subquery structures
• Correlated subqueries
• Use of EXISTS and NOT EXISTS operators
• Various other subquery classifications

Hierarchical Queries and Data Sampling

• Building hierarchical structures using CONNECT BY PRIOR and START WITH clauses
• Employing the SYS_CONNECT_BY_PATH function
• Data sampling techniques via the SAMPLE clause

Data Manipulation Language (DML)

• Execution of INSERT, UPDATE, and DELETE statements
• Handling large-scale dataset operations (INSERT FIRST, INSERT ALL, MERGE)

Concurrency Control and User Access

• Transaction management principles
• Locking mechanisms and implementation
• Leveraging FLASHBACK technology

Schema Object Management

• Views
• Sequences
• Private and public synonyms
• Indexing

Conclusion and Recommended Next Steps