Oracle Database Administration I Training MS 1000 English
Who should attend:
Database administrators, application developers, project managers
Voraussetzungen
Prerequisites:
Basic knowledge of data processing, relational databases and SQL (MS 100)
Teilnehmeranzahl
Number of participants:
max. 10 persons
Weiterführende Kurse
follow up courses
(only available in German):
Oracle Kurs-Inhalt
Course Overview:
The course gives an overview of the basics of database administration and the most important DBA activities. It is also a good preparation for the OCP (Oracle Certified Professional).
Starting with the architecture and concepts of an Oracle Database you will learn how to install, maintain and monitor an Oracle Database.
Further topics include a detailed instruction of tablespace and user management as well as import/export and backup/recovery operations.
The theoretical background knowledge will be reinforced by lots of examples from daily practice and hands-on exercises.
The following topics will be covered:
- Architecture of the database system (DBS)
- Administration of the database instance
- Network administration (client and server)
- Initialization parameters and SPFILE
- Creation and management of control, redolog and datafiles
- Basics of memory structures (blocks, extents and segments)
- Database installation with or without the Oracle Installer
- Tablespace administration (including undo and temporary tablespace)
- Rollback/undo administration
- Managing users, profiles, privileges and roles
- Export, import, datapump
- Basics of backup & recovery:
online backup, offline backup, archiving, recovery - New features in Oracle Database 11g
Schulungsinhalte
Gerne senden wir Ihnen auf Anfrage die detaillierten Schulungsinhalte. Ansprechpartnerin:
Renate Hülß
