ụdịỌzụzụ klas
Deba aha

Oracle 11 g PL SQL Developer

Oracle 11 g PL SQL Developer Training Course & Certification

Overview

Ndị na-ege ntị na ihe ndị dị mkpa

Ihe ndepụta

Nhazi & Ụgwọ

Asambodo

Oracle 11 g PL SQL Developer Training Course Overview

PL / SQL bụ ngwakọta nke SQL tinyere usoro usoro nke asụsụ mmemme. Ọ bụ Oracle Corporation mepụtara ya na mmalite nke 90 iji mee ka ikike nke SQL.PL/SQL (Language Procedural Language / Structured Query Language) bu usoro ntụgharị asụsụ nke Oracle Corporation maka SQL na Oracle relational database. PL / SQL dị na Oracle Database

Ihe mgbaru ọsọ nke Oracle 11 g PL SQL Developer Training

Mgbe ị gụsịrị akwụkwọ a, ị ga-enwe ike:

  • Kọwaa isi ihe nke asụsụ PL / SQL mmemme
  • Dee ma mee ihe PL / SQL na SQL * Plus
  • Iwu PL / SQL ụdị ntụgharị ọrụ data
  • Gosipụta mmepụta site na mmemme PL / SQL
  • Nhazi agwa na-adaba na mmemme PL / SQL
  • Mmemme Debug PL / SQL

Ejiri na-ege ntị maka Oracle 11 g PL SQL Onye Mmepụta N'ezie

A haziri nkuzi a maka ndị ọkachamara na Software, ndị dị njikere ịmụta PL / SQL mmemme Asụsụ na mfe na dị mfe. Nke a nkuzi ga-enye gị nnukwu nghọta na PL / SQL mmemme echiche, na mgbe na-emecha a nkuzi, ị ga-na n'etiti larịị nke nka si ebe i nwere ike na-onwe gị elu ọkwa nke nka.

Ihe ndị dị mkpamaka Oracle 11 g PL SQL Developer Certification

I kwesiri ighota ihe software echiche dị iche iche dị ka ihe nchekwa data, koodu ntinye, nchịkọta ederede na mkpochapụ nke mmemme, wdg. Ọ bụrụ na ị nwere nghọta na SQL na kọmputa ndị ọzọ na-emepụta asụsụ ahụ, ọ ga-abụ uru kwadoro n'ihu.

Oge Nhazi Oge: 3 Days

  1. Okwu Mmalite na PL / SQL
  • Chọpụta uru nke PL / SQL Subprograms
  • Nkọwapụta ụdị ụdị PL / SQL
  • Mepụta Mgbochi Anonymous Dị Mfe
  • Kedu otu esi esi na PL / SQL Block?

2. Kpọsaa ndị PL / SQL Identifiers

  • Depụta ụdị Njirimara ụdị dị iche iche na subprogram PL / SQL
  • Iji Ngalaba Nkwupụta Nkebiiwu eme ihe iji Kọwaa Njirimara
  • Jiri mgbanwe iji chekwaa data
  • Chọpụta Scalar Data Types
  • Ihe% Ụdị Ụdị
  • Kedu ihe bụ Ụdị Agbanwe?
  • Usoro na okwu PL / SQL

3. Dee Nkwupụta Ntucha

  • Kọwaa Ntuziaka PL / SQL Block Syntax Guidelines
  • Mụta ịzaa Usoro ahụ
  • Ịnye ọrụ SQL na PL / SQL
  • Olee otú iji gbanwee ụdị data?
  • Kọwaa Mgbochi Kwadoro
  • Chọpụta ndị ọrụ na PL / SQL

4. Mkpakọrịta na Server Ọdịdị

  • Kpọsaa Nkwupụta Nhọrọ na PL / SQL
  • Weghachite Data na PL / SQL
  • Echiche SQL dị njọ
  • Zere Njehie site na iji Mkpọkọta Aha mgbe ị na-eji nkwupụta na DML Nkwupụta
  • Ntughari data na Server site na iji PL / SQL
  • Ghọta ihe kpatara SQL Cursor
  • Jiri Okwenye Cursor SQL iji nweta Nzaghachi na DML
  • Zọpụta na tufuo ọrụ

5. Atụmatụ Nhazi

  • Nhazi nhazi site na iji nkwupụta okwu
  • Nhazi nhazi site na iji okwu CASE
  • Kọwaa okwu Nkwupụta Mgbochi dị mfe
  • Kọwaa Mgbe Nkwupụta Ntughari
  • Kọọ maka Nkwupụta Nkwalite
  • Jiri Nkwupụta Gaa n'ihu

