Concentrika poppy

About us
The basics

About the course
The course is intended for those who need to find out how to administer an ORACLE database, be this from the viewpoint of DBA, project manager, developer, or as support staff. Throughout the course, the training follows a pattern of firstly how and why ORACLE works as it does, followed by how to engineer changes, hands-on. Lastly, as the course moves on and the delegate acquires more skills, business based workshops are introduced. These require you to decide how the database should be built, deployed and managed, as well as drawing upon the hands-on skills needed to effect an actual outcome based on your decisions.


Please note the course is a general DBA course. Should you require training in more detail in any aspect of Oracle DBA, we are able to provide you with dedicated training in specialist areas such as backup and recovery, database security, performance management, and networking databases.


Audience

  • Progression path to specialist Oracle DBA
  • First and second line support
  • Oracle developers wishing to know more about the underlying RDBMS
  • Those seeking an introduction to Oracle DBA


Prequisites
Delegates must be familiar with Oracle. This is essential. Ideally you should have received the introductory course and had some months direct experience with Oracle in the workplace subsequently. There is a great deal of information to take in over the time we are together and the pace of the course is necessarily brisk. The more previous Oracle experience you have had, the more you will get out of the course. If you have used Oracle SQL for some time and are familiar with the terminology used by Oracle specialists, you will be able to take this course in your stride.


Duration 3 days
1. Introducing database administration
Responsibilities of a DBA
Elements of an RDBMS
Client server considerations
Database administrative tools
Enterprise Manager		 4. Tablespaces
ORACLE Optimal Flexible Architecture (OFA)
Storage strategies
Managing the tablespace system object
Moving a tablespace
Monitoring tablespace growth
Oracle managed datafiles (OMF)
Logical organisation within datafiles
Rollback segments (supported, but deprecated at Oracle 9i)		 7. Problems with data storage
Fragmentation of blocks and extents
Deleted rows fail to release space
Chained rows
List partitioning
Constraints
External tables
2. Installing Oracle 5. Creating a database
Instance management
Components of a database
Creating and deleting a database
Startup and shutdown
Loading the catalogue
Easy database creation using OMF
System parameters
Alter system, alter database, alter session
Database i/o control
Multiple block sizes 		8. Users and Security
User management strategies
Managing the user object
Limiting consumption of resources
- user profiles
- resource management
Managing security
permission and privilege
roles
trusted login to ORACLE
operating system privileges OSOPER, OSDBA
The audit subsystem
Fine grained auditing
Labels and the virtual private database
3. The System Global Area and Background Processes
Memory structures
Background processes
Data dictionary
Oracle 9i data dictionary specifics		 6. Localised resilience mechanisms
Undo management
Flashback query
Resumable space management
Resource management
Oracle streams
Advanced replication		  
Courses
schedule
Contact us