|
Provided by: Cympac Software Solutions Pvt. Ltd. Oracle DBA Training Courses on LinuxOracle PL/SQL |
 |
Oracle DBA is certification oriented course which covers FIVE major parts as:
1. UNIX
2. PL/ SQL
3. DBA Admin Part1 on 11g
4. DBA Admin Part2 on 11g
5. Real Application Cluster (RAC)
Syllabus:
*** UNIX
Fundamentals
Architecture
Commands
File System
The vi Editor
The SHELL & Shell Scripting
***PL/ SQL
Creating and altering tables and views
Writing and running PL/ SQL programs from SQL*Plus or SQL Developer
Using SQL statements within PL/ SQL
Conditional execution and loop constructs
Triggers, Cursors
Trapping and handling errors and exceptions in code
Implementing nested and labeled loops and blocks
Exceptions
Handling PL/ SQL records and tables
***DBA Admin Part1 on 11g
Installing and Configuring Oracle
Creating and Managing Database Storage Structures
Managing Users, Profiles, Privileges and Roles
Maintaining Database Security
Monitoring the Performance of the Database
Backing Up and Recovering the Database
*** DBA Admin Part2 on 11g
Planning a backup strategy and a disaster recovery strategy
Altering a database to ARCHIVELOG and NOARCHIVELOG modes
Performing online and offline backups
Recovering a database from non-critical losses
Performing logical backups with the export and import utilities
Reviewing database logs for diagnostic purposes
Automating management tasks with the scheduler
***Real Application Cluster (RAC)
Installing and configuring an Oracle 10g RAC Database
Administering and Monitoring a RAC database using Enterprise Manager and command line tools
Using configuration and management tools for RAC databases
Administering ASM using command line and GUI clients
Setting up services for workload management and application high availability
Backing up, restoring and recovering a RAC database
Creating duplicate and standby databases in a RAC Environment
Monitoring and tuning the performance of a RAC database
Faculty:
We are having world class faculty having 8+ years of experience in the DBA field.
Two certifications are:
Paper I: OCA: Oracle Certified Associates
Paper II: OCP: Oracle Certified Professional
Duration of this course would be approx 5. 5-6 months.
Batch Timings would be
Morning :- 7 AM to 9AM
Evening :- 7 PM to 9PM
Contact Details:
Cympac Software Solutions Pvt. Ltd.
Email:
info@cympac. com
Web: www. cympac. com
1. UNIX
2. PL/ SQL
3. DBA Admin Part1 on 11g
4. DBA Admin Part2 on 11g
5. Real Application Cluster (RAC)
Syllabus:
*** UNIX
Fundamentals
Architecture
Commands
File System
The vi Editor
The SHELL & Shell Scripting
***PL/ SQL
Creating and altering tables and views
Writing and running PL/ SQL programs from SQL*Plus or SQL Developer
Using SQL statements within PL/ SQL
Conditional execution and loop constructs
Triggers, Cursors
Trapping and handling errors and exceptions in code
Implementing nested and labeled loops and blocks
Exceptions
Handling PL/ SQL records and tables
***DBA Admin Part1 on 11g
Installing and Configuring Oracle
Creating and Managing Database Storage Structures
Managing Users, Profiles, Privileges and Roles
Maintaining Database Security
Monitoring the Performance of the Database
Backing Up and Recovering the Database
*** DBA Admin Part2 on 11g
Planning a backup strategy and a disaster recovery strategy
Altering a database to ARCHIVELOG and NOARCHIVELOG modes
Performing online and offline backups
Recovering a database from non-critical losses
Performing logical backups with the export and import utilities
Reviewing database logs for diagnostic purposes
Automating management tasks with the scheduler
***Real Application Cluster (RAC)
Installing and configuring an Oracle 10g RAC Database
Administering and Monitoring a RAC database using Enterprise Manager and command line tools
Using configuration and management tools for RAC databases
Administering ASM using command line and GUI clients
Setting up services for workload management and application high availability
Backing up, restoring and recovering a RAC database
Creating duplicate and standby databases in a RAC Environment
Monitoring and tuning the performance of a RAC database
Faculty:
We are having world class faculty having 8+ years of experience in the DBA field.
Two certifications are:
Paper I: OCA: Oracle Certified Associates
Paper II: OCP: Oracle Certified Professional
Duration of this course would be approx 5. 5-6 months.
Batch Timings would be
Morning :- 7 AM to 9AM
Evening :- 7 PM to 9PM
Contact Details:
Cympac Software Solutions Pvt. Ltd.
Email:
info@cympac. com
Web: www. cympac. com
Related Software Programs or Products: Linux RHEL, Oracle 11g
Related Awards, Degrees or Certifications: OCA and OCP
Related Jobs or Careers: DBA, Admin, PL/SQL Admin
|
|
||||||||||||||||||||||||
Certificate Program
Provided by Cympac Software Solutions Pvt. Ltd.
- D asked: Dear Sir, I want to joing oracle DBA traingin courses please provide me courese fee, Co. No.& address
- V asked: I need a oracle DBA class
- A asked: telll me the fees and address of he institue
- A asked: sir, plz give me info. regarding to Database Addministrator means as criteria, course duration, fees and exact location in Pune. rply me as quick as possible
- K asked: I want to know about the dba course..simultaneously in window and linux background. and also about the fees structure. You can contact me on-
- P asked: Hiii i am intersted in this course can you send the details for this case and specially the name of Faculty.
- M asked: I am interested for course Oracle DBA on window/ linux. Please let me know the duration and fees for this course. Thanks
- S asked: I want DBA training course. Could you please send me the details like duration, price, timing and the course syllabus for further processing. I want immediate response. Thanks, santosh
- S asked: i want to inquiry about Oracal DBA , where is the branch in pune
- V asked: i would like to know the course structure and the fee when it starts the next batch is possible to come thr only for saturday at evening and sunday full day for that course
- S asked: Information on Oracle DBA course in Pune
- S asked: Please provide me with the Oracle DBA training Fees, and the training schedule (I mean the next batch starting).Also do share your number. Thanks and Regards,
- V asked: coures duration, how much amuont
- R asked: Dear Sir/ Madam, Plz provide me the information related to oracle g/ g(DBA)(Linux as well as Windows), preparation, timings, fee structure, placement etc. As well as provide me your address and contact details. Regards,
- V asked: I want join this course. plz some tell me about fee structure and more details about this. Plz call me on
- A asked: I would like to know the career of this program in detail and also what shall be the fees for it. Can it be done with job corresponding to it, if I have to join what are the basic skills I need to possess
- S asked: details on this course, fee involved, location....etc.
- M asked: Dear Sir/ Mam, I want certification of OCP in Oracle on Linux platform, so please send me details about this course and fees structure on my mail id as early as possible. Thanks, , . Mail_ID- com
- S asked: I would like to change my career from F & A to IT industry. I have work experience in Operations (FO & BO)in F & A processes in Consumer Banking, Foreign Exchange, Insurance and related AR processes. I am a graduate in Science without Computers. The applications generally used for Database processes are Oracle, Java... Academics : Degree (B. Sc.)completed with gold medals. I can be dedicated for studies. Companies worked : Bank of America, Thomas Cook , EXL and STERIA (Current Employer)...worked almost for an year in every organisation. I would like to go for a transition now and would want to start a career as a DBA. Would that be a wise decision? Will it be easier for me to learn Oracle DBA g on LINYX / UNIX ? Will i be able to become a DBA?
- P asked: Need more information on the course as well as the fee structure
- V asked: i m interested in oracle dba kindly send me fees structure
- V asked: Hi, Please send me the course fee details and batches timing etc for Oracle g OCA & OCP certifications.
- N asked: Dear , i am working as oraclei dba for a consultancy. Would like to update myself on g .Would appriciate if you could provide some more detail of g upgrade course with fee structure. thanks
Oracle DBA Training Courses on Linux
*** UNIX
-Fundamentals
-Architecture
-Commands
-File System
-The vi Editor
-The SHELL & Shell Scripting
***PL/ SQL
-Creating and altering tables and views
-Writing and running PL/ SQL programs from SQL*Plus or SQL Developer
-Using SQL statements within PL/ SQL
-Conditional execution and loop constructs
Triggers, Cursors
-Trapping and handling errors and exceptions in code
-Implementing nested and labeled loops and blocks
Exceptions
-Handling PL/ SQL records and tables
Oracle 11g Administrator I
-Installing the Oracle Database Software
-Installation: System Requirements
-Checking the System Requirements
-Optimal Flexible Architecture (OFA)
-Setting Environment Variables
-Installing the Oracle Software
Creating an Oracle Database
-Database Configuration Assistant (DBCA)
-Using the DBCA to Create a Database
Managing the Oracle Instance
-Starting and Stopping Database Control
-Oracle Enterprise Manager
Managing Database Storage Structures
-How Table Data Is Stored
-Tablespaces and Data Files
-Space Management in Tablespaces
-What Is Automatic Storage Management?
-ASM: Key Features and Benefits
-ASM: Concepts
Administering User Security
-Database User Accounts
-Authenticating Users
-Administrator Authentication
-Unlocking a User Account and Resetting the Password
-Creating a Password Profile
Managing Schema Objects
-What Is a Schema?
-Accessing Schema Objects
-Naming Database Objects
-Types of Indexes
-B-Tree Index
-Bitmap Indexes
-What Is a View?
-Creating Views
-Sequences
-Creating a Sequence
-Data Dictionary:
-Data Dictionary Views
Managing Data and Concurrency
-Manipulating Data Through SQL
Managing Undo Data
-Data Manipulation
-Undo Data
-Undo Data Versus Redo Data
-Configuring Undo Retention
-Guaranteeing Undo Retention
Implementing Oracle Database Security
-Database Security
-Standard Database Auditing
-Uniform Audit Trails
-Value-Based Auditing
-Fine-Grained Auditing
-DBA Auditing
Configuring the Oracle Network Environment
-Oracle Net Services
-Oracle Net Listener
-Establishing Net Connections
-Establishing a Connection
-Naming Methods
Proactive Maintenance
-Optimizer Statistics
-Using the Manage Optimizer Statistics
-Automatic Workload Repository (AWR)
-Automatic Database Diagnostic Monitor (ADDM)
-Enterprise Manager and Advisors
Performance Management
-Performance Monitoring
-SQL Tuning Advisor:
-Enabling Automatic Shared Memory Management (ASMM)
-Using the Memory Advisor
Oracle 11g Administrator II
Backup and Recovery Concepts
Performing Database Backups
-Oracle Secure Backup
-User-Managed Backup
-Recovery Manager (RMAN)
-Managing Backups
Performing Database Recovery
Performing Flashback
-When to Use the Flashback Technology
Moving Data
-Loading Methods
-Data Pump:
-Data Pump Export and Import:
-Data Pump Utility
-External Table Population with ORACLE_DATAPUMP
-External Table Population with ORACLE_LOADER
Configuring Recovery Manager
Using Recovery Manager
Database Recovery
Flashback
Dealing With Database Curruption
Monitoring and Managing Memory
-Memory Management
-How ASMM Works and how to Configure
Autumatic Performance Management
-Tuening Activity
-Performance Planning
-Statics collection
-Troubleshooting and Tuening
-Database Control and Advisor
Managing Storage
-Space Management
-Extends Typs
-Row Chaning and Migretion
-Monitoring Tablespace
-Transporting Tablespace
-Transporting Database
Automatic Storage Management
-ASM Architecture
-Creating ASM Instance
-ASM Storage
-Disk Group Mirroring
-ASM files
-Migreting Database to ASM instance
Real Application Cluster (RAC)
-Installing and configuring an Oracle 10g RAC Database
-Administering and Monitoring a RAC database using Enterprise Manager and command line tools
-Using configuration and management tools for RAC databases
-Administering ASM using command line and GUI clients
-Setting up services for workload management and application high availability
-Backing up, restoring and recovering a RAC database
-Creating duplicate and standby databases in a RAC Environment
-Monitoring and tuning the performance of a RAC database
-Fundamentals
-Architecture
-Commands
-File System
-The vi Editor
-The SHELL & Shell Scripting
***PL/ SQL
-Creating and altering tables and views
-Writing and running PL/ SQL programs from SQL*Plus or SQL Developer
-Using SQL statements within PL/ SQL
-Conditional execution and loop constructs
Triggers, Cursors
-Trapping and handling errors and exceptions in code
-Implementing nested and labeled loops and blocks
Exceptions
-Handling PL/ SQL records and tables
Oracle 11g Administrator I
-Installing the Oracle Database Software
-Installation: System Requirements
-Checking the System Requirements
-Optimal Flexible Architecture (OFA)
-Setting Environment Variables
-Installing the Oracle Software
Creating an Oracle Database
-Database Configuration Assistant (DBCA)
-Using the DBCA to Create a Database
Managing the Oracle Instance
-Starting and Stopping Database Control
-Oracle Enterprise Manager
Managing Database Storage Structures
-How Table Data Is Stored
-Tablespaces and Data Files
-Space Management in Tablespaces
-What Is Automatic Storage Management?
-ASM: Key Features and Benefits
-ASM: Concepts
Administering User Security
-Database User Accounts
-Authenticating Users
-Administrator Authentication
-Unlocking a User Account and Resetting the Password
-Creating a Password Profile
Managing Schema Objects
-What Is a Schema?
-Accessing Schema Objects
-Naming Database Objects
-Types of Indexes
-B-Tree Index
-Bitmap Indexes
-What Is a View?
-Creating Views
-Sequences
-Creating a Sequence
-Data Dictionary:
-Data Dictionary Views
Managing Data and Concurrency
-Manipulating Data Through SQL
Managing Undo Data
-Data Manipulation
-Undo Data
-Undo Data Versus Redo Data
-Configuring Undo Retention
-Guaranteeing Undo Retention
Implementing Oracle Database Security
-Database Security
-Standard Database Auditing
-Uniform Audit Trails
-Value-Based Auditing
-Fine-Grained Auditing
-DBA Auditing
Configuring the Oracle Network Environment
-Oracle Net Services
-Oracle Net Listener
-Establishing Net Connections
-Establishing a Connection
-Naming Methods
Proactive Maintenance
-Optimizer Statistics
-Using the Manage Optimizer Statistics
-Automatic Workload Repository (AWR)
-Automatic Database Diagnostic Monitor (ADDM)
-Enterprise Manager and Advisors
Performance Management
-Performance Monitoring
-SQL Tuning Advisor:
-Enabling Automatic Shared Memory Management (ASMM)
-Using the Memory Advisor
Oracle 11g Administrator II
Backup and Recovery Concepts
Performing Database Backups
-Oracle Secure Backup
-User-Managed Backup
-Recovery Manager (RMAN)
-Managing Backups
Performing Database Recovery
Performing Flashback
-When to Use the Flashback Technology
Moving Data
-Loading Methods
-Data Pump:
-Data Pump Export and Import:
-Data Pump Utility
-External Table Population with ORACLE_DATAPUMP
-External Table Population with ORACLE_LOADER
Configuring Recovery Manager
Using Recovery Manager
Database Recovery
Flashback
Dealing With Database Curruption
Monitoring and Managing Memory
-Memory Management
-How ASMM Works and how to Configure
Autumatic Performance Management
-Tuening Activity
-Performance Planning
-Statics collection
-Troubleshooting and Tuening
-Database Control and Advisor
Managing Storage
-Space Management
-Extends Typs
-Row Chaning and Migretion
-Monitoring Tablespace
-Transporting Tablespace
-Transporting Database
Automatic Storage Management
-ASM Architecture
-Creating ASM Instance
-ASM Storage
-Disk Group Mirroring
-ASM files
-Migreting Database to ASM instance
Real Application Cluster (RAC)
-Installing and configuring an Oracle 10g RAC Database
-Administering and Monitoring a RAC database using Enterprise Manager and command line tools
-Using configuration and management tools for RAC databases
-Administering ASM using command line and GUI clients
-Setting up services for workload management and application high availability
-Backing up, restoring and recovering a RAC database
-Creating duplicate and standby databases in a RAC Environment
-Monitoring and tuning the performance of a RAC database
About The Training Provider: Cympac Software Solutions Pvt. Ltd.
Cympac Software Solutions Pvt. Ltd. - Cympac Software Solutions Pvt Ltd is a high end full service IT solution Company based in India. Established in 2005, we're pioneer in providing total offshore and onshore web based solutions for small to large corporate companies. Today we are comprised of a team of programming technicians, designers, and marketing executives- selectively chosen to lead our clients in their IT solutions.
...
