Oracle Database 19c Administration (STA_O19CDBA)
Om kurset
Oracle Database 19c Administration Course Overview
This Oracle Database 19c Administration course is designed to give the Oracle database administrator practical experience in administering,monitoring,tuning and troubleshooting an Oracle database.
A database administrator will gain an understanding of the architecture and processes of the Oracle database server. The delegate will learn how to ensure the integrity and availability of a company's data within the Oracle environment. The delegate will also learn how to monitor the performance of a database,allocate resources with the Resource Manager and schedule jobs with the Oracle Job scheduler.
Similarly,the course is targeted to closely follow the official Oracle Database curriculum for certification.
Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.
Versions supported 12cR2,18c,19c.
Dette lærer du
Kursinnhold
Kurset dekker blant annet følgende temaer:
- Oracle Database 19c Administration Training Course
- Course Contents - DAY 1
- Course Introduction
- Session 1: INTRODUCTION TO ORACLE DATABASE
- Session 2: ORACLE DATABASE ARCHITECTURE
- Session 3: ADMINISTER A DATABASE INSTANCE
- Session 4: CONFIGURE THE ORACLE NETWORK ENVIRONMENT
- Session 5: STORAGE STRUCTURES
- Course Contents - DAY 2
- Session 6: MANAGE USERS
- Session 7: MANAGE PRIVILEGES
- Session 8: MANAGE PROFILES AND RESOURCES
- Session 9: DATABASE AUDITING
- Course Contents - DAY 3
- Session 10: DATA CONCURRENCY AND LOCK CONFLICTS
- Session 11: UNDO MANAGEMENT
- Session 12: BACKUP AND RECOVERY CONFIGURATION
- Session 13: PROACTIVE DATABASE MAINTENANCE
- Session 14: PERFORMANCE MANAGEMENT
- Course Contents - DAY 4
- Session 15: SQL TUNING
- Session 16: MOVING DATA
- Session 17: MANAGING RESOURCES WITH RESOURCE MANAGER
- Session 18: AUTOMATE TASKS WITH THE SCHEDULER
- Course Contents - DAY 5
- Session 19: MANAGE SPACE
- Session 20: ORACLE SUPPORT
Forkunnskaper
Hvem passer kurset for?
Videre kurs
Kursdatoer
Hvorfor velge SG Partner?
Vi gjør det enkelt å finne riktig kurs og riktig gjennomføring for deg og din virksomhet.
Offisielle kurs
Kursinnhold fra anerkjente teknologileverandører og fagmiljøer.
Erfarne instruktører
Praktisk og faglig undervisning med fokus på kompetanse du kan bruke.
Fleksibel gjennomføring
Velg mellom tilgjengelige virtuelle, fysiske og bedriftsinterne kurs.
Personlig rådgivning
Vi hjelper deg med å finne kurs og kompetanseløp som passer behovet ditt.
Ofte stilte spørsmål
Hvor lenge varer kurset?
Kursets oppgitte varighet er 5.
Kan jeg ta en sertifisering?
Kurset kan være relevant som forberedelse til sertifisering. Se kursbeskrivelsen for informasjon om aktuell sertifisering og eksamen.
Hvilke forkunnskaper trenger jeg?
Requirements Delegates who wish to attend the Oracle Database 19c Administration course should have an understanding of relational database concepts and good operating system knowledge. They should have attended the Oracle SQL course or have a good working knowledge of Oracle SQL. The ability to describe and use Oracle built-in PL/SQL packages would be highly advantageous but is not essential. This course is run on a Linux operating system,a basic knowledge of Linux/UNIX is recommended but is not essential.
Hvem passer kurset for?
Who will the Course Benefit? This Oracle Database 19c Administration course is for anyone who needs to administer,monitor and support an Oracle database.
Kan kurset leveres som bedriftsinternt kurs?
Ja.
Hvor kan kurset leveres?
Kurset kan leveres over hele Norge, blant annet i Oslo, Kristiansand, Stavanger, Bergen, Trondheim og Tromsø.