TypeHo Koetlisa Sekolo
Ngodisa

Contact

Masimo a tšoauoa ka * ho hlokahala

 

Oracle 11 g PL SQL Developer

Oracle 11 g PL SQL Moqapi oa Koetliso ea Koetliso le Tlhahlobo

Overview

Bamameli le Litlhokahalo

Tlhahiso ea Tlhahlobo

Kemiso le Litefiso

tiiseletswe

Oracle 11 g PL SQL Motlatsi oa Koetliso ea Thupelo

PL / SQL ke motsoako oa SQL hammoho le lintlha tsa mekhoa ea lipuo. E qapiloe ke Oracle Corporation mathoasong a 90 ho ntlafatsa bokhoni ba SQL.PL/SQL (Puo ea Procedural Language / Structured Query) ke Oracle Corporation e kenyelletsoang puo ea SQL le database ea Oracle relational. PL / SQL e fumaneha ho Oracle Database

Sepheo sa Oracle 11 g PL SQL Mokhanni Koetliso

Kamora ho qeta thuto ena, o lokela ho tseba ho:

  • Hlalosa lintlha tsa motheo tsa puo ea PL / SQL Programming
  • Ngola le ho phethisa mananeo a PL / SQL ho SQL * Plus
  • Etsa mosebetsi oa phetoho ea mofuta oa data oa Execute PL / SQL
  • Hlahisa phallo ka PL / SQL mananeo
  • Sebelisa mekhoa ea litšoaneleho mananeong a PL / SQL
  • Merero ea PL / SQL

Bamameli ba Atlehileng bakeng sa Oracle 11 g PL SQL Developer thupelo

Thuto ena e etselitsoe Software Professionals, ba ikemiselitseng ho ithuta PL / SQL Language Language ka mehato e bonolo le e bonolo. Thuto ena e tla u fa kutloisiso e kholo litabeng tsa PL / SQL Programming, 'me ka mor'a ho qeta thupelo ena, u tla ba boemong ba bobeli ba litsebo ho tloha moo u ka ipehelang boemong bo phahameng ba tsebo.

Lintho tse hlokahalangbakeng sa Oracle 11 g PL SQL Developer de Certification

U lokela ho ba le kutloisiso ea motheo ea Software lintlha tsa mantlha joaloka sebopeho sa li-database, mohloli oa mohloli, mongolo oa mongolo le ho phethahatsa mananeo, joalo-joalo. Haeba u se u ntse u e-na le kutloisiso holim'a SQL le lipuo tse ling tsa lenaneo la k'homphieutha joale e tla ba monyetla o eketsehileng oa ho tsoela pele.

Nako ea Nako ea Tlhahlobo: Matsatsi a 3

  1. Kenyelletso ho PL / SQL
  • Hlalosa melemo ea Likaroloana tsa PL / SQL
  • Kakaretso ea mefuta ea PL / SQL e thibela
  • Etsa Block e Bonolo e sa Tsejoeng
  • Joang ho hlahisa ho tsoa ho PL / SQL Thibela?

2. Bolela Litsomi tsa PL / SQL

  • Thathamisa mefuta e fapaneng ea Lits'oants'o ka subprogram ea PL / SQL
  • Tšebeliso ea Karolo e Hlalosang ea ho Hlalosa Litsomi
  • Sebelisa mefuta-futa ho boloka lintlha
  • Khetholla Mefuta ea Litsela tsa Scalar
  • Sephetho sa% TYPE
  • Liphetoho tsa Bind ke life?
  • Ho latela litlhaloso tsa PL / SQL

3. Ngola Litlaleho tse sebetsang

  • Hlalosa motheo oa PL / SQL o thibela Litsamaiso tsa Syntax
  • Ithute ho hlalosa Khoutu
  • Ho romela mesebetsi ea SQL ho PL / SQL
  • Joang ho fetola Mefuta ea Data?
  • Hlalosa Matlo a Nested
  • Hlalosa Basebetsi ba PL / SQL

4. Ho sebelisana le Oracle Server

  • Kopa Litsebiso tsa SELECT ho PL / SQL
  • Fumana Lintlha ho PL / SQL
  • SQL Cursor khopolo
  • Qoba Liphoso ka ho sebelisa Likopano tsa Lebitso ha u sebelisa Litlhaloso tsa ho Khutlisa le DML
  • Tlhaloso ea Ditaba ho Sebedisa PL / SQL
  • Utloisisa mohopolo oa SQL Cursor
  • Sebelisa Litšoaneleho tsa Lihlahisoa tsa SQL ho fumana Feedback ho DML
  • Boloka 'me u lahle Litšebetso

5. Mekhoa ea ho Laola

  • Tshebetso e sebetsanang le melaetsa ya IF
  • Tshebetso e sebetsang ka CASE Statements
  • Hlalosa Tlhaloso e bonolo
  • Hlalosa Nakong ea Lekhetho
  • Hlalosa Tlhaloso ea Loop
  • Sebelisa Tlhaloso ea Tsoelopele

