Oracle Database 23ai: Administration Workshop
Код курса
D1106070GC10
Продолжительность
5 Дней, 40 Ак. Часов
Описание курса
Цели
Требования
Программа курса
Описание курса
This course is targeted at Database Administratorsand 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.
Цели
Objectives
- Configure Listener and Explain Oracle Database Naming Methods: Understand and implement Oracle Net services and listener configurations.
- Create and Manage Tablespaces: Learn to handle tablespace creation, maintenance, and management.
- Create and Manage PDBs: Understand the procedures for provisioning, cloning, and managing pluggable databases.
- Create and Manage a Database and Optimize UNDO Tablespace: Establish a database setup and optimize the usage of the undo tablespace.
- Determine Audit Requirements and Create Audit Policies: Implement comprehensive auditing strategies to ensure database security and compliance.
- Configure and Manage Automated Maintenance Tasks: Automate routine maintenance with the Oracle Scheduler and Resource Manager.
- Monitor Database and SQL Performance: Utilize performance views, metrics, and advisors to ensure optimal database performance.
- Transport and Load Data Between Databases: Learn methods for Data Migration and integration using Data Pump and SQL*Loader.
- Perform Database Start-Up and Shutdown: Master essential operations for controlling database availability
Требования
Prerequisites
- Familiarity with Computers: Basic understanding of computer operations and software navigation.
- Basic Understanding of Databases: General knowledge of database concepts, including the ability to comprehend database schemas and data structures.
- SQL Proficiency: Basic skills in SQL query writing for interacting with databases.
- Operating System Skills: Understanding of essential operating system commands and file management operations.
- General IT Knowledge: Foundational awareness of IT practices and networking concepts.
Target Audience
- Database Administrators
- Database Architects
- IT Managers
- System Administrators
- Database Engineers
- Data Analysts
- SQL Developers
- IT Consultants
- Solution Architects
- Technical Support Engineers
- Security Administrators
- Cloud Database Administrators
- Technical Project Managers
- Data Warehouse Engineers
Программа курса
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 a SQL Command
5 Starting Up and Shutting Down a Database Instance
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 Creating PDBs from Seed
12 Using Other Techniques to Create PDBs
13 Managing PDBs
14 Database Storage Overview
15 Creating and Managing Tablespaces
16 Improving Space Usage
17 Managing Undo Data
18 Creating and Managing User Accounts
19 Configuring Privilege and Role Authorization
20 Configuring User Resource Limits
21 Implementing Oracle Database Auditing
22 Introduction to Loading and Transporting Data
23 Loading Data
24 Transporting Data
25 Using External Tables to Load and Transport Data
26 Automated Maintenance Tasks: Overview
27 Automated Maintenance Tasks: Managing Tasks and Windows
28 Database Monitoring and Tuning Performance Overview
29 Monitoring Database Performance
30 Analyzing SQL and Optimizing Access Paths
