homKev Kawm hauv Chav Kawm
Sau npe

Tiv tauj peb

Cov tsiaj ntawv cim nrog tus * yog xav tau

 

Oracle 11 g PL SQL tsim tawm ua ntej

Oracle 11 g PLSQL Tsim tawm Kev Kawm Ua Ntej Ua Ntej & Muab Ntawv Pov Thawj

Txheej txheem cej luam

Suab Seev & Seem Ua Ntej

Cov Qauv Dua

Teem & Cov Nqi

Certification

Oracle 11 g PLSQL Tus Tsim Kho Kev Kawm Ua Ntej

Hauv no Oracle Database 11G Advanced PL / SQL kev kawm, tus kws qhia Oracle University instructors yuav pab koj tshawb txog cov qauv ntawm PL / SQL los tsim thiab qhib PL / SQL. Koj yuav kawm tau li cas nws cov interfaces nrog cov database thiab lwm yam kev siv rau hauv cov txheej txheem zoo tshaj plaws.

Kawm Rau

  • PL / SQL tsim cov kev coj ua zoo tshaj plaws.
  • Ua daim ntawv thov PL / SQL uas siv cov khoom siv.
  • Siv cov ntaub ntawb virtual nrog cov khoom siv tau zoo heev.
  • Sau cov ntawv rau lwm tus nrog C thiab Java cov kev siv.
  • Sau cov cai rau kev sib txuas nrog cov khoom loj thiab siv SecureFile LOBs.
  • Sau thiab qhib lub PL / SQL code kom muaj txiaj ntsig zoo.

Cov hom phiaj ntawmOracle 11 g PLSQL Tsim tawm Ua Ntej Kawm

  • Tsim PL / SQL tej pob khoom thiab cov kev pabcuam hauv kev ua haujlwm uas tau ua tiav zoo
  • Sau cov ntawv rau kev sib txuas nrog cov kev siv sab nraud thiab kev khiav hauj lwm
  • Ua daim ntawv thov PL / SQL uas siv cov khoom siv
  • Sau thiab qhib lub PL / SQL code kom muaj txiaj ntsig zoo
  • Siv cov ntaub ntawb virtual nrog cov khoom siv tau zoo heev
  • Sau cov cai rau kev sib txuas nrog cov khoom loj thiab siv SecureFile LOBs

Lub Tswv Yim Txheem Technology muaj PL / SQL Developer Advance Training nyob rau hauv 9 ntau qhov chaw hauv Is Nrias teb - Bangalore, Chennai, Delhi, Gurgaon, Hyderabad, Kolkata, Mumbai, Noida & Pune.

Cov Neeg Sawv Cev RauOracle 11 g PLSQL Tsim Txawj Ua Ntej

  • Database Thawj Coj
  • Cov neeg tsim daim ntawv thov
  • PL / SQL Tsim tawm

Yam yuavtsum tau kawm uantejrauOracle 11 g PLSQL Developer Certification

    • Kev paub ntawm SQL
    • PL / SQL Programming kev
    • Kev Ntsuam Xyuas Kawm Ua Ntej

Tus neeg sib tw yuav tsum muaj "qhov PL / SQL Developer Associate" qhov kev lees paub

