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
Saturday, May 9, 2009
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
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
Labels:
DCL,
DDL,
DML,
SQL Basics,
SQL Commands,
Types of SQL Commands
Subscribe to:
Posts (Atom)