Roles and Responsibilities of a "Software Testing Engineer"

Generally Roles and Responsibilities of a Testing Engineer may vary, depending upon the working company. But here we are going to discuss about the general and important roles and responsibilities of a Testing Engineer.

1) Analyzing the Requirements from the client
2) Participating in preparing Test Plans
3) Preparing Test Scenarios
4) Preparing Test Cases for module, integration and system testing
5) Preparing Test Data’s for the test cases
6) Preparing Test Environment to execute the test cases
7) Analyzing the Test Cases prepared by other team members
8) Executing the Test Cases
9) Defect Tracking
10) Giving mandatory information of a defect to developers in order to fix it
11) Preparing Summary Reports
12) Preparing Lesson Learnt documents from the previous project testing experience
13) Preparing Suggestion Documents to improve the quality of the application
14) Communication with the Test Lead / Test Manager
15) Conducting Review Meetings within the Team

These are the Roles and Responsibilities of a Testing Engineer which is based upon my knowledge. If you know more about this kindly write it down in the comments section.
Your Feed backs are welcome!

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