{"id":31862,"date":"2016-01-28T11:27:25","date_gmt":"2016-01-28T05:57:25","guid":{"rendered":"https:\/\/2thenew.online\/blog\/?p=31862"},"modified":"2016-02-08T12:55:18","modified_gmt":"2016-02-08T07:25:18","slug":"initiate-your-testing-with-database","status":"publish","type":"post","link":"https:\/\/2thenew.online\/blog\/initiate-your-testing-with-database\/","title":{"rendered":"Initiate your testing with database"},"content":{"rendered":"<h1>Database Testing<\/h1>\n<p>Whenever we talk about any <a title=\"manual testing services\" href=\"https:\/\/2thenew.online\/testing\/automated-independent-manual-testing\">windows or web application testing<\/a>, Database does always sound loud. Backbone of the application always take care with the database. So as a QA it\u2019s very necessary for us to take care of this backbone to prevent the application from the forthcoming defects in our functional test.<\/p>\n<h2>When to Test?<\/h2>\n<p>In most of the application Database design get ready in the starting of the Development or after the requirement freezing process. Same case in the <a href=\"https:\/\/2thenew.online\/blog\/tips-for-agile-development-with-unit-testing-approach\/\">Agile methodology<\/a>, database design get finalize in the starting of the sprint. Also if the store procedures for any particular function is in the ready to QA mode then we can start our testing.<\/p>\n<h2>What to Test?<\/h2>\n<p>Scope of the testing should always be defined before starting the Database Testing. We should have to keep ourselves aware with the requirement for which this database is designed. Following points should always be test with the Database:<\/p>\n<ul>\n<li>Database Schema<\/li>\n<li>Relations between two tables<\/li>\n<li>Data Type and Range\/length of the different columns defined in tables<\/li>\n<li>Triggers<\/li>\n<li>Store procedures<\/li>\n<\/ul>\n<p>Most of the time we find that some of the basic column in the database designs are missing like isDeleted, LastModifiedTime, CreationTime, etc. Although this does not make any impact on the frontend but sometimes it\u2019s very important for analysis purpose.<\/p>\n<h2>How To Test ?<\/h2>\n<p>If we talk about the best practice, Testing with Test Cases is very important for the full coverage of the application or scope. We \u00a0Can use the following flow for the database testing:<\/p>\n<ul>\n<li>Gather information about the required tables, relations, Required Store procedures and triggers.<\/li>\n<li>Create your Test cases with this information. Try to include the validation of every column in the test case designing.<\/li>\n<li>Consider all positive and negative cases in Store procedures testing.<\/li>\n<li>For the Store procedure, it\u2019s better to create test data as well before testing it in actual.<\/li>\n<li>Run your Test<\/li>\n<li>Report your defect using the tracking tools.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Database Testing Whenever we talk about any windows or web application testing, Database does always sound loud. Backbone of the application always take care with the database. So as a QA it\u2019s very necessary for us to take care of this backbone to prevent the application from the forthcoming defects in our functional test. When [&hellip;]<\/p>\n","protected":false},"author":843,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":10,"footnotes":""},"categories":[1817],"tags":[3068,3067],"class_list":["post-31862","post","type-post","status-publish","format-standard","hentry","category-manual-testing","tag-database-manual-testing","tag-database-user-testing"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.0.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"Database Testing Whenever we talk about any windows or web application testing, Database does always sound loud. Backbone of the application always take care with the database. So as a QA it\u2019s very necessary for us to take care of this backbone to prevent the application from the forthcoming defects in our functional test. When\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Akansha Chaturvedi\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/2thenew.online\/blog\/initiate-your-testing-with-database\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.0.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"TO THE NEW BLOG\" \/>\n\t\t<meta property=\"og:type\" content=\"blog\" \/>\n\t\t<meta property=\"og:title\" content=\"Initiate your testing with database | TO THE NEW Blog\" \/>\n\t\t<meta property=\"og:description\" content=\"Database Testing Whenever we talk about any windows or web application testing, Database does always sound loud. Backbone of the application always take care with the database. So as a QA it\u2019s very necessary for us to take care of this backbone to prevent the application from the forthcoming defects in our functional test. When\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/2thenew.online\/blog\/initiate-your-testing-with-database\/\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/2thenew.online\/blog\/wp-content\/themes\/ttn\/images\/social-logo.png\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/2thenew.online\/blog\/wp-content\/themes\/ttn\/images\/social-logo.png\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary\" \/>\n\t\t<meta name=\"twitter:site\" content=\"@tothenew\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Initiate your testing with database | TO THE NEW Blog\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Database Testing Whenever we talk about any windows or web application testing, Database does always sound loud. Backbone of the application always take care with the database. So as a QA it\u2019s very necessary for us to take care of this backbone to prevent the application from the forthcoming defects in our functional test. When\" \/>\n\t\t<meta name=\"twitter:image\" content=\"https:\/\/2thenew.online\/blog\/wp-content\/themes\/ttn\/images\/social-logo.png\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.tothenew.com\\\/blog\\\/initiate-your-testing-with-database\\\/#article\",\"name\":\"Initiate your testing with database | TO THE NEW Blog\",\"headline\":\"Initiate your testing with database\",\"author\":{\"@id\":\"https:\\\/\\\/www.tothenew.com\\\/blog\\\/author\\\/akansha-chaturvedi\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/www.tothenew.com\\\/blog\\\/#organization\"},\"datePublished\":\"2016-01-28T11:27:25+05:30\",\"dateModified\":\"2016-02-08T12:55:18+05:30\",\"inLanguage\":\"en-US\",\"commentCount\":1,\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.tothenew.com\\\/blog\\\/initiate-your-testing-with-database\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.tothenew.com\\\/blog\\\/initiate-your-testing-with-database\\\/#webpage\"},\"articleSection\":\"Manual Testing, database manual testing, database user testing\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.tothenew.com\\\/blog\\\/initiate-your-testing-with-database\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.tothenew.com\\\/blog#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.tothenew.com\\\/blog\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.tothenew.com\\\/blog\\\/category\\\/manual-testing\\\/#listItem\",\"name\":\"Manual Testing\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.tothenew.com\\\/blog\\\/category\\\/manual-testing\\\/#listItem\",\"position\":2,\"name\":\"Manual Testing\",\"item\":\"https:\\\/\\\/www.tothenew.com\\\/blog\\\/category\\\/manual-testing\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.tothenew.com\\\/blog\\\/initiate-your-testing-with-database\\\/#listItem\",\"name\":\"Initiate your testing with database\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.tothenew.com\\\/blog#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.tothenew.com\\\/blog\\\/initiate-your-testing-with-database\\\/#listItem\",\"position\":3,\"name\":\"Initiate your testing with database\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.tothenew.com\\\/blog\\\/category\\\/manual-testing\\\/#listItem\",\"name\":\"Manual Testing\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.tothenew.com\\\/blog\\\/#organization\",\"name\":\"TO THE NEW Blog\",\"url\":\"https:\\\/\\\/www.tothenew.com\\\/blog\\\/\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.tothenew.com\\\/blog\\\/author\\\/akansha-chaturvedi\\\/#author\",\"url\":\"https:\\\/\\\/www.tothenew.com\\\/blog\\\/author\\\/akansha-chaturvedi\\\/\",\"name\":\"Akansha Chaturvedi\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/www.tothenew.com\\\/blog\\\/initiate-your-testing-with-database\\\/#authorImage\",\"url\":\"https:\\\/\\\/newersworld-sf-static.tothenew.net\\\/prod\\\/profilePicFolder\\\/e84e3a4e-38a8-450d-8af4-3206a744369a_akansha.chaturvedi@tothenew.com.jpg\",\"width\":96,\"height\":96,\"caption\":\"Akansha Chaturvedi\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.tothenew.com\\\/blog\\\/initiate-your-testing-with-database\\\/#webpage\",\"url\":\"https:\\\/\\\/www.tothenew.com\\\/blog\\\/initiate-your-testing-with-database\\\/\",\"name\":\"Initiate your testing with database | TO THE NEW Blog\",\"description\":\"Database Testing Whenever we talk about any windows or web application testing, Database does always sound loud. Backbone of the application always take care with the database. So as a QA it\\u2019s very necessary for us to take care of this backbone to prevent the application from the forthcoming defects in our functional test. When\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.tothenew.com\\\/blog\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.tothenew.com\\\/blog\\\/initiate-your-testing-with-database\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/www.tothenew.com\\\/blog\\\/author\\\/akansha-chaturvedi\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/www.tothenew.com\\\/blog\\\/author\\\/akansha-chaturvedi\\\/#author\"},\"datePublished\":\"2016-01-28T11:27:25+05:30\",\"dateModified\":\"2016-02-08T12:55:18+05:30\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.tothenew.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.tothenew.com\\\/blog\\\/\",\"name\":\"TO THE NEW Blog\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.tothenew.com\\\/blog\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Initiate your testing with database | TO THE NEW Blog","description":"Database Testing Whenever we talk about any windows or web application testing, Database does always sound loud. Backbone of the application always take care with the database. So as a QA it\u2019s very necessary for us to take care of this backbone to prevent the application from the forthcoming defects in our functional test. When","canonical_url":"https:\/\/2thenew.online\/blog\/initiate-your-testing-with-database\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/2thenew.online\/blog\/initiate-your-testing-with-database\/#article","name":"Initiate your testing with database | TO THE NEW Blog","headline":"Initiate your testing with database","author":{"@id":"https:\/\/2thenew.online\/blog\/author\/akansha-chaturvedi\/#author"},"publisher":{"@id":"https:\/\/2thenew.online\/blog\/#organization"},"datePublished":"2016-01-28T11:27:25+05:30","dateModified":"2016-02-08T12:55:18+05:30","inLanguage":"en-US","commentCount":1,"mainEntityOfPage":{"@id":"https:\/\/2thenew.online\/blog\/initiate-your-testing-with-database\/#webpage"},"isPartOf":{"@id":"https:\/\/2thenew.online\/blog\/initiate-your-testing-with-database\/#webpage"},"articleSection":"Manual Testing, database manual testing, database user testing"},{"@type":"BreadcrumbList","@id":"https:\/\/2thenew.online\/blog\/initiate-your-testing-with-database\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/2thenew.online\/blog#listItem","position":1,"name":"Home","item":"https:\/\/2thenew.online\/blog","nextItem":{"@type":"ListItem","@id":"https:\/\/2thenew.online\/blog\/category\/manual-testing\/#listItem","name":"Manual Testing"}},{"@type":"ListItem","@id":"https:\/\/2thenew.online\/blog\/category\/manual-testing\/#listItem","position":2,"name":"Manual Testing","item":"https:\/\/2thenew.online\/blog\/category\/manual-testing\/","nextItem":{"@type":"ListItem","@id":"https:\/\/2thenew.online\/blog\/initiate-your-testing-with-database\/#listItem","name":"Initiate your testing with database"},"previousItem":{"@type":"ListItem","@id":"https:\/\/2thenew.online\/blog#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/2thenew.online\/blog\/initiate-your-testing-with-database\/#listItem","position":3,"name":"Initiate your testing with database","previousItem":{"@type":"ListItem","@id":"https:\/\/2thenew.online\/blog\/category\/manual-testing\/#listItem","name":"Manual Testing"}}]},{"@type":"Organization","@id":"https:\/\/2thenew.online\/blog\/#organization","name":"TO THE NEW Blog","url":"https:\/\/2thenew.online\/blog\/"},{"@type":"Person","@id":"https:\/\/2thenew.online\/blog\/author\/akansha-chaturvedi\/#author","url":"https:\/\/2thenew.online\/blog\/author\/akansha-chaturvedi\/","name":"Akansha Chaturvedi","image":{"@type":"ImageObject","@id":"https:\/\/2thenew.online\/blog\/initiate-your-testing-with-database\/#authorImage","url":"https:\/\/newersworld-sf-static.tothenew.net\/prod\/profilePicFolder\/e84e3a4e-38a8-450d-8af4-3206a744369a_akansha.chaturvedi@tothenew.com.jpg","width":96,"height":96,"caption":"Akansha Chaturvedi"}},{"@type":"WebPage","@id":"https:\/\/2thenew.online\/blog\/initiate-your-testing-with-database\/#webpage","url":"https:\/\/2thenew.online\/blog\/initiate-your-testing-with-database\/","name":"Initiate your testing with database | TO THE NEW Blog","description":"Database Testing Whenever we talk about any windows or web application testing, Database does always sound loud. Backbone of the application always take care with the database. So as a QA it\u2019s very necessary for us to take care of this backbone to prevent the application from the forthcoming defects in our functional test. When","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/2thenew.online\/blog\/#website"},"breadcrumb":{"@id":"https:\/\/2thenew.online\/blog\/initiate-your-testing-with-database\/#breadcrumblist"},"author":{"@id":"https:\/\/2thenew.online\/blog\/author\/akansha-chaturvedi\/#author"},"creator":{"@id":"https:\/\/2thenew.online\/blog\/author\/akansha-chaturvedi\/#author"},"datePublished":"2016-01-28T11:27:25+05:30","dateModified":"2016-02-08T12:55:18+05:30"},{"@type":"WebSite","@id":"https:\/\/2thenew.online\/blog\/#website","url":"https:\/\/2thenew.online\/blog\/","name":"TO THE NEW Blog","inLanguage":"en-US","publisher":{"@id":"https:\/\/2thenew.online\/blog\/#organization"}}]},"og:locale":"en_US","og:site_name":"TO THE NEW BLOG","og:type":"blog","og:title":"Initiate your testing with database | TO THE NEW Blog","og:description":"Database Testing Whenever we talk about any windows or web application testing, Database does always sound loud. Backbone of the application always take care with the database. So as a QA it\u2019s very necessary for us to take care of this backbone to prevent the application from the forthcoming defects in our functional test. When","og:url":"https:\/\/2thenew.online\/blog\/initiate-your-testing-with-database\/","og:image":"https:\/\/2thenew.online\/blog\/wp-content\/themes\/ttn\/images\/social-logo.png","og:image:secure_url":"https:\/\/2thenew.online\/blog\/wp-content\/themes\/ttn\/images\/social-logo.png","twitter:card":"summary","twitter:site":"@tothenew","twitter:title":"Initiate your testing with database | TO THE NEW Blog","twitter:description":"Database Testing Whenever we talk about any windows or web application testing, Database does always sound loud. Backbone of the application always take care with the database. So as a QA it\u2019s very necessary for us to take care of this backbone to prevent the application from the forthcoming defects in our functional test. When","twitter:image":"https:\/\/2thenew.online\/blog\/wp-content\/themes\/ttn\/images\/social-logo.png"},"aioseo_meta_data":{"post_id":"31862","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":"","og_description":"","og_object_type":"blog","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":"","og_custom_url":null,"og_article_section":"","og_article_tags":"","twitter_use_og":false,"twitter_card":"summary","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"Article","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"limit_modified_date":false,"created":"2021-04-30 06:14:03","updated":"2024-02-29 09:16:18","focus_keyword":null,"additional_keywords":null,"truseo_locale":null,"ai":null,"breadcrumb_settings":null,"seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/2thenew.online\/blog\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/2thenew.online\/blog\/category\/manual-testing\/\" title=\"Manual Testing\">Manual Testing<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tInitiate your testing with database\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/2thenew.online\/blog"},{"label":"Manual Testing","link":"https:\/\/2thenew.online\/blog\/category\/manual-testing\/"},{"label":"Initiate your testing with database","link":"https:\/\/2thenew.online\/blog\/initiate-your-testing-with-database\/"}],"_links":{"self":[{"href":"https:\/\/2thenew.online\/blog\/wp-json\/wp\/v2\/posts\/31862","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/2thenew.online\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/2thenew.online\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/2thenew.online\/blog\/wp-json\/wp\/v2\/users\/843"}],"replies":[{"embeddable":true,"href":"https:\/\/2thenew.online\/blog\/wp-json\/wp\/v2\/comments?post=31862"}],"version-history":[{"count":0,"href":"https:\/\/2thenew.online\/blog\/wp-json\/wp\/v2\/posts\/31862\/revisions"}],"wp:attachment":[{"href":"https:\/\/2thenew.online\/blog\/wp-json\/wp\/v2\/media?parent=31862"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/2thenew.online\/blog\/wp-json\/wp\/v2\/categories?post=31862"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/2thenew.online\/blog\/wp-json\/wp\/v2\/tags?post=31862"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}