UhloboUkuqeqesha ekilasini
BHALISA

I-Oracle 11 g PL SQL Developer

I-Oracle 11 g PL SQL Developer Training Course & Certification

Uhlolojikelele

Izilaleli & Izidingo Zokuqala

Uhlaka Lokufunda

Uhlelo noHlelo

Certification

I-Oracle 11 g PL SQL Developer Training Course Overview

I-PL / SQL inhlanganisela ye-SQL kanye nezici zenqubo yezilimi zokuhlela. Yakhiwe yi-Oracle Corporation ekuqaleni kwe-90 yokuthuthukisa amandla ka-SQL.PL/SQL (uLimi Lwezinqubo Zamagama / Ulimi Oluhlelekile) yi-Oracle Corporation yokwandisa ulimi lwezinqubo ze-SQL kanye nedatha ye-Oracle relational. I-PL / SQL iyatholakala ku-Oracle Database

Izinhloso ze-Oracle 11 g PL SQL Developer Training

Ngemuva kokuqedela lesi sifundo, kufanele ukwazi:

  • Chaza okuyisisekelo kolimi lwe-PL / SQL lokuhlela
  • Bhala futhi usebenzise izinhlelo ze-PL / SQL ku-SQL * Plus
  • Yenza imisebenzi yokuguqula uhlobo lwedatha ye-PL / SQL
  • Bonisa okukhipha ngokusebenzisa izinhlelo ze-PL / SQL
  • Phatha izintambo zomlingisi ezinhlelweni ze-PL / SQL
  • Dedula izinhlelo ze-PL / SQL

Izilaleli ezihlosiwe ze-Oracle 11 g PL ye-PL SQL Developer

Lesi sifundo senzelwe i-Software Professionals, abazimisele ukufunda ulimi lwe-PL / SQL Programming ngezinyathelo ezilula futhi ezilula. Lokhu kufundisa kuzokunika ukuqonda okukhulu kumigomo ye-PL / SQL Yokuhlela, futhi ngemva kokuqedela lesi sifundo, uzoba ngezinga eliphakathi lolwazi kusuka lapho ungayithatha khona izinga eliphezulu lobuchwepheshe.

OkudingekayoI-Oracle 11 g PL SQL Developer Certification

Kufanele ube nokuqonda okuyisisekelo isofthiwe imiqondo eyisisekelo njengokuthi i-database, ikhodi yomthombo, umhleli wombhalo kanye nokwenziwa kwezinhlelo, njll. Uma usuvele uqonda ku-SQL kanye nolunye ulimi lwezinhlelo zekhompiyutha kuzoba yinzuzo eyengeziwe yokuqhubeka.

Isikhathi sokuphuma kwesikhathi sezinkathi: Izinsuku ze-3

  1. Isingeniso ku-PL / SQL
  • Thola izinzuzo ze-PL / SQL
  • Ukubuka ngokugcwele izinhlobo ze-PL / SQL ezivimbelayo
  • Dala i-Block e-Anonymous Block
  • Indlela yokwenza okukhiphayo kusuka ku-PL / SQL Ukuvimba?

I-2. Memezela abasebenzisi be-PL / SQL

  • Faka uhlu lwezinhlobo ezahlukene zezikhombi kuhlelo lokusebenza lwe-PL / SQL
  • Ukusetshenziswa kwesigaba esimemezelayo sokuchaza izihlonzi
  • Sebenzisa okuguquguqukayo ukugcina idatha
  • Thola izinhlobo ze-Scalar Data
  • I-% TYPE Attribute
  • Yiziphi Izinhlamvu Zobungakanani?
  • Ukulandelana kumazwi we-PL / SQL

I-3. Bhala izitatimende ezithintekayo

  • Chaza isisekelo se-PL / SQL Ukuvimbela izinkombandlela ze-Syntax
  • Funda ukuphawula ikhodi
  • Ukuthunyelwa kwemisebenzi ye-SQL ku-PL / SQL
  • Indlela yokuguqula izinhlobo zeDatha?
  • Chaza amabhulokhi akhadiweyo
  • Thola abaSebenzi ku-PL / SQL

I-4. Ukuxhumana ne-Oracle Server

  • Vuma izitatimende zokukhetha ku-PL / SQL
  • Thola idatha ku-PL / SQL
  • Umqondo we-SQL Cursor
  • Gwema Iziphambeko ngokusebenzisa Amagama Okubamba Amagama lapho usebenzisa Izitatimende Zokubuyisa kanye ne-DML
  • Ukuguqulwa kwedatha kuSeva isebenzisa i-PL / SQL
  • Qonda umqondo we-SQL Cursor
  • Sebenzisa izici zobunikazi be-SQL ukuze uthole impendulo ku-DML
  • Londoloza futhi Ulahle Ukuthengiswa

