Cursos de Oracle SQL Intermediate - Data Extraction

  1. Base de Dados Training
  2. Oracle Training
  3. Cursos de Oracle SQL Intermediate - Data Extraction

Nossos Clientes

Código do Curso

osqlide

Duration

14 hours (usually 2 days including breaks)

Requisitos

Recommended attendance on the "Oracle SQL for Beginners" training course

Overview

O objetivo do curso é permitir que os participantes adquiram o domínio de como trabalhar com a linguagem SQL no banco de dados Oracle para extração de dados em nível intermediário.

Machine Translated

Programa do Curso

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

SQL functions

  • 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

Aggregating data using the grouping function

  • 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

Subqueries

  • 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

Operators collective

  • UNION operator
  • UNION ALL operator
  • INTERSECT operator
  • MINUS operator

Further Usage Of Joins

  • Revisit Joins
  • Combining Inner and Outer Joins
  • Partitioned Outer Joins
  • Hierarchical Queries

Further Usage Of Sub-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

Analytics functions

  • OVER clause
  • Partition Clause
  • Windowing Clause
  • Rank, Lead, Lag, First, Last functions

Retrieving data from multiple tables (if time at end)

  • 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

Aggregate Functions (if time at end)

  • Revisit Group By function and Having clause
  • Group and Rollup
  • Group and Cube

Declaração de Clientes

★★★★★
★★★★★

Categorias Relacionadas

Cursos Relacionados

Oracle SQL LanguageAdvanced SQL, Stored Procedures and Triggers for Microsoft SQL ServerOracle 12c database administrationFundamentos ORACLE PL/SQLOracle 18c Migration StrategyMigrating to Oracle Web FormsOracle SQL AdvancedOracle SQL para iniciantesOracle SQL for development and database managementORACLE SQL FundamentalsOracle SQL IntermediárioSQL Advanced level for Analysts SQL FundamentalsSQL Advanced in MySQLSQL in SQL Server

Descontos em Cursos

R Programming for Finance

10/28/2019 - 09:30
Curitiba - Corporate Evolution
A distância
R$41625
R$26.966
 Sala de aula
R$43525
R$28.866
Leia mais

Open Source Cyber Intelligence - Introduction

11/08/2019 - 09:30
Salvador - Mundo Plaza
A distância
R$11063
R$9.956
 Sala de aula
R$12663
R$11.556
Leia mais

Data Visualization: Creating Captivating Reports

01/14/2020 - 09:30
Rio de Janeiro, Lagoa Rodrigo de Freitas - Humaita
A distância
R$30938
R$27.844
 Sala de aula
R$33038
R$29.944
Leia mais

Dos Dados a Decisão com Big Data e Análises Preditivas

01/20/2020 - 09:30
Recife - JCPM Trade Center
A distância
R$30938
R$27.844
 Sala de aula
R$32738
R$29.644
Leia mais

Gerenciando Processos de Negócios com ProcessMaker

02/03/2020 - 09:30
Brasília - Corporate Financial Center
A distância
R$21188
R$19.069
 Sala de aula
R$22988
R$20.869
Leia mais

Boletim Informativo de Descontos

Nós respeitamos a privacidade dos seus dados. Nós não vamos repassar ou vender o seu email para outras empresas.
Você sempre poderá editar as suas preferências ou cancelar a sua inscriçāo.

is growing fast!

We are looking to expand our presence in Brazil!

As a Business Development Manager you will:

  • expand business in Brazil
  • recruit local talent (sales, agents, trainers, consultants)
  • recruit local trainers and consultants

We offer:

  • Artificial Intelligence and Big Data systems to support your local operation
  • high-tech automation
  • continuously upgraded course catalogue and content
  • good fun in international team

If you are interested in running a high-tech, high-quality training and consulting business.

Apply now!