6. Mefuta e Fapaneng ea Data

  • Sebelisa Records PL / SQL
  • Tšobotsi ea% ROWTYPE
  • Kenya le Phatlalatso ka PL / SQL Records
  • NETEX ka litables
  • Hlahloba INDEX ka Mekhoa ea Litlhaku
  • Sebelisa INDEX ka Lethathamo la Libuka

7. Cursors e hlakileng

  • Li-expurs Cursors ke eng?
  • Bolela Moqapi
  • Bula Mohatelli
  • Tlosa dintlha ho tswa ho Mohatelli
  • Koala Moqapi
  • Mohatelli HO SELELA
  • % HO HLOKAHALA le% ROWCOUNT Litšoaneleho
  • Hlalosa SELELETSO SA SEHLOOHO le MOLAO OA CURRENT

8. Ho Itšoara ka Sekhetho

  • Utloisisa Exceptions
  • Tšoaroa ka ntle ho letsoho le PL / SQL
  • Leraba Litlhapiso tsa Oracle Server li khethiloe
  • Leraba la Oracle Server le sa Khethiloeng
  • Sekhetho se hlalositsoeng sa mosebedisi
  • Ho khetholla ho phatlalatsa
  • Mokhoa oa RAISE_APPLICATION_ERROR

9. Litsela tse bolokiloeng

  • Etsa Tlhahlobo ea Tlhahlobo ea Moralo oa Boithuto bo Botle
  • Ntlafatso ea Modularize le PL / SQL Blocks
  • Utloisisa Sebaka sa ho Sebetsa sa PL / SQL
  • Thathamisa melemo ea ho sebelisa li-PL / SQL
  • Thathamisa phapang pakeng tsa Monyatsi oa Mabitso le Li-Subprograms
  • Bopa, Bitsa, 'me u tlose Litsela tse bolokiloeng
  • Sebelisa Mekhoa ea Parameters le Parameters Mekhoa
  • Sheba Boitsebiso ba Tsamaiso

10. Mesebetsi e bolokiloeng le Likaroloana tsa Debugging

  • Bopa, Bitsa, 'me u tlose mosebetsi o bolokiloeng
  • Hlalosa melemo ea ho sebelisa mesebetsi e bolokiloeng
  • Hlalosa mehato ea ho etsa mosebetsi o bolokiloeng
  • Kopa Mesebetsi e hlalositsoeng ke Mosebetsi litlalehong tsa SQL
  • Lithibelo ha u bitsa Liketso
  • Litla-morao tsa taolo ha u bitsa Liketso
  • Sheba Mosebetsi oa Boitsebiso
  • Mokhoa oa ho senya Mesebetsi le Mekhoa ea Ts'ebetso joang?

11. Lipapaka

  • Ho thathamisa menyetla ea liphutheloana
  • Hlalosa liphutheloana
  • Ke likarolo life tsa Package?
  • Hlahisa Package
  • Ke eng e ka nolofalletsang ho bonahala ha Lihlopha tsa Package?
  • Etsa Tlhahiso ea Phakatsi le 'Mele o sebelisa SQL CREATE Statement le SQL Developer
  • Kopa Paseka e theha
  • Sheba Code ea PL / SQL ea Mohloli ho sebelisa Dataiso ea Data

12. Ho tsamaisa liphutheloana

  • Ho tlatsa ho tlatsetsoa ha li-PL / SQL
  • Sebelisa Pakete ea STANDARD
  • Sebelisa Liphatlalatso Tse Tsoelang pele ho rarolla Tlaleho ea Litsela tse sa Lebelloang
  • Qetella mesebetsi ea Package SQL le lithibelo
  • Lipapaka tsa Machaba tse tsitsitseng
  • Mohatelli oa Phakatsi oa Lekhetho
  • Litla-morao tsa taolo ea lik'hamphani tsa PL / SQL
  • Kopa Litlaleho tsa Libuka tsa PL / SQL Liphuthehong

13. Sebelisa liphutheloana tse fanoeng ka Oracle ho Ntlafatso ea Kopo

  • Li-Packages tse fanoeng ke Oracle ke life?
  • Mehlala ea likarolo tse ling tsa Oracle-Supplied Packages
  • Phakete ea DBMS_OUTPUT e sebetsa joang?
  • Sebelisa Package ea UTL_FILE ho Sebelisana le Ts'ebetso ea Files
  • Kopa UTL_MAIL Package
  • Ngola Litlhaloso tsa UTL_MAIL

