Autoplay
Autocomplete
HTML5
Flash
Player
Speed
Previous Lecture
Complete and continue
Oracle 11g DBA For Beginners
Before you start
Lets keep in touch!
Introduction to Database
Understanding Data Before Database (19:32)
What is a Database (22:55)
How a Database Function (11:01)
Quiz - Test your knowledge!
Interview Questions
Oracle 11g Architecture
User Connectivity in Oracle (23:16)
Phases of SQL Execution (5:18)
Select Statement Processing (15:04)
DML / DDL Statement Processing (22:05)
Oracle 11g Architecture Components (12:14)
Oracle Background Processes (12:09)
Oracle Files (14:49)
Quiz - Test your knowledge!
Interview Questions
Oracle 11g Software Installation
Downloading Oracle Database Software (0:50)
Database Installation Prerequisites (1:03)
Lab Activity – Pre Installation Tasks (6:17)
Lab Activity – Installing Oracle 11g Software (3:35)
Lab Activity – Post Installation Tasks (1:13)
Quiz - Test your knowledge!
Interview Questions
Oracle 11g Database Creation
Lab Activity – Setting Environment Variables (3:41)
Lab Activity – Create Database Using DBCA (4:04)
Lab Activity – Connecting to Database (3:42)
Lab Activity – Manual Database Creation (20:07)
Lab Activity – Deleting Database using DBCA (1:28)
Quiz - Test your knowledge!
Interview Questions
Navigating Oracle Database
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
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
Lab Activity – Get Tablespace Utilization (4:52)
Lab Activity – Create New Tablespace (8:02)
Lab Activity – Capacity Planning (8:50)
Quiz - Test your knowledge!
Interview Questions
User Administration
Users in Oracle (2:56)
Lab Activity – User Management (16:25)
Lab Activity – User Role Management (7:27)
Lab Activity – User Permission Management (8:21)
Profile Management in Oracle (6:32)
Lab Activity – Create Profile (9:39)
Quiz - Test your knowledge!
Interview Questions
Oracle Networking
Oracle 11g Client Installation on Windows (7:09)
Lab Activity – Configuring Linstener (10:13)
Lab Activity – Configuring TNS Entries (12:07)
Oracle DB Links (3:37)
Quiz - Test your knowledge!
Interview Questions
Oracle Utilities
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
Purpose of Backup & Recovery (8:13)
Oracle Backup and Recovery Solutions (9:23)
Quiz - Test your knowledge!
Interview Questions
Oracle User Managed Backups
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
Lab Activity - Recovery Through Loss of Parameter File (17:17)
Lab Activity - Recovery Through Loss of Control File (19:15)
Lab Activity - Recovery Through Loss of Entire Dtabase (1:31)
Quiz - Test your knowledge!
Interview Questions
Introduction to RMAN
What is RMAN - Recovery manager (9:15)
How to Connect RMAN Utility (1:37)
Lab Activity – User Permission Management
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock