Change Qa Resume Sdlc Software Visual Testing HistoryTutorial Database Testing using SQL SQL for Testers Software Testing Times. The demand for all round testers, i. Basics of Database testing contains the following. How to connect to the database Ability to write simple queries to retrieve data and manipulate the data using DML operations. Functional flow should be very well known Good knowledge on table level, column level constraints, ability to understand and execute complex queries related to joins is added advantage. Contents of this tutorial 1. INTRODUCTION to Database Testing. Why back end testing is so important 1. Characteristics of back end testing 1. Back end testing phases 1. Back end test methods. STRUCTURAL BACK END TESTS. Database schema tests 2. Databases and devices 2. Tables, columns, column types, defaults, and rules 2. Keys and indexes. Stored procedure tests 2. Individual procedure tests 2. Integration tests of procedures. Optimal Blue Digital Marketplace, The Leading Secondary Marketing eCommerce Platform For Lenders, Investors Providers. The State of California is an equal opportunity employer to all, regardless of age, ancestry, color, disability mental and physical, exercising the right to family. Trigger tests 2. 3. Update triggers 2. Insert triggers 2. Delete triggers. 2. Integration tests of SQL server. Server setup scripts. Common bugs. 3. FUNCTIONAL BACK END TESTS 3. Dividing back end based on functionality 3. Checking data integrity and consistency 3. Login and user security 3. Stress Testing 3. Test back end via front end 3. Benchmark testing 3. Common bugs. 4. Testing The Nightly downloading and Distribution jobs 4. Batch jobs 4. 2 Data downloading 4. Data conversion 4. Data distribution 4. Nightly time window 4. Common bugs. 5. Testing the Interfaces to Transaction APIS5. APIs queries to back end 5. Outputs of back end to APIs 5. Common bugs. 6. Other Database testing Issues. Test tips 6. 2 Test tools 6. Useful queries Download the SQL For Testers tutorial from here. Before going through chapters 2 to 6, one should know the basics of SQL 1. What are the difference between DDL, DML and DCL commandsA blog about Software Testing, Java Programming, and SQL. Manual Testing, Selenium, UFT, Java, and Database Technologies. DDL is Data Definition Language statements. 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 GRANT gives users access privileges to database REVOKE withdraw access privileges given with the GRANT command. DML is Data Manipulation Language statements. 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 CALL call a PLSQL or Java subprogram EXPLAIN PLAN explain access path to data LOCK TABLE control concurrency. DCL is Data Control Language statements. Some examples COMMIT save work done SAVEPOINT identify a point in a transaction to which you can later roll back ROLLBACK restore database to original since the last COMMIT SET TRANSACTION Change transaction options like what rollback segment to use. Download the SQL For Testers tutorial from here. Read SQL for Testers Part 2.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
November 2017
Categories |