Oracle Database: PL/SQL Fundamentals Eğitimi

  • Eğitim Tipi: Classroom / Virtual Classroom / Online
  • Süre: 2 Gün
  • Bu eğitimi kendi kurumunuzda planlayabilirsiniz. Bize Ulaşın!
En Yakın Tarih

31 Ocak 2022

2 Gün

This Oracle Database: PL/SQL Fundamentals training will teach you the basics of PL/SQL, syntax, blocks and programming constructs. By enrolling in a Self-Study Course, you'll be able to learn at your own pace, when it's most convenient for you.Learn To:Identify the programming extensions that PL/SQL provides to SQL.Write PL/SQL code to interface with the database.Design PL/SQL anonymous blocks that execute efficiently.Use PL/SQL programming constructs and conditional control statements.Seamlessly integrate procedural constructs with SQL.Handle run-time errors.Create stored procedures and functions. Develop Your PL/SQL Fundamental SkillsThe Procedural Language extension to SQL (PL/SQL) is Oracle Corporation's standard data access language for relational databases. Invest in this course to develop core PL/SQL skills that will serve you well in your career.


Audiences

Application Developers

Database Administrators

Database Designers

Forms Developer

PL/SQL Developer

Technical Consultant




Objectives

Identify the steps for getting started with PL/SQL, recognizing the benefits of the available tools

Identify the steps for using PL/SQL to manipulate data, control transactions, determine the outcome of statements, and create loops and conditional control structures

Recognize ways to create user-defined PL/SQL records and INDEX BY tables, and identify the steps for declaring and controlling explicit cursors and cursors with parameters

Recognize ways to handle unanticipated errors in PL/SQL, write stored procedures and functions, deploy Java applications and Web services, and use cursor variables




Topics

Oracle Database 11g: PL/SQL Variables, Attributes, and Executable Statements


Oracle Database 11g: Using DML, DDL, Cursors, Control Structures, and Loops


Oracle Database 11g: Using Data Types, INDEX BY Tables, and Cursors in PL/SQL


Oracle Database 11g: Working with Exceptions, Subprograms, JDeveloper, and REF Cursors


Herhangi bir ön koşul yoktur. 



Eğitimlerle ilgili bilgi almak ve diğer tüm sorularınız için bize ulaşın!

Yakın tarihte açılacak eğitimler

Sınıf eğitimlerimizi İstanbul, Ankara ve Londra ofislerimizde düzenlemekteyiz. Kurumunuza özel eğitimleri ise, dilediğiniz tarih ve lokasyonda organize edebiliriz.

31 Ocak 2022

Classroom / Virtual Classroom

İstanbul, Ankara, Londra
27 Şubat 2022

Classroom / Virtual Classroom

İstanbul, Ankara, Londra
02 Mart 2022

Classroom / Virtual Classroom

İstanbul, Ankara, Londra
06 Mart 2022

Classroom / Virtual Classroom

İstanbul, Ankara, Londra
19 Mayıs 2022

Classroom / Virtual Classroom

İstanbul, Ankara, Londra
24 Temmuz 2022

Classroom / Virtual Classroom

İstanbul, Ankara, Londra
09 Ağustos 2022

Classroom / Virtual Classroom

İstanbul, Ankara, Londra
27 Eylül 2022

Classroom / Virtual Classroom

İstanbul, Ankara, Londra