Online
Uplatz Oracle DBA (Video-Based) Uplatz
  • Duration / Course length: Upto 10 Hours Start now
  • Accredited by: SAP Extended Business Partner
  • Course delivery: This course is delivered in video format

Course details

Database Administrators (DBAs) are responsible for the design, implementation, support and maintenance of computerized databases in today’s organizations.

The role also includes architecting, building and scaling databases for future data growth and capacity. They are also responsible for security, performance and availability of data to users and customers.

All the above tasks are performed with the help of a Database Management System (DBMS) and the leading and most widely used DBMS across the world today are the Oracle Database, Microsoft SQL Server, MySQL database etc. Out of the three DBMS technologies, Oracle Database is the most popular and widely used database in the world today.

Oracle consists of various software mechanisms to achieve maximized data concurrency, high performance, and maximum productivity for a multi-user database environment.

'Oracle Database Administration for Absolute Beginners' course explains about the basic concepts of Relational Database Management Systems (RDBMS). It will help you to become an Oracle Database Administrator(Oracle DBA).

Database Administrator is one of the highly sought after jobs in the IT industry. It is also one of the highly stable jobs as DATA is a vital part of every organization and they need that to be in the capable hands of a good DBA team.
.
Some of the key features of Oracle DBA are as follows:

Database administration is not the task of a single person but handled by a group of specialists.

It is the first-ever database suitable for enterprise grid computing.

It works on grid-based architecture.

Course curriculum:-

Introduction to Linux
  • History of Linux
  • Components of Linux
  • Linux Basic Commands
  • File permission to users
Introduction to DBMS
  •  What is a database?
  •  History of Oracle database
  •  Role of a Database Administrator
Basic SQL
  •  What are DML, DDL and DCL Statement
  •  Examples on DML, DDL and DCL
  •  Creation of Table, Views, Sequence, Synonyms & Index
Oracle Database Architecture
  •  Detail explanation on components of an Oracle database architecture
  •  Oracle database memory and process architecture
Installing Oracle database software (11g R2)
  •  Pre-requisites for a successful Oracle software installation
  •  Installation of oracle software using GUI and Manual Method
  •  Installation of Oracle 11g R2 database software
Oracle Database Creation
  •  Introduction
  •  Planning for an Oracle database creation
  •  Creating an Oracle database using the MANUAL method
  •  Creating an Oracle database using the GUI Tool (DBCA)
  •  Startup and Shutdown Methods
  •  Best practices using OFA for database creation
Database Storage Management
  •  Introduction
  •  Tablespaces creation methods
  •  Datafiles creation methods
  •  How to resize/rename the tablespace/datafiles
  •  How to Change the location of datafiles
  •  Redolog file architecture and best practices
  •  How to resize/rename the redolog file
  •  Benefits of Archiving, how to enable/disable Archivelog mode for a database
  •  Temporary tablespaces and temporary tablespace groups
Oracle Networking
  •  Oracle listener & TNS configuration using NETMGR
  •  Managing & Distributing by using DB-link concept
  •  Oracle database connections from other systems
  •  Oracle Shared server Dispatcher & Architecture
User Administration and Security
  •  Create database users
  •  Database resource management (User’s Profile and Role)
  •  Locking/unlocking a user account
  •  User’s password management
User Managed Backup and Recovery
  •  Introduction: Backup and Recovery Strategy for user managed backup
  •  How to backup an Oracle database using COLD BACKUP
  •  How to backup an Oracle database using HOT BACKUP
  •  Recovery scenarios using User managed backup
RMAN Backup and Recovery
  •  RMAN backup of Database, controlfile,Archivelogfiles
  •  Database backup using RMAN with normal and compressed mode
  •  Database backup using catalog and no-catalog and virtual catalog
  •  Querying the backup details using Catalog database
  •  Benefits of Fast Recovery Area using RMAN backup for storage
  •  How to backup incremental database
  •  Recovery scenarios using RMAN
  •  Tablespace Point in time recovery (TSPITR)
Oracle Datapump {Logical backup & Restore}
  •  Introduction on Datapump(Expdp,Impdp) Utilities
  •  Benefits of Logical backup & Physical backup
  •  Exporting/Importing Tables, Schema Tablespace
  • database and Transportable tablespace
  •  Backup methods using datapump
