CENTRO DE FORMACIÓN
MODALIDAD
- Presencial
DURACIÓN
- 14 horas
LUGAR DE IMPARTICIÓN
- Aula Virtual
DOCENTES
- No disponible
El curso responde a las preguntas.
- ¿Cómo construir consultas avanzadas?
- ¿Cómo crear informes avanzados?
Control user access
- User Management
- System permissions and object
- Granting
- Receiving permission
- Roles
- Using the links
Managing schema objects
- ALTER TABLE command
- Adding, modifying, and deleting columns
- Add, remove, turn off constraintów
- Create indexes
- Flashback operations
- External tables
Operations on large data sets
- MERGE command
- DML operations of podzapytaniami
- DML operations with RETURNING clause
- INSERT command multi tables
Conditional expressions
- CASE expression
- DECODE expression
Generate reports by grouping related data
- The GROUP BY clause
- The HAVING clause
- Aggregating data - ROLLUP and CUBE operators
- Identification summaries - GROUPING function
- Aggregating data - GROUPING SETS operator
Managing data in different time zones
- Time zones
- Variations TIMESTAMP
- Differences between DATE and TIMESTAMP
- Conversion operations
Advanced subqueries
- Subqueries
- Multi-column subqueries
- The subquery in the FROM clause
- Correlated subqueries
- WITH clause - re-use query blocks
Join tables
- Inequality in the WHERE clause and the FROM clause
- Semijoin
- Antijoin
The processing of hierarchical data
- The tree structure
- hierarchical Queries
- Pseudo column
- Sort data in a hierarchical query
- Useful functions
Regular expressions
- Simple and complex patterns
Otros cursos bonificables de NobleProg:
¡Bonifica este curso!
Nosotros nos encargamos de gestionar la bonificación de estos cursos. Para información sobre la inscripción, CONTACTA CON EL CENTRO.