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

4.3 (4766)
MOOC
Payment
Learning paid
Language
English
Duration
11 hours course
Course by Udemy
$ 129.99
$ 129.99
What will you learn?
Final Goal: Get a job as an Oracle Database Administrator (Oracle DBA)
As a Oracle Database Administrator (Oracle DBA), you would be able 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
About the course

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!!!

Program
Introduction
In this DBA Section, you will learn fundamentals of database to set the stage for Oracle Architecture
What is a Database?
Role of a DBA!!!
OLTP vs OLAP Databases
What is Oracle 11g?
What is Oracle 12c?
Database abc's
Undo vs Redo Data
Oracle Instance vs Database
Quiz Time!!!
Quiz1
Oracle Process Architecture
In this DBA Section, you will learn how various Processes work
Process Architecture
Requirements
  • Students should have basic SQL Knowledge
  • Students should know the basic UNIX/LINUX commands
  • An open mind to understand Architecture, before jumping into demo's
Lecturers
Amarnath Reddy
Amarnath Reddy
Oracle Architect & Best Selling Instructor | 27000+ Students
Platform
/storage/img/providers/udemy.svg
Udemy courses are suited to professional development. The platform is organized in such a way that it is experts themselves that decide the topic and when the course will start. All supporting documents are made available to you for lifetime access. On this platform, you can find a course on about any subject, and that is no exaggeration – from a tutorial on how to ride a motorcycle, to managing the financial markets. The language and the course format are established by the teacher. This is why it is important to read the information about the course carefully before parting with any money.
Rating
4.3
(2184)
(1851)
(682)
(115)
(72)
Comments (4766)
Like any other website, konevy uses «cookies». These cookies are used to store information including visitor's preferences, and the pages on the website that the visitor accessed or visited. The information is used to optimize the users' experience by customizing our web page content based on visitors' browser type and/or other information. For more general information on cookies, please read the «What Are Cookies» article on Cookie Consent website.