ituaigaAoaoga a le potuaoga
Tusi Resitala

Faafesootai matou

Faifaʻailoga ua faailogaina i se * e manaʻomia

Oracle 11 g PL SQL Developer

Oracle 11 g PL Lapataʻi aʻoaʻoga a le Developer Training & Tusi Faamaonia

lagona

Tagata o loʻo faʻalogo ma faʻamuamua

Taʻiala o le Vasega

Faamatalaga & Totogifuapauina

faʻamaoniga

Oracle 11 g PL Laʻasaga Aʻoaʻoga Faʻapitoa a le Faufautua o aʻoaʻoga a le SQL

PL / SQL o se tuufaatasiga o le SQL faatasi ai ma tulaga o taualumaga o gagana amata. Na atiina ae e le Oracle Corporation i le amataga o le 90 e faʻaleleia ai le mafai gafatia o le SQL.PL/SQL (Language Procedural Language / Structured Query Language) o le faʻalauteleina o le faʻalauteleina o le faʻalauteleina o le tulafono mo le SQL ma le Oracle database database. PL / SQL o loʻo maua i le Oracle Database

Faamoemoe o Oracle 11 g PL SQL Developer Training

A maeʻa lenei lesona, e tatau ona e:

  • Faamatala mea faavae o le PL / SQL Programming language
  • Tusi ma faʻatalama polokalama PL / SQL i le SQL * Plus
  • Faʻaaogaina PL / SQL faʻamaumauga o le liua
  • Faʻaalia le gaioiga e ala i polokalame PL / SQL
  • Faʻasaoina amio i totonu ole polokalame PL / SQL
  • Debug PL / SQL polokalama

Tagata faʻapitoa e manaʻomia mo Oracle 11 g PL SQL Developer course

O lenei aʻoaʻoga ua mamanuina mo Polokalame Tau Polokalame, o loʻo naunau e aʻoaʻoina le gagana PL / SQL Programming Language i ni laasaga faigofie ma faigofie. O lenei aʻoaʻoga o le a avatu ai ia te oe se malamalamaaga tele i le polokalame PL / SQL Programming concepts, ma a maeʻa lenei aʻoaʻoga, o le ae i ai i tulaga maualuga o tomai mai le mea e mafai ona e faʻaogaina ai oe i tulaga maualuga o le tomai.

Tulaga e manaʻomia muamuamo Oracle 11 g PL SQL Faʻatonu Faʻamaumauga

E tatau ona i ai sou malamalamaaga autu o polokalama manatu autu e pei o le database, code source, tusitala o tusitusiga ma le faatinoga o polokalama, ma isi. Afai ua uma ona e malamalama i luga o le SQL ma isi gagana polokalama komepiuta, o le a avea ma se avanoa faaopoopo e faʻaauau.

Taʻiala o le Taimi Taimi: 3 Days

  1. Folasaga i PL / SQL
  • Faailoa mai aoga o polokalame ole PL / SQL
  • Aotelega o ituaiga o poloka PL / SQL
  • Fausia se Faʻamatalaga Faalilolilo Faalilolilo
  • E faʻapefea ona faia ni gaioiga mai se PL / SQL Block?

2. Faailoa PL / SQL Identifiers

  • Lisi ituaiga Eseese o Faʻamatalaga i totonu o se polokalame PL / SQL
  • Faʻaaogaina o le Tautinoga Vaega e Faʻamatala ai Faʻamatalaga
  • Faʻaaogā fesuiaiga e teu ai faʻamaumauga
  • Faʻamau i le Scalar Data Types
  • O le% TYPE Attributes
  • O le a le Variability Bind?
  • Faʻasologa i le PL / SQL Upu

3. Tusi Faʻamatalaga Mataʻina

  • Faʻamatala auala amata PL / Faʻamatalaga o le Faʻasologa o Faʻamaumauga SQL
  • Aoao e Faʻamatala le Tulafono
  • Faʻatinoina o Galuega Faʻatino i le PL / SQL
  • Faʻapefea ona liua ituaiga o faʻamatalaga?
  • Faamatala Faʻailoga Faʻamau
  • Faailoa Tagata Faʻatino i PL / SQL

