IICT Chromepet

                                 Facebook Linked In Twitter Google Plus Pinterest Blogspot Youtube   Phone

90038 53466

Oracle SQL Training in Chennai & Oracle SQL Training Institutes in Chennai & Oracle SQL Training Institute in Chennai & Oracle SQL Training Centers in Chennai



Attend one hour Free demo class with Ganesh Sir for Oracle Course and then decide whether to join in the Oracle Course or Not.



We Challenge you that even a layman can easily understand our Oracle training easily.



Oracle Training by Ganesh Sir having 20+ years of experience in leading MNC Company handles various Overseas Projects. Ganesh Sir teaches all the Oracle topics in real time & hands on along with demo project.



Ganesh is expert in Oracle, Oracle SQL, Oracle PL/SQL, RDBMS, Performance Tuning trained many number of students and experienced professionals in Oracle domain and helped for Job Placement.



Think Oracle Think IICT Ganesh Sir.



Once you complete our Oracle Training you can able to handle any kind of Oracle Project very easily with 100% Confidence.



Oracle SQL Course Fees is Only Rs.10000 with two installments



Oracle SQL and Oracle PL/SQL Course Fees is Only Rs.15000 with two installments



Oracle DBA Course Fees is Only Rs.15000 with two installments



Oracle Performance Tuning Course Fees is Only Rs.20000 with two installments



IICT is No.1 and Best Coaching Center in Following Oracle Courses:



Oracle SQL Training in Chennai


Oracle PLSQL Training in Chennai


Oracle DBA Training in Chennai


Performance Tuning Training in Chennai



Oracle SQL Training in Chennai , Oracle SQL Training Center in Chennai with Placement , Oracle fees


Oracle SQL Training Institute in Chennai & Oracle SQL Training in Chennai with Placement & Oracle SQL Training Center in Chennai & Oracle SQL Training with Placement in Chennai



Oracle SQL Training Course Syllabus in Chennai



Course I:



