Course Outline
Controlling User Access
- User management strategies.
- Understanding system privileges and object privileges.
- Granting privileges.
- Revoking privileges.
- Utilizing roles.
- Using synonyms.
Managing Schema Objects
- Using the ALTER TABLE command.
- Adding, modifying, and dropping columns.
- Adding, dropping, and disabling constraints.
- Creating indexes.
- Performing Flashback operations.
- Working with external tables.
Operations on Large Data Sets
- Using the MERGE command.
- Performing DML operations with subqueries.
- Utilizing the RETURNING clause in DML operations.
- Executing multi-table INSERT commands.
Conditional Expressions
- Implementing the CASE expression.
- Implementing the DECODE expression.
Generating Reports by Grouping Related Data
- The GROUP BY clause.
- The HAVING clause.
- Aggregating data using ROLLUP and CUBE operators.
- Identifying summary groups with the GROUPING function.
- Aggregating data using the GROUPING SETS operator.
Managing Data Across Time Zones
- Understanding time zones.
- Variations of the TIMESTAMP data type.
- Differences between DATE and TIMESTAMP.
- Performing conversion operations.
Advanced Subqueries
- Standard subqueries.
- Multi-column subqueries.
- Subqueries within the FROM clause.
- Correlated subqueries.
- Using the WITH clause for reusable query blocks.
Joining Tables
- Handling inequalities in the WHERE and FROM clauses.
- Semijoins.
- Antijoins.
Processing Hierarchical Data
- Understanding tree structures.
- Executing hierarchical queries.
- Utilizing pseudo columns.
- Sorting data in hierarchical queries.
- Employing useful hierarchical functions.
Regular Expressions
- Working with simple and complex patterns.
Requirements
Completion of the introductory Oracle SQL course is required.
Testimonials (7)
many exercises with lots of explanations and time allocated for potential questions.
Theodor - DB Global Technology SRL
Course - Oracle SQL Advanced
An engaging and friendly atmosphere, lots of exercises with gradual increasing complexity to practice theoretical concepts.
Andrei - DB Global Technology SRL
Course - Oracle SQL Advanced
Training was very interactive and the trainer was always trying to make us validate our responses and to share our way of thinking
Roxana - DB Global Technology SRL
Course - Oracle SQL Advanced
The way it was structured as well as the balance between learning, exercises and breaks in order to keep the students engaged
Ciprian - DB Global Technology SRL
Course - Oracle SQL Advanced
Exercises are entertaining and the topics were nicely introduced.
Adrian-Madalin Chirita - DB Global Technology SRL
Course - Oracle SQL Advanced
The trainer knowledge and style of explication
Vlad-Mihai Nicolae - DB Global Technology SRL
Course - Oracle SQL Advanced
There were many exercises