4. Fegalegaleaiga ma le Tūmau Oracle

  • Faʻasalaga Fuaiupu FUAFUAʻI i PL / SQL
  • Toe Maua Data i PL / SQL
  • SQL Cursor concept
  • Aloese mai Agasala e ala i le faʻaaogaina o Naming Conventions i le faʻaaogaina o Toe Maua mai ma Faamatalaga DML
  • Faʻamatalaga Faʻamatalaga i le Tagata Faʻatino e faʻaaoga PL / SQL
  • Malamalama i le manatu o le SQL Cursor
  • Faʻaaogā Uiga o le Cursor SQL e Maua ai Manatu ile DML
  • Faasaoina ma Faʻasese Galuega

5. Pulea Fausaga

  • Faʻatulagaga faʻapitoa e faʻaaoga ai IF Faʻamatalaga
  • Faʻatulagaga faʻapitoa e faʻaaoga ai faʻasologa o faʻasologa
  • Faamatala faʻamatalaga faigofie
  • Faʻamatala Aʻo Lau Tala
  • Faʻamatalaga mo le faʻamalamalamaina o faʻamatalaga
  • Faʻaaogā le Faʻamatalaga Faʻaauau

6. Faʻasologa o Faʻamaumauga

  • Faaaoga PL / Faʻamaumauga SQL
  • O le% ROWTYPE Attributes
  • Faʻatumu ma Faʻafou i PL / SQL Records
  • INDEX SAUNIA E TALA
  • Iloilo le INDEX SAUNIA E LAU TALAFAASOGA
  • Faaaoga le INDEX E Lisi o Faamaumauga

7. Faʻailoga manino

  • O a Ituaiga Faʻailoga manino?
  • Faʻaalia le Cursor
  • Tatala le Cursor
  • Maua faʻamatalaga mai le Cursor
  • Kuni le Cursor
  • Puluʻu MO LE faʻapipiʻi
  • O le% NOTFOUND ma le% ROWCOUNT Attributes
  • Faamatala le FUAFUAGA FUAFUAGA MA LE MEA UA FUAFUAINA Fuaiupu

8. Faʻasalaga Manatu

  • Malamalama i Tuusaunoaga
  • Tuʻu Tuusaunoaga ma PL / SQL
  • Faʻasalaga Faʻasalalauina Faʻasalalau Tapa o Oracle Server
  • Faʻasalaga Non-Predefined Oracle Server Errors
  • Faʻasalaga Faʻasalaga Faʻamatalaina o Tagata
  • Faʻasalaga Faʻapitoa
  • RAISE_APPLICATION_ERROR Taualumaga

9. Taʻiala Faʻasaoina

  • Fausia se Faʻataʻitaʻiga Polokalame Faʻataʻitaʻi ma Layered
  • Faʻafaigofie le Atinaʻe ma le PL / Palo SQL
  • Malamalama i le Siosiomaga PL / SQL
  • Lisi le aoga o le faʻaaogaina o polokalame PL / SQL
  • Lisi le eseesega i le va o Poloka Faalilolilo ma Subprograms
  • Fatuina, Valaʻau, ma Aveese Taualumaga Faʻasaoina
  • Faʻaaogā Faataitaiga Taʻitaʻitū ma Taʻitaʻitū Metotia
  • Faʻaaliga Faamatalaga

10. Faʻamaumauga Faʻamaumauina ma le Faʻasalaga Subprograms

  • Fatuina, Valaʻau, ma Aveese se Matafaioi Faʻasoloina
  • Faailoa le lelei o le faʻaaogaina o Matafaioi Faʻasaoina
  • Faailoa laasaga e fatu ai se galuega e teuina
  • Faʻasalaga Tagata Faʻamatalaina Faʻamatalaina i Faʻamatalaga Sii
  • Tapulaa pe a valaauina Fonotaga
  • Puleaina aʻafiaga i le taimi e fai ai Fonotaga
  • Faʻaalia Faʻamatalaga Galuega
  • Faʻafefea ona faʻapipiʻi Galuega ma Taualumaga?

