Oracle SQL Advanced

Oracle SQL undergoing a course in the first part

Listeners

This course is designed for people who want to use the advanced features of SQL in Oracle

The course answers the questions

• How to build advanced queries?
• How to create advanced reports?

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