دوره حضوری آنلاین (لایو) Oracle Database Administration Workshop 1 & Performance Tuning

دوره حضوری آنلاین (لایو) Oracle Database Administration Workshop 1 & Performance Tuning

نام دوره:

Performance Tuning and Oracle Database Administration Workshop1

مدت دوره:

50ساعت

پيش نياز:

آشنایی با Oracle SQL & PL/SQL

سرفصل‌ها

معرفی دوره
آماده سازی محیط پایگاه داده
معماری پایگاه داده اوراکل
ایجاد پایگاه داده
مدیریت نمونه پایگاه داده
تنظیم شبکه در اوراکل
مدیریت ساختار دخیره سازی داده در پایگاه داده
مدیریت کردن امنیت کاربران
مدیریت اشیاء پایگاه داده
تغییرات داده و مدیریت همزمانی تغییرات
پیاده سازی امنیت در پایگاه داده اوراکل
پشتیبانی و نگهداری پایگاه داده
مدیریت کارایی
بهینه سازی با استفاده از ایندکس
پارتیشن کردن
خلاصه سازی داده

Course Objectives

Introduction
Install, create, and administer Oracle Database 11g
Configure the database for an application
Employ basic monitoring procedures
Implement a backup and recovery strategy
Move data between databases and files

Preparing the Database Environment
Describe your role as a database administrator (DBA) and explain typical tasks and tools
Plan an Oracle Database installation
Use Optimal Flexible Architecture(OFA)
Install the Oracle software by using Oracle Universal Installer (OUI)

Exploring the Oracle Database Architecture
List the major architectural components of Oracle Database
Explain the memory structures
Describe the background processes
Correlate the logical and physical storage structures

Creating an Oracle Database
Create a database by using the Database Configuration Assistant (DBCA)
Create a listener by using the Oracle Net Configuration Assistant (NetCA)
Create a database design template with the DBCA
Generate database creation scripts with the DBCA

Managing the Oracle Instance
Start and stop the Oracle database and components
Use Oracle Enterprise Manager
Access a database with SQL*Plus
Modify database initialization parameters
Describe the stages of database startup
Describe database shutdown options
View the alert log
Access dynamic performance views

Configuring the Oracle Network Environment
Use Enterprise Manager to:Create additional listeners
Create Oracle Net Service aliases
Configure connect-time failover
Control the Oracle Net Listener
Use tnsping to test Oracle Net connectivity
Identify when to use shared servers and when to use dedicated servers

Managing Database Storage Structures
Describe the storage of table row data in blocks
Define the purpose of tablespaces and data files
Create and manage tablespaces
Obtain tablespace information
Describe the main concepts and functionality of Automatic Storage Management (ASM)

Administering User Security
Create and manage database user accounts
Authenticate users
Assign default storage areas (tablespaces)
Grant and revoke privileges
Create and manage roles
Create and manage profiles
Implement standard password security features
Control resource usage

Managing Schema Objects
Define schema objects and data types
Create and modify tables
Define constraints
View the columns and contents of a table
Create indexes
Create views
Create sequences
Explain the use of temporary tables

Managing Data and Concurrency
Manage data by using SQL
Identify and administer PL/SQL objects
Describe triggers and triggering events
Monitor and resolve locking conflicts
Explain DML and undo data generation
Monitor and administer undo data
Describe the difference between undo data and redo data
Configure undo retention

Implementing Oracle Database Security
Describe DBA responsibilities for security
Apply the principle of least privilege
Enable standard database auditing
Specify audit options
Review audit information
Maintain the audit trail

Database Maintenance
Manage optimizer statistics
Manage the Automatic Workload Repository (AWR)
Use the Automatic Database Diagnostic Monitor (ADDM)
Use advisors and checkers
Set alert thresholds
Use server-generated alerts
Use automated tasks

Performance Management
Use Enterprise Manager to monitor performance
Use Automatic Memory Management (AMM)
Use the Memory Advisor to size memory buffers
View performance-related dynamic views
Troubleshoot invalid and unusable objects

Oracle Index Optimization
Oracle Index types
Index cardinality
multi-column indexes
Index unique vs. index normal
Finding missing indexes
Partition Index and Local Indexes

Partitioning
Getting optimal pruning
Partition exchange loading
Partitioning and unusable indexes
Partitioning method
Partitioning key
Partition granularity
Partitioning Indexes
Local Prefixed Indexes
Global Prefixed Indexes
Global Non-Prefixed Indexes
Efficient statistics management

Materialized view
Explain the benefits of materialized views
Increase application performance using Materialized Views
Learn how to create and use Materialized
Different types of materialized views
Views and Materialized View logs
Set Materialized Views to refresh in a variety of ways
Create materialized views
Create materialized view logs
Refreshing materialized views
Altering Materialized Views
Dropping Materialized views
Understand Materialized View Groups
Exploit Oracle’s Query Rewrite capability



جزئیات سرفصل آموزشی دوره حضوری آنلاین Oracle Database Administration Workshop 1 & Performance Tuning را از طریق لینک زیر دریافت کنید:


سرفصل دوره سماتک