6. Ụdị ụdị data

  • Jiri PL / SQL Records
  • The% ROWTYPE Attribute
  • Tinye na Melite na PL / SQL Records
  • INDEX Site na tebụl
  • Nyochaa usoro ihe eji eme ihe
  • Jiri akwukwo ndekọ nke ederede INDEX

7. Ndị ọhụụ doro anya

  • Kedu ihe na-akpata Ọhụụ doro anya?
  • Kpọsaa oku
  • Mepee oku
  • Chọta data site na Cursor
  • Mechie Cursor
  • Ogbugbu maka aka
  • Ihe% NOTFOUND na% ROWCOUNT Attributes
  • Kọwaa Nkọwa siri ike na MGBE OZI NTỤTA

8. Ịnaghị ejikwa ya

  • Ghọta naanị
  • Ntughari aka na PL / SQL
  • Njehie Mgbasa Ozi Nzuzo Predefined
  • Nwunye Njehie Nzuzo Na-enweghị Ntọala
  • Nwunye Onye Nwepu - Nanị Nhọrọ
  • Naanị ihe gbasara ego
  • Usoro RAISE_APPLICATION_ERROR

9. Usoro nchekwa

  • Wụpụta Ihe Ntinye Agbanwe Agbanwe na Layered
  • Dezie mmepe na ogwe / PL / SQL
  • Ghọta na PL / SQL Execution Environment
  • Depụta uru nke iji PL / SQL Subprograms
  • Depụta esemokwu dị iche iche n'etiti Ngalaba Anyi na Ngalaba Programs
  • Mepụta, Kpọọ, na Wepu usoro ịchekwa
  • Mee usoro nhazi na njedebe usoro
  • Lelee ozi usoro

10. Ihe ndị echekwara echekwa ma na-emepụta Mbadamba usoro

  • Mepụta, Kpọọ, ma Wepu Ọrụ Echetara
  • Chọpụta uru nke iji Ọrụ Nchekwa
  • Chọpụta usoro iji mepụta ọrụ echekwara
  • Kpọsaa Ọrụ Ndị Nkọwapụtara na Akaụntụ na Nkwupụta SQL
  • Mgbochi mgbe ị na-akpọ Ọrụ
  • Njikwa mmetụta na-achịkwa mgbe ị na-akpọ Ọrụ
  • Lelee ozi ọrụ
  • Kedu esi arụ ọrụ na usoro?

11. Nchịkọta

  • Depụta uru nke nchịkọta
  • Kọwaa nchịkọta
  • Kedu ihe bụ ngwugwu nke ngwugwu?
  • Zụlite ngwugwu
  • Kedu ka esi mee ka ngosipụta nke ngwongwo ngwugwu?
  • Mepụta nkwupụta ngwugwu na Isi na iji SQL CREATE Nkwupụta na SQL Onye Mmepụta
  • Kpọsaa Nzube Mgbasa Ozi
  • Lelee usoro PL / SQL Source site na iji Data Dictionary

12. Ihe nchịkọta nchịkọta

  • Ịkwanye Subprograms na PL / SQL
  • Jiri nchịkọta STANDARD
  • Jiri Nkwupụta Ọdịnihu na-aga n'ihu iji dozie usoro iwu na-akwadoghị
  • Mee Mmemme Ngwugwu na SQL na Ibechi
  • Nchịkọta State nke nchịkọta
  • Obodo na-adịgide adịgide
  • Njikwa mmetụta nke PL / SQL Subprograms
  • Invoke PL / SQL Tebụl nke Records na nchịkọta

13. Mee Nchịkọta Na-enweghị Nzuzo na Mgbasa Ngwa

  • Kedu ihe nchịkọta Oracle-Supplied?
  • Ihe Nlereanya nke ụfọdụ nchịkọta Oracle-Supplied
  • Kedu ka ọrụ DBMS_OUTPUT Package si arụ?
  • Jiri ngwugwu UTL_FILE iji jikọta Nhazi System
  • Kpọsaa ngwugwu UTL_MAIL
  • Dee ihe ndenye UTL_MAIL

14. SQL di omimi

  • Ogbugbu nke SQL
  • Kedu ihe bụ SQL dị omimi?
  • Kpọsaa mgbanwe dị iche iche
  • Dynamically Executing a PL / SQL Block
  • Zigharie SQL di omimi ka ichikota PL / SQL Code
  • Kedu ka esi akpọ DBMS_SQL ngwugwu?
  • Jiri DBMS_SQL rụọ ọrụ na nkwupụta DML setịpụrụ
  • Nzuzu arụmọrụ SQL dị omimi

