PROKODA Gmbh

Oracle Database SQL and PL/SQL New Features Ed 1

PROKODA Gmbh
Online

1.354 
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
Beschreibung

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.

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

Zu berücksichtigen

· An wen richtet sich dieser Kurs?

ProjektmanagerDatenbankadministratorenSystemanalytiker

· Voraussetzungen

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

Fragen & Antworten

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

Was lernen Sie in diesem Kurs?

SQL
PL SQL
Service

Themenkreis

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)

User, die sich für diesen Kurs interessiert haben, interessierten sich auch für...
Mehr ansehen