تفاصيل الدورة

The overall objective of this course is to allow the student to gain the skills necessary for day-today administration of an Oracle database. This course is the starting point for Oracle database administrators and also sets the foundation for advanced administrator training and certification. Major tasks to be considered within this course are:

  • Software installation and the creation of new databases.
  • An in-depth exploration of the database architecture, including memory, process and data structures, and the management of those structures.
  • Management of database files.
  • Specialized facilities intended to maximize performance of enterprise-scale transactional applications, such as the shared SQL and PL/SQL cache, the result cache, the database buffer cache, and other similar components.
  • Management of security policies and procedures, including administration of user accounts, roles, privileges and profiles.
  • Utilization of advanced self-tuning and self-management capabilities, including the use of Oracle-Managed Files, database Advisors and other components of the Management Framework.
  • Performance monitoring, problem troubleshooting, and resolving lock and conflict issues.
  • Using the Oracle Enterprise Manager and SQL interfaces for administration tasks.
  • Control over database support services, including the Database Control, Oracle Net and others.
  • A primer on backup and recovery structures and strategies.
  • Operating system-specific considerations for various platforms, especially Linux and MS Windows Server.
Prerequisites:
Many students taking this course have familiarity with system administration and administration of other non-Oracle databases, and this is helpful though not mandatory. Specific course prerequisites for this course are:
  • ORACLE DATABASE 11G: SQL FUNDAMENTALS – COMPLETE LIBRARY
  • ORACLE DATABASE 11G: PROGRAM WITH PL/SQL – COMPLETE LIBRARY
Enterprise Edition Installation:
  • Identify System Requirements
  • The Optimal Flexible Architecture (Ofa) 
  • Oracle_Base
  • Oracle_Home
  • Configure The Installation Environment
  • Enterprise Edition Installation
  • Dbca
The Administrator Interface :
  • Enterprise Manager Tour
  • Using Em Sql Worksheet
  • Duties Of A Database Administrator
  • Exploring The Oracle Database Architecture: General
The Oracle Enterprise Architecture:
Exploring The Oracle Database Architecture: Instance Memory :
  • What Is An Oracle Database Instance?
  • More About The System Global Area (Sga)
  • About The Pga
  • Managing Memory
Exploring The Oracle Database Architecture: Instance Processes:
  • Instance Background Processes
  • Sql Execution Processes
Creating An Oracle Database:
  • Create A New Database
  • Configure An Existing Database
  • Drop A Database
  • Manage Dbca Templates
  • Manually Create A Database
Managing The Database Instance :
  • Configuring A Linux Environment
  • Starting & Stopping Database Control
  • Starting & Stopping The Database Listener
  • Starting & Stopping The Database Instance
  • More About The Database Files
Manage Database Storage Structures: Tablespaces:
  • About Tablespaces
  • Tablespace Management
  • Drop Tablespace
  • Alter Tablespace
Manage Database Storage Structures: Advanced Tablespaces:
  • More About Temporary Tablespaces
  • About Temporary Tablespace Groups
  • More About Permanent Tablespaces
  • More About Bigfile Tablespaces
  • More About The Sysaux Tablespace
Manage Database Storage Structures:
  • Data Files & Temp Files
  • Managing Data Files
  • Managing Temp Files
  • Enable Oracle-Managed Files (Omf)
Managing Undo Data:
  • About Undo Space Management
  • Configure Automatic Undo Management 
  • Undo_Management
  • Undo_Tablespace
  • Undo_Retention
  • Guarantee Undo Retention
  • Monitor Undo Space
  • Use The Undo Advisor
Network Environment: Oracle Shared Servers:
  • Shared Servers Architecture
  • Configure Shared Servers
  • Monitor Shared Servers
  • V$Shared_Server
  • V$Shared_Server_Monitor
  • V$Session
  • V$Circuit
  • V$Dispatcher & V$Dispatcher_Config
  • V$Queue
Security: Implementing Database Security :
  • Database System Privileges
  • Database Object Privileges
  • Administrator Auditing Of Database Activity
  • Enhanced Default Security Settings
Security: Administering User Security :
  • Create & Manage Database Accounts
  • Grant & Revoke Database Privileges
  • Resource Limits Via Profiles
  • Alter Profile
  • Drop Profile
  • Password Management Via Profiles
  • About Role-Based Security
  • With Admin Option
  • Alter User...Default Role
  • Set Role
  • Enhanced Default Security Settings
Moving Data: Sql Loader:
  • Loader Concepts
  • Control File Options
  • Load Methods
  • Using The Em Interface
Moving Data: Export & Import:
  • Manage Directory Objects
  • About The Data Pump Architecture
  • Data Pump Export
  • Data Pump Import
  • Data Pump Data Dictionary Views
  • Using The Em Interface
Database Maintenance & Performance Management:
  • The Management & Advisory Framework
  • Manage The Automatic Workload Repository
  • Automatic Database Diagnostic Monitor
  • Use Metrics & Alert Thresholds
  • Automatic Maintenance Tasks
Managing Concurrency & Locks:
  • About Latches & Locks
  • Manage & Monitor Latches
  • Manage & Monitor Locks
  • V$Lock
  • V$Locked_Object
  • V$Session
  • V$Session_Wait
  • Dba_Blockers & Dba_Waiters
  • Dba_Dml_Locks & Dba_Ddl_Locks
  • Dml_Locks
Backup & Recovery Concepts & Configuration :
  • About Database Backup & Recovery Structures
  • Managing Redo Data
تحديث بتاريخ 08 November, 2015

نبذة عن معهد Professional Training Solutions Ltd

Professional Training is a group of experienced specialists providing specific training and consultancy solutions, within Management Skills, I.T. systems, Human Restheirce Development, Credit Management, Sales, Finance and Engineering.
they believe in using a combination of tailored, flexible approaches and real-life business knowledge to develop and provide techniques and solutions for immediate implementation.
their recent projects include supporting major initiatives for clients in utilities, telecoms, manufacturing and software, covering:
restructuring for competitiveness
productivity improvements through updating work processes to match new technology
managing outstheircing
strategic financial planning and engineering
their methodology is to:
Work closely with clients to understand and help them prioritise their needs
Design and deliver the best mix of training activities and consultancy to establish the competencies required
Provide ongoing coaching to sustain the improved practices and processes
they create relevant, targeted, enjoyable, and interactive, training sessions which are designed to improve the retention of information by participants and create a clear link from the training to the workplace. This creates a planned, visible improvement in key business indicators such as productivity, motivation, loyalty, employee retention, and ultimately, profit.
their collaborative approach builds long-term relationships with clients. Together, they can deal effectively with the inevitable challenges all businesses face.
عرض الجميع دورات Professional Training Solutions Ltd
Are you from Professional Training Solutions Ltd ? Claim your course!
دورات يمكنك الالتحاق بها على الفور... خذ دورة عبر الإنترنت على Oracle ابتداءً من الآن. See all courses

هل هذه الدورة التدريبية الاختيار المناسب لك؟

قيِم هذه الصفحة

لم تجد ما كنت تبحث عنه؟

أو