mhandoChikoro Kudzidzisa
nyoresa

Oracle 11 g PL SQL Developer

Tsanangudzo 11 g PL SQL Mushanduri Kudzidzisa Nharo & Certification

tsananguro

Vateereri & Prerequisites

Course Outline

Purogiramu nemitengo

kutaura kuti ichokwadi

Tsanangudzo 11 g PL SQL Mushanduri Kudzidzisa Nhaurirano

PL / SQL inobatanidza SQL pamwe chete nematongerwo emarongerwo emitauro. Yakagadzirwa naOracle Corporation munguva yekutanga ye90 yekuwedzera kukwanisa kweSQL.PL/SQL (Procedural Language / Structured Query Mutauro) ndiyo Oracle Corporation yekuwedzera mutauro weSQL uye database yeOracle relational. PL / SQL inowanika muOracle Database

Zvinangwa zve Oracle 11 g PL SQL Developer Developer

Pashure pokupedzisa chidzidzo ichi, unofanira kukwanisa:

  • Rondedzera zvinyorwa zve PL / SQL Programming language
  • Nyora uye uite zvirongwa zve PL / SQL muSQL * Plus
  • Dzokorora PL / SQL dudzi rudzi rwekutendeuka mabasa
  • Ratidza zvabuda kuburikidza ne PL / SQL zvirongwa
  • Shandisa maitiro emhando mu PL / SQL mapurogiramu
  • Kugadzirisa PL / SQL zvirongwa

Intended Audience for Oracle 11 g PL SQL Developer course

Izvi zvidzidzo zvakagadzirirwa Software Software, avo vanoda kudzidza PL / SQL Programming Mutauro muzvikwata nyore uye zviri nyore. Iyi dzidzo ichakupa kunzwisisa kukuru pa PL / SQL Programming concepts, uye shure kwekupedzisa iyi tadzidzo, iwe uchava uri pakati pehutano hweunyanzvi kubva kwaunogona kutora uende kune imwe yepamusoro younyanzvi.

Zvinotarisirwa for Oracle 11 g PL SQL Developer Certification

Iwe unofanirwa kuva nekunzwisisa kwekutanga Software pfungwa huru, sezvinonzi database, source code, text editor uye nekushandiswa kwemapurogiramu, nezvimwewo. Kana iwe uine kutinzwisisa pane SQL nemimwe mitauro yepurogiramu yepakombiyuta ipapo ichava chinhu chakawedzerwa kuburitsa.

Course Outline Duration: 3 Days

  1. Nhanganyaya ku PL / SQL
  • Ziva zvinobatsira zve PL / SQL Subprograms
  • Mhedziso yemhando dze PL / SQL dzinodzima
  • Ita Anonymous Anonymous Block
  • Nzira yekugadzira zvakabuda sei pane PL / SQL Block?

2. Declare PL/SQL Identifiers

  • Rondedzera zvakasiyana-siyana zveMhando dzeZvizivi mu PL / SQL subprogram
  • Kushandiswa kweChechi Chinojekesa Kujekesa Zvidhori
  • Shandisa zvinoshandiswa kuti uchengetedze data
  • Ziva Nhamba Dzematambiro eScalar
  • I% TYPE Inobatsira
  • Chii chinonzi Bind Variables?
  • Kuenzaniswa mu PL / SQL Zviratidzo

3. Write Executable Statements

  • Rondedzera Basic PL / SQL Dzivisa Mazano eSineta
  • Dzidza Kupa Purogiramu
  • Kutumirwa kweSQL Mabasa mu PL / SQL
  • Nzira yekushandura Data Types?
  • Rondedzera Nested Blocks
  • Zivai Vashandi mu PL / SQL

4. Interaction with the Oracle Server

  • Invoke SELECT Zvinyorwa mu PL / SQL
  • Tora Data mu PL / SQL
  • SQL Cursor pfungwa
  • Dzivisa Zvikanganiso uchishandisa Kushandisa Kokorodzano paunoshandisa Kudzorera uye DML Zvinyorwa
  • Dhiyabhorosi Dhiyabhorosi muSeva uchishandisa PL / SQL
  • Kunzwisisa pfungwa yeSQL Cursor
  • Shandisa SQL Zvikwangwani Zvinowanikwa Kuti Uwane Mhinduro paDML
  • Ponesa uye Ramba Kurapa

