Install, Create, Administer Oracle Database
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. This course will take you through database installation, basic administration, user administration, tablespace administration and more.
What you will learn
- Install and configure Oracle 11gR2 database on Oracle Linux
- Manage database space allocation so that users can work smoothly
- Setup Oracle networking to allow external clients to connect the database
- Export and import data from one database to another database
Course Contents
Introduction to Database
Available in
days
days
after you enroll
Oracle 11g Architecture
Available in
days
days
after you enroll
Oracle 11g Software Installation
Available in
days
days
after you enroll
Oracle 11g Database Creation
Available in
days
days
after you enroll
Navigating Oracle Database
Available in
days
days
after you enroll
- Database Metadata (6:02)
- Basic Views You Must Know (4:33)
- Key Database Files and Locations (13:21)
- Physical and Logical Storage Structures of Database (6:38)
- Lab Activity – Find Physical Locations of All DB Files (6:50)
- Lab Activity – Find Tablespaces and Related Datafiles (9:20)
- Quiz - Test your knowledge!
- Interview Questions
Basic Database Administration
Available in
days
days
after you enroll
- Database Operating Modes (11:45)
- Lab Activity – Startup and Shutdown of Database (1:24)
- Multiplexing of Database Files (2:00)
- Lab Activity – Multiplexing of Control Files (7:35)
- Lab Activity – Multiplexing of Redolog Files (5:39)
- Lab Activity - Database Archivelog Mode (9:43)
- Quiz - Test your knowledge!
- Interview Questions
Tablespace Administration
Available in
days
days
after you enroll
User Administration
Available in
days
days
after you enroll
Oracle Networking
Available in
days
days
after you enroll
Oracle Utilities
Available in
days
days
after you enroll
- SQL * loader (3:38)
- Lab Activity - Import csv to Database Table (11:53)
- Oracle Export Import (8:07)
- Lab Activity - Performing Export (17:13)
- Lab Activity - Performing Import (13:50)
- Oracle Data Pump (6:20)
- Lab Activity - Create Data Pump Directory (6:23)
- Lab Activity - Performing Data Pump Export (8:29)
- Lab Activity - Performing Data Pump Import (10:49)
- Data Pump Automation
- Quiz - Test your knowledge!
- Interview Questions
Database Backup & Recovery
Available in
days
days
after you enroll
Oracle User Managed Backups
Available in
days
days
after you enroll
- Cold DB Backup and Recovery (12:35)
- Hot Database Backups (3:25)
- Lab Activity - How to Find DB Files Locations (3:31)
- Lab Activity - How to Take Hot DB Backup (9:24)
- Lab Activity - Hot Backup Important Queries (2:10)
- Understanding RESTORE and RECOVER (5:04)
- Quiz - Test your knowledge!
- Interview Questions
Oracle User Managed Recovery
Available in
days
days
after you enroll
Introduction to RMAN
Available in
days
days
after you enroll
Meet Your Instructor!
Hi there! I'm Arun Kumar, owner and instructor at DBA Genesis. I created this platform to share my DBA knowledge with all of you. My vision is to simplify DBA learning in order to make you become more competent in your professional career.
Apart from database, I love swimming, filming and business automation!