Core DBA Traning 19c


  • What is DBA?

  • Why a Company needs a DBA?

  • Roles & Responsibilities of DBA

  • Oracle Architecture

  • Physical and Logical Phase of Database

  • Types of files(Control file, Redolog file and Datafile)

  • Different types of Datafiles

  • Instance

  • SGA(System Global Area) and Background Process

  • Different Startup Modes

  • Different Shutdown Modes

  • Types of Database Creation

  • Manual Method of Creation

  • Introduction to Table space

  • Types of Table space(BIG & SMALL)

  • Temporary Table space

  • Altering/Renaming a Table space

  • Renaming a data file

  • Temporary Groups

  • Table space Encryption(11g)

  • What are segments?

  • What are extents?

  • What is Blocks?

  • Oracle Blocks

  • Estimation of Extents

  • Dictionary Managed Table space

  • Locally Managed Table space

  • Storage Parameters(Initial, Next, Min Extents, Xtents, Pctincrease)

  • Who are Database Users?

  • Why to create a User?

  • Creation of Users

  • Assigning Privileges

  • Creating and granting Roles

  • Allocating table space Quotas to Users

  • Assigning default table space for the Users

  • Setting Profiles for the Users

  • Levels of Authentication

  • Schema Management(11g)

  • Security(11g)

  • What is Undo?

  • Why Undo required?

  • Pending offline status

  • Brief idea about Rollback segments

  • Flashback Features

  • Flashback Table

  • Flashback query

  • Flashback Version query

  • What is spfile?

  • Difference between spfile and pfile

  • Advantages of spfile

  • What is OMF?

  • Advantages of OMF

  • Files conventions of OMF

  • Introduction to Oracle Networking

  • Network default location

  • Editing Network file

  • Tnsnames.ora

  • Introduction to Database Links

  • Types of Database Links

  • Introduction to Materialized views

  • Advantages of Materialized view

  • Refresh Modes

  • Introduction to Redo log

  • Status of Redo logs

  • Multiplexing the Redo log files

  • Re-creation of Control file

  • Renaming the Database

  • Multiplexing the Control file

  • What is a logical backup

  • Why it is required

  • Export/import Utility

  • Data Pump

  • Difference between Data Pump and Traditional Export/import

  • Impdp/expdp

  • Transportable Table spaces

  • Introduction to Physical backup

  • Types of Physical backup

  • Cold & Hot backup

  • Recovery scenarios

  • RMAN backup

  • RMAN Point in time recovery

  • RMAN 11g new features

  • What is Performance Tuning?

  • Why Tuning required?

  • Types of Tuning

  • Database Tuning

  • Tuning

  • SQL Tuning

  • Memory Tuning

  • Network Tuning

  • Partitioning and Indexes

  • Partitioning Enhancements

  • AWR/ASH/ASMM/ADDM

  • RAT(Real Application Testing)(11g)

  • SQL Performance Analyses (11g)

  • Row Chaining and Row migration

  • Resemble Table spaces


Labels: