ExitCertified Formation Formation de Java Solaris Red Hat IBM Symantec Siebel PeopleSoft
 
ExitCertified Formation Formation de Java Solaris Red Hat IBM Symantec Siebel PeopleSoft
 
start courses and schedules education savings it certification education solutions
recherche de formation
Faites confiance à votre formation en TI   |
Oracle University reconnaît ExitCertified comme Partenaire en formation de l’année en Amérique du Nord.

Oracle Database 11g: 2 Day DBA Release 2

Format: Formation virtuelle avec formateur
Autres formats:
 
 

The goal of this course is to teach Database Administrators how to install the Oracle Database 11g software and perform the tasks required to manage an Oracle database. Enterprise Manager is used throughout to teach students how to quickly accomplish the required task. Emphasis is on the self-managing capabilities and automatic features of Oracle Database 11g. This course is targeted towards Database Administrators of small to medium sized businesses.

Learn To:
  • Install Oracle Database 11g software and create a database
  • Use Enterprise Manager Database Control to manage the database
  • Manage database storage structures and schema objects
  • Administer users and security
  • Back up and recover the Oracle database
  • Monitor the database and use the Advisors

A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.

 
 

Compétences acquises

 
  • Manage database storage structures

  • Administer users and security

  • Manage schema objects

  • Back up and recover the database

  • Monitor the database

  • Use the Advisors

 
  • Use the Support Workbench

  • Manage the Oracle Database software

  • Install Oracle Database 11g

  • Create a database

  • Use Enterprise Manager Database Control

  • Configure and manage the Oracle Network environment

Qui peut en profiter

 
  • Database Administrators

  • Support Engineer

 
  • Technical Administrator

  • Technical Consultant

 
Enroll For This Class
Enroll For This Class
Oracle DB PeopleSoft Hyperion Ce cours est donné par des formateurs certifiés Oracle.

Oracle University a nommé ExitCertified Partenaire de l’année 2011

Il y a une différence....découvrez-la.
Training Class Enrollment Ask A Question About This Training
Code: D59770GC20
Format: Formation virtuelle avec formateur
Durée: 2
Certifié par: Oracle
Frais d’inscription (CAD): 1,650$
Oracle University Awards ExitCertified the North American Partner of the Year Award for 2011
Recherchez des cours semblables
Cours connexes

Trier l'horaire par: 
Live Virtual Class  May.31 - Jun.1.2012 course register
Live Virtual Class  Jun.3 - Jun.4.2012 course register
Live Virtual Class  Jun.10 - Jun.11.2012 course register
Live Virtual Class  Jun.27 - Jun.28.2012 course register
Live Virtual Class  Jul.5 - Jul.6.2012 course register
Live Virtual Class  Jul.12 - Jul.13.2012 course register
Live Virtual Class  Jul.19 - Jul.20.2012 course register
Live Virtual Class  Aug.2 - Aug.3.2012 course register
Live Virtual Class  Aug.5 - Aug.6.2012 course register
Live Virtual Class  Aug.16 - Aug.17.2012 course register
Live Virtual Class  Sep.6 - Sep.7.2012 course register
Live Virtual Class  Oct.3 - Oct.4.2012 course register
Live Virtual Class  Oct.11 - Oct.12.2012 course register
Live Virtual Class  Oct.28 - Oct.29.2012 course register
Live Virtual Class  Oct.30 - Oct.31.2012 course register
Live Virtual Class  Dec.19 - Dec.20.2012 course register
16 Dates Offered      
   
demander une autre date/un autre emplacement demander de la formation sur place
 

Oracle Database 11g: 2 Day DBA Release 2 Contenu détaillé

 
 
Overview of Oracle Database Administration
  • Structure of a Relational Database
  • SQL
  • Components of an Oracle Instance and Database
  • Basic Tasks of an Oracle DBA
  • Tools Used to Administer an Oracle Database
Installing Oracle Database and Creating the Database
  • Using the Oracle Universal Installer to Install the Oracle Database Software
  • Using DBCA to Create a Database
  • Using DBCA to Manage Templates
Using Oracle Enterprise Manager Database Control and SQL*Plus
  • Overview of Administering the Database Using Enterprise Manager
  • Starting the Enterprise Manager Console Process
  • Granting Enterprise Manager Administrative Privileges
  • Setting Enterprise Manager Preferred Credentials
  • Using SQL*Plus to Access Your Database
Configuring the Oracle Network Environment
  • Tools for Configuring and Managing the Oracle Network
  • Using the Enterprise Manager Net Services Administration Page
  • Managing the Oracle Net Listener with Enterprise Manager
  • Using the Listener Control Utility
  • Oracle Net Naming Methods
  • Using Enterprise Manager to Configure Local Naming
  • Using Oracle Net Manager to Configure Local Naming
