Glasspaper er Oracle Approved Education Center i Norge


Oracle Database 12c: Analytic SQL for Data Warehousing

Kursavgift: kr 11 500 | Varighet: 2 dager

Beskrivelse:

This Oracle Database 12c: Analytic SQL for Data Warehousing training teaches you how to interpret the concept of a hierarchical query, create a tree-structured report, format hierarchical data and exclude branches from the tree structure. Youll also learn to use regular expressions and sub-expressions to search for, match, and replace strings.

Learn To:
  • Use SQL with aggregation operators, SQL for Analysis and Reporting functions.
  • Group and aggregate data using the ROLLUP and CUBE operators, the GROUPING function, Composite Columns and the concatenated Groupings.
  • Analyze and report data using Ranking functions, the LAG/LEAD Functions and the PIVOT and UNPIVOT clauses.
  • Perform advanced pattern matching.
  • Use regular expressions to search for, match and replace strings.
Benefits to You;
Enrolling in this course will help data warehouse builders and implementers, database administrators, system administrators and database application developers to better design, maintain and use data warehouses. Through working with expert Oracle University instructors in a hands-on classroom environment, youll deepen your knowledge so you can perform better on the job.


Målgruppe:

  • Datavarehusanalytiker
  • Databaseadministrator


Practical information


Our Oracle courses is conducted at the following hours:
  • Monday to Friday: 09.00 – 16.00
Location
Our Oracle courses will take place at Glasspaper`s course center at Crayon in Nydalen:
Adress: Crayon, Sandakerveien 114A, 0402 Oslo.

Course material
We use official Oracle material in our Oracle trainings. This include eKit (electronic documentation) and Lab environment from Oracle University.



Forkunnskaper:

Before attending this course, you should be familiar with the following: relational database concepts, data warehouse theory and implementation, Oracle server concepts )including application and server tuning) and the operating system environment on which the Oracle Database Server is running. Youll use Oracle SQL Developer to develop program units. SQL*Plus is introduced as an optional tool.

Required Prerequisites:
  • Data Warehouse design, implementation, and maintenance experience
  • Good working knowledge of the SQL Language
  • Familiarity with Oracle SQL Developer and SQL*Plus
  • Familiarity with SQL
  • Oracle Database 11g: Data Warehousing Fundamentals
  • Oracle Database 12c: Introduction to SQL Ed 1.1

Innhold:


Course objectives
  • Group and aggregate data using the ROLLUP and CUBE operators
  • Analyze and report data using Ranking, LAG/LEAD, and FIRST/LAST functions
  • Use the MODEL clause to create a multidimensional array from query results
  • Use Analytic SQL to aggregation, Analyze and Reporting, and Model Data
  • Interpret the concept of a hierarchical query, create a tree-structured report, format hierarchical data, and exclude branches from the tree structure
  • Use regular expressions to search for, match, and replace strings
  • Perform pattern matching using the MATCH_RECOGNIZE clause
Read the complete course description:
Oracle Database 12c: Analytic SQL for Data Warehousing




Epost mottat


Du er nå meldt på nyhetsbrevlisten

Epost mottat


Du er nå meldt på nyhetsbrevlisten

Bestill kurset her

arrow

Velg kurssted

    arrow

    Velg dato

    kurs merket med * har startgaranti

    arrow

    Mailen er sendt:

    Ditt tips er registrert og sendt!
    Vi håper snarlig å se deg på kurs hos oss!

    Feilmelding:

    OBS! Vi har problemer med å sende ditt tips!

    Vi anbefaler deg å sjekke om du har skrevet inn en gyldig mailadresse.

    Tips sjefen

    Lyst til å delta på dette kurset, men må overbevise sjefen først?

    Glasspaper har laget en tips funksjon, som gjør det enklere for deg å overbevise din sjef om at dette kurset er perfekt for deg.
    Det eneste du trenger å gjøre er å fylle ut kontaktinformasjon, så sender vi relevant informasjon om kurset rett til dine utvalgte kontaktpersoner.
    Bruk gjerne funksjonen til å tipse venner og kollegaer om at dette er et nyttig kurs for dem





    Kontakt oss

    Kursansvarlig

    Karin Sørensen

    932 10 626

    karin.sorensen@glasspaper.no


    Glasspaper er kåret til Årets Microsoft Kurspartner 2016 - 2015 - 2014 - 2013 - 2012 - 2011 - 2010 - 2008!