Oracle SQL Intermediate - Data Extraction
Corso
A Milano
Hai bisogno di un coach per la formazione?
Ti aiuterà a confrontare vari corsi e trovare l'offerta formativa più conveniente.
Descrizione
-
Tipologia
Corso
-
Luogo
Milano
L'obiettivo del corso è di consentire ai partecipanti di acquisire una padronanza su come lavorare con il linguaggio SQL nel database Oracle per l'estrazione dei dati a livello intermedio.
Machine Translated
Sedi e date
Luogo
Inizio del corso
Inizio del corso
Profilo del corso
Recommended attendance on the "Oracle SQL for Beginners" training course
Opinioni
Materie
- SQL
- Sub
Programma
Limiting results
- The WHERE clause
- Comparison operators
- LIKE Condition
- Prerequisite BETWEEN ... AND
- IS NULL condition
- Condition IN
- Boolean operators AND, OR and NOT
- Many of the conditions in the WHERE clause
- The order of the operators.
- DISTINCT clause
- The differences between the functions of one and multilines
- Features text, numeric, date,
- Explicit and implicit conversion
- Conversion functions
- Nesting functions
- Viewing the performance of the functions - dual table
- Getting the current date function SYSDATE
- Handling of NULL values
- Grouping functions
- How grouping functions treat NULL values
- Create groups of data - the GROUP BY clause
- Grouping multiple columns
- Limiting the function result grouping - the HAVING clause
- Place subqueries in the SELECT command
- Subqueries single and multi-lineage
- Operators Subqueries single-line
- Features grouping in subquery
- Operators Subqueries multi-IN, ALL, ANY
- How NULL values are treated in subqueries
- UNION operator
- UNION ALL operator
- INTERSECT operator
- MINUS operator
- Revisit Joins
- Combining Inner and Outer Joins
- Partitioned Outer Joins
- Hierarchical Queries
- Revisit sub-queries
- Use of sub-queries as virtual tables/inline views and columns
- Use of the WITH construction
- Combining sub-queries and joins
- OVER clause
- Partition Clause
- Windowing Clause
- Rank, Lead, Lag, First, Last functions
- Types of connectors
- The use NATURAL JOIN
- Aliases tables
- Joins in the WHERE clause
- INNER JOIN
- External Merge LEFT, RIGHT, FULL OUTER JOIN
- Cartesian product
- Revisit Group By function and Having clause
- Group and Rollup
- Group and Cube
Hai bisogno di un coach per la formazione?
Ti aiuterà a confrontare vari corsi e trovare l'offerta formativa più conveniente.
Oracle SQL Intermediate - Data Extraction