uhloboUqeqesho lweKlasi
INCWADI

Qhagamshelana nathi

Iimimandla ezimakwe kunye * zifunwa

 

I-Oracle 11 g I-PL yeSQL Developer

I-Oracle 11 g I-PL yeSQL yonxibelelwano yoQeqesho noQeqesho

isishwankathelo

Abaphulaphuli kunye neemfuno ezifunekayo

Inkcazo yeNkcazo

IShedyuli kunye neMali

iziQinisekiso

I-Oracle 11 g I-PL yeSQL yoQeqesho loQeqesho loPhuhliso

PL/SQL is a combination of SQL along with the procedural features of programming languages. It was developed by Oracle Corporation in the early 90XCHARXs to enhance the capabilities of SQL.PL/SQL (Procedural Language/Structured Query Language) is Oracle CorporationXCHARXs procedural language extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database

Iinjongo ze-Oracle 11 g INkqubo ye-PL yeSQL yoQeqesho

Emva kokugqiba le sifundo, kufuneka ukwazi uku:

  • Chaza izinto ezisemgangathweni zoLwimi lwe-PL / SQL
  • Bhala kwaye wenze iiprogram ze-PL / SQL kwi-SQL * Plus
  • Yenza imisebenzi yokuguqula uhlobo lwe data PL / SQL
  • Bonisa imveliso ngokusebenzisa iP PL / SQL iinkqubo
  • Yenza amacandelo ompawu kwiiprogram ze-PL / SQL
  • Iiphulophu zeP PL / SQL

Abaphulaphuli abafunyenweyo kwi-Oracle 11 g PL ye-PL ye-Developer SQL

Olu qeqesho lenzelwe i-Software Professionals, ekulungele ukufunda i-PL / SQL uLwimi loLwimi kwiimanyathelo ezilula kwaye kulula. Olu qeqesho luza kukunika ukuqonda okukhulu kwiiplati zeP PL / SQL Programming, kwaye emva kokugqiba le khokelo, uya kuba sezingeni eliphakathi lobuchule ukusuka apho ungazithatha khona kumgangatho ophezulu wobungcali.

MfunekoI-Oracle 11 g I-PL yeSQL Developer Certification

Kufuneka ube nolwazi oluyisiseko isoftwe Iingcamango ezisisiseko ezifana nolwazi lwesiseko, ikhowudi yomthombo, umhleli wombhalo kunye nokuqhutywa kweeprogram, njl. Ukuba sele usenokuqonda kwiSQL kunye nolunye ulwimi lwenkqubo yekhomputha koko kuya kuba yinzuzo eyongeziweyo yokuqhubeka.

Ixesha loKhutshwa kweNkundla: Iintsuku ze-3

  1. Isingeniso kwi PL / SQL
  • Ukuchonga izibonelelo ze-PL / SQL Inkqutyana
  • Ubume bemizekelo yeendidi ze-PL / SQL
  • Yakha i-Block elula
  • Indlela yokuvelisa umveliso kwi-PL / SQL Block?

2. Memezela i-PL / SQL Identifiers

  • Uluhlu lweentlobo ezahlukeneyo zeenkcukacha kwi-PL / SQL subprogram
  • Ukusetyenziswa kweCandelo eliCacisayo lokuchaza abaLawuli
  • Sebenzisa iindlela zokugcina idatha
  • Ukuchonga iintlobo zeenkcukacha ze-Scalar
  • I-% TYPE Attribute
  • Ziziphi iiNguqulelo zeBind?
  • Ukutshintshana kwi PL / SQL

3. Bhala iiNkcazo eziLawulayo

  • Chaza i-PL / SQL isiseko se-Syntax
  • Funda ukuphawula iMigaqo
  • Ukuthunyelwa kweeSQL Imisebenzi kwi PL / SQL
  • Indlela yokuguqula iiNdawo zeDatha?
  • Chaza iibhloko zeNdawo
  • Ukuchonga abaSebenzi kwi PL / SQL

4. Ukusebenzisana ne-Oracle Server

  • Yenza i-SELECT SELECT Statements kwi PL / SQL
  • Fumana iDatha kwi PL / SQL
  • Umxholo weCursor SQL
  • Gwema iimpazamo ngokusebenzisa iMigqaliselo yokuQamba amagama xa usebenzisa iItransval and DML Statements
  • Ukusetyenziswa kweDatha kwiServer usebenzisa PL / SQL
  • Qonda i-SQL yeCursor concept
  • Sebenzisa iimpawu zeCursor Cursor zokufumana impendulo kwi-DML
  • Gcina kwaye Ulawule Ukuthengwa

5. Izakhiwo zolawulo

  • Ukusetyenziswa ngokubambisana usebenzisa iI-Statements IF
  • Ukuqhutyelwa kweemeko usebenzisa iiNkcazo ze-CASE
  • Chaza iNgxelo yeLoop elula
  • Chaza ngoxa iNgxelo yeLoop
  • Chaza kwiNgxelo yeLoop
  • Sebenzisa iSitatimende sokuqhubeka

