مروری بر دوره
طراحی دوره Oracle Database 19c: Administration Workshop به گونه ای انجام شده است دانش و مهارت های شما در زمینه نحوه مدیریت پایگاه داده Oracle را به بهترین شکل ممکن پایه ریزی کند. شناخت صحیح مفاهیم و اصول معماری پایگاه داده Oracle به شما کمک خواهد نمود که چگونه یک پایگاه داده Oracle را به شیوه ای موثر و کارآمد مدیریت کنید.
.
سرفصل ها
Oracle Database 19c: Administration Workshop
1: Introduction to Oracle Database
Database Server Architecture
Course Practice Environment: Security Credentials
2: Accessing an Oracle Database
Accessing an Oracle Database
Demonstration: Usage of general DBCA Tools to Interact with Database
3: Creating an Oracle Database by Using DBCA
Creating a Database Using DBCA
4: Creating an Oracle Database by Using a SQL Command
Creating Database using SQL Command
5: Starting Up and Shutting Down a Database Instance
Starting Up and Shutting Down a Database Instance
Opening and Closing PDBs
6: Managing Database Instances
Managing the Database
7: Oracle Net Service: Overview
Configuring and Administering Oracle Net Service
Course Practice Environment: Security Credentials
8: Configuring Naming Methods
Oracle Net Components
Naming Method
9: Configuring and Administering the Listener
Configuring and Administering the Listener
10: Configuring a Shared Server Architecture
Configuring a Shared Server Architecture
Configuring Shared Server Mode
Configuring Clients to Use a Shared Server
11: Configuring Oracle Connection Manager for Multiplexing and Access Control
Connection Manager
12: Creating PDBs from Seed
Creating PDBs from Seed
Provisioning New Pluggable Databases
13: Using Other Techniques to Create PDBs
Using Other Techniques to Create PDBs
Method of Creating and Migrating PDBs
14: Managing PDBs
Managing PDBs
15: Database Storage Overview
Database Storage Overview
Purpose of the Default Tablespaces
Storage of Data in Blocks
Advantage of Deferred Segment Creation
16: Creating and Managing Tablespaces
Creating and Managing Tablespaces
Viewing Tablespace Information
17: Improving Space Usage
Space Management Features
Creating Global Temporary Tables
18: Managing Undo Data
Managing the Undo
Enabling Temporary Undo
19: Creating and Managing User Accounts
Creating and Managing User Accounts
Creating Common Users in the CDB and PDBs
Assigning Quotas
20: Configuring Privilege and Roles Authorization
Configuring Privilege and Roles Authorization
21: Configuring User Resource Limits
Configuring User Resource Limits
22: Implementing Oracle Database Auditing
Implementing Oracle Database Auditing
Configuring Auditing
Viewing Audit Policy Information
23: Introduction Loading and Transporting Data
Introduction Loading and Transporting Data
Course Practice Environment: Security Credentials
24: Loading Data
Loading Data
25: Transporting Data
Transporting Data
Using the RMAN Convert Command
26: Using External Tables to Load and Transport Data
Using External Tables to load Transport Data
27: Automated Maintenance Tasks: Overview
Automated Maintenance Tasks: Overview
Automated Maintenance Tasks: Components
Course Practice Environment: Security Credentials
28: Automated Maintenance Tasks: Managing Tasks and Windows
Configuring Automated Maintenance Tasks
29: Database Monitoring and Performance Tuning Overview
Database Monitoring and Tuning Performance Overview
30: Monitoring Database Performance
Understanding What Database Performance is Monitored
31: Tuning Database Performance
Tuning Database Performance
32: Analyzing SQL and Optimizing Access Paths
Analyzing SQL and Optimizing Access Paths
Adaptive Execution Plans
به عنوان اولین نفر، نظر خود را بنویسید!