|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/advanced-datapump-expdpimpdp-course-for-oracle-dbas/
课程评论：没有评论
**课程名称：Oracle DBA数据泵EXPDP/IMPDP实战课程** **课程概述：** 本课程旨在通过大量动手实践，帮助Oracle DBA掌握数据泵（Data Pump）工具。数据泵是Oracle数据库中用于数据和元数据迁移、复制、刷新以及云迁移的核心工具。学完本课程，您将能够自信地处理各种与数据泵相关的实际工作场景。 **学习目标：** * 熟练掌握Oracle数据泵（EXPDP/IMPDP）工具的使用。 * 通过模拟真实场景的动手实验，深入理解数据泵的各项功能。 * 了解并应用数据泵的各种参数，以优化导出和导入过程。 * 熟悉在不同Oracle版本（11g, 12c, 19c）下的数据泵操作，并进行效率对比。 * 能够导出和导入数据库、模式（schema）、表、索引、约束、视图及查询等。 * 学会多种数据复制和刷新方法。 * 能够通过不同的参数和方法加速导出和导入过程。 * 独立应对来自应用团队的数据迁移和管理请求。 **课程特点：** * **高度实战化：** 所有教学内容围绕实际工作场景展开，通过大量的动手实验室（Hands-on Lab）进行练习。 * **模拟环境：** 使用VirtualBox构建Oracle虚拟机环境，模拟真实操作。 * **版本覆盖：** 涵盖Oracle 11g, 12c, 19c等多个版本的数据泵功能。 * **核心工具聚焦：** 课程内容严格围绕数据泵（Data Pump）展开。 **先修要求：** * 具备Oracle数据库管理基础知识。 * 了解Linux操作系统基础。 * 拥有配置至少16GB内存、60GB硬盘空间、64位CPU（至少2核）的PC（Windows 7, 8, 或 10）。 **目标学员：** * desejo aprender a utilizar as ferramentas de exportação e importação de dados do Oracle. * Oracle DBA **联系导师：** Kishan-Oracle (Oracle Community)
Objective:Practice makes perfect! Master datapump utility by performing different hands on lab scenarios with this courseOracle datapump tool boosts the migration of data and metadata from source database to destination database. It is also the most widely used utility in oracle database for data copy,refresh, etc and also used in cloud migrations. So learning this tool help you in your career. This course is for oracle learners who want to learn datapump utility in oracle for performing different methods of data copy and refresh dataIn this course, learners will perform hands on tasks as if like a real time scenario with different situation based tasksAll the parameters will be used in the practical box for different oracle versions Oracle machine is built in virtual box for simulation of the tasksLearners can be able to confidently face a request from application team after completing the courseDatapump is the core of this course. So only datapump utility will be explained Hope the learner who applies for this course has a prior understanding of what oracle database is.There are different oracle versions for datapump like 11g,12c and 19c. All these versions will be used and their efficiency will be compared.You will learn how to export a database,schema,table,index,constraint,view and query etc.. and import them to a database using different methods You will learn how to speed up the export and import with different parameters and different approaches.Prerequisites:Oracle Database Administration fundamentalsLinux operating system basicsPC with atleast 16 GB, 60 GB HDD, Windows 7,8,or 10 64-bit CPU core(minimum) - 2Student category:Oracle DBAFor any questions, reach out to me at oracle communityProfile name- Kishan-Oracle
