Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Control user access
- User Management
- System permissions and object
- Granting
- Receiving permission
- Roles
- Using the links
Managing schema objects
- ALTER TABLE command
- Adding, modifying, and deleting columns
- Add, remove, turn off constraintów
- Create indexes
- Flashback operations
- External tables
Operations on large data sets
- MERGE command
- DML operations of podzapytaniami
- DML operations with RETURNING clause
- INSERT command multi tables
Conditional expressions
- CASE expression
- DECODE expression
Generate reports by grouping related data
- The GROUP BY clause
- The HAVING clause
- Aggregating data - ROLLUP and CUBE operators
- Identification summaries - GROUPING function
- Aggregating data - GROUPING SETS operator
Managing data in different time zones
- Time zones
- Variations TIMESTAMP
- Differences between DATE and TIMESTAMP
- Conversion operations
Advanced subqueries
- Subqueries
- Multi-column subqueries
- The subquery in the FROM clause
- Correlated subqueries
- WITH clause - re-use query blocks
Join tables
- Inequality in the WHERE clause and the FROM clause
- Semijoin
- Antijoin
The processing of hierarchical data
- The tree structure
- hierarchical Queries
- Pseudo column
- Sort data in a hierarchical query
- Useful functions
Regular expressions
- Simple and complex patterns
Requirements
Oracle SQL undergoing a course in the first part
14 Hours
Testimonials (4)
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
Udrescu Daiana - DB Global Technology SRL
Course - Oracle SQL Advanced
Really liked the trainer's attitude towards the students