6. Iintlobo zeDatha eziHlangeneyo

  • Sebenzisa iiRekhodi ze-PL / SQL
  • I-% ROWTYPE Attribut
  • Faka kwaye Uhlaziywe nge-PL / SQL Records
  • INDEX ngeeTables
  • Hlola INDEX ngeendlela zeThebula
  • Sebenzisa i-INDEX NGUHLU LOKUBHALA

7. Cursors ecacileyo

  • Ziziphi iiCursors ezicacileyo?
  • Memezela iCursor
  • Vula iCursor
  • Fetha idatha kwiCursor
  • Vala iCursor
  • Umgcini-mvume
  • I-% NOTFOUND ne-% ROWCOUNT Iimpawu
  • Chaza INKQUBO YENKQUBO YOKUPHATHISWA KUNYE NOMTHETHO WENKQUBO

8. UkuKhathalela ngaphandle

  • Ukuqonda okungekho
  • Ukukhuphela ngaphandle kwe-PL / SQL
  • Iimpazamo ze-Oracle Server ezicetywayo
  • I-Error Not Predised Oracle Server Iimpazamo
  • Ukhokelo oluchaziweyo lomsebenzisi
  • Ukupapashwa okungekho
  • I-RAISE_APPLICATION_ERROR Inkqubo

9. Procedures Procedures

  • Yakha i-Design Modularrized and Layered Subprogram Design
  • Uphuhliso lweModularize nge PL / SQL Blocks
  • Qonda i-PL / SQL Ukusetyenziswa kweNdalo
  • Bhala uluhlu lokusebenzisa i-PL / SQL Inkqutyana
  • Bhala uluhlu phakathi kweeNgcaciso zeBlokhi kunye neeprogram
  • Yakha, Shayela, kwaye Susa iiNkqubo eziGcinwe
  • Ukuphunyezwa kweeNkqubo zeParameters kunye neModameters
  • Jonga ulwazi lweNkqubo

10. ImiSebenzi egcinwe kunye neeNkqubo zoLungiso lweeNgxaki

  • Yakha, Shayela, kwaye Susa I-Function Stored
  • Ukuchonga iinzuzo zokusebenzisa imisebenzi egcinwe
  • Ukuchonga amanyathelo okudala umsebenzi ogcinwe
  • Ukufakela imisebenzi echazwe ngumsebenzisi kwiStell Statements
  • Imiqobo xa ubiza imisebenzi
  • Iziphumo zecandelo lokulawula xa ubiza imisebenzi
  • Jonga ulwazi lo msebenzi
  • Indlela yokulungisa iSebenzi kunye neNkqubo?

11. Iipakethi

  • Ukubhala uluhlu lweePakethi
  • Chaza iipakethi
  • Ziziphi iimpawu zePakethe?
  • Ukuphuhlisa iPakethe
  • Unokukwenza njani ukubonakala kweePakethe zePakethe?
  • Yakha iPackage Specification kunye neQumrhu usebenzisa iStell Statement kunye ne-SQL Developer
  • Ukufakela iPakethe yokwakha
  • Jonga i-PL / SQL Umthombo woMthombo usebenzisa iData yeData

12. Ukuhambisa iipakethi

  • Ukulayinisa ii-Subprograms kwi-PL / SQL
  • Sebenzisa iPakethe ye-STANDARD
  • Sebenzisa iiNkcazo zokuPhumela ukuSombulula iNgxelo yeNkqubo engekho mthethweni
  • Phunyezwa Imisebenzi yePakethe kwi-SQL kunye neZithintelo
  • Iimeko eziPhezulu zePhakheji
  • Isimo esiqhubekayo seCursor Package
  • Iziphumo zecandelo lolawulo lwe PL / SQL Inkqutyana
  • Ukucela ii-PL / SQL Iingxelo zeRekhodi kwiiphakethi

13. Ukuphunyezwa kweePhakheji ezinikezelwe nge-Oracle ekuPhuhlisweni kwezicelo

  • Ziziphi iipakethi ze-Oracle-Supplied?
  • Imizekelo yezinye iipakethi zee-Oracle-Supplied Packages
  • I-DBMS_OUTPUT ikhekhe isebenza njani?
  • Sebenzisa i-UTL_FILE Iphakheji ukuze usebenzisane neefayile zeeNkqubo zokuSebenza
  • Yenza i-UTL_MAIL Iphakheji
  • Bhala UTL_MAIL Iprogram

