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

Oracle 11 g PL SQL Developer Training Course & Certification

Txheej txheem cej luam

Suab Seev & Seem Ua Ntej

Cov Qauv Dua

Teem & Cov Nqi

Certification

Oracle 11 g PL SQL Tsim tawm Kev Kawm Zaj Kawm

PL / SQL ua ke nrog SQL nrog rau txheej txheem ntawm cov lus programming. Nws yog tsim los ntawm Oracle Corporation hauv 90 thaum ntxov yuav txhim khu lub peev xwm ntawm SQL.PL / SQL (Cov Lus Cov Lus Qhia / Cov Lus Nyuaj Kawm Lus) yog Oracle Corporation tus txheej txheem kev hais lus ntxiv rau SQL thiab Oracle cov ntaub ntawv sib txuas lus. PL / SQL muaj nyob hauv Oracle Database

Lub hom phiaj ntawm Oracle 11 g PL SQL Tsim tawm Kev Kawm

Tom qab ua tiav qhov kev qhia no, koj yuav tsum muaj peev xwm:

  • Qhia txog cov ntsiab lus ntawm PL / SQL Programming Language
  • Sau thiab ua txhaum PL / SQL cov kev pab cuam hauv SQL * Plus
  • Execute PL / SQL cov ntaub ntawv hloov hom kev ua haujlwm
  • Tso zis tso tawm los ntawm PL / SQL cov kev pab cuam
  • Manipulate cov cwj pwm cim hauv PL / SQL cov kev pab cuam
  • Debug PL / SQL cov kev pabcuam

Cov Neeg Nruab Nrab rau Oracle 11 g PL SQL Developer thaum kawg

Qhov kev nyeem no yog tsim los rau Cov Kws Ua Haujlwm Software, uas txaus siab kawm PL / SQL Programming Language yooj yim thiab yooj yim cov kauj ruam. Qhov kev qhia no yuav qhia rau koj txog kev nkag siab zoo txog PL / SQL Programming, thiab tom qab ua tiav qhov kev qhia no, koj yuav tsum nyob rau theem ntawm kev txawj ntse los ntawm qhov chaw uas koj tuaj yeem coj koj tus kheej mus rau qib siab dua.

Yam yuavtsum tau kawm uantejrau Oracle 11 g PL SQL Developer Certification

Koj yuav tsum muaj kev nkag siab yooj yim ntawm software cov ntsiab lus yooj yim xws li cov ntaub ntawv database, source code, text editor thiab tiav ntawm cov kev pab cuam, thiab lwm yam. Yog tias koj twb to taub txog SQL thiab lwm yam tshuab computer programming ces nws yuav yog qhov kom zoo dua ntxiv mus.

Cov Qauv Ntu Kev Kawm Duration: 3 Hnub

  1. Introduction to PL / SQL
  • Txheeb xyuas cov txiaj ntsim ntawm PL / SQL Subprograms
  • Txheej txheem cej luam ntawm cov hom PL / SQL blocks
  • Tsim ib qho yooj yim Anonymous Block
  • Yuav ua li cas los tsim cov zis los ntawm PL / SQL Block?

2. Tshaj tawm PL / SQL Identifiers

  • Sau cov lus sib txawv ntawm cov Identifiers hauv PL / SQL subprogram
  • Kev Siv Cov Lus Tshaj Tawm los Teev Txhais Cov Qauv
  • Siv cov tsiaj ntawv khaws cov ntaub ntawv
  • Txheeb xyuas Cov Ntawv Scalar Cov Ntaub Ntawv
  • % TYPE Attribute
  • Dab tsi yog Bind Variables?
  • Sequences hauv PL / SQL Cov Lus Qhia

3. Sau cov ntawv sau Executable

  • Piav qhia txog PL / SQL Block Syntax Guidelines
  • Kawm Kom Saib Txoj Cai
  • Txiag ntawm SQL dej num hauv PL / SQL
  • Yuav ua li cas hloov cov ntaub ntawv?
  • Qhia txog Nested Blocks
  • Txheeb xyuas cov Tswv Haujlwm hauv PL / SQL

4. Kev sib tham nrog Oracle Server

  • Caw lus xaiv lus xaiv nyob hauv PL / SQL
  • Retrieve Cov Ntaub Ntawv hauv PL / SQL
  • SQL Cursor tswvyim
  • Zam txhob ua yuam kev los ntawm kev siv Naming Conventions thaum siv Kev Siv Tawm thiab DML
  • Cov ntaub ntawv Manipulation nyob rau hauv tus neeg siv kev siv PL / SQL
  • Nkag siab txog Kev Cai Cursor SQL
  • Siv SQL Cursor Attributes kom paub cov tswv yim ntawm DML
  • Txuag thiab rho cov nqi khoom lag luam

5. Cov Kev Tswj Tswj

  • Txuj kev ua haujlwm uas siv cov lus qhia yog
  • Txwm ua haujlwm uas siv cov kab lus CASE
  • Piav Qhia Loop yooj yooj yim
  • Piav Qhia Thaum Tsaus Loop
  • Piav Qhia Loop
  • Siv Daim Ntawv Ntxiv

