J. S., Framestore CFC
B. M., London Internet Exchange
Oracle SQL Advanced training course contents
Retrieve data using subqueries
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.
Enhanced grouping features
Review of basic grouping concepts, The ROLLUP and CUBE extensions, The GROUPING SETS extension, Using the GROUPING and GROUPING_ID functions.
Manage large data sets
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 AS clause, Flashback table, Flashback drop.
Date, time and time zone support
Date, Timestamp and Interval datatypes, Handling dates and times, Handling intervals, Date, timestamp and interval functions and literals, Related NLS parameters.
Regular expression support
Regular expression notation, Character matching, Repetition operators, Sub expression grouping, Regular expression functions.
Manage objects with the Data Dictionary
The Data Dictionary, Useful Data Dictionary tables, Using the Data Dictionary.
Manage schema objects
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.
Why Choose Us
SNT trainers score an average of over 90% on the three main areas of:
- Ability to teach
- Technical knowledge
- Answering questions
We limit our maximum class size to 8 delegates; often we have less than this. This ensures optimal interactivity between delegates and instructor.
"Excellent course. The small class size was a great benefit…" M.B. IBM
We write our own courses; courseware does not just consist of slides and our slides are diagrams not bullet point text. A typical chapter provides clearly defined objectives with a chapter overview, slides with text underneath, a quiz at the end to check the learning of the students. Hands on exercises are at the end and are used to reinforce the theory.