TypeKuphunzira Maphunziro
Register

Lumikizanani nafe

Minda yodziwika ndi * zofunikira

 

Oracle 11 g PL SQL Developer

Oracle 11 g PL SQL Womanga Maphunziro Ophunzirira & Certification

mwachidule

Omvetsera ndi Zoperekera

Zolembera Mwachidule

Ndandanda ndi Malipiro

chitsimikizo

Oracle 11 g PL SQL Womanga Maphunziro Phunziro

PL / SQL ndi kuphatikiza SQL pamodzi ndi ndondomeko yazinenero zolumikiza. Linayambitsidwa ndi Oracle Corporation kumayambiriro kwa 90 kuti apange mphamvu za SQL.PL/SQL (Procedural Language / Structured Query Language) ndi Oracle Corporation yowonjezera chinenero cha SQL ndi database ya Oracle relational. PL / SQL ikupezeka ku Oracle Database

Zolinga za Zolemba 11 g PL SQL Developer Developer

Mukamaliza phunziro ili, muyenera:

  • Fotokozani zikhazikitso za PL / SQL Programming language
  • Lembani ndikuchita mapulogalamu a PL / SQL mu SQL * Plus
  • Gwiritsani ntchito mtundu wa deta ya Execute PL / SQL
  • Onetsani zotsalira kupyolera mu mapulogalamu a PL / SQL
  • Pangani ndondomeko za khalidwe mu mapulogalamu a PL / SQL
  • Zonongeka PL / SQL mapulogalamu

Omvera Ovomerezeka a Oracle 11 g PL SQL Developer Developer

Maphunzirowa apangidwa kuti apange Mapulogalamu a Mapulogalamu, omwe ali okonzeka kuphunzira PL / SQL Programming Language m'zinthu zosavuta komanso zosavuta. Phunziroli lidzakupatsani chidziwitso chachikulu pa mfundo za PL / SQL Programming, ndipo mutatha kumaliza maphunzirowa, mudzakhala ndi luso labwino kuchokera komwe mungadzitengere nokha kuntchito yapamwamba.

Zofunikirakwa Oracle 11 g PL SQL Developer Certification

Muyenera kumvetsa bwino software mfundo zofunikira ngati zomwe zili m'masitolo, mapulogalamu a chinsinsi, malemba ndi machitidwe, etc. Ngati muli ndi chidziwitso pa SQL ndi chinenero china cha pulogalamu ya pakompyuta ndiye kuti padzakhalanso mwayi wopitilira.

Nthawi Yoyendetsera Nthawi Yomweyi: Masiku a 3

  1. Mau oyamba a PL / SQL
  • Dziwani phindu la PL / SQL Subprograms
  • Zambiri za mitundu ya PL / SQL imatseka
  • Pangani Lembani Losavuta Kudziwika
  • Kodi mungapange bwanji zotsatira zochokera ku PL / SQL?

2. Lengezani Odziwika PL / SQL

  • Lembani mitundu yosiyanasiyana ya zizindikiro mu PL / SQL subprogram
  • Kugwiritsira ntchito Gawo Loyamikira Kufotokozera Odziwika
  • Gwiritsani ntchito kusintha kusunga deta
  • Dziwani Mitundu ya Dongosolo la Scalar
  • Chigawo cha% TYPE
  • Kodi Mitundu Yabwino N'chiyani?
  • Zotsatira m'mawu a PL / SQL

3. Lembani Zomwe Zingatheke

  • Fotokozani Basic PL / SQL Pewani Zotsatira za Syntax
  • Phunzirani Kuyankha Code
  • Kutumizidwa kwa Ntchito SQL mu PL / SQL
  • Kodi mungasinthe bwanji mitundu ya ma data?
  • Fotokozani Makhalidwe Abwino
  • Dziwani Ogwira Ntchito ku PL / SQL

4. Kuyanjana ndi Oracle Server

  • Pemphani Zomwe ZINENERO mu PL / SQL
  • Pezani Dongosolo mu PL / SQL
  • SQL Cursor concept
  • Pewani Zolakwika pogwiritsira ntchito Misonkhano Yogwiritsa Ntchito Pogwiritsira ntchito Zowonjezeretsa ndi DML
  • Kusokoneza Deta mu Server pogwiritsa ntchito PL / SQL
  • Kumvetsa lingaliro la SQL Cursor
  • Gwiritsani ntchito Zizindikiro Zotsutsa za SQL Kuti Mudzalandila DML
  • Sungani ndi Kutaya Zochitika

5. Ma Structure Control

  • Kukonzekera koyenera pogwiritsira ntchito ndondomeko za IF
  • Kukonzekera koyenera pogwiritsa ntchito CASE Statements
  • Fotokozani Zolemba Zosavuta
  • Fotokozani Pamene Loop Statement
  • Fotokozani za Loop Statement
  • Gwiritsani Mfundo Yopitiriza

