Oracle 11g DBA For Beginners
Administer the most stable Oracle database version
Count
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
Introduction to Database
19:32
What is Data?
22:55
What is a Database?
11:01
How a Database Function
Oracle 11g Architecture
23:16
User Connectivity in Oracle
05:18
Phases of SQL Execution
15:04
Select Statement Processing
22:05
DML / DDL Statement Processing
12:14
Oracle Architecture Components
12:09
Oracle Background Processes
14:49
Oracle Files
Oracle 11g Software Installation
00:50
Download Oracle 11g
01:03
Installation Prerequisites
06:17
Pre Install Tasks
03:35
Install Oracle 11g
01:13
Post Install Tasks
Oracle 11g Database Creation
03:41
Set Environment Variables
04:04
DBCA Create Database
03:42
Connect Database
20:07
Manual DB Creation
01:28
DBCA Delete Database
Navigating Oracle Database
06:02
Database Metadata
04:33
Basic Views You Must Know
13:21
Key Database Files
06:38
Database Storage Structures
06:50
Datafiles Metadata
09:20
Tablespace Metadata
Basic Database Administration
11:45
Database Operating Modes
01:24
DB Startup & Shutdown
02:00
Multiplexing of Database Files
07:35
Multiplexing Control Files
05:39
Multiplexing Redolog Files
09:43
Database Archivelog Mode
Tablespace Administration
04:52
Tablespace Utilization
08:02
Create New Tablespace
08:50
Capacity Planning
User Administration
02:56
Users in Oracle
16:25
User Management
07:27
User Role Management
08:21
User Permission Management
06:32
Profile Management
09:39
Create User Profile
Oracle Networking
07:09
Install Oracle 11g Client
10:13
Configuring Listener
12:07
Configuring TNS Entries
03:37
Oracle DB Links
Oracle Utilities
03:38
SQL * Loader
11:53
Import csv into Table
08:07
Oracle Export Import
17:13
Performing Export
13:50
Performing Import
06:20
Oracle Data Pump
06:23
Data Pump Directory
08:29
Data Pump Export
10:49
Data Pump Import
Database Backup & Recovery
08:13
Why Backup & Recovery?
09:23
Backup & Recovery Solutions
Oracle User Managed Backups
12:35
Cold DB Backup and Recovery
03:25
Hot Database Backups
03:31
Find DB Files Location
09:24
Taking Hot DB Backup
02:10
Hot Backup Queries
05:04
RESTORE vs RECOVER
Oracle User Managed Recovery
17:17
Parameter File Recovery
19:15
Control File Recovery
01:31
Entire Database Recovery
Introduction to RMAN
09:15
What is RMAN?
01:37
How to Connect RMAN Utility