typeAikin Kwalejin
rajistar

Tuntube Mu

Ƙungiyoyi da aka lakafta da wani * ana buƙatar

 

Oracle 11 g PL SQL Developer

Oracle 11 g PL SQL Developer Training Course & Certification

Overview

Masu sauraro & kaddara

Jagoran Bayanan

Jadawalin & Kudin

Certification

Oracle 11 g PL SQL Developer Training Course Overview

PL / SQL ne hadewa na SQL tare da fasali na tsarin shirye-shirye. Cibiyar Oracle ta ƙaddamar da ita a farkon 90 ta don bunkasa damar SQL.PL/SQL (Harshen Tsarin Harshe / Structured Query) shine Oracle Corporation ta hanyar haɓakawa ta hanyar SQL da Oracle relational database. PL / SQL yana samuwa a cikin Oracle Database

Manufofin Oracle 11 g PL SQL Developer Training

Bayan kammala wannan darasi, ya kamata ka iya:

  • Bayyana ainihin mahimmancin harshe PL / SQL
  • Rubuta da aiwatar da shirye-shiryen PL / SQL cikin SQL * Plus
  • Ayyukan PL / SQL nau'in fasalin bayanai
  • Nuna fitarwa ta hanyar shirye-shiryen PL / SQL
  • Sarrafa halayen kirki a shirye-shiryen PL / SQL
  • Debug PL / SQL shirye-shirye

Amfani masu saurare don Oracle 11 g PL SQL Developer hanya

An tsara wannan koyawa don masu sana'a na Software, waɗanda suke son su koyi PL / SQL Shirya Harshe a cikin matakai mai sauki da sauƙi. Wannan koyaswar za ta ba ka babban fahimta game da ka'idoji na PL / SQL, kuma bayan kammala wannan koyawa, za ka kasance a matsakaicin matakin gwaninta daga inda za ka iya kai kanka zuwa matakin da ke da kwarewa.

Abinda ake bukatadon Oracle 11 g PL SQL Developer Certification

Ya kamata ku sami fahimtar fahimta software asali mahimmanci kamar abin da ke cikin bayanai, lambar tushe, edita rubutu da aiwatar da shirye-shiryen, da dai sauransu. Idan kun rigaya fahimtar SQL da sauran harshe shirye-shiryen kwamfuta don haka zai zama wani ƙarin amfani don ci gaba.

Ra'ayin Zuwa Duration: 3 Days

  1. Gabatarwa ga PL / SQL
  • Gano amfanin amfanin shirin PL / SQL
  • Bayani na irin nau'ikan PL / SQL
  • Ƙirƙiri Ƙarin Bincike M
  • Yadda za a samar da fitarwa daga PL / SQL Block?

2. Bayyana masu amfani da PL / SQL

  • Rubuta nau'ikan Masarrafan Gida a cikin wani tsari na PL / SQL
  • Amfani da Yanayin Bayanai don Ƙayyade Masu Bayarwa
  • Yi amfani da canje-canje don adana bayanai
  • Gano Nau'in Bayanan Scalar
  • A% TYPE Attribute
  • Mene ne Bind Variables?
  • Takaddun kalmomin PL / SQL

3. Rubuta Bayanai Kalmomin

  • Bayyana ka'idoji na PL / SQL Block Syntax
  • Koyi don Sharhi Code
  • Yin amfani da ayyuka na SQL a PL / SQL
  • Yadda za a maida iri iri?
  • Yi Bayyana Kuskuren Nested
  • Gano masu aiki a PL / SQL

4. Haɗi tare da Oracle Server

  • Kira Bayanan SELECT a PL / SQL
  • Sauke Bayanai a PL / SQL
  • SQL Cursor ra'ayi
  • Ka guje wa Kurakurai ta amfani da Gudun Naming lokacin amfani da Sake dawo da Bayanan DML
  • Riga bayanai a cikin Server ta amfani da PL / SQL
  • Fahimci ka'idar SQL Cursor
  • Yi amfani da Halayen Cursor SQL don Samun Bayanan DML
  • Ajiye da kuma watsar da ayyuka

5. Control Structures

  • Yin amfani da yanayin ta amfani da Bayanan IF
  • Yin amfani da ka'ida ta amfani da Bayanan CASE
  • Bayyana Magana mai sauƙi
  • Bayyana Duk da yake Bayanin Loop
  • Bayyana Ga Bayanin Gida
  • Yi amfani da Bayanin Ci gaba

