Project with example

                                                                                                                                           <<<        >>>

Project

Here I am taking emp table as example. For this I will write test scenarios and test cases, that means we are testing emp table.   


 
Check List or Test Scenarios:-

    1. To  validate  the  data in table (emp)
    2. To validate the table structure.
    3. To validate the null values  of the table.
    4. To validate the null values of very attribute.
    5. To check the duplicate values of  the table.
    6. To check the duplicate values of each attribute of the table
    7. To check the field value or space (length of the field size)  
    8. To check the constraints (foreign ,primary key)
    9. To check the name of the employer who has not earned any commission
    10. To check the all employers who are work in dept no (Account dept,sales dept)
    11. To check the row count of each attribute.
    12. To check the row count of the table.
    13. To check the max salary from emp table.
    14. To check the min salary from emp table.


     ..-----Test Case:-             .------Bug Reporting:- 

                 

35 comments:

  1. could you please upload one more project with detailed test cases scenarios

    ReplyDelete
    Replies
    1. Hello my name is favour Johnson from south African married with three kids Mary joy and rose lost my husband four years ago. Since then things have become hard for me and my children even to eat was a problem because they have no money to buy food stuff and to pay my children's school fees. April 12 2017 a friend of my gave me contact of agent Williams that help her on blank ATM card that make her to be rich now and she said the card can be use in any bank without trace so are contact the man and him ask me to send my bank details which him we use for the ATM card which are did and are send it in two days him contact me back and said my ATM card is ready and are pay some money to the DHM that send the card to me in South African in three days of it are got my ATM card and my code which are can use to we draw money in any bank now me and my family are now living better now are want to thank agent Williams by telling him thank you and may God reward you for your good work tool ward our life you can contact on his email (internationalhackingcompany@gmail.com) you can also contact him on +17068042665.

      Delete
  2. This is Vry Useful.Thanks for uploading.But i Want Some other Domain.
    Could You please Upload.........................

    ReplyDelete
    Replies
    1. http://etltestingguide.blogspot.com/p/project-with-example.html

      Delete
  3. could u plz send me the detailed view to my mail.

    kota.thrinadh@gmail.com

    ReplyDelete
  4. Pretty good post. I just came across your site and wanted to say that I’ve really enjoyed reading your posts. In any case I’ll be subscribing to your feed and I hope you will keep a good work!Cheer!

    sap online training
    software online training
    sap sd online training
    hadoop online training
    sap-crm-online-training

    ReplyDelete
    Replies
    1. Do you still have the SAP Online training class?

      Delete
  5. I really enjoy the blog.Much thanks again. Really Great.
    Very informative article post. Really looking forward to read more. Will read on…


    oracle online training
    sap fico online training
    dotnet online training
    qa-qtp-software-testing-training-tutorial

    ReplyDelete
  6. Latest Government Jobs 2016

    Good write up, I am regular visitor of website, maintain up the excellent operate, and It’s going to be a regular visitor for a long time...........

    ReplyDelete
  7. Latest Govt Jobs Notification 2016


    The information mentioned in the blog are several of the very best available..................

    ReplyDelete
  8. Please help me with health care /Banking/Retail Projects using etl testing... (with all the details like test cases, scenarios, queries etc) and in interview what type of questions they can ask on projects.. please send it by mail. my id is sujata_shining@rediffmail.com

    ReplyDelete
  9. Nice blog thanks for sharing.

    ReplyDelete
  10. This article information was so nice. Which is very much useful for me and impressed by reading. ETL Testing Online Training Videos

    ReplyDelete
  11. This is pretty much good but can you please upload the answers to the questions so that we can get sure about what to say in interviews.

    ReplyDelete
  12. This comment has been removed by the author.

    ReplyDelete
  13. Good articles, Have you heard of LFDS (Le_Meridian Funding Service, Email: lfdsloans@outlook.com --WhatsApp Contact:+1-9893943740--lfdsloans@lemeridianfds.com) is as USA/UK funding service they grant me loan of $95,000.00 to launch my business and I have been paying them annually for two years now and I still have 2 years left although I enjoy working with them because they are genuine Loan lender who can give you any kind of loan.

    ReplyDelete



  14. INSTEAD OF GETTING A LOAN,, I GOT SOMETHING NEW
    Get $10,050 USD every week, for six months!

    See how it works
    Do you know you can hack into any ATM machine with a hacked ATM card??
    Make up you mind before applying, straight deal...
    Order for a blank ATM card now and get millions within a week!: contact us
    via email address:: besthackersworld58@gmail.com or whats-app +1(323)-723-2568

    We have specially programmed ATM cards that can be use to hack ATM
    machines, the ATM cards can be used to withdraw at the ATM or swipe, at
    stores and POS. We sell this cards to all our customers and interested
    buyers worldwide, the card has a daily withdrawal limit of $2,500 on ATM
    and up to $50,000 spending limit in stores depending on the kind of card
    you order for:: and also if you are in need of any other cyber hack
    services, we are here for you anytime any day.
    Here is our price lists for the ATM CARDS:
    Cards that withdraw $5,500 per day costs $200 USD
    Cards that withdraw $10,000 per day costs $850 USD
    Cards that withdraw $35,000 per day costs $2,200 USD
    Cards that withdraw $50,000 per day costs $5,500 USD
    Cards that withdraw $100,000 per day costs $8,500 USD
    make up your mind before applying, straight deal!!!

    The price include shipping fees and charges, order now: contact us via
    email address::besthackersworld58@gmail.com or whats-app +1(323)-723-2568

    ReplyDelete
  15. Thanks for your information. Looking for your further blogs.
    etl testing
    etl testing course

    ReplyDelete
  16. This comment has been removed by the author.

    ReplyDelete
  17. Do you need to hack into any, databaseserver spy on Facebook,Emails, Whatsapp, Viber, Snapchat, Instagram and many more.
    I urge you to get in touch with the best people for the job, i have confirm the service when i need to spy on my spouse phone. They are good at Phone Cloning and Bitcoin/binary minning and any other hack job.
    Thanks guys for the team work HACKINTECHNOLOGYATGMAILDOTCOM
    +12132951376(WHATSAPP)

    ReplyDelete
  18. Welcome. BE NOT TROUBLED anymore. you’re at the right place. Nothing like having trustworthy hackers. have you lost money before or bitcoins and are looking for a hacker to get your money back? You should contact us right away. It's very affordable and we give guarantees to our clients. Our hacking services are as follows:Email:Creditcards.atm@gmail.com 
    -hack into any kind of phone
    _Increase Credit Scores
    _western union, bitcoin and money gram hacking
    _criminal records deletion_BLANK ATM/CREDIT CARDS
    _Hacking of phones(that of your spouse, boss, friends, and see whatever is being discussed behind your back)
    _Security system hacking...and so much more. Contact THEM now and get whatever you want at
    Email:Creditcards.atm@gmail.com 

      Whats app:+1(305) 330-3282  

    WHY WOULD YOU NEED TO HIRE A HACKER??:
    There are so many Reasons why people need to hire a hacker, It might be to Hack a Websites to deface information, retrieve information, edit information or give you admin access.
    • Some people might need us To Hack Their Target Smartphone so that they could get access to all activities on the phone like , text messages , call logs , Social media Apps and other information
    • Some might need to Hack a Facebook , gmail, Instagram , twitter and other social media Accounts,
    • Also Some Individuals might want to Track someone else's Location probably for investigation cases
    • Some might need Us to Hack into Court's Database to Clear criminal records.
    • However, Some People Might Have Lost So Much Funds With BINARY OPTIONS BROKERS or BTC MINING and wish to Recover Their Funds
    • All these Are what we can get Done Asap With The Help Of Our Root Hack Tools, Special Hack Tools and Our Technical Hacking Strategies Which Surpasses All Other Hackers.

    ★ OUR SPECIAL SERVICES WE OFFER ARE:
    * RECOVERY OF LOST FUNDS ON BINARY OPTIONS
    * Credit Cards Loading ( USA Only )
    * BANK Account Loading (USA Banks Only)

    ★ You can also contact us for other Cyber Attacks And Hijackings, we do All ★

    ★ CONTACTS:
    * For Binary Options Recovery,feel free to contact (Creditcards.atm@gmail.com)for a wonderful job well done,stay safe.

    Why waste your time waiting for a monthly salary. When you can make up to $3,000 in 5-7days from home,                     
    Invest $300 and earn $3,000
    Invest $500 and earn $5,000
    Invest $600 and earn $6,000
    Invest $700 and earn $7,000
    Invest $800 and earn $8,000
    Invest $900 and earn $9,000
    Invest $1000 and earn $10,000

    IT HAS BEEN TESTED AND TRUSTED  

    ReplyDelete
  19. Need a Debt Loan To Pay Off Bills?
    Take control of your debt today
    Available Now Business Expansion Loan Offer?
    Do you need a loan to pay off Bills?
    Do you need a loan?
    Do you need Personal Loan?
    Business Expansion Loan?
    Business Start-up, Education,
    Debt Consolidation Loan
    Hard Money Loans
    Loan for any thing ?
    We offer loan at low interest rate of 3%
    Loan with no credit check,
    Email us: financialserviceoffer876@gmail.com
    Call or add us on what's app +918929509036

    ReplyDelete
  20. Have you pay your necessary BILLS? Do you need money? Do you want a better way to transform your own life? My name his Elizabeth Maxwell. I am here to share with you about Mr OSCAR WHITE new system of making others rich with not less than two to three days.I was in search of a job opportunity on the internet when i come across his aid on a blogs that i was on to, talking on how he can help the needy with a programmed BLANK ATM CARD.I thought it was a scam or normal gist but i never had a choice than to contact him cause i was seriously in need of Finance for Business.I contacted him on the CARD, and not less than a minute he respond and give me the necessary information’s on how to get the card. My friends, today am a sweet happy woman with good business and a happy family. I charge you not to live by ignorance.Try and get an ATM card today through (MR OSCAR WHITE)and be among the lucky ones who are benefiting from this card. This ATM card is capable of hacking into any ATM machine anywhere in the world.It has really changed my life and now I can say I’m rich because I am a living testimony. The less money I get in a day with this card is $15,000.Every now and then money keep pumping into my account. Although is illegal, there is no risk of being caught, as it is programmed so that it can not trace you, but also has a technique that makes it impossible for the CCTV to detect you.. I urge you to contact him on the BLANK ATM CARD. For details on how to get yours today, email hackers Below:

    email address is oscarwhitehackersworld@gmail.com

    whats-app +1(513)-299-8247.

    ReplyDelete
  21. My name is Mr. Klaus Dieter, I work for the French financial institution Crédit Mutuel with the partnership of the bank BNP Paribas, we offer you offers at an interest rate of 3% per year, to start with new projects:
    - You have unpaid debt.
    - Buying a new house.
    - buy a new car.
    - Buying a new apartment or property.
    Get personal loans, business loans.
    If you would like loans for setting up your business and project, do not hesitate to send us an email:
    bnpfinanzenhilfe@gmail.com

    Whatsapp: +4917694954827

    ReplyDelete
  22. Hello
    We grant loans between individuals with an annual rate of 3%. For more information contact by
    Whatsapp +4917683840419

    bnpfinanzenhilfe@gmail.com

    ReplyDelete
  23. We offer private, commercial and personal loans with an annual interest rate of very low temperatures up to 2% per year with a maturity of 50 years, anywhere in the world. We offer loans between US $ 5,000 and US $ 100 million.
    Lender Email Address: Garryjonesloanfirm@hotmail.com

    Sincerely,
    Mr. Garry Jones.
    Garryjonesloanfirm@hotmail.com

    ReplyDelete
  24. Emergency Cash Loans Hello Everybody, My name is Mrs. Phyllis Sue South. I live in UK London and i am a happy woman today? and i told my self that any lender that rescue my family from our poor situation, i will refer any person that is looking for loan to him, he gave me happiness to me and my family, i was in need of a loan of $350,000.00 to start my life all over as i am a single mother with 2 kids I met this honest and GOD fearing man loan lender that help me with a loan of $350,000.00 U.S. Dollar, he is a GOD fearing man, if you are in need of loan and you will pay back the loan please contact him tell him that is Mrs. Phyllis Sue South that refer you to him. contact Dr. James Eric via email: financialserviceoffer876@gmail.com Whats-App +918929509036

    ReplyDelete
  25. Hello my name is favour Johnson from south African married with three kids Mary joy and rose lost my husband four years ago. Since then things have become hard for me and my children even to eat was a problem because they have no money to buy food stuff and to pay my children's school fees. April 12 2017 a friend of my gave me contact of agent Williams that help her on blank ATM card that make her to be rich now and she said the card can be use in any bank without trace so are contact the man and him ask me to send my bank details which him we use for the ATM card which are did and are send it in two days him contact me back and said my ATM card is ready and are pay some money to the DHM that send the card to me in South African in three days of it are got my ATM card and my code which are can use to we draw money in any bank now me and my family are now living better now are want to thank agent Williams by telling him thank you and may God reward you for your good work tool ward our life you can contact on his email (internationalhackingcompany@gmail.com) you can also contact him on +17068042665.

    ReplyDelete
  26. I just have to introduce this hacker that I have been working with him on getting my credit score been boosted across the Equifax, TransUnion and Experian report. He made a lot of good changes on my credit report by erasing all the past eviction, bad collections and DUI off my credit report history and also increased my FICO score above 876 across my three credit bureaus report you can contatc him for all kind of hacks . Email him here via Email him here via hackintechnology@cyberservices.com or whatsapp Number: +1 213 295 1376.

    ReplyDelete
  27. me and my husband are here to testify about how we use Oscar White black ATM card to make money and also have our own business today. Go get your blank ATM card today and be among the lucky ones. This PROGRAMMED blank ATM card is capable of hacking into any ATM machine,anywhere in the world.It has really changed our life for good and now we can say we are rich and we can never be poor again. You can withdraw the maximum of $5,000 daily and $140,000 a month, We can proudly say our business is doing fine and we have up to $20,000 000 (20 millions dollars in our account) Is not illegal,there is no risk of being caught ,because it has been programmed in such a way that it is not traceable,it also has a technique that makes it impossible for the CCTV to detect you..For details and cost on how to get yours today, email the hackers on : oscarwhitehackersworld@gmail.com ,Text & Call or Whats-app: +1(209)-643-1515

    ReplyDelete
  28. I never thought that I will be qualify for a loan that Officer Pedro and his loan company granted me which was very smooth and transparent in every conversation that we make through the loan process, I will once again thank him and his loan organization for a job well done by offering me a loan of 22 million Euro with the low rate of 2% annual return they are genuine and loan register company with simple terms and conditions.
    Contact the loan company through pedroloanss@gmail.com

    ReplyDelete
  29. I have being hearing about this blank ATM card for a while and i never really paid any interest to it because of my doubts. Until one day i discovered a hacking guy called Mr. Oscar White, he is really good at what he is doing. Back to the point, I inquired about The Blank ATM Card. If it works or even Exist. They told me Yes and that its a card programmed for random money withdraws without being noticed and can also be used for free online purchases of any kind. This was shocking and i still had my doubts. Then i gave it a try and asked for the card and agreed to their terms and conditions. Hoping and praying it was not fake. One week later i received my card and tried with the closest ATM machine close to me, It worked like magic. I was able to withdraw up to $6000. This was unbelievable and the happiest day of my life with my girlfriend Laurel. So far i have being able to withdraw up to $78000 without any stress of being caught. I don't know why i am posting this here, i just felt this might help those of us in need of financial stability. blank ATM has really change my life. If you want to contact them, Here is the email address: oscarwhitehackersworld@gmail.com ,whats-app +1(209)-643-1515

    ReplyDelete
  30. Get BLANK ATM Programmed Card and cash money directly in any ATM Machine around you. There is no risk of being caught, because the card has been programmed in such a way that it's not traceable, it also has a technique that makes it impossible for the CCTV to detect you. Now email us today at our E-mail address at: jimleehacker07@gmail.com for you to get your own Programmed Card today

    ReplyDelete
  31. CryptoCurrency RecoveryMasters:

    If you need any genuine hacker and you want to be prevented from the so called scammers who rip people of their money, RecoveryMasters got you covered, He's a secured Hacker from USA who deal with cyber issues of all kind, such as WhatsApp hack, Facebook hack, gmail hack, mobile phone hack, accounts hack, erase criminal records, websites hack, Bitcoin Trade, and other hack relating to cyber issues.
    Visite RecoveryMasters or Contact them on
    Email: (Recoverymasters@email.cz)
    whatsapp +1(551) 202-23-35
    Don't forget to say Victoria perks Recommended you

    ReplyDelete