Curso Focado para Certificação Oracle Sql Expert

Neste treinamento vocês serão focados nesses tópicos que abrange a prova de SQL Expert.

Managing Objects with Data Dictionary ViewsUse the data dictionary views to research data on your objectsQuery various data dictionary views

Controlling User AccessDifferentiate system privileges from object privilegesGrant privileges on tablesView privileges in the data dictionaryGrant rolesDistinguish between privileges and roles

Managing Schema ObjectsAdd constraintsCreate indexesCreate indexes using the CREATE TABLE statementCreating function-based indexesDrop columns and set column UNUSEDPerform FLASHBACK operationsCreate and use external tables

Manipulating Large Data SetsManipulate data using subqueriesDescribe the features of multitable INSERTsUse the following types of multitable INSERTs (Unconditional, Conditional and Pivot)Merge rows in a tableTrack the changes to data over a period of time

Generating Reports by Grouping Related DataUse the ROLLUP operation to produce subtotal valuesUse the CUBE operation to produce crosstabulation valuesUse the GROUPING function to identify the row values created by ROLLUP or CUBEUse GROUPING SETS to produce a single result set

Managing Data in Different Time ZonesUse Various datetime functions

Retrieving Data Using SubqueriesWrite a multiple-column subqueryUse scalar subqueries in SQLSolve problems with correlated subqueriesUpdate and delete rows using correlated subqueriesUse the EXISTS and NOT EXISTS operatorsUse the WITH clause

Regular Expression SupportUsing Meta CharactersRegular Expression FunctionsReplacing PatternsRegular Expressions and Check Constraints