What is Oracle's DBA Training
Training - ORACLE database administration
You are here: Start> Seminars> Oracle Administration
- Live online or presence
- 4REAL4REAL © stands for a new generation of advanced training: heterogeneous and customizable training for a sustainable transfer of learning into the work environment.
After the "ORACLE database administration" seminar, you will know the structure of an ORACLE database system and know how to install, manage and analyze it using the tools available. The seminar is a good basis for daily work as a DBA.
Our learning platform LearningHub @Cegos is part of this face-to-face seminar. In addition to the digital seminar documents, the training is enriched with additional learning formats and media. In order to achieve a sustainable transfer of knowledge in everyday work, the seminar is implemented according to our 4REAL process model.
This seminar is part of the ORACLE DBA qualification plan.
Who should attend:
The "ORACLE database administration" training course is aimed at prospective database administrators as well as application developers, system administrators and consultants who take on tasks in the DBA area.
The "ORACLE database administration" training requires basic knowledge of relational databases, preferably ORACLE, as well as knowledge of SQL in accordance with sem. 4051 ORACLE and SQL.
- Definitions of terms
- Logical and physical structure
- ORACLE installation
- What's new in current versions
- ORACLE process structure
- Data Dictionary and Data Dictionary Views
- Globalization support
- Manually or via the DBCA (database configuration assistant)
- Administration of an instance
- Initialization parameters and SPFILE
- Starting and stopping an instance
- Management of control files, redolog files
- Storage structures: block, extent, segment, tablespace
- Creation and administration of big file and small file tablespaces
- Undo management
- Fast recovery area
- User administration and schema concept
- Allocation of system and object privileges
- The role concept
- User profiles
- Password encryption and password files
Backup and recovery:
- Backup and recovery strategies
- Flashback Database
- Flashback table
- SQL * Net
- Setting up the client and server
- Connection establishment
Tips and Tricks:
- Performance problems
- Storage problems
- Network problems
- Connection of databases in the cloud
- SQL * Plus
- SQL Developer
- SQL * loader
- Data Pump Export / Import
Lecture, demonstrations on the system and discussion. You can use your own exercise database to try out and consolidate what you have learned in practical exercises.
The current ORACLE version is used.
- From Jun 21 to Jun 25, 2021
- From 26 Jul to 30 Jul 2021
- From 26 Jul to 30 Jul 2021Integrata Cegos GmbH MunichLuitpoldstrasse 3, 1st floor (Elisenhof)
- From 16 Aug to 20 Aug 2021Integrata Cegos GmbH Hamburg
- From 06 Sep to 10 Sep 2021
- From 06 Sep to 10 Sep 2021Integrata Cegos GmbH MunichLuitpoldstrasse 3, 1st floor (Elisenhof)
- From 04 Oct to 08 Oct 2021Integrata Cegos GmbH Frankfurt
- From Oct 25 to Oct 29, 2021
- From Oct 25 to Oct 29, 2021Integrata Cegos GmbH Düsseldorf
- From 06 Dec to 10 Dec 2021Integrata Cegos GmbH Stuttgart
Save time and money with Integrata's in-house seminars
You can also book all seminars from our open offer as in-house events. The focus is on your company and your employees. We offer you the opportunity to make individual requirements and adapt the content to your company.
The individual solution:
- - Individual appointment
- - Individual location, either in our training centers or on your own premises
- - Upon request, individual content tailored to your needs
The in-house package includes:
- - Implementation as live online, hybrid or face-to-face training
- - The implementation by field-tested and industry-experienced trainers
Additional costs may apply depending on the number of participants, accreditation or license fees. The price does not include, for example, room and entertainment costs, as well as additional costs for seminar materials.
Please do not hesitate to contact us and let us create your individual offer now.
Receive the program by email
The seminar program was further developed
You have chosen a date from the year, the seminar program has been further developed since then. Do you want to:
Consult the program of this training in or continue your booking
There are no additional delivery and shipping costs
- What do technical and scientific texts mean
- Which billionaires use Android phones
- What does isha mean in Japanese
- How did your journey to filmmaking begin
- What is technology integration in the website
- Consciousness is a requirement for consciousness
- Can I take Mucinex with Delsyn?
- Which 2020 candidates speak Spanish
- What's the best about Manali
- Have you read the Mueller report?
- How can tutors give instant lessons
- What is faster Intel or PowerPC
- Which natural phenomena can predict future events?
- What is Keyword Density in SEO
- How does the dating change after 70
- How much is the population of Ahmedabad
- Can I leave Wipro after training?
- How is CSE at PES University
- Which hereditary disease can cause irreversible harm
- Judy Garland was an alto
- Why do water bottle rockets fly
- What's your breakup song 1
- Why is strongman training not more popular
- How do I invest money in Litecoin