Oracle Database 12c: Analytic SQL for Data Warehousing

      PROKODA Gmbh

      Möchten Sie den Bildungsanbieter lieber direkt anrufen?
      0221/... Mehr ansehen

      Wichtige informationen

      Tipologie Seminar
      Methodologie Online
      Beginn nach Wahl
      • Seminar
      • Online
      • Beginn:
        nach Wahl

      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.

      Einrichtungen (1)
      Wo und wann
      Beginn Lage
      nach Wahl
      Beginn nach Wahl

      Zu berücksichtigen

      · An wen richtet sich dieser Kurs?

      Datenbankdesigner Data Warehouse-Analytiker

      · Voraussetzungen

      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...

      Fragen & Antworten

      Teilen Sie Ihre Fragen und andere User können Ihnen antworten

      Was lernen Sie in diesem Kurs?

      Business Intelligence


      IntroductionGrouping and Aggregating Data Using SQLHierarchical RetrievalWorking with Regular ExpressionsAnalyzing and Reporting Data Using SQLPerforming Pivoting and Unpivoting OperationsPattern Matching using SQLModeling Data Using SQLOracle Business Intelligence Cloud Service Overview
      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 ( zur Kursbeschreibung als PDF: dieses Online-Trainings:18:00 Uhr bis 2:00 Uhr (Mitteleuropäischer Zeit)

      Vergleichen Sie und treffen Sie die beste Wahl:
      Mehr ansehen