SQL:



  • Retriving data using the SQL select statement]

  • Restricting and sorting data

  • Using single row function to customize output.

  • Reporting aggregated data using the grout function.

  • Displaying data from multiple tables -I

  • Displaying data from multiple tables - II

  • Using sub queries to solve problems

  • Using set operators

  • Manipulating data

  • Using DDL statements to create and manage tables

  • Creating other schema objects

  • Managing objects with data dictionary

  • Controlling User access

  • Managing schema objects

  • Manipulating large data sets

  • Generating report by grouping related data

  • Managing data in different time zones

  • Retrieving data using sub queries

  • Hierarchical retrieval

  • Regular expression support


  • PL/SQL:



  • Introduction

  • Declaring Variables

  • Writing Executable Statements

  • Interacting with Oracle Server

  • Writing Control Structures

  • Working with Composite Data Types

  • Writing Explicit Cursors

  • Writing Implicit Cursors

  • Handling Exceptions

  • Creating Procedures

  • Creating Functions

  • Managing Subprograms

  • Creating Packages

  • More Package concepts

  • Oracle supplied Packages

  • Manipulating Large Objects

  • Creating Database Triggers

  • More Trigger concepts

  • Managing Dependents


  • Course II:



    SQL:



  • Retriving data using the SQL select statement]

  • Restricting and sorting data

  • Using single row function to customize output.

  • Reporting aggregated data using the grout function.

  • Displaying data from multiple tables -I

  • Displaying data from multiple tables-II

  • Using sub queries to solve problems

  • Using set operators

  • Manipulating data

  • Using DDL statements to create and manage tables

  • Creating other schema objects

  • Managing objects with data dictionary

  • Controlling User access

  • Managing schema objects

  • Manipulating large data sets

  • Generating report by grouping related data

  • Managing data in different time zones

  • Retrieving data using sub queries

  • Hierarchical retrieval

  • Regular expression support


  • Admin I:



  • Introduction

  • Installing the Oracle Database Structure

  • Creating an Oracle Instance

  • Managing the Oracle Instance

  • Managing Database Storage Structure

  • Oracle managed file(OMF)

  • Creating a table space

  • Administering security

  • Managing Schema Objects

  • Types of Indexes

  • Managing Data and Concurrency

  • Locking Mechanism

  • Managing Undo Data


  • Implementing Oracle Database Security

  • Configuring the Oracle Network environment

  • Proactive Maintenance

  • ADDM

  • Performance Management

  • Backup and Recovery Concept

  • Hot Backup

  • Cold Backup

  • Hands on practice

  • Performing Database Backups

  • Performing Database Recovery

  • Performing Flashback

  • Hands on practice

  • Flashback version query

  • Moving Data

  • Oracle Data pump


  • Admin II:



  • Introduction

  • Oracle managed files

  • Configuring recovery manager

  • Using recovery manager

  • RMAN backup types

  • Hands on practice

  • Recovering from non critical loses

  • Database recovery

  • Types of incomplete recovery

  • Flashback

  • Dealing with database corruption

  • Hands on practice

  • Monitoring and managing memory

  • Automatic shared memory management

  • Automatic performance management

  • Automatic workload repository

  • Managed schema objects

  • Hands on practice

  • Clusters

  • Managing storage

  • Automatic storage management

  • ASM disk group

  • Portioning a disk

  • Managing resources

  • Automatic task with scheduler

  • Database security

  • Transparent data encryption

  • Using globalization support

  • Hands on practice

  • Oracle SQL Related Training Courses in Chennai



    Oracle Training in Chennai


    Oracle SQL Training in Chennai


    Oracle PLSQL Training in Chennai


    Oracle DBA Training in Chennai


    Oracle RAC Training in Chennai


    Oracle Apps DBA Training in Chennai


    Oracle Apps Finance Training in Chennai


    Oracle Apps HRMS Training in Chennai


    Oracle Apps SCM Training in Chennai


    Oracle Apps Technical Training in Chennai


    OAF Technical Training in Chennai


    Oracle OTM Training in Chennai


    Taleo Training in Chennai


    Oracle Demantra Training in Chennai


    Oracle Retail Trade Management Training in Chennai


    Peoplesoft Finance Training in Chennai


    Peoplesoft HCM Training in Chennai


    Performance Tuning Training in Chennai


    SQL Server DBA Training in Chennai


    DB2 DBA Training in Chennai


    Teradata DBA Training in Chennai


    Informix Training in Chennai


    Sybase Training in Chennai


    MongoDB Training in Chennai


    PostgreSQL Training in Chennai



     

    Latest Reviews of IICT- " Students Are Brand Ambassadors "


    Road Map of IICT


    IICT Chromepet Address, IICT Contact, IICT Location, IICT Chrompet address, IICT Chennai Address, IICT

    Click Here For Google Map



    Websites of IICT


    IICT Academy
    IICT - Training in Chennai

     







    Are you located in any of these areas - Abiramapuram, Adambakkam, Adyar, Agaram, Alandur, Alwarpet, Alwarthirunagar, Ambattur, Ambattur Industrial Estate, Aminjikarai, Anakaputhur, Anna Nagar, Anna Nagar East, Anna Nagar West, Anna Salai, Arumbakkam, Ashok Nagar, Avadi, Ayanavaram, Besant Nagar, Broadway, Chengalpet, Chennai Others, Chetpet, Chintadripet, Chitlapakkam, Choolai, Choolaimedu, Chromepet, Egmore, Ekkaduthangal, Ennore, Flowers Road, George Town, Gopalapuram, Gowrivakkam, Guduvanchery, Guindy, Iyyapanthangal, Jafferkhanpet, Jawahar Nagar, K.K. Nagar, Kattupakkam, Kellys, Kilpauk, Kodambakkam, Kodungaiyur, Kolathur, Korattur, Korrukupet, Kottur, Koyambedu, Kundrathur, M.K.B. Nagar, Madhavaram, Madipakkam, Manali, Manapakkam, Mandaveli, Mangadu, Maraimalai Nagar, Medavakkam, Meenambakkam, Minjur, Mogappair, Mogappair East, Moulivakkam, Mudichur, Mylapore, Nandambakkam, Nandanam, Nanganallur, Neelangarai, Nungambakkam, Old Washermenpet, Orgadam, Padi, Palavakkam, Palavanthangal, Palavayal, Pallavaram, Pallikaranai, Pammal, Park Town, Parrys, Pattabiram, Perambur, Periyar Nagar, Perungalathur, Perungudi, Poonamallee, Porur, Potheri, Pozhichalur, Pudupet, Purasawalkam, Puzhal, R.A. Puram, Redhills, Royapettah, Saidapet, Saligramam, Santhome, Selaiyur, Sembiam, Shenoy Nagar, sholavaram, Sholinganallur, Singaperumalkoil, Sowcarpet, Sri Iyappa Nagar, St. Thomas Mount, T. Nagar, Tambaram, Teynampet, Thiruninravur, Thiruvanmiyur, Thiruverkadu, Thiruvotriyur, Thousand Lights, Tondiarpet, Triplicane, Urapakkam, Vadapalani, Valasaravakkam, Vandalur, Velachery, Vepery, Villivakkam, Virugambakkam, Vyasarpadi, Washermanpet and West Mambalam

    Our Chrompet office is just few kilometers away from your location. If you need the best training in Chennai, driving couple of extra kilometers is worth it.

    RSS Sitemap   |   Sitemap  ©IICT, CHENNAI , TN. All rights reserved.