Oracle Database SQL and PL/SQL New Features Ed 1

Seminar

Online

Preis auf Anfrage

Beschreibung

  • Kursart

    Seminar

  • Methodik

    Online

  • Beginn

    auf Anfrage

The Oracle Database 12c: SQL and PL/SQL New Features training introduces you to the new features available in Oracle Database 12c. Expert Oracle University instructors will help you explore the latest features available in SQL language and feature enhancements in PL/SQL, data types, language performance and data warehousing. In this course, you will be introduced to Oracle Database Exadata Express Cloud Service.Learn To:Understand the FETCH clause to limit the rows returned by a SQL query.Take advantage of the invisible and hidden columns.Make use of the IDENTITY column to automatically generate the number column.Utilize the ACCESSIBLE BY clause to create a white list of PL/SQL units.Grant roles to PL/SQL packages and standalone stored procedures.Understand Synchronous Materialized Views.Identify ways to improve query performance against OLAP cubes.Gain an understanding of the Oracle Database Exadata Express Cloud Service.Benefits to YouWhen you walk away from this course, you will have gained a better understanding of the data warehousing new features available in Oracle Database 12c. This includes maintaining multiple partitions and SQL for pattern matching.

Standorte und Zeitplan

Lage

Beginn

Online

Beginn

auf AnfrageAnmeldung möglich

Hinweise zu diesem Kurs

ProjektmanagerDatenbankadministratorenSystemanalytiker

Erforderliche Vorkenntnisse:Knowledge of Oracle Database, Structured Query Language(SQL), Basic programming concepts such as IF-THEN statements, loops, procedures, and functions

Fragen & Antworten

Ihre Frage hinzufügen

Unsere Berater und andere Nutzer werden Ihnen antworten können

Wer möchten Sie Ihre Frage beantworten?

Geben Sie Ihre Kontaktdaten ein, um eine Antwort zu erhalten

Es werden nur Ihr Name und Ihre Frage veröffentlicht.

Meinungen

Erfolge dieses Bildungszentrums

2020

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

  • SQL
  • PL SQL
  • Service

Inhalte

Course IntroductionSQL Language EnhancementsData Types EnhancementsPL/SQL EnhancementsData Warehousing EnhancementsOracle Cloud Overview
Förderung durch z.B. Bildungsprämie und NRW-Bildungsscheck möglichEmpfehlenswerte verwandte Kurse:Oracle Database: SQL Workshop II Ed 2 The Oracle Database: SQL Workshop II Ed 2 course will help students enhance their skills as Application developers by learning to manage the database objects, data dictionary views and multicolumn subqueries. Students also learn to write more efficient queries using the functions supporting the timezone and regular expressions.Oracle Database: SQL Workshop II This Oracle Database: SQL Workshop II helps you manage the database objects, data dictionary views and multicolumn subqueries. Learn to write more efficient queries using the functions supporting the timezone and regular expressions.Oracle Database: SQL Workshop I Ed 2 The Oracle Database: SQL Workshop I Ed 2 course offers students an introduction to Oracle Database 12c database technology. The students are also introduced to Oracle Database Exadata Express Cloud Service. In this class students learn the concepts of relational databases and the powerful SQL programming language.Oracle Database: SQL Workshop I This Oracle Database: SQL Workshop I introduces you to Oracle Database 12c database technology. Discover essential SQL skills that allow developers to write queries against single & multiple tables, manipulate data in tables & create database objects.Oracle Database: PL/SQL Fundamentals Ed 2 The Oracle Database: PL/SQL Fundamentals Ed 2 course introduces students to the PL/SQL programming language. In the class, students learn to create PL/SQL blocks of application code.Oracle Database: PL/SQL FundamentalsOracle Database: PL/SQL Fundamentals introduces you to the PL/SQL programming language. Learn about stored procedures, functions and creating blocks of application code that can be shared by multiple forms and data management applications. Oracle Database: Develop PL/SQL Program Units Ed 2 The Oracle Database: Develop PL/SQL Program Units Ed 2 course helps students enhance their skills as PL/SQL developers by learning to develop stored procedures, functions, packages, and database triggers. Oracle Database: Develop PL/SQL Program UnitsThis Oracle Database: Develop PL/SQL Program Units training helps you enhance your skills by developing stored procedures, functions, packages, and database triggers. Learn to manage PL/SQL program units and use Oracle-supplied packages. Oracle Database 12c: Advanced PL/SQLThisOracle Database 12c: Advanced PL/SQL training teaches you how to use the advanced features of PL/SQL. Learn how to efficiently design and tune PL/SQL to interface with the database and integrate with the other applications. In this course, you will be introduced to Oracle Database Exadata Express Cloud Service.Oracle Database 12c R2: Advanced PL/SQL Ed 2 In the Oracle Database 12c R2: Advanced PL/SQL course, students learn how to use the advanced features of PL/SQL in order to design and tune PL/SQL to interface with the database and integrate with the other applications. 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=D90165GC10Seminarzeiten dieses Online-Trainings:4:30 Uhr bis 12:30 Uhr (Mitteleuropäischer Zeit)

Oracle Database SQL and PL/SQL New Features Ed 1

Preis auf Anfrage