Udemy

Oracle DBA 11g/12c - Database Administration for Junior DBA

立即報名
  • 44,082 名學生
  • 更新於 5/2022
4.5
(10,920 個評分)
CTgoodjobs 嚴選優質課程,為職場人士提升競爭力。透過本站連結購買Udemy課程,本站將獲得推廣佣金,有助未來提供更多實用進修課程資訊給讀者。

課程資料

報名日期
全年招生
課程級別
學習模式
修業期
10 小時 59 分鐘
教學語言
英語
授課導師
Amarnath Reddy
評分
4.5
(10,920 個評分)
4次瀏覽

課程簡介

Oracle DBA 11g/12c - Database Administration for Junior DBA

Learn to become an Oracle Database Administrator (DBA) in 6 weeks and get a well paid job as a Junior 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 Architecture
  • Understand 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 security
  • Networking (Configuring Listeners and TNS entries)
  • Understand various Data dictionary tables/views
  • Diagnose issues using Diagnose data and generate packages for Oracle Support.
  • Backup and Recovery (User Managed)
  • Backup and Recovery (RMAN)
  • Materialized Views
  • Table Partitioning
  • Project Work

Let's start and I will take you step by step to lead your journey into the DBA world!!!

課程章節

  • 17 個章節
  • 129 堂課
  • 第 1 章 Introduction
  • 第 2 章 Oracle Process Architecture
  • 第 3 章 Oracle Memory Architecture
  • 第 4 章 Architecture Recap
  • 第 5 章 Software Installation
  • 第 6 章 Tablespace Management
  • 第 7 章 UNDO Management
  • 第 8 章 REDO Management
  • 第 9 章 User Management
  • 第 10 章 Oracle Networking
  • 第 11 章 Data Dictionary
  • 第 12 章 Diagnostic Data
  • 第 13 章 Backup and Recovery (User Managed)
  • 第 14 章 Backup and Recovery (RMAN Backup)
  • 第 15 章 Database Objects - Materialized Views
  • 第 16 章 Table Partitioning
  • 第 17 章 Project Work!!!

課程內容

  • Final Goal: Get a job as an Oracle Database Administrator (Oracle DBA), As a Oracle Database Administrator you would understand the Database Architecture, which will help you to perform your DBA duties with better understanding., As a Oracle Database Administrator (Oracle DBA), you would be able to Install the necessary Oracle Software/Database, As a Oracle Database Administrator (Oracle DBA), you would be able to Administer User accounts in the Database, As a Oracle Database Administrator (Oracle DBA), you would be able to Manage Tablespace's to provide required space for the data, As a Oracle Database Administrator (Oracle DBA), you would be able perform Backup and Recovery as needed., As a Oracle Database Administrator (Oracle DBA), you would be able to diagnose the problems and if required will be able to work with Oracle Support, As a Oracle Database Administrator (Oracle DBA), you would be able to configure the Listeners for users to communicate


評價

  • J
    Jyoti Zoting
    5.0

    Very detailed and useful explanation. Thanks

  • K
    Kamil Kazanecki
    3.5

    Well explained and prepared. Unfortunately, the 11g and 12c databases on Oracle Linux 5 don't work properly. Numerous errors and conflicts pop up during installation. The software is significantly outdated. It's still possible to install the system and Oracle DB 12g, but when upgrading to 12c, the system starts throwing errors. Despite numerous attempts and support, the system couldn't be upgraded and I ended up having to rebuild Linux and the 11g database.

  • N
    Nancy Calzon Portillo
    5.0

    El curso me parecio muy claro y bien explicado, estoy segura que aplicare lo que aprendi. Gracias

  • S
    Satyajeet Kumar
    4.0

    Good course for beginner who wants to learn about DB.

立即關注瀏覽更多

本網站使用Cookies來改善您的瀏覽體驗,請確定您同意及接受我們的私隱政策使用條款才繼續瀏覽。

我已閱讀及同意