Clement Mariyan

If you are planning to certificate in ORACLE or struggling in live projects, don't not waste anytime. Call me on. I am Clement, working as a ERP Techno-Functional Analyst in a top notch INSTRUMENTATION ENGINEERING MANUFACTURE Company in Chennai on lines of my M. Sc(IT).,M. Phil(CS), MCP (SQL2000), OCA (ORACLE). I have 5 years of industry experience (It will help you as I will give you and expose you to practical situations in real time projects). I offer coaching for Oracle 9i / 10g Certification for SQL and PL/ SQL. SQL*-20 hrs Writing Basic SQL Statement, Restricting & Sorting Data Single Row Functions, Displaying Data From Multiple Tables Aggregating Data Using Group Functions, Sub-Queries Producing Readable Output With iSQL*Plus Manipulating Data, Creating and Managing Tables Including Constraints, Creating Views & Other Database Objects Controlling User Access, Using Set Operators Oracle 9i Datetime Functions, Enhancements to the Group BY Clause Advanced Sub-Queries Oracle 9i Extensions to DML and DDL Statements PL/ SQL - 20 hrs Introduction, Declaring Variables Writing Executable Statements, Interacting With The Oracle Server Writing Control Structures, Working With Composite Data Types Writing Explicit Cursors and advanced Explicit Cursor Handling Exceptions, Creating Procedures Creating Functions, Managing Subprogram Creating Packages, More Package Concepts Oracle Supplied Packages, Manipulation Large Objects Creating Database Triggers, Managing Dependencies SQL PAPER CODE IZ0-007 - Course duration 20 Hrs PL/ SQL PAPER CODE 1Z0-147 - Course duration 20 Hrs I will be taking classes on weekends only. (Sat/ Sun), I need at least a fortnight advance information for planning my schedules.

''

Head Office Chennai Tamil Nadu India