曙海教育集团
全国报名免费热线:4008699035 微信:shuhaipeixun
或15921673576(微信同号) QQ:1299983702
首页 课程表 在线聊 报名 讲师 品牌 QQ聊 活动 就业
   班.级.规.模.及.环.境--热.线:4008699035 手.机:15921673576( 微.信.同.号)
       坚持小班授课,为保证培训效果,增加互动环节,每期人数限3到5人。
   上.课.时.间.和.地.点
上课地点:【上海】:同济大学(沪西)/新城金郡商务楼(11号线白银路站) 【深圳分部】:电影大厦(地铁一号线大剧院站)/深圳大学成教院 【北京分部】:北京中山学院/福鑫大楼 【南京分部】:金港大厦(和燕路) 【武汉分部】:佳源大厦(高新二路) 【成都分部】:领馆区1号(中和大道) 【沈阳分部】:沈阳理工大学/六宅臻品 【郑州分部】:郑州大学/锦华大厦 【石家庄分部】:河北科技大学/瑞景大厦 【广州分部】:广粮大厦 【西安分部】:协同大厦
最近开课时间(周末班/连续班/晚班):即将开课,详情请咨询客服!
   实.验.设.备
     ☆资深工程师授课
        
        ☆注重质量 ☆边讲边练

        ☆合格学员免费推荐工作
        ★实.验.设.备请点击这儿查看★
   质.量.保.障

        1、免费重修;
        2、课程结束后,授课老师留联系方式,保障培训效果,免费技术支持。
        3、推荐机会。

课程大纲
 
  • Oracle 10g: Administration II培训
    Oracle 10g: Administration II培训
    培训大纲:
    1. Using Flashback Technology in Oracle 10g
    Situations that are suited to the use of Flashback Database
    Execute a Flashback Database operation
    Enable Flashback features and perform a Flashback Database operation
    Recommended steps for performing a Flashback Table operation in a given scenario
    Appropriate Flashback Query feature to be used for given scenarios
    Use Flashback features to audit and fix tables
    Use the Recycle Bin to perform a Flashback Drop operation and to purge items
    Suitable uses of appropriate Flashback features for given scenarios
    2. Performing and Managing Backups in Oracle 10g
    Characteristics of an example RMAN command
    Use the RMAN command line to create basic backups
    Implement a suitable backup strategy in a given scenario
    Use appropriate commands to manage backups in RMAN
    Use RMAN commands to create and manage backups
    3. Advanced Database Recovery and Repair in Oracle 10g
    Steps to recover non-critical files
    Perform a suitable incomplete recovery in a given scenario
    Perform an appropriate incomplete recovery and recoveries of non-critical files in a given scenario
    Appropriate detection method for database corruption scenarios
    Appropriate steps and their associated procedures for using DBMS_REPAIR
    Use the BLOCKRECOVER command to restore data blocks
    Implement an appropriate recovery strategy for database corruption
    4. Controlling the Oracle Listener and Enabling Distributed Transactions in Oracle 10g
    Set the listener password and specify who can access a database
    Improve the security for external procedures
    Tighten security for the Oracle 10g listener
    Use Net Services to connect to a database
    Create database links and view information about them
    Situations when manual resolution of distributed transactions is required
    Use database links and transactions
    5. Using Globalization Support in Oracle 10g
    How Oracle''s architecture supports globalization features
    Appropriate NLS parameter to use in a given scenario
    Specify character sets and use appropriate datatypes to standardize timestamps across time zones
    Appropriate methods for implementing a globalization solution for a given database
    Use the appropriate method for configuring linguistic sorting in a given scenario
    Determine suitable methods for implementing linguistic comparisons and case-insensitive searches, and distinguish between methods to display linguistic settings
    Use the appropriate methods to utilize linguistic support in a given scenario
    6. Optimizing Database Performance in Oracle 10g
    View and configure alerts
    Situations when trace files and SQL tracing are useful
    Use Oracle Database 10g diagnostic tools to resolve database problems in a given scenario
    Situations to run ADDM
    When to use the SQL Tuning Advisor and Access Advisor
    Use the Segment Advisor and Undo Advisor to implement appropriate space management settings
    Use appropriate Oracle advisor tools in given scenarios
    7. Managing Storage and System Resources in Oracle 10g
    Components of the Automatic Storage Management architecture in Oracle Database 10g
    Processes associated with ASM instance administration, startup, and shutdown
    Create and manage disk group
    Create a disk group and add a disk in a given scenario
    Create a basic database resource plan
    Suitable Resource Manager configuration options to use in given scenarios
    Create and implement a resource management plan
    8. Using the Scheduler to Automate Tasks in Oracle 10g
    Components of the Oracle Database 10g Scheduler and the SQL used to assign privileges to them
    Create jobs, programs, and schedules in Oracle Database 10g
    Create job classes, windows, and job priorities in Oracle Database 10g
    Create a job, job class, and window in Oracle Database 10g Enterprise Manager in a given scenario
    Use the GUI and code-based tools to manage Scheduler components in Oracle Database 10g
    View information about jobs and purge jobs in Oracle Database 10g
    Use the appropriate tools in Enterprise Manager to drop a job, change Scheduler attributes, and view job details in a given scenario
    9. Using Advanced Features in Oracle 10g
    Steps required to use the resumable statements feature
    Create an external table
    Create and configure materialized views
    Enable resumable statements and create external tables and materialized views
     
     
     

  •  

  •  

  •  
     
     
     

  •  
     



 
 



 



 


 


 


 
 



 
 



 


 


 


 
   


 



 
 



 


 













 

 

 

友情链接:Cadence培训 ICEPAK培训 EMC培训 电磁兼容培训 sas容培训 罗克韦尔PLC培训 欧姆龙PLC培训 PLC培训 三菱PLC培训 西门子PLC培训 dcs培训 横河dcs培训 艾默生培训 robot CAD培训 eplan培训 dcs培训 电路板设计培训 浙大dcs培训 PCB设计培训 adams培训 fluent培训系列课程 培训机构课程短期培训系列课程培训机构 长期课程列表实践课程高级课程学校培训机构周末班培训 南京 NS3培训 OpenGL培训 FPGA培训 PCIE培训 MTK培训 Cortex训 Arduino培训 单片机培训 EMC培训 信号完整性培训 电源设计培训 电机控制培训 LabVIEW培训 OPENCV培训 集成电路培训 UVM验证培训 VxWorks培训 CST培训 PLC培训 Python培训 ANSYS培训 VB语言培训 HFSS培训 SAS培训 Ansys培训 短期培训系列课程培训机构 长期课程列表实践课程高级课程学校培训机构周末班 曙海 教育 企业 学院 培训课程 系列班 长期课程列表实践课程高级课程学校培训机构周末班 短期培训系列课程培训机构 曙海教育企业学院培训课程 系列班