6. Zowonjezereka Zina Za Dongosolo

  • Gwiritsani ntchito PL / SQL Records
  • Chigawo cha% ROWTYPE
  • Lowani ndi Kusintha ndi PL / SQL Records
  • INDEX NDI matebulo
  • Fufuzani INDEX ndi Njira Zamagetsi
  • Gwiritsani ntchito INDEX BY Table of Records

7. Cursors Owonetsa

  • Kodi Explicit Cursors ndi chiyani?
  • Lengezani Wotembereredwa
  • Tsegulani Wotsutsa
  • Tengerani dera kuchokera kwa Wotembereredwa
  • Tsekani Wotsutsa
  • Wotembereredwa YOKHUDZA
  • % NOT NOT and% ROWCOUNT Mbali
  • Fotokozani NKHANI YOPHUNZITSIRA NDIPO KODI MUTU WOYERA

8. Kugwira Ntchito Mwachinsinsi

  • Kumvetsa Kupatula
  • Sungani Zopatula ndi PL / SQL
  • Misampha Yopangidwira Yopangira Oracle Server
  • Mtsuko Osasankhidwa Oracle Server Zolakwika
  • Kusiyanitsa kwa Msuti-Zofotokozedwa ndi Mtumiaji
  • Chotsani Zophatikizapo
  • NJIRA_ACHPLICATION_ERROR Ndondomeko

9. Ndondomeko Zosungidwa

  • Pangani Zojambula Zowonongeka ndi Zosakaniza
  • Kukula kwa Modularize Pogwiritsa Ntchito PL / SQL Zimene
  • Mvetserani Malo Omwe Akugwiritsira Ntchito PL / SQL
  • Lembani phindu logwiritsa ntchito PL / SQL Subprograms
  • Lembani kusiyana pakati pa Anonymous Blocks ndi Subprograms
  • Pangani, Limbirani, ndi Chotsani Ndondomeko Zosungidwa
  • Gwiritsani ntchito Ndondomeko ya Parameters ndi Parameters Modes
  • Onani Zomwe Mukutsatira

10. Ntchito Zosungidwa ndi Zomangamanga Zotsutsa

  • Pangani, Limbirani, ndi Chotsani Ntchito Yosungidwa
  • Dziwani ubwino wogwiritsa ntchito ntchito yosungidwa
  • Dziwani njira zothetsera ntchito yosungidwa
  • Pemphani Ntchito Zowonongeka ndi Mtumiki muzolemba za SQL
  • Zoletsa pamene mukuitana Ntchito
  • Zotsatira zoyendetsa poyitana Ntchito
  • Onani Ntchito Zowonjezera
  • Kodi mungasokoneze bwanji ntchito ndi ndondomeko?

11. Phukusi

  • Kulemba ubwino wa maphwando
  • Fotokozerani ma Packages
  • Kodi ndi zigawo ziti za Phukusi?
  • Pangani Phukusi
  • Kodi mungatani kuti ziwonetsedwe za Mapangidwe a Phukusi?
  • Pangani ndondomeko ya Phukusi ndi Thupi pogwiritsa ntchito SQL CREATE Statement ndi SQL Developer
  • Pemphani Phukusi Kupanga
  • Onani Code PL / SQL Source Source pogwiritsa ntchito Data Dictionary

12. Kutumiza Mapepala

  • Kuwonjezera majekesero mu PL / SQL
  • Gwiritsani ntchito Package STANDARD
  • Gwiritsani ntchito Mauthenga Otsogolera kuti athetse Malamulo Oletsedwa Oletsedwa
  • Sungani Ntchito za Phukusi mu SQL ndi Zoletsa
  • Ma Packages Okhazikika
  • Wotsutsa Wachigawo Chokwanira
  • Zotsatira zoletsa za PL / SQL Zopangira
  • Pemphani Masamba a PL / SQL a Zolemba M'maphukusi

13. Gwiritsani ntchito maphukusi ovomerezedwa ndi Oracle mu Kukonzekera kwa Zapangidwe

  • Kodi Ma Pac Package Oracle Ndi Otani?
  • Zitsanzo za zina mwa Oracle-Packageges Packages
  • Kodi DBMS_OUTPUT Phukusi imagwira ntchito motani?
  • Gwiritsani ntchito Phukusi la UTL_FILE kuti muyanjane ndi Maofesi Ogwira Ntchito
  • Lembani UTL_MAIL Phukusi
  • Lembani zolemba za UTL_MAIL

