homKev Kawm hauv Chav Kawm
Sau npe

oracle database 11g

Oracle Database 11g: Kev Rhiav Kev Tshawb Xyuas Kuv Txoj Kev Kawm Tshaj & Ntawv Tshaj Tawm

Txheej txheem cej luam

Suab Seev & Seem Ua Ntej

Cov Qauv Dua

Teem & Cov Nqi

Certification

Oracle Database 11g: Kev Rhiav Kev Kawm I

No Oracle Database 11g: Kev Rhiav Kev Tshawb Fawb Kuv Tso 2 chav kawm tshawb txog cov ntsiab lus ntawm kev tswj hwm database. Tus kws qhia Oracle University instructors yuav txhawb cov ncauj lus nrog cov kev xyaum ua tes ua haujlwm uas yuav npaj koj mus rau Oracle Certified Associate exam.

Objectives

  • Nruab Oracle Daim phiaj Infrastructure
  • Nruab thiab configure Oracle Database 11g
  • Configure Oracle Net cov kev pab cuam
  • Saib xyuas thiab muab cov ntaub ntawv tso tawm
  • Tswj cov ntaub ntawv cia cov khoom
  • Tsim thiab tswj cov neeg siv nyiaj
  • Ua tau yooj yim thaub qab thiab rov qab los ntawm lub database
  • Tswj cov ntaub ntawv concurrency
  • Saib kev ua haujlwm
  • Qhia txog Oracle Database Architecture

npaj cov neeg tuaj saib

  • Database Thawj Coj
  • Java tsim tawm
  • Txhawb Kws Tshawb Fawb
  • Tus kws pab tswv yim
  • Tus Thawj Coj

yuavtsum tau kawm uantej

  • Tau txais Oracle Taw qhia rau SQL chav kawm lossis sib npaug
  • Oracle Database: Taw qhia rau SQL

Course Outline Duration: 5 Days

Tshawb nrhiav Oracle Database Architecture

  • Oracle Database Architecture Txheej txheem cej luam
  • Oracle ASM Architecture Txheej txheem cej luam
  • Txheej Txheem Kawm Ntawv
  • Nco kev teebmeem
  • Cov tswv yim zauv thiab lub cev
  • ASM cia khoom

Txhim kho koj li Oracle Software

  • Cov haujlwm ntawm ib tus Thawj Coj Ntawm Database Oracle
  • Cov Cuab Yeej Siv Los Muab Kev Tshawb Xyuas Oracle Database
  • Kev Nruab Nrab: Qhov Yuav Tsum Tau Ua
  • Oracle Universal Installer (TAU)
  • Txhim kho Oracle Grid Infrastructure
  • Txhim kho Oracle Database Software
  • Ntsiag To nruab

Tsim ib qho Oracle Database

  • Npaj lub Database
  • Siv lub DBCA los tsim Database
  • Password Management
  • Tsim Database Design Template
  • Siv lub DBCA rho tawm Database

Tswj cov Oracle Database Instance

  • Pib thiab nres cov Oracle database thiab cov khoom
  • Siv Oracle Enterprise Manager
  • Nkag tau ib lub database nrog SQLPlus
  • Hloov database installation tsis
  • Piav qhia cov theem ntawm kev pib database
  • Piav cov kev xaiv kaw database
  • Saib cov lus ceeb toom kev ceeb toom
  • Siv tau kev ua haujlwm dynamic

Tswj cov ASM Instance

  • Teem li initialization parameter ntaub ntawv rau ASM Xws li
  • Pib thiab kaw ASM zaus
  • Muab pawg ASM pab pawg

Configuring Oracle Network Ib Cheeb Tsam

  • Siv Enterprise Manager los tsim thiab kho tus Mloog
  • Enable Oracle Restart los saib xyuas tus neeg mloog
  • Siv tnsping los ntsuam xyuas Oracle Net connectivity
  • Txheeb xyuas thaum twg siv cov servers uas tau muab qhia thiab thaum twg siv cov servers siab

Tswj Kev Saib Xyuas Databases

  • Cia Cov Qauv
  • Yuav Ua Li Cas Cov Ntaub Ntawv Cov Ntaub Ntawv Cia
  • Lub zauv ntawm qhov Database Block
  • Chaw Tswj Hauv Tsev nyob hauv Tablespaces
  • Tablespaces nyob rau hauv lub Database Preconfigured
  • Kev nqis tes nrog Tablespaces
  • Oracle Managed Files (OMF)

