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

Workday HCM Demo New Batches Starting from Monday... 13-11-2017
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 Starting From 14th NOV & 15th NOV.


Hadoop Dev New Batch Starting From 15th NOV & 16th NOV.


IBM COGNOS TM New Batch Starting From 16th NOV & 17th NOV.


Informatica Dev New Batch Starting From 17th NOV & 18th NOV.


Mean Stack New Batch Starting From 18th NOV & 19th NOV.

SAP BODS new Batch Starting From 19th NOV & 20th NOV.

SAP S/4 HANA New Batch Starting From 20th NOV & 21st NOV
.

Tableau New Batch Starting From 21st NOV & 22nd NOV

PUBLIC DEMO


(1) Workday Technical Demo Training

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

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