14. SQL Yamphamvu

  • Kuyenda kwa SQL
  • Kodi Dynamic SQL ndi chiyani?
  • Lengezani Zosintha Zotsutsa
  • Kuchita Mowonjezera PL / SQL Pewani
  • Sungani Native Dynamic SQL Kuti Muphatikize PL / SQL Code
  • Momwe mungapempherere DBMS_SQL Phukusi?
  • Gwiritsani ntchito DBMS_SQL ndi Ndondomeko ya DML Yowonjezera
  • Mphamvu ya SQL Yokwanira

15. Zoganizira Zokonzekera Code / SQL Code

  • Kulimbitsa Mphamvu ndi Zosiyana
  • Mvetserani Zowonjezera Zamtundu
  • Lembani Zochita Zovomerezeka
  • Tsatirani ndondomeko ya NOCOPY yolemba
  • Lembani ndemanga ya PARALLEL_ENABLE
  • Cross-Session PL / SQL Zotsatira Zogwira Ntchito
  • Lamulo loyamba ndi Ntchito
  • Kugwiritsira Ntchito Kokumbiritsa Nkhuku Kukulitsa Kuchita

16. Zimayambitsa

  • Fotokozani Zovuta
  • Dziwani Mitundu Yopangirako Mitundu ndi Thupi
  • Zochita Zogwira Ntchito za Bizinesi Yogwiritsira Ntchito Zovuta
  • Pangani DML Otsogolera pogwiritsa ntchito CREATE TRIGGER Statement ndi SQL Developer
  • Dziwani Mitundu Yowonekera, Thupi, ndi Kuthamanga (Kutha nthawi)
  • Kusiyanasiyana pakati pa Statement Level Triggers ndi Row Level Triggers
  • Pangani M'malo mwa Mavuto Olemala
  • Kodi mungasamalire bwanji, kuyesa ndi kuchotsa zovuta?

17. Kupanga Makompyuta, DDL, ndi Mbiri Yokambirana Zokambirana

  • Kodi Compound Triggers ndi chiyani?
  • Dziwani Zigawo Zopangira Nthawi Yophatikizira Pakompyuta
  • Mvetserani Chikhalidwe cha Trigger Pakompyuta ndi Mawonekedwe
  • Gwiritsani ntchito Trigger Yomangamanga Yothetsa Zolakwitsa Zophatikizira Zamtundu
  • Kuyerekeza kwa Database Kuwongolera Njira Zosungidwa
  • Pangani Zovuta pa Ma DDL
  • Pangani Zotsatira Zokambirana ndi Zomwe Zimayambitsa Zochitika
  • Maudindo a Mautumiki Akuyenera Kutha Kusintha

18. PL / SQL chojambulira

  • Kodi PL / SQL Compiler ndi chiyani?
  • Fotokozerani Kuyambira Parameters kwa PL / SQL Compilation
  • Lembani PL / SQL yatsopano Yambani Zhenjezo Zanthawi
  • Zowonjezera za PL / SQL Yambani Zhenjezo Zanthawi za Majekesenti
  • Lembani phindu la machenjezo a Compiler
  • Lembani PL / SQL Yambani Zigawo Zowonjezera Nthawi
  • Kuyika Mndandanda wa Mauthenga: Kugwiritsa ntchito SQL Developer, PLSQL_WARNINGS Initialization Parameter, ndi DBMS_WARNING Penyani machenjezo a Compiler: Pogwiritsa ntchito SQL Developer, SQL * Plus, kapena Views Dictionary Deta

19. Sungani Maganizo

  • Zowonongeka za Kusagwirizana kwa Scheme Object Dependencies
  • Kufunsira Zofuna Zowongoka Zogwiritsa Ntchito USER_DEPENDENCIES View
  • Akufunsani Chikhalidwe cha Object
  • Kuletsedwa kwa Zinthu Zodalirika
  • Onetsani Magulu Otsatira ndi Odziwika
  • Kukonzekera kwabwino Kwambiri ku Oracle Database 12c
  • Kumvetsetsa Kudalira Kwambiri
  • Kuwerenganso PL / SQL Program Unit

chitsimikizo

Kutsegulira kukonzekera ophunzirawa ayenera kukhala okonzeka kutenga mayeso awiri:
Step1 Pass Phunziroli
Sankhani imodzi mwa mayesowa
Oracle Database SQL Expert
OR
Oracle Database 11g: SQL Zopindulitsa I
OR
Oracle Database 12c: SQL Zofunikira
Step2 Pass Phunziroli
Sankhani imodzi mwa mayesowa
Pulogalamu ndi PL / SQL
OR
Oracle Database 11g: Pulogalamu ndi PL / SQLPakuti mulankhulane ndi ife mwachifundo.


Reviews