Oracle Database 12c: Analytic SQL for Data Warehousing
Seminar
In Gummersbach
Beschreibung
-
Kursart
Seminar
-
Ort
Gummersbach
-
Beginn
auf Anfrage
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. You’ll also learn to use regular expressions and sub-expressions to search for, match, and replace strings. In this course, you will be introduced to Oracle Business Intelligence Cloud Service.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.Gain an understanding of the Oracle Business Intelligence Cloud Service.Benefits to YouEnrolling 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, you’ll deepen your knowledge so you can perform better on the job.Before Attending this CourseBefore 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. You’ll use Oracle SQL Developer to develop program units. SQL*Plus is introduced as an optional tool.
Standorte und Zeitplan
Lage
Beginn
Beginn
Hinweise zu diesem Kurs
Datenbankdesigner Data Warehouse-Analytiker
Erforderliche Vorkenntnisse:Familiarity with SQLData Warehouse design, implementation, and maintenance experienceGood working knowledge of the SQL languageFamiliarity with Oracle SQL Developer and SQL*Plus Oracle Database 11g: Data Warehousing FundamentalsOracle Database: Introduction to SQL Ed 2 Empfohlene Vorkenntnisse:Conceptual experience designing data warehousesPractical experience implementing data warehousesGood understanding of relational technologyOracle Database 11g: Administer a Data WarehouseOracle Database 12c: Introduction for Experienced SQL UsersUsing Java - for PL/SQL and...
Meinungen
Erfolge dieses Bildungszentrums
Sämtlich Kurse sind auf dem neuesten Stand
Die Durchschnittsbewertung liegt über 3,7
Mehr als 50 Meinungen in den letzten 12 Monaten
Dieses Bildungszentrum ist seit 15 Mitglied auf Emagister
Themen
- Server
- SQL
- Business Intelligence
- Service
- Business
Inhalte
Förderung durch z.B. Bildungsprämie und NRW-Bildungsscheck möglichEmpfehlenswerte verwandte Kurse:Oracle Database: SQL Tuning for DevelopersIn the Oracle Database: SQL Tuning for Developers course, you learn about Oracle SQL tuning and how to apply tuning techniques to your SQL code. Learn the different ways in which data can be accessed efficiently. In this course, you will be introduced to Oracle Database Exadata Express Cloud Service.Oracle Database: SQL Tuning for DevelopersIm Kurs "Oracle Database: SQL Tuning for Developers" lernen die Teilnehmer Oracle SQL-Tuning kennen und erfahren, wie sie die Tuningverfahren auf ihren SQL-Code anwenden. Die Teilnehmer lernen die verschiedenen Möglichkeiten kennen, mit denen sie effizient auf Daten zugreifen können.Verwendete Datenbank Version:Oracle Database 12c Release 1 (12.1.0.1.0)URL zur Kursbeschreibung als PDF:http://education.oracle.com/pls/web_prod-plq-dad/view_pdf?c_org_id=34&c_lang=D&c_id=D79991GC10Seminarzeiten dieses Online-Trainings:18:00 Uhr bis 2:00 Uhr (Mitteleuropäischer Zeit)
Oracle Database 12c: Analytic SQL for Data Warehousing