Oracle DBA – L1
 Oracle DBA training and certification – Focus training services |
Introduction Oracle DBA |
|
- Describe course objectives
- Explore the Oracle DBA (Oracle 11g & 12C database architecture)
|
|
Installing the Oracle Database Software |
|
- Explain core Oracle DBA tasks and tools
- Plan an Oracle DBA installation
- Use optimal flexible architecture
- Install software with the Oracle Universal Installer (OUI)
|
|
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
|
|
Managing the Oracle Instance |
|
- Start and stop the Oracle database and components
- Use Enterprise Manager (EM)
- Access a database with SQL*Plus and iSQL*Plus
- Modify database initialization parameters
- Understand the stages of database startup
- View the Alert log
- Use the Data Dictionary
|
|
Managing Database Storage Structures |
|
- Describe table data storage (in blocks)
- Define the purpose of tablespaces and data files
- Understand and utilize Oracle Managed Files (OMF)
- Create and manage tablespaces
- Obtain tablespace information
- Describe the main concepts and functionality of Automatic Storage Management (ASM)
|
|
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
|
|
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
|
|
Managing Data and Concurrency |
|
- Manage data through SQL
- Identify and administer PL/SQL Objects
- Describe triggers and triggering events
- Monitor and resolve locking conflicts
|
|
Managing Undo Data |
|
- Explain DML and undo data generation
- Monitor and administer undo
- Describe the difference between undo and redo data
- Configure undo retention
- Guarantee undo retention
- Use the undo advisor
|
|
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
|
|
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 versus dedicated servers
|
|
Proactive Maintenance |
|
- Use statistics
- Manage the Automatic Workload Repository (AWR)
- Use the Automatic Database Diagnostic Monitor (ADDM)
- Describe advisory framework
- Set alert thresholds
- Use server-generated alerts
- Use automated tasks
|
|
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
|
|
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
|
|
Performing Database Backups |
|
- Create consistent database backups
- Back your database up without shutting it down
- Create incremental backups
- Automate database backups
- Monitor the flash recovery area
|
|
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
|
|
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
|
|
Moving Data |
|
- Describe available ways for moving data
- Create and use directory objects
- Use SQL*Loader to load data from a non-Oracle database (or user files)
- Explain the general architecture of Data Pump
- Use Data Pump Export and Import to move data between Oracle databases
- Use external tables to move data via platform-independent files
Upcoming Batches Schedule
14th Dec 2020 | Regular | 7.30 am To 9.30 am |
19th Dec 2020 | Weekend | 10.30 am To 02.30 pm |
21st Dec 2020 | Regular | 7.30 am To 9.30 am |
26th Dec 2020 | Weekend | 10.30 am To 02.30pm |
This table shows all the upcoming batches for the month of December 2020.
Contact – Call us at 9372005897/ 8956930899 or fill out this form, and we will be happy to contact you back. |