Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Oracle 11g DBA For Beginners
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 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)
Quiz - Test your knowledge!
Complete and Continue