Oracle SQL Intermediate - Data Extraction Kurzusok

  1. Adatbázis Training
  2. Oracle Training
  3. Oracle SQL Intermediate - Data Extraction Kurzusok

Kurzuskód

osqlide

Duration

14 hours (usually 2 days including breaks)

Követelmények

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

Overview

A kurzus célja, hogy a résztvevők elsajátítsák, hogyan dolgozzanak az SQL nyelvvel az Oracle adatbázisban az adatgyűjtéshez közepes szinten.

Machine Translated

Kurzusleírás

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

Ajánlások

★★★★★
★★★★★

Hasonló kategóriák

Related Courses

Oracle SQL LanguageOracle 11g - SQL language for administrators - workshopsOracle 11g - SQL language for developers - WorkshopOracle 11g - Programming with PL / SQL I - WorkshopsOracle 11g - Programming with PL / SQL IIOracle 11g - Application Tuning - WorkshopOracle 12c database administrationORACLE PL/SQL FundamentalsOracle SQL AdvancedOracle SQL for beginnersOracle SQL for development and database managementORACLE SQL FundamentalsOracle SQL IntermediateSQL Advanced level for Analysts SQL Fundamentals

Course Discounts

Cognitive Computing: An Introduction for Business Managers

11/14/2019 - 09:30
Miskolc
Távoktatás
1750EUR
1575EUR
 Tanterem
2150EUR
1975EUR
Read more

Modelling and Forecasting for Government

11/19/2019 - 09:30
Budapest, City Center
Távoktatás
3500EUR
3150EUR
 Tanterem
4100EUR
3750EUR
Read more

Raspberry Pi + OpenCV for Facial Recognition

01/01/2020 - 09:30
Budapest, City Center
Távoktatás
5250EUR
4725EUR
 Tanterem
6050EUR
5525EUR
Read more

Data Visualization

01/27/2020 - 09:30
Pécs, belváros
Távoktatás
7000EUR
6300EUR
 Tanterem
8000EUR
7300EUR
Read more

From Data to Decision with Big Data and Predictive Analytics

02/12/2020 - 09:30
Budapest, City Center
Távoktatás
5250EUR
4725EUR
 Tanterem
6050EUR
5525EUR
Read more

Hírlevél kedvezmény

Tiszteletben tartjuk adatai bizalmas jellegét. A NobleProg soha nem továbbítja e-mail címét harmadik személyeknek.
Hírlevelünkről bármikor leiratkozhat.

Kiemelt ügyfeleink

is growing fast!

We are looking to expand our presence in Hungary!

As a Business Development Manager you will:

  • expand business in Hungary
  • 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!