Oracle Database 23ai: Administration Workshop
This course is targeted at Database Administrators and begins with explaining the architecture of an Oracle Database instance and the tools used to access it. The course includes creating and managing a database, configuring and managing Oracle Net Services along with creating and administering pluggable databases (PDBs). You learn how to create and manage database storage, users, backup, and implement database security. Additionally, the course covers protection of database against failures, loading, and transporting data.
Versions supported: 23ai, 21c, 19c
«Very professional instructor. Kind, great at explaining intricate details and always took time to make sure we were with him.»
In this course you will learn to:
- Describe Oracle Database architecture
- Configure the database to support your applications
- Manage database security and implement auditing
- Implement basic backup and recovery procedures
- Move data between databases and files
- Employ basic monitoring procedures and manage performance
About the instructor Cuneyt Yilmaz
Cuneyt is working as senior instructor and consultant with specialty in Analytics, Business Intelligence, Data Management and Performance Tuning. He is a certified trainer for Microsoft and Oracle, and he also delivers training on MongoDB and PostgreSQL.
Cuneyt is based in Istanbul but has been working with customers in 35 countries across the Nordics and EMEA over the last 15 years. He combines top technology skills with his kindness and strong pedagogical skills. We dare to say, nobody leaves Cuneyt`s classroom disappointed!
Audience:
Prerequisites:
A working knowledge of SQL is very helpful in the course. Suggested courses that will help you gain this knowledge:
Course topics
1. Introduction to Oracle Database
2. Accessing an Oracle Database
3. Creating an Oracle Database by Using DBCA
4. Creating an Oracle Database by Using SQL Command
5. Starting Up and Shutting Down a Database
6. Managing Database Instances
7. Oracle Net Services: Overview
8. Configuring Naming Methods
9. Configuring and Administering the Listener
10. Configuring a Shared Server Architecture
11. Configuring Oracle Connection Manager
12. Creating PDBS from Seed
13. Using Other Techniques to Create PDBs
14. Managing PDBs
15. Database Storage Overview
16. Creating and Managing Tablespaces
17. Improving Space Usage
18. Managind Undo Data
19. Creating and Managing User Accounts
20. Configuring Privilege and Role Authorization
21. Configuring User Resource Limits
22. Implementing Oracle Database Auditing
23. Introduction to Loading and Transporting Data
24. Loading Data
25. Transporting Data
26. Using External Tables to Load and Transport Data
27. Automated Maintenance Tasks: Overview
28. Automated Maintenance Tasks: Managing Tasks and Windows
29. Database Monitoring and Tuning Performance Overview
30. Monitoring Database Performance
31. Database Processes
32. Managing Memory
