Oracle SQL Advanced Training Course

Control user access

• User Management
• System permissions and object
• Granting
• Receiving permission
• Roles
• Using the links

• ALTER TABLE command
• Adding, modifying, and deleting columns
• Add, remove, turn off constraintów
• Create indexes
• Flashback operations
• External tables

• MERGE command
• DML operations of podzapytaniami
• DML operations with RETURNING clause
• INSERT command multi tables

• CASE expression
• DECODE expression

• The GROUP BY clause
• The HAVING clause
• Aggregating data - ROLLUP and CUBE operators
• Identification summaries - GROUPING function
• Aggregating data - GROUPING SETS operator

• Time zones
• Variations TIMESTAMP
• Differences between DATE and TIMESTAMP
• Conversion operations

• Subqueries
• Multi-column subqueries
• The subquery in the FROM clause
• Correlated subqueries
• WITH clause - re-use query blocks

• Inequality in the WHERE clause and the FROM clause
• Semijoin
• Antijoin

• The tree structure
• hierarchical Queries
• Pseudo column
• Sort data in a hierarchical query
• Useful functions

• Simple and complex patterns