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

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

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

课程大纲
 
  • Oracle 10g: Administration I培训
    Oracle 10g: Administration I培训
    培训大纲:
    1. Oracle Database 10g: Installing Oracle Database 10g Release 2
    Characteristics of a relational database system
    Basic tasks and tools involved in Oracle database administration
    Basic concepts involved in RDBMS and Oracle database administration
    Components involved in the Oracle preinstall process
    How to configure the Oracle Database 10g installation and Oracle install environment using the Oracle Universal Installer
    Install Oracle Database 10g on a UNIX operating system
    2. Oracle Database 10g: Creating Databases Release 2
    Files and logical storage units that make up the Oracle database
    Characteristics of the Oracle instance and its management interfaces
    Basic components of Oracle database architecture
    Configure database identification, management, password, and storage options using the Database Configuration Assistant
    Use the Database Configuration Assistant to set file locations and parameters
    Set database storage settings and creation options and delete a database using the Database Configuration Assistant
    Create an Oracle database, and delete one, using the Database Configuration Assistant
    3. Oracle Database 10g: Database Interfaces Release 2
    Ways of sending SQL commands to a database and how to start SQL*Plus and iSQL*Plus
    Use the DESCRIBE, PROMPT, and SELECT commands to work with data
    Join tables and use DML and DDL statements to manipulate and define data
    Functions of different SQL statements and the function of data locking
    Ways of sending SQL commands to a database and how to start SQL*Plus and iSQL*Plus
    Use SQL*Plus and iSQL*Plus to manage data
    Basic elements of PL/SQL and the uses of PL/SQL
    Characteristics of and how Oracle works within some common database interfaces
    4. Oracle Database 10g: Database Control and Storage Structures Release 2
    Use the Oracle Database 10g management framework
    Start up and shut down an Oracle 10g database
    Characteristics of initialization parameters and the alert log and how to view them
    Start and stop the Oracle Enterprise Manager Database Control, Oracle Listener, and Oracle Database 10g instance
    Recognize how table data is stored and create tablespaces as well as manipulate tablespaces in an Oracle database
    5. Oracle Database 10g: Users and Security Release 2
    Create user accounts and profiles, grant privileges and assign quotas to users, and create a role and assign it to a user
    Administer user accounts on an Oracle 10g database
    Restrict access to an Oracle database
    Implement database security by configuring user profiles
    Implement password security by configuring user profiles
    Monitor database activity using Oracle''s built-in audit tools
    Implement fine-grained auditing in an Oracle 10g database
    Audit database activity in an Oracle 10g database
    6. Oracle Database 10g: Managing Schema Objects and Data Release 2
    Basic features of objects in a database schema
    Create and modify tables in an Oracle 10g database
    Create, delete, and modify tables in an Oracle 10g database
    Recognize the most common index types, create indexes and views, and use sequences in an Oracle 10g database
    Work with indexes, views, and sequences in an Oracle 10g database
    Manipulate tables, views, and indexes in an Oracle 10g database
    Manage data using the INSERT, UPDATE, DELETE, COMMIT, and ROLLBACK commands
    Use Oracle''s Data Pump to export and import data
    Export and import data using Oracle''s Data Pump utility
    7. Oracle Database 10g: The SQL*Loader and PL/SQL Release 2
    Function of the SQL*Loader and the files it uses
    Load data using the SQL*Loader
    Characteristics of PL/SQL objects, functions, and procedures
    Characteristics of PL/SQL packages and triggers and the configuration options that control PL/SQL performance
    Basic concepts of PL/SQL
    8. Oracle Database 10g: Oracle Net Services and Shared Servers Release 2
    Create and configure an Oracle Net listener in Oracle Database 10g
    Monitor Oracle Net Services using the Listener Control utility
    Create and configure an Oracle Net Listener
    Configure local name resolution in a given scenario
    Configure local Oracle Net Services aliases
    Configure advanced connection options and test Oracle Net connectivity
    Oracle server connection types
    Initialization parameters used to configure Shared Server
    Monitor Shared Server
    Configure and verify Shared Server
    9. Oracle Database 10g: Monitoring and Maintenance Release 2
    Repair invalid and unusable objects
    Detect and repair unusable indexes
    Monitor performance using dynamic performance views, Enterprise Manager, and optimizer statistics
    Gather optimizer statistics for a database schema
    Set thresholds and baselines for performance metrics
    Functions of various tuning and diagnostic advisors and how to use them in a given scenario
    Manage the AWR and use the ADDM to review database performance in Oracle Database 10g
    Configure a database for proactive maintenance
    10. Oracle Database 10g: Managing Undo Data and Lock Conflicts Release 2
    Factors to take into consideration when managing undo
    Estimate required tablespace size and resize a tablespace in a given scenario
    Calculate undo tablespace sizing and resize an undo tablespace
    How locks are used to ensure concurrent user access to a database
    Manage lock conflicts
    Detect and resolve lock conflicts
    11. Oracle Database 10g: Managing Backup and Recovery Release 2
    Types of database failure that can occur in an Oracle 10g database and identify possible solutions
    Tune instance recovery and configure a database for maximum recoverability
    Multiplex the Oracle 10g redo log and archive redo log files
    Configure a database for backup and recovery
    Configure and manage database backups
    Schedule database backups and back up control files to trace
    Configure database backups
    Back up a database
    Types of media failure that can cause an instance to fail
    Recover from the loss of control files, redo log files, and datafiles
    Perform flashback recovery operations in Oracle database 10g
    Recover a database
     
     
     

  •  

  •  

  •  
     
     
     

  •  
     



 
 



 



 


 


 


 
 



 
 



 


 


 


 
   


 



 
 



 


 













 

 

 

友情链接: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培训 短期培训系列课程培训机构 长期课程列表实践课程高级课程学校培训机构周末班 曙海 教育 企业 学院 培训课程 系列班 长期课程列表实践课程高级课程学校培训机构周末班 短期培训系列课程培训机构 曙海教育企业学院培训课程 系列班