PROKODA Gmbh

Oracle Database: Program with PL/SQL Ed 2

PROKODA Gmbh
Online

3.385 
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

This Oracle Database: Program with PL/SQL training starts with an introduction to PL/SQL and then explores the benefits of this powerful programming language. Through hands-on instruction from expert Oracle instructors, you’ll learn to develop stored procedures, functions, packages and more.Learn To:Conditionally control code flow (loops, control structures). Create stored procedures and functions.Use PL/SQL packages to group and contain related constructs.Create triggers to solve business challenges.Use some of the Oracle supplied PL/SQL packages to generate screen output and file output.Create custom packages for applications.Write Dynamic SQL code for applications.Benefits to YouEnsure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.Use Oracle SQL DeveloperYou will use Oracle SQL Developer to develop these program units. SQL*Plus is introduced in this course as optional tools.Course BundleNote: This course is a combination of Oracle Database: PL/SQL Fundamentals and Oracle Database: Develop PL/SQL Program Units courses.

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

Zu berücksichtigen

· An wen richtet sich dieser Kurs?

PL/SQL-EntwicklerTechnischer BeraterDatenbankadministratorenSystemanalytikerFormsentwicklerEntwickler

· Voraussetzungen

Erforderliche Vorkenntnisse:Oracle Database: Introduction to SQL Oracle Database: SQL Workshop II Ed 2 Oracle Database: SQL Workshop I Ed 2 Empfohlene Vorkenntnisse:Previous programming experience

Fragen & Antworten

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

Was lernen Sie in diesem Kurs?

SQL
PL SQL

Themenkreis

IntroductionWorking with Oracle Cloud Exadata Express Cloud ServiceIntroduction to PL/SQLDeclare PL/SQL VariablesWrite Anonymous PL/SQL BlocksSQL Statements in a PL/SQL blockControl StructuresComposite Data TypesExplicit CursorsException HandlingStored ProceduresStored FunctionsDebugging SubprogramsPackagesDeploying PackagesImplement Oracle-Supplied Packages in Application DevelopmentDynamic SQLDesign Considerations for PL/SQL CodeTriggersCreating Compound, DDL, and Event Database TriggersPL/SQL Compiler Manage DependenciesIntroductionIntroduction to PL/SQLDeclare PL/SQL IdentifiersWrite Executable StatementsInteraction with the Oracle Server Control StructuresComposite Data Types Explicit CursorsException Handling Stored ProceduresStored Functions and Debugging SubprogramsPackagesDeploying PackagesImplement Oracle-Supplied Packages in Application DevelopmentDynamic SQLDesign Considerations for PL/SQL CodeTriggersCreating Compound, DDL, and Event Database TriggersPL/SQL Compiler Manage Dependencies

Zusätzliche Informationen

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.Oracle Database 12c: Analytic SQL for Data WarehousingThis Oracle Database 12c: Analytic SQL for Data Warehousing training teaches you how to use Analytic SQL to aggregate, analyze, report and model data. Interact with expert Oracle University instructors. In this course, you will be introduced to Oracle Business Intelligence Cloud Service. 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 2 (12.2.0.1.0)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=D80186GC20Seminarzeiten dieses...

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