6. Bayanan Bayanan Haɗakarwa

  • Yi amfani da PL / SQL Records
  • Sakamakon% ROWTYPE
  • Shigar da Sabuntawa da PL / SQL Records
  • SANTA DA Tables
  • Binciken CIKIN DUNIYA ta hanyar tafarki
  • Yi amfani da INDEX BY Table of Records

7. Cursors Bayani

  • Mene ne Cursors Bayani?
  • Bayyana Mai Cursor
  • Bude Cursor
  • Ana samo bayanai daga Mai karfin
  • Rufe Cursor
  • Cursor GA madauki
  • Sakamakon% NOTFOUND da% ROWCOUNT
  • Yi bayani akan FASHIN GABATARWA DA BABI NA BAYANE

8. Hanyar Hanya

  • Fahimci Ban
  • Gyara Hannu tare da PL / SQL
  • Ra'ayoyin da aka yi wa Error Server Errors
  • Tana Hanyoyin Cutar Neman Kuskuren Bacci
  • Tarkon Ƙirar Mai amfani
  • Abun ƙari
  • RAISE_APPLICATION_ERROR Hanyar

9. Dokar da aka adana

  • Ƙirƙirar Shirin Shirye-shiryen Shirye-shiryen Ba da Lissafi
  • Shirya Ƙaddamarwa tare da Gwanayen PL / SQL
  • Yi la'akari da PL / SQL Kashe Girma
  • Yi amfani da amfanin amfanin amfani da PL / SQL Subprograms
  • Rubuta bambance-bambance a tsakanin Maƙalalan Abubuwa da Subprograms
  • Ƙirƙirar, Kira, da kuma Cire hanyoyin da aka adana
  • Aikace-aikacen Matakan Hanyoyi da Yanayin Matakan
  • Duba Bayanin Shirin

10. Ayyuka da aka adana da kuma ƙaddamar da Shirye-shiryen Subprograms

  • Ƙirƙirar, Kira, kuma Cire Ɗaukaka Taskar
  • Gano amfanin da ake amfani da Abubuwan Da aka Ajiye
  • Gano matakai don ƙirƙirar aikin adana
  • Kira Ayyuka da aka ƙayyade na mai amfani a cikin Bayanan SQL
  • Ƙuntatawa lokacin kira Ayyuka
  • Ƙaramar haɓaka a yayin da ake kira Ayyuka
  • Duba Shafin Ayyuka
  • Ta yaya za a dage ayyuka da hanyoyin?

11. Packages

  • Listing da abũbuwan amfãni na Packages
  • Bayyana kwangila
  • Mene ne kayan haɗin Package?
  • Samar da Kunshin
  • Ta yaya za a iya ganin bayyanar wani abun da ke cikin Package?
  • Ƙirƙirar Musamman bayani da Jiki ta amfani da SQL CREATE Statement da SQL Developer
  • Kira da Gidan Gida
  • Dubi Ka'idar PL / SQL ta amfani da Bayanan Bayanan

12. Deploying Packages

  • Ana sauke Subprograms a PL / SQL
  • Yi amfani da Jakar Kayan Farawa
  • Yi amfani da Jagoran Bayanai don magance Hukuncin Shari'a marar adalci
  • Yi aiwatar da ayyuka na Kunshin bayanai a cikin SQL da Ƙuntatawa
  • Kasashe na Packages
  • Ƙasashen Tsarin Kasuwanci
  • Sakamakon kariya na PL / SQL Subprograms
  • Kira PL / SQL Tables na Records a cikin Packages

13. Aikace-aikacen Saitunan Oracle-Kasuwanci a Cibiyar Haɓaka Aikace-aikace

  • Menene Oracle-Samar da Packages?
  • Misalai na wasu daga cikin Oracle-Samun Packages
  • Yaya aikin DBMS_OUTPUT Package yake?
  • Yi amfani da Kunshin UTL_FILE don Tattaunawa tare da Fayilolin Mai sarrafawa Fayiloli
  • Kira UTL_MAIL Package
  • Rubuta Ƙananan Shirin UTL_MAIL

14. Dynamic SQL

  • Kuskuren Kashewa na SQL
  • Mene ne Dynamic SQL?
  • Yi Bayyana Maɓuɓɓuwan Cursor
  • Dynamically aiwatar da wani PL / SQL Block
  • Sanya Gidan Dynamic SQL don Tattauna PL / SQL Code
  • Yadda za a kira DBMS_SQL Package?
  • Yi aiwatar da DMS_SQL tare da Bayanan DML da aka ƙayyade
  • Dynamic SQL Functional Kammala