11. Papa

  • Lisiina o tulaga lelei o Papa
  • Faamatala Papa
  • O a vaega o se Papatusi?
  • Atiae se Papifi
  • E faʻapefea ona faʻaalia se vaega o le Package?
  • Fatuina le Faʻamatalaga o le Faʻapipiʻiga ma le Body e faʻaaoga ai le SQL CREATE Statement and SQL Developer
  • Faʻasalalau le Faʻatulagaga o Faʻamaumauga
  • Vaʻai le PL / SQL Source Code e faʻaaoga ai le Faʻamaumauga o Faʻamaumauga

12. Faʻapipiʻi Packages

  • Faʻapipiʻi Subprograms i PL / SQL
  • Faʻaaoga le STANDARD Package
  • Faaaoga Tautinoga i luma e foia ai le Faʻasalaga Taualumaga Faʻaletulafono
  • Faʻaaogā Galuega Faʻasologa i totonu o le SQL ma Taofiga
  • Faʻaauau pea o Pusa
  • Faʻaauau pea o se Pusa Faʻapipiʻi
  • Puleaina aʻafiaga o PL / SQL Subprograms
  • Faʻasalalau PL / SQL Lisi o Faamaumauga i Papa

13. Faʻaaogā Papatusi Oracle-Faʻapipiʻi i le Faʻaaogāina o Faʻamatalaga

  • O a Packaging-Provided Packages?
  • Faataʻitaʻiga o nisi o Packaging Offers packages
  • E faʻapefea ona galue le DBMS_OUTPUT Package?
  • Faʻaaogā le UTL_FILE Package e Faʻaaogāina ma Faʻamaumauga Faʻamaumauga
  • Faʻasalaga le UTL_MAIL Package
  • Tusi UTL_MAIL Subprograms

14. Faʻaolaina le SQL

  • O le Taunuuga o Galuega o le SQL
  • O le a le mea e faʻaolaina ai SQL?
  • Faʻaalia Variables Taʻilia
  • Faʻaolaina le faʻatinoina o se PL / SQL Block
  • Faʻasalalau le Faʻalauiloaina o le Faʻalauiloaina o le SQL i le Faʻatusatusaina o le PL / SQL Code
  • Faʻapefea ona faʻaaoga le DBMS_SQL Package?
  • Faʻaaogā le DBMS_SQL ma se faʻamatalaga DML Faʻataʻatia
  • Faʻatinoina o le faʻatinoga o le faʻatinoga o le faʻatinoga o le SQL

15. Fuafuaga Fuafuaga mo le PL / SQL Code

  • Faʻasalalau Faʻamaumauga ma Tuusaunoaga
  • Malamalama i Polokalame Faʻapitonuʻu
  • Tusi Gaoioiga Toto
  • Faʻaaogaina le NOCOPY Faʻataʻitaʻiga Faʻataʻatia
  • Faʻasaga le PARALLEL_ENABLE Hint
  • O le Cross-Session PL / Lafo Faʻatonu Faʻatonu a le SQL
  • FUAFUAGA FUAFUAGA ma Faʻamasinoga
  • Faʻaaogāina o le Fusi Faʻapipiʻi e Faʻaleleia ai Galuega

16. Tigā

  • Faamatala Triggers
  • Faailoa le Vaega o Mea Faʻatosina ma le Tino
  • Talosaga Pisinisi Taulaʻi mo le Faʻatinoina o Tigā
  • Fatuina Tigā TrML e faʻaaoga ai le CREATE TRIGGER Statement and SQL Developer
  • Faailoa Vaega o Mea e Tutupu ai, Tino, ma Faigatā (Taimi)
  • Eseesega i le va o Faʻamatalaga o Faʻamatalaga Faʻateleina ma Faʻasolosolo Fua Maualuga
  • Foafoaga Nai lo o le ma le faʻafitauli
  • Faʻafefea ona Pulea, Suʻe ma Aveese Triggers?

