Hands-on Oracle DBA Workshop by experienced professional
Learn the intricacies of database management from an expert who knows the subject and does it in front of you, full handson! No ppt , No Theory .. only practical!!!
Due to popular demand, weekend batches start every month. 1. Installing the Oracle Database Software * Explain core DBA tasks and tools * Plan an Oracle installation * Use optimal flexible architecture * Install software with Oracle Universal Installer (OUI) 2. Creating an Oracle Database * Create a database with the Database Configuration Assistant (DBCA) * Create a database design template with the DBCA * Generate database creation scripts with the DBCA 3. Managing the Oracle Instance * Start and stop the Oracle database & components * Use Enterprise Manager (EM) * Access database with SQL*Plus & iSQL*Plus * Modify database initialization parameters * Understand the stages of database startup * View the Alert log * Use the Data Dictionary 4. Managing Database Storage Structures * Describe table data storage (in blocks) * Define the purpose of tablespaces & data files * Understand & utilize Oracle Managed Files (OMF) * Create and manage tablespaces * Obtain tablespace information * Describe the main concepts and functionality of Automatic Storage Management (ASM) 5. Administering User Security * Create and manage database user accounts * Authenticate users * Assign default storage areas (tablespaces) * Grant and revoke privileges * Create and manage roles * Create and manage profiles * Implement standard password security features * Control resource usage by users 6. Managing Schema Objects * Define schema objects and data types * Create and modify tables * Define constraints * View the columns and contents of a table * Create indexes, views and sequences * Explain the use of temporary tables * Use the Data Dictionary 7. Managing Data and Concurrency * Manage data through SQL * Identify and administer PL/SQL Objects * Describe triggers and triggering events * Monitor and resolve locking conflicts 8. Managing Undo Data * Explain DML and undo data generation * Monitor and administer undo * Describe the difference between undo & redo data * Configure undo retention * Guarantee undo retention * Use the undo advisor 9. Implementing Oracle Database Security * Describe DBA responsibilities for security * Apply the principal of least privilege * Enable standard database auditing * Specify audit options * Review audit information * Maintain the audit trail 10. Configuring the Oracle Network Environment * Use Enterprise Manager for configuring the Oracle network environment * Create additional listeners * Create Net Service aliases * Configure connect-time failover * Control the Oracle Net Listener * Test Oracle Net connectivity * Identify when to use shared vs dedicated servers 11. Proactive Maintenance * Use statistics * Manage Automatic Workload Repository (AWR) * Use Automatic Database Diagnostic Monitor (ADDM) * Describe advisory framework * Set alert thresholds * Use server-generated alerts * Use automated tasks 12. Performance Management * Use Enterprise Manager pages to monitor performance * Use the SQL Tuning Advisor * Use the SQL Access Advisor * Use Automatic Shared Memory Management * Use the Memory Advisor to size memory buffers * Use performance related dynamic views * Troubleshoot invalid or unusable objects 13. Backup and Recovery Concepts * Identify the types of failure that may occur in an Oracle Database * Describe ways to tune instance recovery * Identify the importance of checkpoints, redo log files, and archived log files * Configure ARCHIVELOG mode 14. Performing Database Backups * Create consistent database backups * Back your database up without shutting down * Create incremental backups * Automate database backups * Monitor the flash recovery area 15. Performing Database Recovery * Recover from loss of a control file * Recover from loss of a redo log file * Perform complete recovery following the loss of a data file 16. Performing Flashback * Describe Flashback database * Restore the table content to a specific point in the past with Flashback Table * Recover from a dropped table * View the contents of the database as of any single point in time with Flashback Query * See versions of a row over time with Flashback Versions Query * View the transaction history of a row with Flashback Transaction Query Duration: 30hrs What you get: 1) Hands-on practice of concepts discussed in class 2) Participation certificate from Oracle 3) Courseware from Oracle 4) Option to appear for Oracle Certification exam About the Trainer: The trainer is a IT Professional with vast experience of working in the Oracle DBA in large MNC company. Venue: South City Mall; Prince Anwarsah Road & Salt Lake Cost: Call us Contact: Shrabana@84205 94969 www.paliumtrainings.biz www.paliumskills.in
|Ticket Information ||Ticket Price |
| General || USD 195|