Mail : training@ecorptrainings.com
India : +91-8143-111-555
USA : +1-703-445-4802
Whats app : +91-8143-110-555
Facebook Twitter Google Plus Pinit Stumbleupon Youtube Blog

Workday HCM Demo New Batches Starting from Wednesday... 14-12-2016
Search Course Here




Live Chat
Support


Database Testing

overview

Database Testing is one of the major test requirements in case of backend testing. Testing data residing in database requires specific skill set to test properly. This course introduces the attendees about basic database concepts, objects which are available in a database, SQL Queries, and different types of database testing. This course will help database testers to gain a good knowledge about Database Testing concepts. Ultimately it fills the gap in between the training programs and real time projects..
prerequisties
  • Knowledge in Manual Testing.
Duration
Online
  • It is a 12 days program and extends up to 2hrs each.
  • The format is 40% theory, 60% Hands-on.

Corporate
  • It is a 3 days program and extends up to 8hrs each.
  • The format is 40% theory, 60% Hands-on.
Classroom
    Private Classroom arranged on request and minimum attendies for batch is 4.
course content
  • DATABASE TESTING CONCEPTS PRIMER
    • The Database Component: What is a Database Application?
    • Testing at the Database layer
    • Why should Test professionals know DB Basics?
    • The DB component: What is a Data-Based Application?
    • Back end vs. Front End Testing
    • Examining the data's round trip through the app
    • Common problems in Relational Databases that affect the Database Application
    • Testing the Application vs. Testing the DBMS
    • Knowledge Requirements for Database Testing
    • Test Plan: Organizing your approach
    • Data must pass Quality Assurance too!
    • Test Set up
  • RELATIONAL DATABASE BASICS FOR TESTING
    • Why should Test professionals know Relational DB basics?
    • What's a relational database?
    • Types of Data Integrity
    • Lack of data integrity introduces bugs
    • Identifying Design Defects
    • Inspecting table structures to reveal design problems
    • Exploratory Testing: Reading an ERD
    • Table Relationships: 1-1, 1-many, many-to-many
    • What to look for when Testing Relational Databases
  • DATA NORMALIZATION BUGS
    • What bugs are caused by improperly normalized databases
    • Understanding Normalization: First, 2nd and 3rd Normal Form
    • Understanding Denormalization
    • Identifying poor design; developing Test cases
  • INTRODUCTION TO SQL
    • Why should Test professionals know Structured Query Language?
    • SQL essentials
    • Basic SQL statements for Testing
Videos
For Videos Click Here Videos

Flash News


AngularJS New Batch Start From 09th DEC & 10th DEC.


Hadoop Dev New Batch Start From 10th DEC & 11th DEC.


IBM COGNOS TM New Batch Start From 11th DEC & 12th DEC.


Informatica Dev New Batch Start From 12th DEC & 13th DEC.


Mean Stack New Batch Start 13th DEC & 14th DEC.

SAP BODS new Batch Starting From 14th DEC & 15th DEC.

SAP S/4 HANA New Batch Start From 15th DEC & 16th DEC
.

Tableau New Batch Start From 16th DEC & 17th DEC

PUBLIC DEMO


(1) Workday Technical Demo Training

Demo Schedule : 09:30A.M EST / 08:30A.M CST / 6:30A.M PST on 13th DEC & 07:00A.M IST on 14th DEC

SOLVE YOUR QUERIES ONLINE
Email :
Rediff Bol :
ecorptrainings@rediffmail.com
Google Talk :
ecorptrainings@gmail.com
MSN Messenger :
ecorptrainings@hotmail.com
Yahoo Messenger :
ecorptrainings@yahoo.com
Skype Talk :
ecorptrainings