Cov Qauv Ntu Kev Kawm Duration: 3 Hnub

  1. Introduction
    • Cov hom phiaj ntawm cov hom phiaj
    • Cov txheej txheem thaum kawg
    • Cov ntawv thiab cov ntaub ntawv siv rau chav kawm no
    • Txheej txheem cej luam txoj kev loj hlob: SQL Developer, SQL Plus
  2. PL / SQL Programming Tshawb Xyuas
    • Txheeb xyuas PL / SQL thaiv qauv
    • Tsim cov txheej txheem
    • Tsim kev ua haujlwm
    • Sau cov kev txwv thiab cov txheej txheem rau kev hu xov tooj ntawm cov lus qhia hauv SQL
    • Tsim tej pob khoom
    • Tshawb xyuas cov cursors implicit thiab qhia tau meej heev
    • Sau kos npe rau syntax
    • Txheeb xyuas lub Oracle muab khoom ua ke
  3. Tsim PL / SQL Code
    • Piav qhia cov hom kev qhia ua ntej
    • Tsim subtypes raws li hom uas twb muaj rau ib daim ntawv thov
    • Sau cov txheej txheem txawv rau cursor design
    • Cursor zog
  4. Siv Collections
    • Txheeb xyuas kev sau
    • Siv cov qeeb arrays
    • Siv Nested cov ntxhuav
    • Siv VARRAYs
    • Sib piv nais ntxhuav thiab VARRAYs
    • Sau ntawv PL / SQL cov kev pab cuam uas siv cov khoom sau
    • Siv Cov Khoom Sau Kom Zoo
  5. Manipulating Cov Khoom Loj
    • Qhia txog cov khoom LOB
    • Siv BFILEs
    • Siv DBMS_LOB.READ thiab DBMS_LOB.WRITE los ua haujlwm LOBs
    • Tsim ib qho kev pab cuam LOB ib ntus nrog rau DBMS_LOB pob
    • Taw qhia rau SecureFile LOBs
    • Siv SecureFile Lobs khaws cov ntaub ntawv
    • Hloov BasicFile LOBs kom SecureFile LOB hom ntawv
    • Pab kom reduplication thiab compression
  6. Siv Cov Kev Siv Hom Kev Ntsuas
    • Hu Sab Nraud Cov Txheej Txheem los ntawm PL / SQL
    • Cov Kev Pab ntawm Cov Txheej Txheem Sab Nraud
    • C advanced interface txoj kev
    • Java advanced interface txoj kev
  7. Kev ua tau zoo thiab qhov
    • Nkag siab thiab pab txhawb tus compiler
    • Qhib PL / SQL code
    • Pab kom tau txais kev pabcuam hauv koog tsev kawm ntawv
    • Txheeb xyuas thiab qhib cov teeb meem kev nco
    • Paub txog cov teeb meem network
  8. Kev Txhim Kho Nrog Caching
    • Piav qhia txog kev caching
    • Siv SQL lus nug cache
    • PL / SQL ua haujlwm cache
    • Ntsuam xyuas PL / SQL ua haujlwm cache xav txog
  9. Ntsuam xyuas PL / SQL Code
    • Nrhiav Cov Lus Qhia Cov Ntawv
    • Siv DBMS_DESCRIBE
    • Siv ALL_ARGUMENTS
    • Siv DBMS_UTILITY.FORMAT_CALL_STACK
    • Muab cov ntawv PL / Scope Data
    • Tus neeg siv / TXHUA / DBA_IDENTIFIERS Catalog Saib
    • DBMS_METADATA Pob
  10. Kev sib tham thiab nrhiav cov PL / SQL Code
    • Tracing PL / SQL Tiav
    • Tracing PL / SQL: Cov kauj ruam
  11. Kev siv VPD nrog Cov Tswj Kev Nkag Uas Siv Tau Zoo
    • Nkag siab seb txoj kev tswj xyuas cov khoom siv tau zoo npaum li cas
    • Piav kom meej cov yam ntxwv ntawm kev tswj cov khoom siv zoo
    • Qhia txog cov ntsiab lus hauv kev thov
    • Tsim ib lub ntsiab lus teb thov
    • Teem ib lub ntsiab lus teb thov
    • Sau cov txheej txheem DBMS_RLS
    • Siv txoj cai
    • Nug cov phau ntawv txhais lus tuav cov lus qhia txog kev nplua zoo
  12. Txhim Kho Koj Cov Kev Cai Tiv Thaiv SQL Txhaj Txhaum Cai
    • SQL Txhaj Tshuaj Txheej Txheem
    • Txiav Kev Cuam Tshuam Zaum
    • Tsis txhob Dynamic SQL
    • Siv qhov kev sib tw nrog
    • Filtering Input nrog DBMS_ASSERT
    • Tsim Tus Qauv Txheej Txheem rau SQL Injections
    • Kev Ntsuam Xyuas Code rau Kev Txhaj Tshuaj SQL

Certification

Tom qab ua tiav chav kawm no yuav tsum tau muab "Oracle 11g Advanced Pl / SQL 1Z0-146" Xeem tau ntawv pov thawj. Rau ntau info kindly hu rau peb.


Xyuas