Join our DBA course & Get a chance to work on indusrty oriented LIVE projects.

DBA Syllabus

Register for free
  1. Introduction Oracle DBA
  2. Explore the Oracle 10g database architecture
  3. Core DBA tasks and tools
  4. Plan an Oracle installation
  5. Use optimal flexible architecture
  6. Install software with the Oracle Universal Installer (OUI)
  7. Creating an Oracle Database
  8. Managing the Oracle Instance
  9. Table data storage (in blocks)
  10. Purpose of tablespaces and data files
  11. Understand and utilize Oracle Managed Files (OMF)
  12. Create and manage tablespaces
  13. Obtain tablespace information
  14. Create and manage database user accounts
  15. Authenticate users
  16. Assign default storage areas (tablespaces)
  17. Grant and revoke privileges
  18. Create and manage roles
  19. Create and manage profiles
  20. Schema objects and data types
  21. Create and modify tables
  22. Constraints
  23. View the columns and contents of a table
  24. Create indexes, views and sequences
  25. Manage data through SQL
  26. Monitor and resolve locking conflicts
  27. DML and undo data generation
  28. Monitor and administer undo
  29. Configure undo retention
  30. Enable standard database auditing
  31. DBA responsibilities for security
  32. Review audit information