I-5. Izakhiwo Zokulawula

  • Ukucubungula okunemibandela usebenzisa izitatimende ze-IF
  • Ukucubungula okunemibandela usebenzisa izitatimende ze-CASE
  • Chaza isitatimende se-Loop esilula
  • Chaza Ngenkathi I-Loop Statement
  • Chaza Ngokwesitatimende se-Loop
  • Sebenzisa Isitatimende Esiqhubekayo

I-6. Izinhlobo Eziyinkimbinkimbi Zedatha

  • Sebenzisa Amarekhodi we-PL / SQL
  • I-% ROWTYPE Isici
  • Faka futhi Buyekeza nge-PL / SQL Amarekhodi
  • INDEX ngamathebula
  • Hlola INDEX BY Izindlela Zamathebula
  • Sebenzisa i-INDEX BY Table of Records

I-7. I-Cursors ecacile

  • Yiziphi i-Cursors ezicacile?
  • Memezela i-Cursor
  • Vula i-Cursor
  • Dlulisa idatha kusuka kuCursor
  • Vala i-Cursor
  • Isikhalazo se-LOOP
  • I-% NOTFOUND ne-% ROWCOUNT Izimfanelo
  • Chaza i-FOR UPDATE Isigaba kanye NOMA KANYE I-CURRENT Isigaba

I-8. Ukuphathwa kokungaphandle

  • Qonda okungafani
  • Phatha okuhlukile nge-PL / SQL
  • Iziphambeko ze-Oracle Server ezicatshangelwe ugibe
  • Iziphambeko ze-Oracle Server ezingabonisiwe
  • Ukungaxhunyiwe okucacisiwe komsebenzisi
  • Ukukhipha okuhlukile
  • Inqubo ye-RAISE_APPLICATION_ERROR

I-9. Izinqubo ezigcinwe

  • Yakha Idizayini Yokwakhiwa Kwe-Subprogram Enyekisiwe
  • Ukuthuthukiswa kwe-modularize nge-Blocks SQL / SQL
  • Qonda i-PL / SQL Yokusebenza Kwendawo
  • Bhala izinzuzo zokusebenzisa izinhlelo zokusebenza ze-PL / SQL
  • Bhala uhlu phakathi kwamaBhlokhi angaziwa kanye nokuSebenza
  • Yakha, Shayela, futhi Susa Izinqubo Zokulondoloza
  • Phunyelela izinqubo zeParameters nama-Modam Parameters
  • Buka Ulwazi Lwezinqubo

I-10. ImiSebenzi egcinwe kanye nezinhlelo zokuDedula

  • Dala, Shayela, futhi Susa umsebenzi ogcinwe
  • Thola izinzuzo zokusebenzisa Imisebenzi egcinwe
  • Thola izinyathelo zokudala umsebenzi ogcinwe
  • Memezela Imisebenzi Echazwe Umsebenzisi emaSitatimendeni SQL
  • Imingcele lapho ubiza Imisebenzi
  • Lawula imiphumela emibi lapho ubiza Imisebenzi
  • Buka ulwazi lomsebenzi
  • Indlela yokuguqula ukusebenza Imisebenzi nezinqubo?

I-11. Amaphakheji

  • Ukubhalisa izinzuzo zamaPhakheji
  • Chaza amaphakheji
  • Yiziphi izingxenye zePhakheji?
  • Thuthukisa iphakheji
  • Ungavumela kanjani ukubonakala kwezingxenye zePhakheji?
  • Yakha Ukucaciswa Kwephakheji Nomzimba usebenzisa Isitatimende Sokudala SQL ne-SQL Developer
  • Yenza iPhakheji Yakha
  • Buka i-PL / SQL Source Code usebenzisa iData Datha

I-12. Ukuthumela amaphakheji

  • Ukulayisha ngokweqile ukuphrinta ku-PL / SQL
  • Sebenzisa iphakethe le-STANDARD
  • Sebenzisa Okumemezela Okuphambili Ukuxazulula Izinkomba Zomthetho Ongekho Emthethweni
  • Phunyelela Imisebenzi Yephakheji ku-SQL kanye Nemikhawulo
  • State persistent of Packages
  • Isimo esiphikelelayo seKhulasethi yephakheji
  • Lawula imiphumela emibi ye-PL / SQL
  • Icela amathebula we-PL / SQL wamaRekhodi kumaPhakheji

I-13. Qalisa amaPhakheji ahlinzekwa nge-Oracle ekuthuthukiseni uhlelo lokusebenza

  • Yimaphi amaphakheji e-Oracle-Supplied?
  • Izibonelo zezinye zePhakheji ezinikeziwe ze-Oracle
  • Iphakheji le-DBMS_OUTPUT isebenza kanjani?
  • Sebenzisa iphakethe le-UTL_FILE ukuze usebenze namafayela wokusebenza wesistimu
  • Mema i-UTL_MAIL Iphakheji
  • Bhala izinhlelo zokusebenza ze-UTL_MAIL

