TypeHo Koetlisa Sekolo
Ngodisa

database ea oracle 11g

Oracle Database 11g: Tlhahlobo ea Tsamaiso Thupelo ea Koetliso le Litemoso

Overview

Bamameli le Litlhokahalo

Tlhahiso ea Tlhahlobo

Kemiso le Litefiso

tiiseletswe

Oracle Database 11g: Tlhahlobo ea Tsamaiso I

Ena Oracle Database 11g: Tlhahlobo ea Tsamaiso Ke lokolla thupelo ea 2 e hlahloba lits'ebeletso tsa motheo tsa tsamaiso ea basebetsi. Litsebi tsa litsebi tsa Univesithi ea Oracle li tla matlafatsa lihlooho ka matsoho a hlophisitsoeng-litloaelong tse tla u lokisetsa tlhahlobo ea Oracle Certified Associate e tšoanang.

maikemisetso

  • Kenya Infrastructure ea Oracle Grid
  • Kenya le ho lokisa Oracle Database 11g
  • Lokisa Oracle Net services
  • Hlahloba le ho fana ka litlhaloso tse fokolang
  • Laola mehaho ea polokelo ea hau
  • Etsa 'me u tsamaise akhaonto ea mosebedisi
  • Etsa tlhahiso ea motheo le ho hlaphoheloa ha dintlha
  • Laola data concurrency
  • Sheba tshebetso
  • Hlalosa Oracle Database Architecture

o ne a rerile Bamameli

  • Basebelisi ba Ditshebeletso
  • Bahlahisi ba Java
  • Moenjiniere oa ts'ehetso
  • Moeletsi oa setsebi
  • Setsebi sa Tsamaiso

batlehang

  • Ho qhekelloa Selelekela ho SQL kapa phihlelo e lekanang
  • Oracle Database: Selelekela ho SQL

Course Outline Duration: 5 Days

Ho hlahloba Oracle Database Architecture

  • Oracle Database Architecture Overview
  • Oracle ASM Architecture Ka kakaretso
  • Mekhoa ea ho sebetsa
  • Litloaelo tsa mohopolo
  • Mehaho ea polokelo ea mohlolo le ea sebele
  • ASM polokelo ea lisebelisoa

Ho kenya Oracle Software ea hau

  • Mesebetsi ea Oracle Database Administrator
  • Lisebelisoa tse sebelisoang ho laola Oracle Database
  • Kopo: Litlhoko tsa Tsamaiso
  • Oracle Universal Installer (YES)
  • Ho kenya Infrastructure ea Oracle Grid
  • Ho kenya Oracle Database Software
  • Setsi se khutsitseng

Ho theha Database ea Oracle

  • Ho hlophisa Database
  • Ho sebelisa DBCA ho Etsa Database
  • Phatlalatso ea Motlolo
  • Ho theha Setšoantšo sa Moqapi oa Boitsebiso
  • Ho sebelisa DBCA ho Tlosa Database

Ho laola Oracle Database Instance

  • Qala 'me u emise database ea Oracle le likaroloana
  • Sebelisa Mookameli oa Khoebo oa Oracle
  • Fumana boitsebiso bo nang le SQLPlus
  • Fetola maemo a tlhomamiso ea boitsebiso
  • Hlalosa mekhahlelo ea ho qaloa ha database
  • Hlalosa mekhoa ea ho thibela li-database
  • Sheba lebokose la tlhokomeliso
  • Fumana maikutlo a matle a sebetsang

Laola ea ASM Instance

  • Etsa lifaele tsa parameter tsa tlhahlobo ea ASM mohlala
  • Qala le ho koala maemo a ASM
  • Laola lihlopha tsa ASM disk

Ho lokisetsa Oracle Network Environment

  • Sebelisa Mookameli oa Khoebo ho theha le ho lokisa Ea mamelang
  • Numella Oracle Restart ho shebella ea mametseng
  • Sebelisa tnsping ho hlahloba khokahano ea Oracle Net
  • Hlalosa nako ea ho sebelisa lisebelisoa tse arolelanoeng le nako ea ho sebelisa lisebelisoa tse inehetseng

Ho laola mekhoa ea ho boloka mabitso

  • Mehaho ea ho boloka
  • Tsela ea Lethathamo la Boitsebiso e bolokiloe joang
  • Boitsebiso ba Block Database
  • Tsamaiso ea Sebaka ka Tablespaces
  • Lisebelisoa sebakeng sa Boitsebiso bo Preconfigured
  • Liketso tse nang le Tablespaces
  • Oracle Managed Files (OMF)