Managing the Oracle Instance
  • Oracle Instance Management
  • Starting the Instance and Opening the Database
  • Viewing and Modifying Initialization Parameters
  • Managing Memory Components
  • Viewing the Alert Log
Managing Database Storage Structures
  • Oracle Database Structures
  • Multiplexing the Redo Log
  • Enlarging the Database
  • Creating, Modifying, and Dropping Tablespaces
  • Reclaiming Space in Your Tablespace
  • Managing Undo Data
  • Using the Undo Advisor to Compute the Minimum Undo Tablespace Size
 
Administering Users and Security
  • Overview of Users and Security
  • Creating, Modifying, and Dropping Users
  • Unlocking a User Account and Resetting the Password
  • Setting the Password Policy
  • Administering Privileges and Roles
Managing Schema Objects
  • Creating, Modifying, and Dropping Tables
  • Understanding Data Integrity and Defining Constraints
  • Viewing the Contents of a Table
  • Creating and Dropping Indexes
  • Managing Views
  • Managing Program Code Stored in the Database
  • Managing Access to Schema Objects
  • Loading Data
Performing Backup and Recovery
  • Backup, Restore, and Recovery Concepts
  • Configuring the Database for Backup and Recovery
  • Configuring Backup Settings
  • Backing Up the Database
  • Using the Oracle-Suggested Backup Strategy
  • Performing Backup Maintenance Tasks
  • Using Oracle Advised Recovery to Recover the Database
  • Performing Flashback Table and Flashback Drop
Monitoring the Database and Using the Advisors
  • Monitoring General Database State, Workload, and Performance
  • Setting Metric Thresholds
  • Setting Up Direct Alert Notification
  • Viewing ADDM Performance Analysis and Responding to Findings
  • Using the SQL Tuning and SQL Access Advisors
  • Configuring the Automatic SQL Tuning Advisor
  • Viewing Automatic SQL Tuning Results
Investigating, Reporting, and Resolving Problems
  • Using the Enterprise Manager Support Workbench
  • Workflow for Investigating, Reporting, and Resolving a Problem
  • Performing the Tasks to Investigate and Report a Critical Error
Managing Oracle Database Software
  • Understanding Software Management and Patch Releases
  • Patching Oracle Database Software
  • Using the Database Upgrade Assistant to Upgrade the Database


  ExitCertified is your Authorized IT Training Partner  
  Lorsque vous suivez un cours certifié chez ExitCertified, vous apprenez directement des concepteurs des produits que vous utilisez. Notre engagement envers la communauté des TI, de même que notre autorisation à offrir des cours certifiés, vous assurent une expérience de formation supérieure. Il y a une différence. Apprenez directement de la source.

Il y a une différence. Apprenez directement de la source.
 
Training Contacts  
   
Canada United States

Formation à Montréal :: 514.876.1666
Formation à Ville de Québec :: 514.876.1666
Formation à Ottawa :: 613.232.3948
Formation à Toronto :: 416.487.3948

Formation à Vancouver :: 604.633.3948
Formation à Victoria :: 1.866.328.3948
Formation à Calgary :: 403.291.2855
Formation à Edmonton :: 780.441.3948
Formation à Regina :: 1.866.328.3948

Formation à Sacramento :: 916.669.3970
Formation à San Francisco :: 415.975.3948
Formation à San Jose :: 408.288.3948
Formation à Las Vegas :: 1.800.803.3948
Formation à Phoenix :: 602.889.9350
À travers le monde - 613.232.3948 Des questions?
Il nous fait plaisir de vous aider. Transmettez-nous ce formulaire par courriel et nous vous répondrons dans les plus brefs délais.
   



(c) 2012 ExitCertified Corp. Tous droits réservés.


ExitCertified est un fournisseur international agréé de formation en technologies. Voici quelques-uns de nos cours les plus souvent consultés :
 
Formation Sun Formation Oracle Formation Symantec Formation IBM Formation Red Hat :: Linux
Formation Java, Cours J2EE, Formation JSP, servlets, EJB, Struts, réseaux, Formation Solaris, Java Composite Application Platform (JCAPS), SeeBeyond, XML, Formation Solaris 10, certification Java, certification Solaris Cours PeopleSoft, 11g, Formation Oracle SQL, Oracle PL/SQL, DBA, Hyperion, Fusion Middleware, 10g, 9i, certification 11g, certification DBA, certification Oracle Formation NetBackup, Cours Veritas, protection contre les virus, sécurité des TI, certification Symantec DB2, OS/400, Formation zSeries, s/390, iSeries, AIX SUSE, Formation RedHat
         
Formation MySQL Formation Apple Formation en gestion de projet    
Base de données MySQL Cours Apple, Formation Leopard Formation du PMI