GREENS TECHNOLOGY Oracle DBA Best training Institute ADYAR

GREENS TECHNOLOGY

Why should I learn from GREENS TECHNOLOGY?

1. Only Experienced Software Professionals having more than 10 Years working in Top MNC's like Infosys,IBM,Verizon,Syntel,HP,TCS,Wipro,CTS

2. 100% placement assistance, 90% of our Previous Students are Placed in Various Companies

3. 100% certification assistance. Fees Affordable and worth paying for what you get.

4. All Courses are designed to match with most of the corporate companies requirements.

5. Training session on personality development and interview facing techniques @ free of cost.

Oracle Database 10g: Introduction to SQL

Duration: 40 Hours

What you will learn

This course offers students an introduction to Oracle Database 10g database technology. In this class students learn the concepts of relational databases and the powerful SQL programming language. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, create database objects, and query meta data.

Course Objectives :

Use SQL Statements to retrieve data from tables

1. Create and manage tables, and other schema objects

2. Employ SQL functions to generate and retrieve customized data

3. Control privileges at the object and system level

4. Run data manipulation statements (DML) to update data in the Oracle Database 10g

5. Search data using Advanced Sub queries, and retrieve hierarchical data

Oracle Database 10g: Administration Workshop I Release 2

Duration: 40 Hours

What you will learn

This course is your first step towards success as an Oracle professional, designed to give you a firm foundation in basic database administration. In this class, you'll learn how to install and maintain an Oracle database. You will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. The lesson topics are reinforced with structured hands-on practices.

Course Objectives

1. Install Oracle Database 10g and configure a database

2. Manage the Oracle instance

3. Manage the Database storage structures

4. Create and administer user accounts

5. Perform backup and recovery of a database

6. Monitor, troubleshoot, and maintain a database

7. Configure Oracle Net services

8. Move data between databases and files

Oracle Database 10g: Administration Workshop II Release 2

Duration: 40 Hours

What you will learn

This course advances your success as an Oracle professional in the area of database administration. In this class, you'll learn how to configure an Oracle database for multilingual applications. You will practice various methods of recovering the database using RMAN and Flashback technology. Database performance monitoring tools will be covered, in addition to the steps to take to resolve common problems and improve performance. You will also learn how to administer a database efficiently by using database technologies such as the Resource Manager, the Scheduler, Automatic Storage Management (ASM), and VLDB features.

Course Objectives

1. Use RMAN to create and manage backup sets and image copies

2. Recover the database to a previous point in time

3. Use Oracle Secure Backup to backup and recover a database

4. Use Oracle's Flashback technology to recover your database

5. Detect block corruptions and take appropriate measures to correct them

6. Use the various Database advisors and views to monitor and improve database performance

7. Control database resource usage with the Resource Manager

8. Simplify management tasks by using the Scheduler

9. Review database log files for diagnostic purposes

10. Customize language-dependent behaviour for the database and individual sessions

11. Administer a VLDB

12. Implement a secure database

13. Transport data across platform



For any further clarifications, feel free to contact us:

Please reach out to me for any further clarification. Do pass this info to all your near and dear for utilizing this great opportunity.

Best Regards

Dinesh B.E., MIS (USA)., OCM
91 9840496320 / 044-43511623 / 9940516384
Greens Technology
15 first street Padmanabha nagar,
Adyar, Chennai

http://www.youtube.com/watch?v=zFNDxEOfsV0