Ho tsamaisa Security User

  • Basebedisi ba basebetsi ba basebetsi
  • Litlaleho tse khethiloeng tsa tsamaiso
  • Melemo ea Mesebetsi
  • Mesebetsi e khethiloeng
  • Ho kenya ts'ebetsong Profiles

Ho laola Likhopotso tsa Data

  • Ditshwantsho tsa Dintlha
  • Mechine e sa Tšoaneng
  • Ho rarolla likhohlano tsa Lock
  • Li-Deadlocks

Ho Laola Lintlha tsa Boitsebiso

  • Tlhahiso ea Dintlha
  • Litlaleho le ho hlakola Dintlha
  • Fumana Boitsebiso ba Ditshebeletso le ho Fumana Boitsebiso
  • Lokisa ho Hlakola ho boloka

Ho phethahatsa Oracle Database Auditing

  • Hlalosa boikarabello ba DBA bakeng sa tšireletso
  • Etsa bonnete ba tlhahlobo ea li-database
  • Hlalosa likhetho tsa ho hlahloba
  • Tlhahlobo ea tlhahlobo ea tlhahlobo
  • Boloka boemo ba ho hlahloba

Maintenance Database

  • Laola lisebelisoa tsa optimizer
  • Laola ea Automatic Workload Repository (AWR)
  • Sebelisa Automatic Database Diagnostic Monitor (ADDM)
  • Hlalosa le ho sebelisa moralo oa boeletsi
  • Beha litebelisuoa tse falimehileng
  • Sebelisa litlhokomeliso tsa seva
  • Sebelisa mesebetsi e ikemetseng

Tsamaiso ea Tsamaiso

  • Tlhahlobo ea Ts'ebetso
  • Ho laola likarolo tsa ho hopola
  • Ho nolofalletsa Boitsebiso ba Boemo ba ho Hopola (AMM)
  • Moeletsi oa Boitsebiso ba Kemiso ka Kakaretso
  • Ho sebelisa baeletsi ba Memory
  • Lipalo-palo tsa ho Sebetsa
  • Ho rarolla mathata le Pono ea ho Finyella
  • Lintho tse sa lokelang le tse sa sebelisoeng

Likhopolo tsa ho boloka le ho khutlisa

  • Karolo ea Mosebetsi oa hau
  • Tlhahiso ea Statement
  • Phoso ea Mofuta
  • Ho utloisisa Pholoso ea Boemo
  • Mehato ea Phatlalatso ea Phato
  • Ho sebelisa Moeletsi oa MTTR
  • Ho Hlōleha ha Mecha ea litaba
  • Tlaleho ea Log Files

Ho etsa Basebeletsi Backup

  • Mekhoa ea ho boloka: Tlhaloso
  • Oracle Backup e bolokehileng
  • Backup e laoloang ke basebetsi
  • Terminology
  • Motsamaisi oa Puisano (RMAN)
  • Ho lokisetsa Lisebelisoa tsa Backup
  • Ho tšehetsa Fanelo ea Taolo ho File File
  • Ho hlahloba Sebaka sa ho Nchafatsa Flash

Ho etsa Letšoao la ho Nchafatsa

  • Ho bula Database
  • Moeletsi oa ho Fumana Boitsebiso
  • Ho Lahleheloa ke Faki ea Phatlalatso
  • Ho lahleheloa ke Inthanete ea Lefapha la Likhoebo
  • Moeletsi oa ho Fumana Boitsebiso
  • Boitsebiso bo Hlōleha
  • Dintlha tsa Lintlha li hlōleha
  • Boemo ba Lits'oants'o tsa Boithuto ba Ditshebeletso

Dintlha tsa ho falla

  • Hlalosa litsela tsa ho tsamaisa data
  • Etsa lintho tse ngotsoeng le ho li sebelisa
  • Sebelisa SQL * Loader ho tsamaisa data
  • Sebelisa litafole tse ka ntle ho tsamaisa data
  • Bohaho bo tloaelehileng ba Oracle Data Pump
  • Sebelisa Export Pump e romeloang le ho kenya ho tsamaisa data

Ho sebetsa le Ts'ehetso

  • Sebelisa Enterprise Manager Support Workbench
  • Sebetsa ka Tšehetso ea Oracle
  • Litlhoko tsa tšebeletso ea ho kena (SR)
  • Laola lipapatso

Re kopa o re ngolle info@itstechschool.com & re ikopanye le rona ka + 91-9870480053 bakeng sa theko ea theko le theko ea tiiso, kemiso le sebaka

Re Tlisetsa Potso

Bakeng sa lintlha tse ling re ikopanye ka mosa.


Reviews