5. Control Structures

  • Kugadziriswa kwemitemo inoshandisa IF Zvinyorwa
  • Kugadziriswa kwemamiriro ezvinhu uchishandisa CASE Statements
  • Rondedzera zviri nyore zvinyorwa zvinyorwa
  • Rondedzera Apo Loop Statement
  • Rondedzera Che Loop Statement
  • Shandisa Purogiramu Yacho

6. Composite Data Types

  • Shandisa PL / SQL Records
  • I% ROWTYPE Nhengo
  • Isa uye Kuvandudza ne PL / SQL Records
  • INDEX BY Tables
  • Ongorora INDEX Netafura Maitiro
  • Shandisa INDEX Netafura yeZviko

7. Explicit Cursors

  • Chii chinonzi Explicit Cursors?
  • Paridza Mutongi
  • Vhura Cursor
  • Tora data kubva kuCursor
  • Vhura Cursor
  • Muremeti WOKUTANGA
  • I% haina kufungidzirwa uye% ROWCOUNT Zvinhu
  • Rondedzera CHIMWE CHIMWE CHITSAUKO uye WHERE CURRENT Chirevo

8. Kunze kwekubata

  • Kunzwisisa Kusiyana
  • Tora Kusiyanisa ne PL / SQL
  • Trap Predefined Oracle Server Mazano
  • Musungo Usati Wakafanirwa Oracle Server Mhosva
  • Kusiyaniswa Kwetsotsi-Kunotsanangurwa Kunyoresa
  • Paridza Kusiyanisa
  • RAISE_APPLICATION_ERROR Nzira

9. Stored Procedures

  • Dzai Modularized and Layered Subprogram Design
  • Modularize Development Ne PL / SQL Blocks
  • Kunzwisisa PL / SQL Kutongwa Kwemazingira
  • Rondedzera zvikomborero zvekushandisa PL / SQL Subprograms
  • Rondedzera kusiyana pakati peAnonymous Blocks uye Subprograms
  • Dza, Danidzira, uye Bvisa Zvigadziriswa
  • Shandisai nzira dzeParamende uye Parameters Modes
  • Ona Nzira dzeNzira

10. Stored Functions and Debugging Subprograms

  • Dza, Danidzira, uye Bvisa Basa Rakachengetedzwa
  • Ziva zvinobatsira pakushandisa Mabasa Akachengetwa
  • Ziva matanho ekuumba basa rakachengetwa
  • Invoka Mitambo-Inotsanangurwa Mabasa muSQL Zvinyorwa
  • Zvibvumirano paunodana Basa
  • Kudzora migumisiro paunenge uchishevedza Mabasa
  • Ona Basa Rinoitwa
  • Nzira yekugadzirisa sei mabasa uye maitiro?

11. Packages

  • Kunyora zvinobatsira zvePakitiji
  • Rondedzera Packages
  • Ndezvipi izvo zvikamu zvePakiti?
  • Ita Paki
  • Nzira ipi yekugonesa kuonekwa kwePikika yeComputer?
  • Gadzira Package Specification uye Mutumbi uchishandisa SQL CREATE Statement uye SQL Developer
  • Invoke Package Inovaka
  • Ona PL / SQL Source Code uchishandisa Data Dictionary

12. Deploying Packages

  • Kuwedzeredza zvinyorwa pasi mu PL / SQL
  • Shandisa STANDARD Package
  • Shandisa Pamberi Mharidzo yekugadzirisa Mitemo yeZvirevo
  • Kushandisa Mabasa ePackage muSQL uye Zvibvumirano
  • Persistent State Of Packages
  • Persistent State of Package Cursor
  • Kudzora migumisiro ye PL / SQL Subprograms
  • Invoke PL / SQL Tables emarekhodi muPakitiji

13. Implement Oracle-Supplied Packages in Application Development

  • Chii chinonzi Oracle-Supplied Packages?
  • Mienzaniso yeimwe yeOracle-Supplied Packages
  • DBMS_OUTPUT Package inoshanda sei?
  • Shandisa UTL_FILE Package kuti Ubatane neApping System Files
  • Invoka UTL_MAIL Package
  • Nyora UTL_MAIL Subprograms

14. Dynamic SQL

  • Kuyerera Kwekufa kweSQL
  • Chii chinonzi Dynamic SQL?
  • Taura Zvirevo zveCursor
  • Kushanda nesimba PL / SQL Block
  • Rongedza Native Dynamic SQL Kuunganidza PL / SQL Code
  • Nzira yekupikira DBMS_SQL Package?
  • Shandisa DBMS_SQL neDametri DML Statement
  • Dynamic SQL Inoshanda Kuzadzikisa

