Database Administration syllabus

Database Administration

• 1 Introduction (10 LHs)

  • Oracle Database overview and relational database concepts
  • Oracle architecture, instance, memory, processes and storage
  • DBA roles and responsibilities
  • Oracle Data Guard, RAC, ASM and Cloud
  • Connecting to and administering an Oracle instance
  • SQL*Plus and SQL Developer
  • Tables, constraints, indexes, views, synonyms and sequences
  • Partitioning and materialized views
  • Enterprise Manager and initialization parameter files
• 2 Tablespace and Storage Structures (4 LHs)

  • Data storage and database blocks
  • Tablespaces and datafiles
  • Control files, online redo logs and archive logs
  • Multiplexing
• 3 Managing Users, Roles, and Privileges (5 LHs)

  • Administration and user accounts, authentication and passwords
  • Managing and monitoring accounts and sessions
  • Schema-only accounts
  • Database access and Oracle supplied roles
  • System and object privileges; GRANT and REVOKE
  • Creating, modifying and dropping roles; PL/SQL and roles
• 4 User Profiles, Resources, and Auditing (4 LHs)

  • User profiles and resource parameters
  • Password management and resource usage with profiles
  • Database security, auditing and compliance
  • Standard auditing and unified audit trail
  • AUDIT_ADMIN and AUDIT_VIEWER responsibilities
  • Configuring audit trail and options
• 5 Configuration of Oracle Network Environment (5 LHs)

  • Network configuration and Oracle Net listener
  • Oracle Net naming methods
  • Net Configuration Assistant and Net Manager
  • Listener configuration and operation
  • TNSPING and database connectivity
  • Net services with Enterprise Manager
• 6 Concurrency, Backup, and Recovery (8 LHs)

  • Locks, concurrency and contention
  • Detecting and resolving lock conflicts
  • Undo data, retention and tablespaces
  • Flashback queries and Undo Advisor
  • Backup, restoration and recovery strategies
  • Data Pump and user-managed backup and recovery
  • RMAN configuration, backups and restore
  • High availability and multitenant architecture
  • CDB and PDB flashback
• 7 Database Maintenance, Performance Management, and Moving Data (8 LHs)

  • Alert log, AWR, statistics and diagnostics
  • Monitoring, advisors and notification rules
  • Explain plan, plan hash value and gather stats
  • Performance monitoring and tuning methodology
  • Memory management and private temporary tables
  • SQL tuning, optimizer, adaptive execution plans and advisors
  • Data Pump exports and imports
  • SQL Loader and external tables
• 8 Managing Resources and Scheduling Tasks (4 LHs)

  • Database Resource Manager and resource plans
  • Resource plan directives and allocation
  • Scheduler access, components and workflow
  • Jobs, job classes and time- or event-based schedules