6. Kev Sau Ntaus Ntawv

  • Siv PL / SQL Cov Ntaub Ntawv
  • Qhov% ROWTYPE Tus Cwj Pwm
  • Ntxig thiab Hloov tshiab nrog PL / SQL Cov Ntaub Ntawv
  • INDEX los ntxhuav
  • Soj ntsuam ntawm INDEX COV txheej txheem
  • Siv INDEX los ntawm Cov Ntaub Ntawv Cov Ntaub Ntawv

7. Qhib Cursors

  • Dab Tsi Ceev Xwm?
  • Tshaj tawm Cursor
  • Qhib tus Cursor
  • Nqa cov ntaub ntawv los ntawm tus Cursor
  • Kaw tus Cursor
  • Cursor RAU voj
  • Cov% LusFOUND thiab% ROWCOUNT Tus Cwj Pwm
  • Piav kom meej rau UPDATE Clause thiab qhov twg tshaj CURRENT Clause

8. Tsuas yog ua haujlwm

  • To taub tshwj tsis yog
  • Kov Tsuas Siv nrog PL / SQL
  • Trap Predefined Oracle neeg rau zaub mov raug
  • Txheeb Tsis Muaj Cov Txheej Txheem Los ntawm Cov Teeb Meem Oracle Cov Teeb Meem
  • Trap Tus Neeg Siv Cov Lus Tshwj Xeeb
  • Hais tawm tshwj
  • RAISE_APPLICATION_ERROR Tus txheej txheem

9. Cov txheej txheem khaws cia

  • Tsim ib lub Modularized thiab Layered Subprogram Design
  • Modularize Kev Txhim Kho nrog PL / SQL Blocks
  • Nkag siab txog PL / SQL Qhov Kev Txav Ntaus Zog
  • Sau cov txiaj ntsig ntawm kev siv PL / SQL Subprograms
  • Sau qhov txawv ntawm Anonymous Blocks thiab Subprograms
  • Tsim, Hu Xov Xwm, thiab Tshem Cov Txheej Txheem Txhim Kho
  • Siv cov txheej txheem Parameters thiab Parameters Modes
  • Saib Cov Txheej Txheem Qhia

10. Khaws Ntaub Ntawv thiab Debugging Subprograms

  • Tsim, Hu Xov Xwm, thiab Tshem Cov Haujlwm Khaws Ntaub Ntawv
  • Txheeb xyuas qhov zoo ntawm kev siv Cov Haujlwm Khaws Ntaub Ntawv
  • Txheeb xyuas cov kauj ruam los tsim ib qho kev ua haujlwm
  • Caw Tus Neeg Siv Cov Lus Txhais Cov Lus hauv SQL Cov Lus Teb
  • Kev txwv txwv thaum hu xov tooj
  • Kev tswj cov kev mob tshwm sim thaum hu xov tooj
  • Saib Cov Lus Qhia Cov Lus Qhia
  • Yuav ua li cas Debug Cov Haujlwm thiab Cov Txheej Txheem?

11. Tej pob khoom

  • Qhia cov txiaj ntsim ntawm cov pob ntawv
  • Piav Qhia Pob
  • Cov khoom ntawm pob ntawv yog dab tsi?
  • Npaj ib pob
  • Yuav ua li cas pab kom pom tau tias Muaj Ib Cheeb Tsam Khoom?
  • Tsim lub Pob Specification thiab Lub Cev uas siv SQL Cov Lus Hais Lus thiab SQL Developer
  • Hu Cov Pob Khoom Ua Lag Luam
  • Saib PL / SQL qhov Code Code siv cov lus txhais lus

12. Tso pob khoom

  • Overloading Subprograms hauv PL / SQL
  • Siv lub pob STANDARD
  • Siv Kev Xa Mus Rau Kev Hais Kom Txhab Txhim Kho Cov Txheej Txheem Txhaum Cai
  • Siv pob Functions hauv SQL thiab Txwv
  • Persistent lub xeev cov pob khoom
  • Tuaj Nruab Nrab ntawm Ib Pob Cursor
  • Tswj kev phiv ntawm PL / SQL Subprograms
  • Invoke PL / SQL Cov Ntaub Ntawv ntawm Cov Ntaub Ntawv Hauv Cov Khej

13. Siv Oracle-Packages Pob Khoom Siv Hauv Kev Tshawb Pom Tawm

  • Cov khoom siv Oracle-Packages yog dab tsi?
  • Piv txwv ntawm qee qhov ntawm Oracle-Packages
  • DBMS_OUTPUT Package ua hauj lwm li cas?
  • Siv cov UTL_FILE Pob rau Interact nrog Operating System Files
  • Hu rau UTL_MAIL Pob
  • Sau UTL_MAIL Subprograms

14. Dynamic SQL

  • Tus Txiav Txim ntawm SQL
  • Dab tsi yog Dynamic SQL?
  • Txiav Qhia Cursor Variables
  • Dynamically Executing PL / SQL Block
  • Configure haiv neeg Dynamic SQL rau Compile pl / SQL Code
  • Yuav ua li cas thiaj li tau txais DBMS_SQL Pob?
  • Siv DBMS_SQL nrog Parameterized DML Statement
  • Dynamic SQL Functional Completeness

