Oracle Dba Tutorial

Oracle Tutorial

  • Oracle Tutorial / Course main topics:

    ENTERPRISE EDITION INSTALLATION
    • IDENTIFY SYSTEM REQUIREMENTS
    • THE OPTIMAL FLEXIBLE ARCHITECTURE (OFA)
    • ORACLE_BASE
    • ORACLE_HOME
    • CONFIGURE THE INSTALLATION ENVIRONMENT
    • ENTERPRISE EDITION INSTALLATION • DBCA

    THE ADMINISTRATOR INTERFACE
    • ENTERPRISE MANAGER TOUR
    • USING EM SQL WORKSHEET
    • DUTIES OF A DATABASE ADMINISTRATOR
    • EXPLORING THE ORACLE DATABASE ARCHITECTURE: GENERAL

    THE ORACLE ENTERPRISE ARCHITECTURE

    EXPLORING THE ORACLE DATABASE ARCHITECTURE: INSTANCE MEMORY
    • WHAT IS AN ORACLE DATABASE INSTANCE?
    • MORE ABOUT THE SYSTEM GLOBAL AREA (SGA)
    • ABOUT THE PGA • MANAGING MEMORY

    EXPLORING THE ORACLE DATABASE ARCHITECTURE: INSTANCE PROCESSES
    • INSTANCE BACKGROUND PROCESSES
    • SQL EXECUTION PROCESSES

    CREATING AN ORACLE DATABASE
    • CREATE A NEW DATABASE
    • CONFIGURE AN EXISTING DATABASE
    • DROP A DATABASE
    • MANAGE DBCA TEMPLATES
    • MANUALLY CREATE A DATABASE

    MANAGING THE DATABASE INSTANCE
    • CONFIGURING A LINUX ENVIRONMENT
    • STARTING & STOPPING DATABASE CONTROL
    • STARTING & STOPPING THE DATABASE LISTENER
    • STARTING & STOPPING THE DATABASE INSTANCE
    • MORE ABOUT THE DATABASE FILES

    MANAGE DATABASE STORAGE STRUCTURES: TABLESPACES
    • ABOUT TABLESPACES
    • TABLESPACE MANAGEMENT
    • DROP TABLESPACE
    • ALTER TABLESPACE

    MANAGE DATABASE STORAGE STRUCTURES: ADVANCED TABLESPACES
    • MORE ABOUT TEMPORARY TABLESPACES
    • ABOUT TEMPORARY TABLESPACE GROUPS
    • MORE ABOUT PERMANENT TABLESPACES
    • MORE ABOUT BIGFILE TABLESPACES
    • MORE ABOUT THE SYSAUX TABLESPACE

    MANAGE DATABASE STORAGE STRUCTURES
    • DATA FILES & TEMP FILES
    • MANAGING DATA FILES
    • MANAGING TEMP FILES
    • ENABLE ORACLE-MANAGED FILES (OMF)

    MANAGING UNDO DATA
    • ABOUT UNDO SPACE MANAGEMENT
    • CONFIGURE AUTOMATIC UNDO MANAGEMENT
    • UNDO_MANAGEMENT
    • UNDO_TABLESPACE
    • UNDO_RETENTION
    • GUARANTEE UNDO RETENTION
    • MONITOR UNDO SPACE
    • USE THE UNDO ADVISOR

    NETWORK ENVIRONMENT: ORACLE SHARED SERVERS
    • SHARED SERVERS ARCHITECTURE
    • CONFIGURE SHARED SERVERS
    • MONITOR SHARED SERVERS
    • V$SHARED_SERVER
    • V$SHARED_SERVER_MONITOR
    • V$SESSION
    • V$CIRCUIT
    • V$DISPATCHER & V$DISPATCHER_CONFIG
    • V$QUEUE

    SECURITY: IMPLEMENTING DATABASE SECURITY
    • DATABASE SYSTEM PRIVILEGES
    • DATABASE OBJECT PRIVILEGES
    • ADMINISTRATOR AUDITING OF DATABASE ACTIVITY
    • ENHANCED DEFAULT SECURITY SETTINGS

    SECURITY: ADMINISTERING USER SECURITY
    • CREATE & MANAGE DATABASE ACCOUNTS
    • GRANT & REVOKE DATABASE PRIVILEGES
    • RESOURCE LIMITS VIA PROFILES
    • ALTER PROFILE
    • DROP PROFILE
    • PASSWORD MANAGEMENT VIA PROFILES
    • ABOUT ROLE-BASED SECURITY
    • WITH ADMIN OPTION
    • ALTER USER…DEFAULT ROLE
    • SET ROLE
    • ENHANCED DEFAULT SECURITY SETTINGS

    MOVING DATA: SQL LOADER
    • LOADER CONCEPTS
    • CONTROL FILE OPTIONS
    • LOAD METHODS
    • USING THE EM INTERFACE

    MOVING DATA: EXPORT & IMPORT
    • MANAGE DIRECTORY OBJECTS
    • ABOUT THE DATA PUMP ARCHITECTURE
    • DATA PUMP EXPORT
    • DATA PUMP IMPORT
    • DATA PUMP DATA DICTIONARY VIEWS
    • USING THE EM INTERFACE

    DATABASE MAINTENANCE & PERFORMANCE MANAGEMENT
    • THE MANAGEMENT & ADVISORY FRAMEWORK
    • MANAGE THE AUTOMATIC WORKLOAD REPOSITORY
    • AUTOMATIC DATABASE DIAGNOSTIC MONITOR
    • USE METRICS & ALERT THRESHOLDS
    • AUTOMATIC MAINTENANCE TASKS

    MANAGING CONCURRENCY & LOCKS
    • ABOUT LATCHES & LOCKS
    • MANAGE & MONITOR LATCHES
    • MANAGE & MONITOR LOCKS
    • V$LOCK
    • V$LOCKED_OBJECT
    • V$SESSION
    • V$SESSION_WAIT
    • DBA_BLOCKERS & DBA_WAITERS
    • DBA_DML_LOCKS & DBA_DDL_LOCKS
    • DML_LOCKS

    BACKUP & RECOVERY CONCEPTS & CONFIGURATION
    • ABOUT DATABASE BACKUP & RECOVERY STRUCTURES
    • MANAGING REDO DATA
    • MANAGING ARCHIVAL DATA
    • AUTOMATIC CRASH RECOVERY
    • CREATING A BASIC BACKUP STRATEGY


  • Oracle Tutorial for beginners. This video tutorial helps to understand and learn Oracle in few minutes. Once you are done with this introduction tutorial you will get the basic understanding of Oracle and then you can goto detailed tab to become an Oracle expert.

    The following video gives the Oracle fundamentals. Simple fast easy Oracle learning.

  • Oracle tutorial detailed topic wise explanation videos.

  • PL/SQL Oracle tutorial, Oracle introduction, PL/SQL basics:

    Codepen Oracle application example:

    See the Pen Oracle instant search example demo by Shahansha shaik (@shahansha) on CodePen.


  • Top Oracle Interview Questions:


  • Oracle Quick reference pdf and guide:


  • Oracle references and useful links:
    Oracle self learning tutorial – Click here

    Topic link
    Learn Oracle in PDF Click here
    Oracle Official website : http://www.oracle.com/index.html
    Official Oracle tutorial: https://www.w3.org/
    Self learning Oracle tutorials: http://www.oracle.com/technetwork/tutorials/index.html
    Oracle cheat Sheet: Click here