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

27 Eylül 2021

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.

27 Eylül 2021
2 Gün
Classroom / Virtual Classroom

İstanbul, Ankara, Londra
05 Ekim 2021
2 Gün
Classroom / Virtual Classroom

İstanbul, Ankara, Londra
06 Ekim 2021
2 Gün
Classroom / Virtual Classroom

İstanbul, Ankara, Londra
25 Ekim 2021
2 Gün
Classroom / Virtual Classroom

İstanbul, Ankara, Londra
01 Kasım 2021
2 Gün
Classroom / Virtual Classroom

İstanbul, Ankara, Londra
07 Kasım 2021
2 Gün
Classroom / Virtual Classroom

İstanbul, Ankara, Londra
14 Kasım 2021
2 Gün
Classroom / Virtual Classroom

İstanbul, Ankara, Londra
16 Kasım 2021
2 Gün
Classroom / Virtual Classroom

İstanbul, Ankara, Londra