No 1 Training institute for Oracle In Chennai

01/03/2012 Professional & Short Term Course

Price: Free

Description

PERIDOT SYSTEMS Why should I Learn from PERIDOT SYSTEMS?    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 behavior for the database and individual sessions


11.   Administer a VLDB


12 Implement a secure database


13.    Transport data across platform    


 


  Venue:  PeridotSystems Indra nagar Chennai - 600 020.(Near Adyar BSNL Telephone Exchange)044-42115526 / 9952010141 / valli.s@peridotsystems.in / www.peridotsystems.in  

More Details

Total Views:8
Reference Id:#8935
Phone Number:9952010141
Website URL:Click To Visit
Current Rating: /5 0 Vote
Copyright © 2018 |   All Rights Reserved |   tuffclassified.com |   24x7 support |   Email us : info[at]tuffclassified.com