|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/oracle-core-dba-19c/
课程评论：没有评论
课程名称：Oracle DBA 19c 概述： Oracle数据库（通常称为Oracle RDBMS）是由甲骨文公司开发和营销的一种专有多模型数据库管理系统。Oracle Database 19c是Oracle Database 12c系列产品的最终版本，享有“长期支持”，包括4年的高级支持和至少3年的扩展支持。该版本在之前的发布基础上，进一步加强了多租户、内存、JSON支持、分片等功能，推动了甲骨文的自主数据库云服务。 该版本引入了一系列自动化功能，帮助管理员提供更优质的服务，主要包括： - **基于成本的优化**：自动SQL查询优化、统计信息收集、查询重写等。 - **性能调优和诊断**：自动内存和资源管理、索引顾问、数据库诊断监控等。 - **数据优化**：自动撤消管理、段空间管理及存储管理等。 - **云规模操作**：自动备用管理、诊断框架、多租户架构等。 Oracle在2018年推出了自主数据仓库（ADW）和自主事务处理（ATP）云服务，利用自动化数据库功能和机器学习技术，提供了高效可靠的服务。自主数据库具备自驱动、自安全和自修复的特点，旨在通过自动化常规管理任务，降低成本并消除人为错误。 Oracle DBA的职责包括容量规划、数据库服务器硬件评估、Oracle数据库的所有方面管理（如安装、配置、设计和数据迁移），并承担性能监控、安全性、备份、故障排除和数据恢复等任务。本课程将详细讲解安装、架构、数据库组件、备份、恢复及RMAN等内容。 这一密集课程适合希望深入学习Oracle 19c的学员，掌握数据库管理的核心技能。
Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is a proprietary multi-model database management system produced and marketed by Oracle Corporation.Oracle Database 19c is the final, and therefore 'long term support' release of the Oracle Database 12c family of products (which includes Oracle Database 18c). 'Long term support' means that Oracle Database 19c comes with 4 years of premium support and a minimum of 3 years extended support. Oracle Database 19c builds upon the innovations of previous releases such as Multitenant, In-Memory, JSON support, Sharding and many other features that enable Oracle's Autonomous Database Cloud Services. This latest release of the world's most popular database also introduces new functionality, providing customers with a multi-model enterprise-class database for all their typical use cases.JOURNEY TO AUTONOMOUS DATABASE CLOUD Over successive database releases, Oracle has introduced innovative automated features that have helped administrators deliver a superior level of service to their end users. These innovations include: • Cost-based Optimization Automatic SQL query optimization, automatic statistics gathering, automatic query rewrite automatic SQL Plan management and automatic SQL tuning. • Performance Tuning and Diagnostics Automatic memory and resource management, automatic index and materialized view advisors, Automatic Database Diagnostic Monitor, Automatic Database Workload capture & replay and Automatic Workload Repository. • Data Optimization Automatic undo management, automatic segment space management, Automatic Storage Management, Automatic Data Optimization and automatic columnar cache. • Cloud-Scale Operation. Automatic standby management (broker), Diagnostic Framework, Multitenant Architecture, automatic database clone refresh and machine learning in Cluster Health Advisor. In March 2018, Oracle introduced the Autonomous Data Warehouse (ADW) cloud service, and this was followed in August 2018 with the introduction of the Autonomous Transaction Processing (ATP) cloud service. By utilizing automated database functionality with machine-learning techniques, these Autonomous Database Cloud services can provide a level of performance and reliability that manually managed databases struggle to deliver. The Oracle Autonomous Database is specifically designed to provide customers with a higher level of service at lower cost by automating routine administrative tasks and eliminating human error through: • Self-Driving. With easy to define workloads and policies, automation then makes them happen. • Self-Securing. With automated protection from both external attacks and internal users. • Self-Repairing. With automated protection from all downtime. The Oracle Autonomous Database is built on top of the world's most widely proven enterprise-class database: Oracle Database, it runs on the world's best database platform: Oracle Exadata, and available as pay-as-you-go services on Oracle Cloud and Exadata Cloud at Customer (for public cloud and private cloud deployment respectively). In addition, machine learning for performance diagnostics and recovery optimizations are built into each layer of the deployment stackOracle DBAs handle capacity planning, evaluate database server hardware, and manage all aspects of an Oracle database including installation, configuration, design, and data migration. Additional responsibilities include performance monitoring, security, backups, troubleshooting, and data recovery.In this intense course you will learn installation, architecture, different components of oracle database, backup, recovery, RMAN in great details.