15. Zane-zane na Mahimmanci na PL / SQL Code

  • Ƙididdigar Dattijai da Baya
  • Yi la'akari da abubuwan da ke cikin gida
  • Rubuta Ƙamalen Yanayi
  • Yi amfani da NOCOPY Compiler Conception
  • Kira da Alamar PARALLEL_ENABLE
  • Hanya na PL / SQL Sakamakon Sakamako
  • HALITTA DETERMINISTIC tare da Ayyuka
  • Amfani da ƙaddamarwa na Bulk don inganta aikin

16. Ƙwaƙwalwa

  • Bayyana masu cajin
  • Gano abubuwan da ke faruwa a ciki da Jiki
  • Ayyukan Kasuwancin Kasuwanci don Ana aiwatar da Triggers
  • Ƙirƙiri DML Triggers ta amfani da CREATE TRIGGER Statement da kuma SQL Developer
  • Gano irin abubuwan da ke faruwa a cikin mawuyacin hali, Jiki, da Fassara (Lokaci)
  • Bambanci tsakanin Magana da Ƙididdigar Ƙwararrun Ƙwararraki da Ƙwararraki
  • Ƙirƙiri maimakon Maɗaukaki
  • Yadda za a Sarrafa, Gwaji da Cire Triggers?

17. Ƙirƙirar Ƙara, DDL, da Ƙarin Tarihin Bayanan Labaran

  • Mene ne Ma'anar Tambaya?
  • Ƙididdige Matakan Lissafi na Ƙididdigar Lissafi
  • Yi la'akari da Maɗaukaki Ƙarƙashin Maɗaukaki ga Tables da Views
  • Yi aiwatar da Maɗaukaki Maɗaukaki don Gyara Abun Cutar Mutant
  • Daidaita Ƙididdiga na Taswirar Database zuwa Tsarin Ajiyayyen
  • Ƙirƙiri Ƙwararraki a kan Bayanan DDL
  • Ƙirƙirar Ayyukan Kayan Gida da Tsarin Kayan Gida-Yanayi
  • Abubuwan Da ake Bukatar Gudanar da Gudanar da Triggers

18. PL / SQL Mai tarawa

  • Mene ne PL / SQL Mai Compiler?
  • Bayyana ainihin sakonni na farko na PL / SQL
  • Rubuta sabon PL / SQL Tattara Gargaran Lokaci
  • Bayani na PL / SQL Tattara Gargaɗi na lokaci don Subprograms
  • Lissafin amfani da Gargaɗi Masu Shirye-shiryen
  • Rubuta PL / SQL Tattara Saƙonni Masu Gargaɗi Na Wajabi
  • Sanya Saƙonni na Gargaɗi Levels: Amfani da Developer SQL, PLSQL_WARNINGS Faɗakarwar Faɗakarwa, da kuma DBMS_WARNING Duba Masu Gargaɗi Masu Tsarawa: Amfani da SQL Developer, SQL * Plus, ko Bayanin Bayanan Bayanan Bayanai.

19. Sarrafa Yanayayyun

  • Bayani na Taswirar Abin dogara
  • Mahimman Bayanan Gidan Layi na Neman Gida ta amfani da USER_DEPENDENCIES View
  • Tambayi Matsayin Gane
  • Inganci na Abubuwan Dama
  • Nuna Rayayyun Dama da Kai tsaye
  • Gudanar da Gudanar da Harkokin Gudanarwa a Oracle Database 12c
  • Fahimtar Ƙididdiga na Nesa
  • Koma wani tsarin PL / SQL Shirin

Upcoming Events

Babu abubuwa masu zuwa a wannan lokaci.

Da fatan a rubuta mana a info@itstechschool.com & tuntube mu a don farashin farashin & farashin takardun shaida, tsarawa & wuri

Drop Us a Query

Certification

Dole ne a kammala shirye-shiryen 'yan takara don yin gwaji guda biyu:
Mataki na Step1 Wannan Bincike
Zaɓi daya daga cikin waɗannan gwaji
Masanin Tarihi na SQL Database
OR
Oracle Database 11g: SQL Asusun I
OR
Oracle Database 12c: SQL Asusun
Mataki na Step2 Wannan Bincike
Zaɓi daya daga cikin waɗannan gwaji
Shirin tare da PL / SQL
OR
Cibiyar Ma'anar Bayanai ta 11: Shirye-shiryen tare da PL / SQLKarin ƙarin bayani mai tuntuɓi mu.


reviews