17. Fausiaina o le tuufaatasiga, DDL, ma le Faʻamatalaga Faʻamatalaga Faʻamatalaga

  • O le a le mea e faʻaosoosoina ai le faʻamau?
  • Faʻamata i le Taimi Faʻasologa-Faʻasologa o se Faʻamatalaga Faʻasologa o le Laulau
  • Malamalama i le Faʻatulagaga o le Faʻatulagaina o Fuataga mo Laulau ma Manatu
  • Faʻaaogā se Faʻamatalaga Faʻatasi e Faʻasaʻo le Faʻasalaga o le Faʻasologa o Mutuale
  • Faatusatusaga o Faʻamatalaga Faʻamatalaga i Faʻamaumauga Faʻasaoina
  • Fatuina Triggers i luga o faʻamatalaga DDL
  • Faʻatupulaia mea e tutupu i le Faʻamaumauga ma Faʻamatalaga-Faʻamatalaga Faʻamataʻu
  • Faamanuiaga o Mea e Manaomia e Puleaina ai Faʻamataga

18. PL / SQL Compiler

  • O le a le PL / SQL Compiler?
  • Faʻamatala le Faʻamatalaga Faʻatonuina mo le faʻaleleia PL / SQL
  • Lisi le fou PL / SQL Compile Time Warnings
  • Aotelega o le PL / SQL Compile Warning Time mo Subprograms
  • Lisi le aoga o lapataiga Faʻataufanua
  • Lisi le PL / SQL Compile Taimi Faʻasalalau Faʻamatalaga Mataʻitusi
  • Faʻatulagaina o Laʻasaga Faʻaaliga Lapataiga: Faʻaaogaina o le SQL Developer, PLSQL_WARNINGS Faʻamatalaga Faʻamatalaga, ma le DBMS_WARNING View Compiler Warnings: Faʻaaogaina o le SQL Developer, SQL * Plus, poʻo le Faʻamatalaga o Faʻamatalaga Faʻamatalaga

19. Puleaina Taunuuga

  • Aotelega o le Schema Object Devendencies
  • Talosaga Taʻitaʻitino Taʻitaʻitiga Faʻailoa e faʻaaoga ai le USER_DEPENDENCIES View
  • Fesili i se Sini Faʻatekono
  • Le faʻamaonia o mea faʻalagolago
  • Faʻaalia le Taʻiala Taʻitaʻitele ma le Lelei
  • Faʻamaumauga o le Faʻalagolago i le Faʻamamaina Lelei i Oracle Database 12c
  • Malamalama i le Telefoni Totogi
  • Faʻavasega se Vaega PL / SQL Polokalame

Faamolemole tusi mai ia i matou i info@itstechschool.com & faafesootaʻi i matou i + 91-9870480053 mo le tau aʻoaʻoga & tusi faamaonia tau, faʻasologa ma le nofoaga

Tuʻu mai ia i matou se Fesili

faʻamaoniga

Faʻataunuʻuga o lenei tagata aʻoga e tatau ona saunia e suʻe suʻega e lua:
Pasi Step1 O lenei Suʻega
Filifili se tasi o nei suʻega
Oracle Database SQL Expert
OR
Oracle Database 11g: SQL Fundamentals I
OR
Oracle Database 12c: SQL Fundamentals
Pasi Step2 O lenei Suʻega
Filifili se tasi o nei suʻega
Polokalama ma PL / SQL
OR
Oracle Database 11g: Polokalama ma le PL / SQLMo nisi faʻamatalaga faʻafeiloaʻi lelei i matou.


iloiloga




FUAFUAGA TUSI KOMISI

  • Oracle 11 g PL SQL Faufautua i le kolisi
  • Oracle 11 g PL FAʻAALIGA FAʻAALIGA FAʻAALIGA a le SQL Faufautua i Gurgaon
  • Inisitituti mo Oracle 11 g PL SQL Developer i le gurgaon
  • Oracle 11 g PL SQL Developer i Gurgaon
  • Oracle 11 g PL SQL Faʻapitoa le faʻamaonia i le gurgaon
  • Oracle 11 g PL SQL Developer course i Gurgaon
  • Best Oracle 11 g PL SQL Developer Training Online
  • Oracle 11 g PL SQL Faʻapitoa aʻoaʻoga