I-14. I-Dynamic SQL

  • Ukugeleza kokubulawa kwe-SQL
  • Iyini i-Dynamic SQL?
  • Memezela ukuguquguquka kwezikhalazo
  • Ukusebenzisa ngokuqinile i-PL / SQL Block
  • Lungiselela i-Native Dynamic SQL ukuhlanganisa i-PL / SQL Code
  • Indlela yokufaka iphakethe le-DBMS_SQL?
  • Phumelela i-DBMS_SQL ngesitatimende se-DML esimisiwe
  • I-Dynamic SQL Ukusebenza Okuphelele

I-15. Ukucatshangelwa kokuklama kwekhodi ye-PL / SQL

  • Qinisekisa izikhathi ezithile nokungafani
  • Qonda ukuhlelwa kohlelo lwendawo
  • Bhala Ukuthengiswa Okuzimele
  • Phunyelela i-NOCOPY I-Compiler Iqhinga
  • Mema i-PARALLEL_ENABLE I-Hint
  • I-Cross-Session PL / SQL Yomsebenzi Wokulondoloza Umsebenti
  • Isigaba somthetho esiyi-DETERMINISTIC nemisebenzi
  • Ukusetshenziswa kwe-Bulk Ukubophezela Ukuthuthukisa ukusebenza

I-16. Izihlungi

  • Chaza izinkinga
  • Thola izinhlobo zezindawo ze-Trigger noMzimba
  • Izicelo zebhizinisi lezinkampani zokuqalisa ukusebenza
  • Dala abahlukumezi be-DML besebenzisa isitatimende se-CREATE TRIGGER nomthuthukisi we-SQL
  • Thola izinhlobo ze-Trigger, Umzimba, Nokudubula (Isikhathi)
  • Ukwahlukana phakathi kweSitatimende seNgeniso yeZitatimende kanye neBanga leNgcini Yezinga
  • Dala esikhundleni sezinkinga zokukhubazeka
  • Indlela Yokuphatha, Ukuvivinya Nokukhipha Izihlungi?

I-17. Ukwakha i-Compound, i-DDL, ne-Event Database Isusa

  • Iyini i-Compound Triggers?
  • Thola izigaba ze-Timing-Point ze-Table Compound Trigger
  • Qonda isakhiwo se-Compound Trigger yamathebula nokubukwa
  • Qalisa i-Trigger Compound Yokuxazulula Iphutha Lethebula Lokuguqula
  • Ukuqhathaniswa kwe-Database Triggers kuzinqubo ezigcinwe
  • Dala izihlungi kuziTatimende ze-DDL
  • Yakha i-Database-Event ne-System-Events Triggers
  • Ilungelo leSistimu liyadingeka ukulawula izihlungi

I-18. PL / SQL Compiler

  • Iyini i-PL / SQL Compiler?
  • Chaza i-Initialization Parameters ye-PL / SQL Compilation
  • Bhala uhlu olusha lwe-PL / SQL
  • Sibutsetelo se-PL / SQL Qalisa Isixwayiso Sesikhathi Sokuhlela
  • Bhala izinzuzo ze-Compiler Warnings
  • Bhala uhlu lwe-PL / SQL Yakha imiyalezo yezixwayiso zesikhathi
  • Ukubeka Izinga Lemiyalezo Yokuxwayisa: Ukusebenzisa i-SQL Developer, i-PLSQL_WARNINGS I-Parameter yokuqala, ne-DBMS_WARNING Buka izixwayiso ze-Compiler: Ukusebenzisa i-SQL Developer, i-SQL * Plus, noma ukubukwa kwedatha yedatha

I-19. Lawula Ukuthembela

  • Sibutsetelo se-Schema Object Dependencies
  • Umbuzo Wokuzimela Okuqondile Okuqukethwe Ukusebenzisa i-USER_DEPENDENCIES Buka
  • Ukubuza isimo se-Object
  • Ukungaqiniseki Kwezinto Ezixhomeke Kuzo
  • Bonisa Ukuthembela Okuqondile Nokungaqondile
  • Ukuphathwa Kwezintambo Zokuxhomeka Okuhle ku-Oracle Database 12c
  • Qonda ukuthembela okude kude
  • Khumbula uhlelo lwe-PL / SQL Uhlelo

Sicela ubhalele kithi info@itstechschool.com & xhumana nathi + 91-9870480053 ngenxa yezindleko zemali & isitifiketi izindleko, isimiso & indawo

Siphonsa Umbuzo

Certification

Ukuqedela abafundi abaqeqeshwayo kufanele bazilungiselele ukuthatha izivivinyo ezimbili:
Step1 Pass Le Exam
Khetha eyodwa yalezi zivivinyo
I-Oracle Database SQL Uchwepheshe
OR
I-Oracle Database 11g: Izimfuneko ze-SQL I
OR
I-Oracle Database 12c: Izimfuneko ze-SQL
Step2 Pass Le Exam
Khetha eyodwa yalezi zivivinyo
Uhlelo nge PL / SQL
OR
I-Oracle Database 11g: Uhlelo nge PL / SQLNgolwazi oluthe xaxa xhumana nathi ngomusa.


Izibuyekezo