14. Synamic SQL

  • Ukuhamba kweSQL
  • Yintoni i-Dynamic SQL?
  • Memezela iziTshintsho zeCursor
  • Ukusebenza ngamandla kwi PL / SQL Block
  • Qwalasela i-Native Dynamic SQL ukuCwangcisa i-PL / SQL Code
  • Indlela yokufaka iPhakheji yeDBMS_SQL?
  • Ukuphumeza iDBMS_SQL ngeSitatimende seDML seParameteri
  • I-Dynamic SQL esebenza ngokupheleleyo

15. Iingqwalasela zoyilo kwi-PL / SQL Code

  • Ukumisa amaxesha onke kunye nokungafani
  • Qonda iiNgqungquthela zengingqi
  • Bhala ukuThathelana
  • Phunyezwa i-NOCOPY Inkcazo yeCompiler
  • Yenza i-PARALLEL_ENABLE Hint
  • I-Cross-Session PL / iSQL Umsebenzi weCache Result Cache
  • UMGAQOQO OQHELEKILEYO kunye neMisebenzi
  • Ukusetyenziswa koBuck Ukubophezela ukuphucula ukusebenza

16. Abacebisi

  • Chaza i ziphumo
  • Ukuchonga iintlobo zeeNkcazo kunye neQumrhu
  • ISicelo seShishini seShishini zoPhuculo lweZiphumo
  • Yenza i-DML Exggers usebenzisa i-CREATE TRIGGER Statement kunye ne-SQL Developer
  • Ukuchonga iintlobo zeeNkcazo zeMpawu, iQumrhu, kunye nokuDoba (ixesha)
  • Ukwahlukana phakathi kweeNkcazo zeNqanaba leNgcaciso kunye neNgcaciso yeNqanaba leNgcaciso
  • Yakha Endaweni Yezinto kunye nezikhubaza ezikhubaza
  • Indlela yokuLawula, ukuVavanya nokuSusa abaHlengi?

17. Ukudala iCompound, iDDL, kunye neNgcaciso yeSigcineko seSiganeko

  • Ziziphi iiCompound Triggers?
  • Ukuchonga iCandelo loPhulo lweeNqaku zoTywala lweComplete
  • Qonda ukuHlalwa kweTekisi yeTekisi yeeTables kunye neMiboniselo
  • Ukuphumeza i-Trigger Compression yokuSombulula i-Error Conversion
  • Ukuthelekiswa kweeNgcaciso zeNgcaciso kwiiNkqubo zokuGcina
  • Yenza Iibangele kwiiNkcazo zeDDL
  • Yenza i-Database-Event kunye ne-System-Events Events
  • Ilungelo leNkqubo lifunwa ukuLawula iiNguqulelo

18. PL / SQL Compiler

  • Yintoni i-PL / SQL Compiler?
  • Chaza i-Initialization Parameters ye-PL / SQL Compilation
  • Bhala uluhlu olutsha lwe-PL / SQL Qulunqa Ixesha leengcebiso
  • Uqwalaselo lwe PL / SQL Qulunqa ixesha Iingcebiso ze-Subprograms
  • Bhala uluhlu lweeNkcazo zokuCetyiswa
  • Bhala uluhlu lwe-PL / SQL Qulunqa Iimpawu zoMyalezo zoMyalezo
  • Ukubeka iiNqanaba zoMyalezo ezilumkileyo: Ukusebenzisa iS Developer Developer, PLSQL_WARNINGS Initialization Parameter, kunye neDBMS_WARNING Jonga izilumkiso zeCompiler: usebenzisa iSQL Developer, i-SQL * Plus, okanye i-Data Dictionary Views

19. Ukulawula Ukuxhomekeka

  • Ubume bemiSebenzi yoLondolozo lweSkimu
  • Umbuzo Wokuxhomekeka ngokuthe ngqo kwi-USER_DEPENDENCIES View
  • Ukufuna Isimo se-Object
  • Ukungavunyelwanga kwezinto ezixhomekeke kuyo
  • Ukubonisa ukuxhomekeka ngokuthe ngqo nangokungaqondile
  • Ulawulo oluxhomekeke kuCandelo lokuThomba lokuBonelela ngokuCwangcisiweyo kwi-Oracle Database 12c
  • Qonda ukuxhomekeka kwexesha elide
  • Ukuqwalasela kwakhona i-PL / SQL yeNkqubo yeNyunithi

iziQinisekiso

Ukugqitywa kokugqitywa kwabaviwa bekhosi kufuneka balungele ukuthatha iimviwo ezimbini:
Step1 Pass This Exam
Khetha enye yezi ziviwo
I-Oracle Database yeSQL uNgcali
OR
I-Oracle Database 11g: I-SQL Imigaqo-siseko
OR
I-Oracle Database 12c: I-SQL Imimiselo
Step2 Pass This Exam
Khetha enye yezi ziviwo
Inkqubo nge PL / SQL
OR
I-Oracle Database 11g: Inkqubo nge PL / SQLNgolwazi oluninzi xha ga mshelana nathi.


Reviews