Kev Tiv Thaiv Tus Neeg Siv Txoj Cai

  • Databases neeg siv nyiaj
  • Cov Cai Tswj Xyuas Cov Thawj Coj
  • Cov Kev Pab Cuam
  • Cov Cwj Pwm Ua Ntej
  • Xyaum Siv Cov Kev Paub

Tswj Cov Ntaub Ntawv Qhia Txog Concurrency

  • Cov Ntaub Ntawv Sib Txuas Lus
  • Enqueue Mechanism
  • Kev daws teeb meem tsis sib haum
  • Deadlocks

Tswj cov ntaub ntawv Undo

  • Cov ntaub ntawv Manipulation
  • Cov nqi thiab Undo Cov Ntaub Ntawv
  • Undo Data Versus Redo Cov Ntaub Ntawv
  • Configuring Undo Retention

Kev siv Oracle Database Auditing

  • Piav qhia txog DBA cov kev ris dej num rau kev ruaj ntseg
  • Txhawb cov txheej txheem database tshawb nrhiav
  • Qhia meej rau cov kev kuaj xyuas
  • Tshawb xyuas cov ntaub ntawv tshawb xyuas
  • Txhim kho txoj kev tshawb nrhiav

Database Txij Nkawm

  • Tswj kev optimizer txheeb cais
  • Tswj lub Chaw Ua Haujlwm Tsis Siv Neeg Ua Haujlwm Xa Tawm (AWR)
  • Siv Qhov Kev Ntsuas Database Diagnostic Saib Xyuas (ADDM)
  • Piav thiab siv cov tswv yim tawm tswv yim
  • Teem kev ceeb toom rau cov neeg ceeb toom
  • Siv cov server-generated alerts
  • Siv cov haujlwm ua haujlwm

Performance Management

  • Kev Saib Xyuas Kev Ua Zoo
  • Tswj kev nco cov khoom
  • Enabling kev tswj hwm kev tswj hwm (AMM)
  • Tsis siv neeg pauv nco Advisor
  • Siv Cov Kws Muab Kev Ntsuas
  • Kev Ntsuas Kev Ntsuas Kev Ntsuas
  • Troubleshooting thiab Tuning Views
  • Cov Khoom Uas Tsis Muaj thiab Siv Tsis Tau

Thaub qab thiab Rov Qab Pom

  • Ib feem ntawm koj txoj hauj lwm
  • Daim Ntawv Qhia Tsis Tau
  • Neeg yuam kev
  • Nkag Siab Ua Phem Rov Qab
  • Phaj ntawm Kev Rov Qab Ua Ntej
  • Siv cov Thawj Saib Xyuas MTTR
  • Media Tsis Tawm
  • Archive Sau Cov Ntaub Ntawv

Ua Database Backups

  • Them Nqi Xa Ntawv: Txheej txheem cej luam
  • Oracle Secure Backup
  • Tus neeg siv Managed Backup
  • terminology
  • Tus Thawj Saib Xyuas Rov Qab (RMAN)
  • Configuring Backup Settings
  • Txhim rau Cov Ntaub Ntawv Tswjhwm Cov Ntaub Ntawv rau Ib Daim Ntawv Faj
  • Kev saib xyuas qhov Flash Recovery Area

Ua Database Recovery

  • Qhib Database
  • Data Recovery Advisor
  • Poob Ntawm Cov Ntaub Ntawv Tswj Kav
  • Poob ntawm Txoj Cai Redo
  • Data Recovery Advisor
  • Kev Txhaum Cai
  • Sau Cov Kev Tuav Txoj Cai
  • Cov Ntaub Ntawv Tshaj Lij Rau Cov Ntaub Ntawv Raug Ntsuas

Tsiv Cov Ntaub Ntawv

  • Piav qhia txog cov txheej txheem los mus tawm cov ntaub ntawv
  • Tsim thiab siv cov khoom siv khoom
  • Siv SQL * Loader txav cov ntaub ntawv
  • Siv lwm lub rooj txav cov ntaub ntawv
  • General architecture ntawm Oracle Data Pump
  • Siv cov ntaub ntawv tso tawm thiab kev xa tawm kom txav cov ntaub ntawv

Ua Haujlwm Nrog Kev Txhawb

  • Siv tus Enterprise Manager Support Workbench
  • Ua haujlwm nrog Oracle Support
  • Teev cov kev pabcuam (SR)
  • Tswj thaj ua haujlwm

Thov sau ntawv rau peb ntawm info@itstechschool.com & hu rau peb ntawm + 91-9870480053 rau cov nqi kawm & daim ntawv teev nqi, sij hawm & qhov chaw

Tawm Peb ib qho lus nug

Rau ntau info kindly hu rau peb.


Xyuas