14. SQL e matla

  • Phallo ea Phallo ea SQL
  • SQL e matla ke eng?
  • Bolela Mefuta-futa ea Li-cursor
  • Ho Sebetsa ka matla Sebaka sa PL / SQL
  • Lokisa Native Dynamic SQL ho bokella PL / SQL Code
  • Tsela ea ho kopa sephetho sa DBMS_SQL joang?
  • Phethahatsa DBMS_SQL ka Tlhaloso ea DML ea Parameteri
  • Ntho e matla ea SQL e sebetsang hantle

15. Tlhokomelo ea Moqapi bakeng sa Code PL / SQL

  • Etsa hore Li-Constants le Likhetho li behellane
  • Utloisisa Likaroloana tsa Motse
  • Ngola Liketsahalo Tse Ikemetseng
  • Sebelisa tlhahiso ea NOCOPY Compiler
  • Kopa tlhahiso ea PARALLEL_ENABLE
  • Sefapano-Session PL / SQL Sephetho sa Phello ea Mosebetsi
  • MOLAO O HLOKETSEHILENG Mantsoe a nang le Mesebetsi
  • Tšebeliso ea Boikhohomoso ba Bongata ho Ntlafatsa Tshebetso

16. Lisosa

  • Hlalosa lits'oaetso
  • Hlalosa Mefuta ea Liketsahalo tsa Trigger le 'Mele
  • Tlhahlobo ea Khoebo ea Boipheliso bakeng sa ho Sebelisa Lits'oaetso
  • Etsa DML Triggers ho sebelisa CREATE TRIGGER Tlhaloso le Moqapi oa SQL
  • Hlalosa Mefuta ea Liketsahalo tsa Trigger, 'Mele, le ho Fata (Nako)
  • Phapang pakeng tsa Sebopeho sa Lebelo la Boemo le Litsela tsa Row Level
  • Bōpa ho E-na le Lihlopha Tsa Bokooa
  • Tsela ea ho Laola, Tlhahlobo le Tlosa Lisosa?

17. Ho theha Compound, DDL, le Event Event Database

  • Li-Compound Triggers ke eng?
  • Khetholla Likarolo tsa Nako ea Nako ea Letlapa la Trigger Triple
  • Utloisisa Sebopeho sa Trigger ea Lik'hamphani le Litlhaku
  • Phethahatsa Trigger e Ikarabellang ho rarolla Phoso ea Phatlalatso ea ho Fetola
  • Ho bapisoa le Boitsebiso bo Hlahlobang boitsebiso ho Litsela tse bolokiloeng
  • Etsa Lintho tse hlahisang Litaba Litabeng tsa DDL
  • Etsa Ditshwantsho tsa Ditshebeletso-Diketsahalo le Tsamaiso ya Semosa-Tlhahlobo
  • Litokelo tsa Tsamaiso li Hlokeha ho Laola Lintho Tse Hlophisitsoeng

18. PL / SQL Compiler

  • Morekisi oa PL / SQL ke eng?
  • Hlalosa Li-Parameters tsa Qalong bakeng sa ho bokella PL / SQL
  • Thathamisa PL / SQL e ncha Qetella nako Temoso
  • Tlhaloso ea PL / SQL Qetella Nako ea Temoso ea Lik'hamphani
  • Thathamisa melemo ea Litemoso tsa Compiler
  • Thathamisa PL / SQL Ho bokella Melaetsa ea Temoso ea Lihlopha
  • Ho beha Litsela tsa Mantsoe a Lemosang: Ho Sebelisa SQL Developer, PLSQL_WARNINGS Initialization Parameter, le DBMS_WARNING Sheba Litemoso Tsa Khampo: U sebelisa SQL Developer, SQL * Plus, kapa Views Diction Dictionaries

19. Laola Boikarabello

  • Tlhaloso ea Sepheo sa ho Itšetleha ka Lintho
  • Tlhahlobo e tobileng ea ho itšetleha ka ho iketsetsa maikutlo ho sebelisa USER_DEPENDENCIES View
  • Ho botsa boemo ba Boemo
  • Ho se amohelehe ha Lintho Tse Tšoarellang
  • Bontša ho itšetleha ka ho toba le ka ho toba
  • Tsamaiso e ntle ea ho itšireletsa ka ntle ho Oracle Database 12c
  • Utloisisa ho itšetleha ka nako e telele
  • Hopola setho sa PL / SQL Program

tiiseletswe

ho qeta ho qeta liithuti tsena ho lokela ho ikemisetsa ho nka liteko tse peli:
Step1 Pass Phatlalatso ena
Khetha e 'ngoe ea litlhahlobo tsena
Oracle Database SQL Expert
OR
Oracle Database 11g: Lits'ebeletso tsa SQL I
OR
Oracle Database 12c: Lintho tsa bohlokoa tsa SQL
Step2 Pass Phatlalatso ena
Khetha e 'ngoe ea litlhahlobo tsena
Lenaneo le PL / SQL
OR
Oracle Database 11g: Lenaneo le PL / SQLEfono e eketsehileng ikopanye le rona ka mosa.


Reviews