Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA CompTIA Security+ Amazon AWS AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Meditation Life Purpose Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Google Analytics
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Modeling Data Analysis Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Office Productivity Oracle Oracle Database

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.
Bestseller
Rating: 4.3 out of 54.3 (5,398 ratings)
21,816 students
Created by Amarnath Reddy
Last updated 2/2018
English
English [Auto], French [Auto], 
30-Day Money-Back Guarantee

What you'll 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
Curated for the Udemy for Business collection

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

Description

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

Who this course is for:

  • Students who want to start their careen in Database Administration

Course content

17 sections • 129 lectures • 10h 59m total length

  • What is a Database?
    Preview03:28
  • Role of a DBA!!!
    05:17
  • OLTP vs OLAP Databases
    04:14
  • What is Oracle 11g?
    Preview04:58
  • What is Oracle 12c?
    Preview05:28
  • Database abc's
    04:42
  • Undo vs Redo Data
    05:41
  • Oracle Instance vs Database
    03:43
  • Quiz Time!!!
    2 questions

  • Process Architecture
    02:25
  • Database Writer Process
    04:05
  • Log writer Process
    01:14
  • Checkpoint Process
    03:44
  • SMON Process
    01:17
  • PMON Process
    02:24
  • RECO Process
    01:58
  • Archiver Process
    01:33
  • Quiz Time!!!
    4 questions

  • Memory Architecture
    02:34
  • Database Buffer Cache
    03:17
  • Shared Pool
    07:20
  • REDO log buffer
    01:03
  • Large Pool
    01:54
  • Java Pool and Streams Pool
    00:58
  • Keep Buffer Pool
    03:00
  • Recycle Buffer Pool
    01:48
  • nK Buffer Cache
    01:32
  • Program Global Area (PGA)
    02:36
  • Dedicated vs Shared Databases
    04:44
  • PGA in a Shared Envrionment
    00:39
  • Quiz Time!!!
    5 questions

  • Preview04:27
  • Architecture Quiz!!!
    2 questions

  • Software Download...
    00:11
  • Virtual Machine Installation
    02:20
  • Linux Installation
    16:50
  • Oracle Software Installation
    15:00
  • Oracle Parameter Files
    05:55
  • Database creation - Manual Method Demo
    16:08
  • Verify Database creation
    02:17
  • Database creation using DBCA (Preferred option)
    10:46
  • Oracle Startup Steps...
    07:46
  • Oracle Shutdown methods
    08:08
  • Oracle 12c Upgrade
    19:13

  • How data is stored in a Database?
    06:21
  • Tablespace Concepts
    04:19
  • Online and Offline Tablespaces
    01:11
  • Let's create a Tablespace...
    02:00
  • Let's add more space to the Database...
    02:09
  • Tablespace Demo 1
    19:35
  • Tablespace Demo 2
    06:10
  • Tablespaces with different block sizes
    04:39
  • Temporary Tablespace Management
    06:19
  • Temporary Tablespace Groups
    06:18
  • Extent Management (Local vs Dictionary managed)
    08:38

  • UNDO Concepts
    05:32
  • Read Consistency
    03:10
  • ORA-01555 snapshot too old error
    02:34
  • Automatic Undo Management
    02:41
  • UNDO Management
    09:51
  • Configuring Undo Retention Period
    04:26
  • Retention Guarantee!!
    05:27

  • REDO Concepts
    07:12
  • REDO Logfile Management Demo1
    06:01
  • REDO Logfile Management Demo2
    03:32
  • Archival Concepts
    03:00
  • Archival Log Mode Demo
    03:08

  • User Management Concepts
    09:23
  • User Management Demo 1
    09:43
  • User Management Demo 2
    03:52
  • User Creation Exercise
    00:07
  • Privileges
    05:49
  • System Privileges Demo
    07:50
  • Object Privileges Demo
    05:38
  • Revoking User Privileges
    03:06
  • Revoking System Privileges
    02:14
  • Revoking Object Privileges
    02:19
  • Let's practice what we learnt so far...
    02:23
  • Role Management Concepts
    04:09
  • Role Management Demo
    04:11
  • User Profiles
    05:34
  • User Profile Demo
    05:21
  • Managing Passwords using Profiles
    02:13

  • Networking Concepts
    10:00
  • Listener Configuration Demo
    09:00
  • TNSNAMES Configuration Demo
    07:35
  • Database Link Concepts
    03:32
  • Public Database Link
    05:09
  • Private Database Link
    02:45

Instructor

Amarnath Reddy
Oracle Architect & Best Selling Instructor | 27000+ Students
Amarnath Reddy
  • 4.3 Instructor Rating
  • 15,637 Reviews
  • 69,675 Students
  • 9 Courses

Amarnath has a Masters Degree in computer science with around 15 years of experience in the IT industry. He has successfully designed and implemented projects for clients in South Africa, India and USA. Currently his main focus is on Datawarehouse Architecture.

Amarnath is currently working for a fortune 500 company in USA and has pioneered the data architecture discipline. His Innovative and simple architectural designs have won accolades in the company.

Today, he brings leadership and technical expertise to enable customers to optimize and modernize their IT environments leveraging Business Intelligence tools, Big Data, social, mobile, and the Internet of Things.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.