Course not currently available
Oracle SQL Advanced Training Course
Course
Online
Description
-
Type
Course
-
Methodology
Online
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?
About this course
Oracle SQL undergoing a course in the first part
Reviews
Subjects
- Access
- SQL
Course programme
- 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
Additional information
Oracle SQL Advanced Training Course