|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/oracle-exadata-database-machine-and-cloud-service-1z0-338-a/
课程评论：没有评论
课程名称：Oracle Exadata数据库机器及云服务 1Z0-338 课程概述： 本课程旨在教授学员如何配置和管理基本的Oracle数据库，利用Oracle的功能和特性进行调优，以提升在常见使用场景下的数据库性能。学员将深入了解Oracle Exadata的架构，包括处理卸载、智能闪存缓存的使用、以及高级压缩和混合列式压缩等关键概念。此外，本课程还涵盖了高可用性配置、数据仓库工作负载的并行处理、数据库安全概念、以及Exadata设备的电源和内存功能的重要性。 课程内容包括： 1. **Oracle数据库软件**：配置与管理基础数据库，优化性能。 2. **Exadata架构**：描述Exadata软件架构与处理卸载，智能闪存缓存的启用，以及存储索引的应用等。 3. **管理和配置**：使用高级压缩技术，网络配置，以及创建自动存储管理磁盘组的过程。 4. **备份与恢复**：制定备份计划，实施各种故障场景下的恢复程序，并阐述备份过程中的故障排除任务。 5. **高可用性**：实施Oracle推荐的高可用性配置，标识故障场景并执行恢复程序。 6. **监控**：安装企业管理监控插件，使用命令行界面监控存储单元，以及使用 osWatcher 和其他工具进行系统监控。 7. **软件维护**：了解软件组件，补丁管理，及如何进行计划维护。 8. **批量加载与迁移**：使用数据库文件系统进行批量操作，并学习外部表的数据加载策略。 9. **资源管理**：设置实例限制，管理Exadata上的输入输出。 10. **云服务中的Exadata**：了解Oracle Exadata云服务的配置过程，备份与恢复管理。 通过本课程的学习，学员将能够有效管理Oracle Exadata数据库机器，提升其在数据处理和存储管理上的能力，适应高可用性与云环境的需求。
Oracle Database SoftwareConfigure and administer a basic database using Oracle features and functionsTune the Oracle database for performance in common use case scenariosOracle Exadata ArchitectureDescribe offloading processingDescribe the architecture used by Oracle Exadata softwareUse Smart Flash CacheEnable Flash Cache Write BackEnable Advanced Compression and Hybrid Columnar Compression on Exadata tablesDescribe storage indexesDescribe Oracle recommended configurations for High Availability configurationsEnable parallelism for Data Warehouse workloadsDescribe database and Automatic Storage Management-Scoped Security CconceptsDescribe the Power Distribution UnitDescribe memory capabilities of different modelsDescribe the importance and use of In-Memory Fault Tolerance in the Exadata Database MachineExplain the differences between the types of storage servers available on the Exadata Database MachineAdministration and ConfigurationCompress data using Advanced Compression and Hybrid Columnar CompressionUse network configuration optionsCreate and configure Automatic Storage Management disk groups using ExadataExplain the impact of various diskgroup failure group choicesInstall software onto the Exadata Database MachineDescribe various tasks that can be done with the Integrated Lights Out Management (ILOM) consoleReconfigure a 1/8th rack into a 1/4 rackDescribe network components in ExadataCreate a database snapshot on Exadata for testing purposesBackup and RecoveryCreate a backup plan for ExadataImplement recovery procedures on different failure scenariosDescribe troubleshooting tasks for backup and recovery processesDescribe how the Exadata Storage Servers are backed up internallyHigh AvailabilityDescribe Oracle's recommended guidelines for high availability configurations on ExadataIdentify failure scenarios and implement recovery proceduresInstall high availability software onto the Exadata Database MachineMonitoringInstall an Enterprise Manager Exadata Monitoring plug-inSet up an agent, plugin, and Exadata target for Enterprise Manager Cloud ControlMonitor the storage cell using Cell Command Line Interface and Distributed Command Line InterfaceDescribe the purpose and uses for Simple Network Management Protocol (SNMP), Intelligent Platform Management Interface (IPMI) and Integrated Lights Out Management for a DB machineUse osWatcher and iostat to monitor the Database Machine operating systemUse exacli and dbcli to monitor storage cellsSoftware MaintenanceDescribe software componentsLocate patches for ExadataApply Oracle recommendations to the patching process for ExadataDescribe the Oracle Configuration ManagerExplain how to perform planned maintenance of the Exadata machineDescribe how to use the Oracle Exadata Deployment Assistant to create virtual machines on ExadataBulk Loading and MigrationUse Database File System (DBFS) to perform bulk loading operationsUse the ASM Cluster File System (ACFS) to perform bulk data loading operationsConfigure a Database for staging input data filesUse external tables for data loadsDescribe migration strategies for ExadataExplain Oracle recommendations on how to choose a migration strategyResource ManagementSet up instance cagingManage I/O on ExadataSupportSet up an Automatic Service Request (ASR) on the Database MachineExplain the ASR configuration processDescribe implementation requirements for Platinum SupportExadata in the CloudDescribe the Oracle Exadata Cloud Service provisioning processConfigure backup and recovery on the Exadata Cloud ServiceAdminister the Oracle Database on the Exadata Cloud ServiceAdminister the Oracle Database on the Exadata Cloud Machine
