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.
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.
Clement Mariyan is based in Chennai, Tamil Nadu, India
This Provider has not yet told us about their training programs
- S asked: How to contact you about Clement Mariyan
- J asked: Hi Mariyan, I'm a student attempting to do relational database design from a given scenario. But I have no experience in database design and I would really appreciate some help and advice from you . I am having difficulty with everything. Let me start by displaying the scenario and what needs to be designed. First of all the ERD diagram for this with the , ,NF steps. The Vale Universitys (VU) media services department would like to set up an on-line booking system to allow lecturers to book equipment/ services themselves from anywhere within VU. The system should produce a daily list of booking for media services staff and in the case of equipment booking should ensure that stock is available before a booking is accepted. At present, the system is a manual one. The department maintains a stock of equipment, ranging from cameras/ TV monitors through to flip chart holders. The department also issues consumables to staff. Lecturers wishing to book equipment place their requirements in person or by phone/ email. The department staffs ensures the equipment is available for the given date, then send an email/ phone confirmation and fill out a booking form for the equipment. Lecturers will sign the booking form when the collect the item and take away a copy of the signed form. The equipment is booked for a minimum of one day. When they return the equipment the media staff checks it over to make sure that is not damaged, and return it back into stock. On occasions the piece of equipment has been found damage and has had to be taken of stock to be repaired. The vice chancellor now wants the media services department to bill faculties/ schools for use of the service. To this end, the media services manager needs to record the daily hire rate for each category of equipment and it will need to generate appropriate reports at the end of each month. The manger feels that a computerised database should make the whole process more efficient. He has drawn up an initial list of requirements. The system should generate the following reports: h Daily/ Weekly booking schedule h Outstanding returns schedule h Stock list h Annual booking /consumables costs: Per lecture Per school/ faculty Per equipment type h Repair cost (these are to be billed to the school of the lecturer responsibly!) He would like lectures to be able to place booking directly, rather than having to liased with a member of the media services (although this service would still be available). He would also live the lecturers to be able to view their booking history. Ranges of summary statistics should be available on line for each faculty/ school head. The Vale Universitys (VU) media services department would like to set up an on-line booking system to allow lecturers to book equipment/ services themselves from anywhere within VU. The system should produce a daily list of booking for media services staff and in the case of equipment booking should ensure that stock is available before a booking is accepted. At present, the system is a manual one. The department maintains a stock of equipment, ranging from cameras/ TV monitors through to flip chart holders. The department also issues consumables to staff. Lecturers wishing to book equipment place their requirements in person or by phone/ email. The department staffs ensures the equipment is available for the given date, then send an email/ phone confirmation and fill out a booking form for the equipment. Lecturers will sign the booking form when the collect the item and take away a copy of the signed form. The equipment is booked for a minimum of one day. When they return the equipment the media staff checks it over to make sure that is not damaged, and return it back into stock. On occasions the piece of equipment has been found damage and has had to be taken of stock to be repaired. The vice chancellor now wants the media services department to bill faculties/ schools for use of the service. To this end, the media services manager needs to record the daily hire rate for each category of equipment and it will need to generate appropriate reports at the end of each month. The manger feels that a computerised database should make the whole process more efficient. He has drawn up an initial list of requirements. The system should generate the following reports: h Daily/ Weekly booking schedule h Outstanding returns schedule h Stock list h Annual booking /consumables costs: Per lecture Per school/ faculty Per equipment type h Repair cost (these are to be billed to the school of the lecturer responsibly!) He would like lectures to be able to place booking directly, rather than having to liased with a member of the media services (although this service would still be available). He would also live the lecturers to be able to view their booking history. Ranges of summary statistics should be available on line for each faculty/ school head. My initial attempt I found the following tables. Staff member, Faculty, stock, booking, booking line and category. I dont know if this is right. Designing is definitely not my strong point. I would really appreciate some help in finding the right answers. I know I need more tables and attributes, but I dont know what. Please can you help. Thanks in advance, about Clement Mariyan
- M asked: Hi! Could you please provide me your contact info. and provide me the OCA's fees structure. about Clement Mariyan
- N asked: sir i have designed a website with table i have created every page only the problem is when i have click on the button of hyperlinked pages the content of the page should be replaced by the following page the page should b same but the content in the cell must b replaced when i click on the buttons. about Clement Mariyan
- R asked: Hi I need more info .. how can i contact you Mt Mariyan. My email id is com and my mobile number is about Clement Mariyan
|
Head Office
ChennaiTamil NaduIndia
|
