Saturday, May 9, 2009

Expert Rating Certification in Software Testing

Here comes another one certification for Software Testing, "Expert Rating".
While comparing with other certifications it is very cheap and i don't know how worth is this certification
in India. But i am sure that it will increase our confidence level in our "Software Testing" field.

Syllabus for this certification :

1) Fundamentals concepts in software testing
2) Advanced Testing concepts
3) Types of Testing
4) Automation Testing

Fees and Payment Details :

Charges for taking up this certification is 9.95 USD and they are charging 5 USD for hard copy of your certificate.

You can pay the fee by using credit/debit cards and take the exam in online.

Question Types:


There will be 40 multiple choice questions and 40 minutes duration for the exam.
No negative mark is given for your wrong answers. You have to get 50 % to pass the exam.

For more details kindly visit : http://www.expertrating.com/certifications/Software-Testing-Test.asp

There are other useful certifications available for software professionals in this site, for more details visit : http://www.expertrating.com/certifications.asp

I Have completed this certifications and got my logo, Kindly view my Transcript Details in the below link,
http://www.expertrating.com/transcript.asp?transcriptid=2253348

Basic SQL Commands

DDL

DDL (Data Definition Language) statements are used to define the database structure or schema. Some examples:

• CREATE - to create objects in the database
• ALTER - alters the structure of the database
• DROP - delete objects from the database
• TRUNCATE - remove all records from a table, including all spaces allocated for the records are removed
• COMMENT - add comments to the data dictionary
• RENAME - rename an object

DML

DML (Data Manipulation Language) statements are used for managing data within schema objects. Some examples:
• SELECT - retrieve data from the a database
• INSERT - insert data into a table
• UPDATE - updates existing data within a table
• DELETE - deletes all records from a table, the space for the records remain
• MERGE - UPSERT operation (insert or update)
• CALL - call a PL/SQL or Java subprogram
• EXPLAIN PLAN - explain access path to data
• LOCK TABLE - control concurrency

DCL

DCL is Data Control Language statements. Some examples:
• GRANT - gives user’s access privileges to database
• REVOKE - withdraw access privileges given with the GRANT command