Oracle Administration (DBA)
Oracle DBA [Database Administration] course is intended for those who wish to learn database and Database Administration’s. Build your career as an Oracle DBA on a firm foundation of sound practices and technical knowledge. This course gives strong foundation and expertise in the industry’s most advanced database management system.Install Oracle Grid Infrastructure Install and configure Oracle Database 11g Configure Oracle Net services Monitor and administer undo data Manage the database storage structures Create and administer user accounts Perform basic backup and recovery of a database Manage data concurrency Monitor performance Describe Oracle Database Architecture
Who Should Attend?
Basic Computer Knowledge
Basic knowledge about Software’s
Oracle Database: SQL & PL/SQL.
Module I - SQL [Structured Query Language]Introduction about Database. Retrieving Data Using the SQL SELECT Statement Restricting and Sorting Data Using Single-Row Functions to Customize Output Using Conversion Functions and Conditional Expressions Reporting Aggregated Data Using the Group Functions Displaying Data from Multiple Tables Using Sub queries to Solve Queries Using the Set Operators Manipulating Data Using DDL Statements to Create and Manage Tables Creating Other Schema Objects
Module II – Admin IArchitecture Installing the Oracle Database Software Creating an Oracle Database Managing the Oracle Instance Managing Database Storage Structures Administering User Security Managing Schema Objects Managing Data and Concurrency Managing Undo Data Implementing Oracle Database Security Configuring the Oracle Network Environment Proactive Maintenance Performance Management Backup and Recovery Concepts Performing Database Backup Performing Database Recovery Performing Flashback Moving Data
Module III – Admin IIUsing Globalization Support Objectives Configuring Recovery Manager Recovering from User Errors Dealing with Database Corruption Automatic Database Management Using Recovery Manager Recovering from Non-Critical Losses Monitoring and Managing Storage Automatic Storage Management Monitoring and Managing Memory Database Recovery Flashback Database Managing Resources Automating Tasks with the Scheduler
Benefits of Attending
High quality of trainings from Certified Expert Trainers Free personal/Corporate course Customization Guarantee Flexible Days and Timings We encourage you to speak to our trainers before booking to ensure that the requested course
will exactly match the background and project needs of the participant, and that
we can customize the course contents as much as possible to meet those project objectives All class rooms are well equipped with latest computers and networks We take special care to assure high quality of training to our corporate, personal clients post training support [ Email, phone, or personal] Printed Course materials and Certificate of Completion Most VALUE for Money
To know the current Course Fees, kindly contact us +973 1753 0775,6660 0550.