Oracle SQL Advanced
Course
In Bristol, Manchester, Birmingham and 4 other venues
Description
-
Type
Course
-
Location
This course is designed to give delegates practical experience in using some of the more advanced features of Oracle SQL. Additional datatypes and the use of advanced SQL functions and expressions are covered together with enhanced table handling features.
Facilities
Location
Start date
Start date
Start date
Start date
Start date
Start date
Start date
Start date
Reviews
Subjects
- IT
- SQL
Course programme
- Administration and Course Materials
- Course Structure and Agenda
- Delegate and Trainer Introductions
- ANY, ALL or SOME Operators
- Correlated Subqueries
- In-Line Views
- The Exists Operator
- The WITH Clause
- Multi-Column Subqueries
- Insert and Update Using a Query
- Correlated Update and Delete
- Hierarchical data
- The START WITH and CONNECT BY clauses
- The LEVEL pseudo-column
- Sequencing the output
- Eliminating nodes and branches
- Review of basic grouping concepts
- The ROLLUP and CUBE extensions
- The GROUPING SETS extension
- Using the GROUPING and GROUPING_ID functions
- Multi-table Inserts
- Conditional and Unconditional Inserts
- Merging Data into a Table
- Table and View Based Merge
- A Sub Query Based Merge
- Flashback Query
- The DBMS_FLASHBACK Package
- The AS Clause
- Flashback Table
- Flashback Drop
- Flashback Data Archive
- Date, Timestamp and Interval datatypes
- Handling dates and times
- Handling intervals
- Date, timestamp and interval functions and literals
- Related NLS parameters
- Regular Expression Notation
- Character matching
- Repetition operators
- Sub expression grouping
- Regular expression functions
- The Data Dictionary
- Useful Data Dictionary Tables
- Using the Data Dictionary
- Column Operations
- Constraint Operations
- Creating and Dropping Indexes
- B-Tree Indexes
- Function Based Indexes
- Descending Indexes
- Creating and Using External Tables
- System Privileges and Roles
- Create Users
- Alter User Details
- Grant and Revoke Object Privileges
Oracle SQL Advanced