際際滷

際際滷Share a Scribd company logo
Payilagam Software Training Institute

Payilagam Software Training Institute,
No:4/67E, Sri Balajis Ishwarya,
Vijaya Nagar 3rd Cross Street, Velachery, Chennai  600042.
044-22592370, 8344777333, 8883775533.
Mail : info@payilagam.com, Website : www.payilagam.com
ORACLE DBA
1.
2.
3.
4.
5.

Introduction to SQL
Administration I
Administration II
Performance and Tuning
Linux

1. Introduction to SQL














1

Introduction.
Writing a Basic SQL Statement.
Restricting and Sorting Data.
Single Row Functions.
Displaying Data from Multiple Tables.
Reporting aggregated Data.
Writing Sub Queries.
Manipulating Data.
Creating and Managing Tables.
Including Constraints.
Creating Views.
Other Database Objects.
Using Set Operators.

Payilagam Software Training Institute | www.payilagam.com | 83 44 777 333 | 8883 77 55 33
|
Payilagam Software Training Institute

2. Oracle 11g Administration I


















Introduction.
Oracle Architectural Components.
Getting started with the Oracle Server.
Database Startup.
Managing an Oracle Instance.
Creating a Database.
Using the Data Dictionary.
Maintaining the Control File.
Maintaining Redo Log Files.
Managing Tablespaces and Data Files.
Storage Structures and Relationships.
Create and Manage Oracle Users.
Managing Undo Data.
Managing Indexes.
Profiles and Resources.
Managing Privileges.
Managing Roles.

3. Oracle 11g Administration II













2

Backup and Recovery Overview.
User-Managed Backups.
User-Managed Incomplete & Complete Recovery.
RMAN Overview and Configuration.
RMAN Backups.
RMAN Incomplete & Complete Recovery.
RMAN Repository Maintenance.
RMAN Catalog Creation and Usage.
Auxiliary Database Creation.
Oracle Net Architecture.
Oracle Net services Server & Client Side.
Datapumping.
Export & Import.

Payilagam Software Training Institute | www.payilagam.com | 83 44 777 333 | 8883 77 55 33
|
Payilagam Software Training Institute



Flashback Method.
Logminer.

4. Performance and Tuning


















Overview of Oracle Performance Tuning.
Sql Query Tuning (Explain plan, Auto Trace)
Statspack Method.
Shared Pool Tuning.
Checkpoint Tuning.
Sizing the Buffer Cache.
Sizing other SGA Structures.
Disk I/O Tuning.
Sort Area Tuning.
Automatic PGA Memory Management (APMM).
Automatic Shared Memory Management (ASMM).
ADDM, AWR Report.
SQL Statement Tuning.
Database Migration and Upgradation.
Oracle Locks.
Using Oracle Blocks Efficiency.
Oracle Patching.

5. LINUX




Linux Installation.
Oracle Installation in Linux & Windows.
Linux Commands to Operate Oracle Database.

Warm Regards
Payilagam software training institute,
8344777333, 8883775533.
Mail: info@payilaga.com
Website: www.payilagam.com
3

Payilagam Software Training Institute | www.payilagam.com | 83 44 777 333 | 8883 77 55 33
|
Payilagam Software Training Institute

4

Payilagam Software Training Institute | www.payilagam.com | 83 44 777 333 | 8883 77 55 33
|

More Related Content

Payilagam oracle dba training syllabus

  • 1. Payilagam Software Training Institute Payilagam Software Training Institute, No:4/67E, Sri Balajis Ishwarya, Vijaya Nagar 3rd Cross Street, Velachery, Chennai 600042. 044-22592370, 8344777333, 8883775533. Mail : info@payilagam.com, Website : www.payilagam.com ORACLE DBA 1. 2. 3. 4. 5. Introduction to SQL Administration I Administration II Performance and Tuning Linux 1. Introduction to SQL 1 Introduction. Writing a Basic SQL Statement. Restricting and Sorting Data. Single Row Functions. Displaying Data from Multiple Tables. Reporting aggregated Data. Writing Sub Queries. Manipulating Data. Creating and Managing Tables. Including Constraints. Creating Views. Other Database Objects. Using Set Operators. Payilagam Software Training Institute | www.payilagam.com | 83 44 777 333 | 8883 77 55 33 |
  • 2. Payilagam Software Training Institute 2. Oracle 11g Administration I Introduction. Oracle Architectural Components. Getting started with the Oracle Server. Database Startup. Managing an Oracle Instance. Creating a Database. Using the Data Dictionary. Maintaining the Control File. Maintaining Redo Log Files. Managing Tablespaces and Data Files. Storage Structures and Relationships. Create and Manage Oracle Users. Managing Undo Data. Managing Indexes. Profiles and Resources. Managing Privileges. Managing Roles. 3. Oracle 11g Administration II 2 Backup and Recovery Overview. User-Managed Backups. User-Managed Incomplete & Complete Recovery. RMAN Overview and Configuration. RMAN Backups. RMAN Incomplete & Complete Recovery. RMAN Repository Maintenance. RMAN Catalog Creation and Usage. Auxiliary Database Creation. Oracle Net Architecture. Oracle Net services Server & Client Side. Datapumping. Export & Import. Payilagam Software Training Institute | www.payilagam.com | 83 44 777 333 | 8883 77 55 33 |
  • 3. Payilagam Software Training Institute Flashback Method. Logminer. 4. Performance and Tuning Overview of Oracle Performance Tuning. Sql Query Tuning (Explain plan, Auto Trace) Statspack Method. Shared Pool Tuning. Checkpoint Tuning. Sizing the Buffer Cache. Sizing other SGA Structures. Disk I/O Tuning. Sort Area Tuning. Automatic PGA Memory Management (APMM). Automatic Shared Memory Management (ASMM). ADDM, AWR Report. SQL Statement Tuning. Database Migration and Upgradation. Oracle Locks. Using Oracle Blocks Efficiency. Oracle Patching. 5. LINUX Linux Installation. Oracle Installation in Linux & Windows. Linux Commands to Operate Oracle Database. Warm Regards Payilagam software training institute, 8344777333, 8883775533. Mail: info@payilaga.com Website: www.payilagam.com 3 Payilagam Software Training Institute | www.payilagam.com | 83 44 777 333 | 8883 77 55 33 |
  • 4. Payilagam Software Training Institute 4 Payilagam Software Training Institute | www.payilagam.com | 83 44 777 333 | 8883 77 55 33 |