15. Atụmatụ Echiche maka Usoro PL / SQL

  • Nyochaa Ndị Constants na Nanị
  • Ghọta ihe ndị e dere n'okpuru mpaghara
  • Dee mmezi kwurula
  • Mee NOCOPY nchịkọta ihe nchịkọta
  • Kpọsaa na PARALLEL_ENABLE Hint
  • Usoro Cross-Session PL / SQL rụpụtara
  • Nkọwapụta DETERMINISTIC na Ọrụ
  • Ichekwa nnukwu ihe na-eme ka ọ dị mma

16. Triggers

  • Kọwaa ndị na-agba ọsọ
  • Chọpụta ụdị na ụdị isi ihe na-akpata
  • Ihe nyocha ngwa ahia maka imejuputa ndi ozo
  • Mepụta Mmetụta DML na iji Nhazi Nkwupụta na SQL Onye Mmepụta
  • Chọpụta Ụdị Omume Na-emepụta, Isi, na Ịrụ Ọrụ (Oge)
  • Esemokwu dị n'etiti ọkwa okwu ọkwa na-agba ọsọ na ọkwa dị elu
  • Mepụta Kama nke na ndị nkwarụ na-agba
  • Otu esi ejikwa, ule na wepụ ndị na-agba ọsọ?

17. Ịmepụta Compound, DDL, na Omume database Triggers

  • Kedu ihe ndị mejupụtara Compost?
  • Chọpụta Ihe Omume nke Oge Nchịkọta Isiokwu
  • Ghọta Nhazi nke Nchịkọta Na-emepụta Tebụl na Echiche
  • Mee ka otu ngụkọta kpalite imezigharị Ntọala Mmebi
  • N'iji Ntụle data na-akpata na-echekwa usoro echekwara
  • Mepụta Mmetụta na Nkwupụta DDL
  • Mepụta ihe ndekọ data na System-Ihe na-akpata
  • Ihe Nlekọta Nchịkwa Achọrọ Ka Jikwaa Ndị Na-akpata Nchọpụta

18. PL / SQL na-egwu egwu

  • Kedu ihe bụ PL / SQL Compiler?
  • Kọwaa Ntọala Ntọala maka PL / SQL mkpokọta
  • Depụta ọkwa PL / SQL ọhụrụ na-agụnye ịdọ aka ná ntị oge
  • Nkọwapụta nke PL / SQL na-agbakọ ịdọ aka ná ntị oge maka Subprograms
  • Depụta uru nke ndụmọdụ Ngwá Ọrụ
  • Depụta na PL / SQL wepụta oge ịdọ aka ná ntị Ozi Categories
  • Ịtọ ntọala ozi ịdọ aka ná ntị: Iji Onye Mmepụta SQL, PLSQL_WARNINGS Ntọala Ntọala, na DBMS_WARNING Lee Ịnye Nkọwapụta: Iji SQL Developer, SQL * Plus, ma ọ bụ Nkọwapụta Data Dictionary

19. Jikwaa Atụmatụ

  • Nchịkọta nke atụmatụ Ihe Omume Schema
  • Ihe Mgbochi Ihe Ntuziaka Na-eme Ihe na-eji USER_DEPENDENCIES View
  • Ịjụ Ọnọdụ Ihe
  • Invalidation of Objects Objects
  • Gosi Ntuziaka Direct na Mmetụta
  • Nchịkwa Kwesịrị Ekwesị Na-edozi Ihe na Oracle Database 12c
  • Ghọta Ihe Omume nke Ime
  • Rụgharịa PL / SQL Mmemme so

Biko dee anyị na info@itstechschool.com & kpọtụrụ anyị na + 91-9870480053 maka ụgwọ ọnụahịa & asambodo ụgwọ, oge na ọnọdụ

Wepụ Anyị Ajụjụ

Asambodo

emezu ihe ndi a ga - akwadebe iji ule abuo:
Nzọụkwụ Step1 a na-enyocha
Họrọ otu n'ime ule ndị a
Ọkachamara SQL SQL Ogologo
OR
Oracle Database 11g: SQL Fundamentals I
OR
Oracle Database 12c: SQL Fundamentals
Nzọụkwụ Step2 a na-enyocha
Họrọ otu n'ime ule ndị a
Mmemme na PL / SQL
OR
Usoro Nchịkwa Oracle 11G: Mmemme na PL / SQLGụkwuo ozi ọma kpọtụrụ anyị.


Nyocha