|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/oracledbatraining/
课程评论：没有评论
**课程名称：** Oracle DBA 11g/12c - 数据库管理员入门 **课程概述：** 本课程旨在帮助学员在6周内掌握成为一名Oracle数据库管理员（DBA）所需的技能，并为获得初级DBA职位做好准备。课程采用循序渐进的方法，辅以概念讲解和实际演示，让学习过程更加轻松。本课程特别适合希望成为Oracle DBA的人士。 **课程内容：** * **数据库基础知识：** 打下坚实的数据库基础，为理解Oracle体系结构做好准备。 * **Oracle体系结构：** 重点介绍进程和内存体系结构，这对于解决关键性能问题至关重要。 * **Oracle数据库安装：** 学习Oracle Database 11g和12c的手动安装方法以及使用DBCA工具安装。 * **表空间管理：** 掌握管理数据存储空间。 * **UNDO表空间管理：** 学习管理UNDO（回滚）段空间。 * **REDO日志管理：** 了解如何管理REDO日志文件。 * **用户与安全管理：** 学习创建和管理用户账户及数据库安全策略。 * **网络配置：** 配置监听器（Listeners）和TNS entries，实现客户端与数据库的连接。 * **数据字典：** 熟悉各种数据字典表和视图，用于查询数据库元数据。 * **问题诊断与支持包生成：** 学习使用诊断数据识别问题，并为Oracle Support生成必要的数据包。 * **备份与恢复：** * 用户管理备份与恢复 * RMAN（Recovery Manager）备份与恢复 * **高级主题：** * 物化视图（Materialized Views） * 表分区（Table Partitioning） * **项目实战：** 通过项目实践巩固所学知识。 **课程亮点：** * 覆盖Oracle Database 11g和12c，帮助学员适应不同版本的组织环境。 * 循序渐进的教学方法，易于理解和掌握。 * 强调核心概念，如进程和内存管理，以解决实际问题。 * 注重实践操作，包括安装、管理和备份恢复。 本课程将带领您一步步走进DBA的世界！
Learn to become an Oracle Database Administrator (DBA) in 6 weeks and get a well paid job as a Junior DBA. 'Oracle 11g/12c DBA' course follows a step by step methodology in introducing concepts and Demo's to the students so that they can learn with ease. If you want to become an Oracle Database Administrator(Oracle DBA), this course is right for you!!!! Almost in every organization, you will find Database Administrator's (DBA's) to maintain the organization's database. Becoming a good DBA depends on the knowledge you have in the overall architecture of Oracle Database. In this course, I have covered both Oracle Database 11g and Oracle Database 12c so that you get to know the differences and can work in organizations, who are still in 11g. Step by Step methodology followed is. Learn the fundamentals of database to set the stage for Oracle ArchitectureUnderstand the Process and Memory Architecture (This is important as understanding this will help you solve lot of critical performance issues). Install Oracle Database 11g & 12c (Manual method and using DBCA)Tablespace management to manage space to store the data.UNDO Tablespace management to manage undo space.REDO Log file management to manage redo space.Manage users and securityNetworking (Configuring Listeners and TNS entries)Understand various Data dictionary tables/viewsDiagnose issues using Diagnose data and generate packages for Oracle Support.Backup and Recovery (User Managed)Backup and Recovery (RMAN)Materialized ViewsTable PartitioningProject Work Let's start and I will take you step by step to lead your journey into the DBA world!!!