Flashback Feature
  •  Types of flashback and their benefits
  •  Flashback Query, Flashback Table to past time
  •  Flash back of Recovering Drop tables
  •  Flashback Archive
Oracle Enterprise Manager (grid Control)
  •  Introduction
  •  How to install and configure
  •  Monitor databases and performance of the databases
Cloning
  •  Cloning database using RMAN from Active Database
  •  Cloning database using same datafile storage locations and different datafile
  • storage locations
Logminer and SQL Loader
  •  Reading/Extracting the content of Redologs (Online/Archived)
Oracle Dbase Patching/Patch Management
  •  Downloading/Applying Interim & Patchset patches using Opatch
  •  Applying cpu and psu patches
  • Oracle DBase Upgradation and Migration
  •  Upgrating database from 11g to 12c version
Oracle Data Guard
  •  Oracle Dataguard Architecture
  •  Creation of physical standby database using RMAN and Manual Method
  •  How to configure Active standby database and snapshot standby database
  •  Data guard Modes and Switchover/Failover
  •  Scenarios on restore and recovery
Oracle Automatic Storage Management (ASM)
  •  Setup ASM by using Grid Infrastructure Utility
  •  Database Migration from Non-ASM to ASM
Oracle Database Performance Tuning
  •  Basic overview on PT and troubleshooting
  •  Routine Day-to-Day Health Management tasks
  •  Introduction on Proactive & reactive Tuning
  •  Diagnostic tools such as Alert logfile, Trace file, TKPROF
  •  AWR Report, ADDM Report and ASH Report
Oracle 12c New Features
  • Introduction, Architecture, Installation & Creation of DBase
  • Multi-Tenancy Database (PDB,CDBs)
  • SQL Statement & Table level recovery(TPITR) in RMAN
Creating a user, Tablesapce & In-memory Area Updated on 08 February, 2021

Job roles this course is suitable for:

Oracle DBA Specialist , Oracle DBA Consultant , Oracle DBA , Oracle DBA - Junior Database Administrator , Oracle DBA - Technical Specialist , Data Centre Oracle Database Administrator , Senior Associate , Oracle Database Administrator , Cloud Engineering & Services , Senior Oracle Database Administrator

About Uplatz

Uplatz is global leading provider of SAP Training. We have a strong network of qualified and experienced tutors providing training courses on all SAP modules such as SAP FICO, SAP MM, SAP HANA, SAP SuccessFactors, SAP SD, and so on. Besides SAP courses, we provide online training on in-demand technologies such as Big Data, Hadoop, Oracle, Informatica, Python, AngularJS, Wordpress, and more.. in a virtual classroom set-up. We feel proud to say that we are making learning affordable by keeping prices of all our courses very low. No one in the market can beat us in course prices because each of our courses is listed at almost 80% discounted rate from average market price of the same course.

Why should I choose Uplatz?

There are 3 simple reasons of choosing Uplatz:

1) Our elite tutors are highly experienced and experts in their fields.

2) No one in the market can dare to beat our price! It is only 20% of the standard institute price for the same course (Reason - Because these courses are offered directly by the tutors).

3) We are a team of IITians - we will design the course structure for you as per your requirements.

Will I get a Certificate of Course Completion?

Yes. Every learner who successfully completes a course on Uplatz is awarded the Course Completion Certificate.

Will I be provided study material, tutor notes and video recordings?

Ofcourse! All sessions conducted through Uplatz get recorded and life-time access to the recordings is provided to you. Besides that, Uplatz also provides tutor notes, practice assignments, practice sessions, and a lot more for free. Our tutors will assist you in preparing for certification exams as well.

What if I didn’t get the skills that were taught to me?

In case you are unsatisfied with the tutoring or don’t get your problem solved, we will moderate the situation. We will help you get your concepts clear/learn the desired skills. You can keep the fees in the Uplatz vaults and try learning from other tutors or you can get your cash back after nominal administrative fees deduction.

214 students have enrolled with Uplatz through Laimoon
See all Uplatz courses

Rate this page