15. Tsim cov kev xav rau PL / SQL Code

  • Standardize Constants thiab Exceptions
  • Nkag siab Lub Chaw Subprograms
  • Sau cov Nyiaj Luam Hloov
  • Siv lub NOCOPY Compiler Hint
  • Hu rau PARALLEL_ENABLE Hint
  • Ntoo khaub lig-Session PL / SQL kev ua haujlwm kev tshwm sim Cache
  • Lub DETERMINISTIC Clause nrog Kev Zog
  • Kev Pab Txhiv Rau Kev Txhim Kho Kom Zoo

16. Ua rau

  • Piav Qhia Yam Ua Tau
  • Txheeb xyuas cov Kuaj Cov Homphiaj thiab Lub Cev
  • Ua lag luam daim ntawv Scenarios rau cov tswv yim ua lag luam
  • Tsim DML kev siv cov CREATE TRIGGER Statement thiab SQL Developer
  • Taw Qhia Kuaj Cov Hom Phiaj, Lub Cev, thiab Kev Tawm (Sijhawm)
  • Sib txawv ntawm Nqe Lus Cov Qib Siab thiab Cov Qib Cov Qib Teeb
  • Tsim Kev Hloov thiab Kev Xiam Hloov
  • Yuav Tswj, Tuaj thiab Tshem tawm Cov Chiv Keeb Li Cas?

17. Tsim cov Compound, DDL, thiab Event Database Triggers

  • Cov tshuaj dab tsi yog Compester?
  • Txheeb xyuas cov Timing-Point Sections ntawm ib lub ntsiab lus Compound Trigger
  • Nkag siab txog Cov Qauv Ntsuas Cov Qauv Ntsuas rau Cov Ntxhais thiab Kev Ntsuam Xyuas
  • Siv ib lub tswv yim Compound los txiav txim siab Mutating Table Error
  • Sib piv ntawm Database Triggers rau cov txheej txheem ceev tseg
  • Tsim cov yam khoom ntawm DDL Cov Lus Qhia
  • Tsim Database-Hem thiab System-Events Events
  • Cov Kev Ua Haujlwm Yuav Tsum Tau Txais Kev Tswj Tau

18. PL / SQL Compiler

  • Qhov PL / SQL Compiler yog dab tsi?
  • Piav qhia txog cov txheej txheem Initialization rau PL / SQL Compilation
  • Sau cov ntaub ntawv tshiab PL / SQL Compile Time Warnings
  • Txheeb xyuas PL / SQL Compile Time Warnings rau Subprograms
  • Sau cov txiaj ntsim ntawm Cov Lus Cog Tseg
  • Sau lub PL / SQL Compile Time Warning Pawg Pawg
  • Qhov kev ceeb toom cov theem lus: Siv SQL Developer, PLSQL_WARNINGS Initialization Parameter, thiab DBMS_WARNING Saib Compiler Cov Lus Ceeb Toom: Siv SQL Developer, SQL * Ntxiv, los yog Cov Lus Cov Ntaub Ntawv Qhia Views

19. Tswj Cov Nyiaj Tso Haujlwm

  • Lub ntsiab lus ntawm Schema Object Dependencies
  • Nug Cov Khoom Siv Ntawm Cov Ncaj Ncees ncaj qha siv USER_DEPENDENCIES View
  • Lus nug tus txheej xwm
  • Kev Tsis Taus Ntawm Cov Khoom Uas Muaj Kev Xaiv
  • Qha cov Txais Ncaj Qha Ncaj Qha Ncaj Qha Ncaj Qha Ncaj Ncaj tsi ntsees hab tsi pub siv
  • Kev Txiav Txim Uas Muaj Kev Ruaj Ntseg Hauv Cov Tsev Kawm Ntawv Database 12c
  • To taub Cov Kev Txom Nyem Rau Qhov Chaw
  • Rov qab muab dua PL / SQL Program Unit

Yavtom ntej txheej xwm

Tsis muaj cov txheej xwm uas yuav los tom ntej no.

Thov sau ntawv rau peb ntawm info@itstechschool.com & hu rau peb ntawm rau cov nqi kawm & daim ntawv pov thawj, cov sij hawm & qhov chaw

Tawm Peb ib qho lus nug

Certification

fter ua tiav cov hoob kawm no yuav tsum npaj kom tau ob qho kev xeem no:
Step1 Tus Kuaj No
Xaiv ib qho ntawm cov kev xeem no
Oracle Database SQL kws muaj txuj
OR
Oracle Database 11g: SQL Fundamentals Kuv
OR
Oracle Database 12c: SQL Fundamentals
Step2 Tus Kuaj No
Xaiv ib qho ntawm cov kev xeem no
Qhov kev pab cuam nrog PL / SQL
OR
Oracle Database 11g: Kev pab nrog PL / SQLFor ntau info kindly hu rau peb.


Xyuas