15. Kufungidzirwa kwekugadzirwa kwe PL / SQL Code

  • Simbisai Constant and Exceptions
  • Kunzwisisa Mazano Akunharaunda
  • Nyora Kuzvibatanidza Kuita
  • Shandisai NOCOPY Compiler Hint
  • Invoke PARALLEL_ENABLE Hint
  • Muchinjikwa-Session PL / SQL Kushanda kweCache Cache
  • Iyo DETERMINISTIC Mutemo neMabasa
  • Kushandiswa kweBurk Kuvhara Kuvandudza Kuita

16. Triggers

  • Rondedzera Matambudziko
  • Chengetedza Matambudziko Ezvinhu uye Mutumbi
  • Bhizimisi Ongororo Maitiro Ekuita Kushandisa Zvinokonzera
  • Ita DML Triggers uchishandisa CREATE TRIGGER Statement uye SQL Developer
  • Chengetedza Matambudziko Ezvinhu, Muviri, uye Kupisa (Nguva)
  • Kusiyanisa pakati peStatement Level Triggers uye Row Level Triggers
  • Gadzira panzvimbo yeChirwere chekuremara
  • Nzira Yokushandisa Nayo, Kuedza uye Kubvisa Zvinotyisa?

17. Creating Compound, DDL, and Event Database Triggers

  • Chii chinonzi Compound Triggers?
  • Ziva Nguva Yenguva-Chikamu Chikamu cheTeekisi Compound Trigger
  • Inzwisisa Hurongwa hweCompound Trigger yeTables uye Views
  • Itai kuti Tenderera Yakakonzera Kugadzirisa Mutate Mutate Error
  • Kuenzaniswa kweDabhorosi Kunotungamirira Kuzvirongwa Zvichengetedzwa
  • Ita Zvinotyisa paDDL Zvinyorwa
  • Gadzira Database-Event uye System-Zviitiko Zvinokonzera
  • Kodzero dzeSystem Dzinodiwa Kutarisira Matambudziko

18. PL/SQL Compiler

  • Chii chiri PL / SQL Compiler?
  • Tsanangura Mavambo ekutanga kweP PL / SQL Compilation
  • Nyora pasi PL / SQL itsva Nyora Nguva Yenyevero
  • Mukurumbira we PL / SQL Nyora Nguva Yenyevero yeZvikamu
  • Rondedzera zvikomborero zveKutevera mazano
  • Nyora pasi PL / SQL Nyora Nguva Yenyevero Mamwe Mapoka
  • Kugadzirisa Mharidzo Mazano Nhamba: Kushandisa SQL Developer, PLSQL_WARNINGS Initialization Parameter, uye DBMS_WARNING Ona Mazano Emakumbani: Kushandisa SQL Developer, SQL * Plus, kana Deta Dzokuona Dhidhiro

19. Manage Dependencies

  • Kubatana kweStuma Object Dependencies
  • Query Direct Object Dependencies kushandisa USER_DEPENDENCIES View
  • Kutsvaga Chinzvimbo Chekuda
  • Kuvhiringidzwa kwezvinhu zvakachengetedzwa
  • Ratidzai Direct and Direct Direct Dependencies
  • Yakanaka-Yakakonzerwa Nokuchengetedzwa Kwekuchengetedzwa muOracle Database 12c
  • Kunzwisisa Kunzvenga Kure
  • Inodzokorora PL / SQL Program Unit

Ndapota nyorera kwatiri info@itstechschool.com & taura nesu pa + 91-9870480053 pamutengo wekodzero & chikwata chemari, purogiramu & nzvimbo

Dhidzai Mhinduro

kutaura kuti ichokwadi

Zuva rokuzadzisa vatori vechikoro vanofanira kunge vakagadzirira kutora miedzo miviri:
Step1 Pass This Exam
Sarudza chimwe chezvidzidzo izvi
Oracle Database SQL Expert
OR
Oracle Database 11g: SQL Zvinyorwa I
OR
Oracle Database 12c: SQL Zvinyorwa
Step2 Pass This Exam
Sarudza chimwe chezvidzidzo izvi
Purogiramu ne PL / SQL
OR
Oracle Database 11g: Chirongwa ne PL / SQLNokuti mamwe mashoko atisunungure nesu.


Reviews