SPONSORS:






User Tag List

Thanks Thanks:  0
Likes Likes:  0
Dislikes Dislikes:  0
Results 1 to 5 of 5

Thread: SQL

  1. #1
    Junior Member
    Join Date
    Sep 2004
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    SQL

    What is the need of SQL database knowledge in Qality Assurance?

  2. #2
    Junior Member
    Join Date
    Feb 2004
    Location
    Noida
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: SQL

    During the testing process, the testers need to be efficient enough in validating and verifying the data that is been entered through frontend in Database. At least the understanding of Database and basic queries will help the tester to do better job.

  3. #3
    Senior Member
    Join Date
    Mar 2003
    Location
    Austin, TX, USA
    Posts
    1,489
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: SQL

    Being familiar with SQL is a very strong benefit if you're testing a database application. You'll know how to look inside the tables to get the information you need and be able to identify areas that could cause problems. Also things like backing up and restoring test data and clearing out unwanted data is very helpful.

  4. #4
    Junior Member
    Join Date
    Jul 2003
    Location
    FL
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: SQL

    I agree with vas04,

    A simple example of why this is important would be the following:

    Your are testing a web based fincancial transaction system that uses a SQL backend.

    You are black box testing (using the UI, no knowledge of the code behavior).

    You enter a credit card using spaces between each number sequence(just the way it looks on the card) and you submit to test the purchase process.

    You get a blank page as a return from the transaction...

    Now what? As a tester, it's always nice to be able to point to "what" failed, and maybe even "why".

    If you look into the database, you may find that the credit card number that was stored is null (no value at all).

    This in turn caused the app to break.

    By having this information, you can work with the developer to determine what tier the null was created on and and how to address it so it doesn't occur, and if it does, it doesn't break the app.

    yes, this does extend beyond the boundary of Black Box testing, but not by much, and the extra action is of significant value.

    Hope that helps,

    Jeff

    [ 11-18-2004, 02:01 PM: Message edited by: jlafferty ]

  5. #5
    Member
    Join Date
    Jan 2003
    Location
    Hong Kong
    Posts
    36
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: SQL

    It always depends upon the type of Applications that you are testing. In my opinion tester should be a kind of a Jack in all trades of Technology/Software. It always helps if the tester has a minimal knowledge on all the technical aspects of the application and technology.

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Search Engine Optimisation provided by DragonByte SEO v2.0.36 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Resources saved on this page: MySQL 9.09%
vBulletin Optimisation provided by vB Optimise v2.6.4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.2.8 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
vBNominate (Lite) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Feedback Buttons provided by Advanced Post Thanks / Like (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Username Changing provided by Username Change (Free) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
BetaSoft Inc.
Digital Point modules: Sphinx-based search
All times are GMT -8. The time now is 02:04 PM.

Copyright BetaSoft Inc.