Bizi tercih ettiğiniz için teşekkür ederiz. Ekip üyelerimiz en kısa sürede sizlerle iletişime geçecektir.
Rezervasyonunuzu gönderdiğiniz için teşekkür ederiz! Ekibimizden bir yetkili kısa süre içinde sizinle iletişime geçecektir.
Eğitim İçeriği
This data appears to be a structured outline of a course or training material, likely for a database course focusing on PL/SQL (Oracle's procedural language extension to SQL). Here's a breakdown of the topics covered, organized for clarity:
**I. Core PL/SQL Fundamentals**
* **Introduction to PL/SQL:** (Implied - likely covered in the beginning)
* **Data Types:** (Implied - likely covered in the beginning)
* **Operators & Expressions:** (Implied - likely covered in the beginning)
* **Control Structures:** (Implied - likely covered in the beginning)
* **Subprograms (Procedures & Functions):** (Implied - likely covered in the beginning)
**II. Advanced PL/SQL Concepts**
* **Exception Handling:** (Covered in the first section)
* **Cursors:** (Covered in the first section)
* **Triggers:** (Detailed section - creating, types, restrictions, mutating, finding, dropping, auto-numbering, enabling/disabling)
* **Packages:** (Covered in the first section)
**III. Data Manipulation & Access**
* **Collections:** (Detailed section - %Type variables, record variables, index-by tables, nested tables, varrays, bulk binding)
* **Ref Cursors:** (Detailed section - cursor variables, defining types, constrained/unconstrained)
* **Dynamic SQL:** (Detailed section - binding, native dynamic SQL, DDL/DML, DBMS package)
* **Using Files:** (Detailed section - text files, UTL_FILE package, read/write examples, DBMS_ALERT/JOB packages)
**IV. Data & Sample Data**
* **Sample Data:** (Tables: ORDER, FILM, EMPLOYEE) - Used for exercises and examples.
**V. Specific Topics/Tools**
* **Using Files:** (UTL_FILE package, reading/writing, triggering)
* **Collections:** (Nested tables, varrays, bulk binding)
* **Dynamic SQL:** (DBMS package, SELECT procedures)
**Key Observations & Potential Course Structure:**
* **Practical Focus:** The presence of "Sample Data" and numerous examples suggests a hands-on, practical course.
* **Oracle-Specific:** The use of packages like `UTL_FILE`, `DBMS_ALERT`, `DBMS_JOB`, and the emphasis on dynamic SQL strongly indicate this is an Oracle PL/SQL course.
* **Progressive Difficulty:** The topics seem to build in complexity, starting with core PL/SQL and progressing to more advanced concepts like collections, ref cursors, and dynamic SQL.
* **Workshop/Lab Style:** The frequent mention of examples suggests a workshop or lab-based learning environment.
This outline provides a comprehensive overview of PL/SQL programming, covering both fundamental and advanced concepts. It's a well-structured curriculum suitable for developers or database professionals looking to enhance their PL/SQL skills.
Kurs İçin Gerekli Önbilgiler
Bu kurs yalnızca SQL hakkında bilgi sahibi olanlar için uygundur.
Etkileşimli bir bilgisayar sistemiyle daha önce deneyim sahibi olmak tercih edilir ancak zorunlu değildir.
21 Saat
Danışanlarımızın Yorumları (7)
I liked the hands-on experience and the opportunity to work on actual coding activities
Kristine - Isuzu Philippines Corporation
Eğitim - ORACLE PL/SQL Fundamentals
Relate each topic to a real world application case.
Ferdinand - National Grid Corporation of the Philippines
Eğitim - ORACLE PL/SQL Fundamentals
the practices and the trainer notes
Hamda AlMahri - Dubai Courts
Eğitim - ORACLE PL/SQL Fundamentals
Mr. Khobeib was a great lecturer and trainer. As a beginner to PL/SQL, Khobeib explained the basics and was patient with us while going through the training material. He answered all our questions thoroughly and showed a lot of examples when we asked him to. I definitely learned a lot and can start doing tasks with PL/SQL.
Abdulrahman Alsalami - Dubai Courts
Eğitim - ORACLE PL/SQL Fundamentals
the trainer helpful all the time
Maitha Alselais - Dubai Courts
Eğitim - ORACLE PL/SQL Fundamentals
The trainer was fantastic in all aspects. He was very interactive and engaging. Most importantly, the topics were taught very clearly and at a perfect pace to complete the course. I really appreciate it and would like to give a huge thank you to the trainer.
Vivek Thomas - Estee Lauder BV
Eğitim - ORACLE PL/SQL Fundamentals
It was quite hands-on, not too much theory.
