Database Testing using SQL

Bug/Defect

Author

belu

Date

2013-09-18 04:51

Views

70181065

Tutorial Database Testing using SQL

1. INTRODUCTION
1.1 Why back end testing is so important
1.2 Characteristics of back end testing
1.3 Back end testing phases
1.4 Back end test methods

2. STRUCTURAL BACK END TESTS
2.1 Database schema tests
2.1.1 Databases and devices
2.1.2 Tables, columns, column types, defaults, and rules
2.1.3 Keys and indexes
2.2 Stored procedure tests
2.2.1 Individual procedure tests
2.2.2 Intergration tests of procedures
2.3 Trigger tests
2.3.1 Update triggers
2.3.2 Insert triggers
2.3.3 Delete triggers
2.4 Intergration tests of SQL server
2.5 Server setup scripts
2.6 Common bugs

3. FUNCTIONAL BACK END TESTS
3.1 Dividing back end based on functionally
3.2 Checking data intergrity and consistency
3.3 Login and user security
3.4 Stress Testing
3.5 Test back end via front end
3.6 Banchmark testing
3.7 Common bugs

4. NIGHTLY DOWNLOADING AND DISTRIBUTION
4.1 Batch jobs
4.2 Data downloading
4.3 Data conversion
4.4 Data distribution
4.5 Nightly time window
4.6 Common bugs

5. INTERFACES TO TRANSACTION APIS
5.1 APIs' queries to back end
5.2 Outputs of back end to APIs
5.3 Common bugs

6. OTHER TEST ISSUES
6.1 Test tips
6.2 Test tools
6.3 Useful queries

Total 36

senkumari

2012-11-18 14:23

Thanks for the upload....
Iron-Kirby

2012-11-18 17:24

Thanks for sharing.
Steven Phuong

2012-11-21 12:40

Thanks for sharing !
Aarkays

2012-11-24 23:01

One of the imp. topics for a tester.

Thanks.
senvtb

2012-11-26 05:16

thank you!
Nageshd

2012-12-01 15:43

Thanks for sharing .
jangamjangam

2012-12-02 00:52

Thank you Mr.Belu.........................very important
mkhan90

2012-12-04 07:09

thanks
Steven Phuong

2012-12-08 11:27

Thanks for sharing !
nguyenptvn

2012-12-09 14:40

thanks for your sharing!
vaddi

2012-12-11 03:15

Thanks for sharing
romeo

2012-12-16 06:52

good one mate
c3sc

2013-01-10 02:08

thanks for your sharing.
sunflower_smiler

2013-01-25 11:30

Thanks for sharing.
fnana

2013-01-26 07:59

thanks a lot
silverkylin

2013-03-03 10:28

Cám ơn nha.
AtulB

2013-03-03 16:05

Great...
smalldragon

2013-03-12 18:08

Thanks!
hue2410ht

2013-03-28 09:56

thanks
kaloo

2013-04-13 22:15

tnx
twyu

2013-04-20 10:49

good sharing. thanks.
kprasanthkumarr

2013-05-12 14:36

good
SureshK

2013-05-21 19:16

thank u
Ajoy Singha

2013-06-09 19:15

Just downloaded it and seems it is a good book.

Ajoy Singha

http://testingcircus.com
Noe

2013-06-18 20:53

Thanks
Pinky21

2013-07-02 19:20

Good document
siri7

2013-07-02 19:24

Thanks for sharing
vaddi

2013-07-03 08:48

Thanks
Moraj_m

2013-07-07 21:31

thanks
sgarg

2013-09-23 00:20

Thanks
smartys

2013-09-24 21:24

Thanks
fnana

2013-10-07 13:05

This sharing is very helpful. Thanks a lot. I'm just found this a long time. Thanks again.
night'stester

2013-11-06 18:05

thanks
nguyenptvn

2013-11-11 15:15

thanks a lot!
Reddy103

2014-06-02 15:14

How to Get 100 points for downloading???
- VTB
  
  2014-06-03 16:27
  
  You can download now.

« QTP Interview Questions

Performance Testing for Anti-Virus Program »

List

Total 20,614

Number	Title	Author	Date	Votes	Views
20614	Best foreign films to start with? Bobbytrern \| 2026.07.10 \| Votes 0 \| Views 11377038	Bobbytrern	2026.07.10	0	11377038
20613	SileniusStor is specialized in reselling Cheap Aquafadas software online. Softwareces \| 2022.09.15 \| Votes 0 \| Views 70053393	Softwareces	2022.09.15	0	70053393
20612	CSStore is specialized in reselling Cheap Steinberg software online. Softwareces \| 2022.09.04 \| Votes 0 \| Views 70206549	Softwareces	2022.09.04	0	70206549
20611	Software Tester Community Website ItSeTsQtBer \| 2021.04.11 \| Votes 0 \| Views 70792321	ItSeTsQtBer	2021.04.11	0	70792321
20610	SoapUI Certification Course Content Steveskok \| 2021.02.08 \| Votes 0 \| Views 71143725	Steveskok	2021.02.08	0	71143725
20609	JavaScript Course Content Steveskok \| 2021.02.08 \| Votes 0 \| Views 70919229	Steveskok	2021.02.08	0	70919229
20608	Why most mobile testing is not continuous? (TestExpert) \| 2021.02.04 \| Votes 0 \| Views 71058920	(TestExpert)	2021.02.04	0	71058920
20607	8 Common Mistakes When Planning and Documenting Your Tests (TestExpert) \| 2021.02.04 \| Votes 0 \| Views 72548185	(TestExpert)	2021.02.04	0	72548185
20606	Types of Performance Testing Jamessmith \| 2021.01.17 \| Votes 0 \| Views 71588162	Jamessmith	2021.01.17	0	71588162
20605	How to Build E2E Test Cases (1) tanthanh \| 2020.05.28 \| Votes 0 \| Views 71060344	tanthanh	2020.05.28	0	71060344
20604	[White Paper] Delivering better software using Test Automation tanthanh \| 2020.05.28 \| Votes 0 \| Views 71457280	tanthanh	2020.05.28	0	71457280
20603	[Whitepaper] How to choose the right API Testing Solution tanthanh \| 2020.05.28 \| Votes 0 \| Views 71499007	tanthanh	2020.05.28	0	71499007
20602	[Whitepaper] How to choose the right API Testing Solution tanthanh \| 2020.05.28 \| Votes 0 \| Views 71171106	tanthanh	2020.05.28	0	71171106
20601	TestOps Introduction VTB \| 2020.03.23 \| Votes 0 \| Views 69671146	VTB	2020.03.23	0	69671146
20600	TestOps Implementation Case Study VTB \| 2020.03.23 \| Votes 0 \| Views 70994640	VTB	2020.03.23	0	70994640
20599	Selenium Automation Tester Certification Sample Exam Set 3 (TestExpert) \| 2020.02.03 \| Votes 0 \| Views 71234879	(TestExpert)	2020.02.03	0	71234879
20598	Selenium Automation Tester Certification Sample Exam Set 2 (TestExpert) \| 2020.02.03 \| Votes 0 \| Views 71514249	(TestExpert)	2020.02.03	0	71514249
20597	Selenium Automation Tester Certification : Sample Exam Set 1 (TestExpert) \| 2020.02.03 \| Votes 0 \| Views 70798460	(TestExpert)	2020.02.03	0	70798460
20596	What is agile testing? why is agile testing? and what is the benefits? (20) oishichip \| 2019.12.26 \| Votes 0 \| Views 70189930	oishichip	2019.12.26	0	70189930
20595	Crowd Testing — Vantagens para testadores, plataformas e clientes [pt-br] soikmd2 \| 2019.12.14 \| Votes 0 \| Views 70378455	soikmd2	2019.12.14	0	70378455
20594	Software Testing Industry Report (Turkey) 2018-2019 (2) ItSeTsQtB \| 2019.08.08 \| Votes 0 \| Views 70972921	ItSeTsQtB	2019.08.08	0	70972921
20593	How to bypass security in integration tests in ASP.Net Core ItSeTsQtB \| 2019.08.08 \| Votes 0 \| Views 72127075	ItSeTsQtB	2019.08.08	0	72127075
20592	For agile testing, fail fast with test impact analysis ItSeTsQtB \| 2019.08.08 \| Votes 0 \| Views 71439208	ItSeTsQtB	2019.08.08	0	71439208
20591	Career Path in Software Testing ^Software^ \| 2019.07.28 \| Votes 0 \| Views 71107149	^Software^	2019.07.28	0	71107149
20590	Challenges in Big Data Testing ^Software^ \| 2019.07.22 \| Votes 0 \| Views 71796269	^Software^	2019.07.22	0	71796269
20589	Essential Necessities In Big Data Testing ^Software^ \| 2019.07.22 \| Votes 0 \| Views 69888823	^Software^	2019.07.22	0	69888823
20588	5 Test Data Generation Techniques ^Software^ \| 2019.07.22 \| Votes 0 \| Views 71059951	^Software^	2019.07.22	0	71059951
20587	CI and CD for ETL (Extract-Transform-Load) testing. ^Software^ \| 2019.07.22 \| Votes 0 \| Views 70775503	^Software^	2019.07.22	0	70775503
20586	Quest for Quality Conference : 5-6 Nov 2019 at Dublin, Ireland VTB \| 2019.07.08 \| Votes 0 \| Views 70456807	VTB	2019.07.08	0	70456807
20585	TestBash Essentials Conference 2019 VTB \| 2019.07.08 \| Votes 0 \| Views 70813641	VTB	2019.07.08	0	70813641
20584	UKSTAR Conference : 11-03-2019 VTB \| 2019.07.08 \| Votes 0 \| Views 70135104	VTB	2019.07.08	0	70135104
20583	Testing in Context Conference Australia (TiCCA) 2019 VTB \| 2019.07.08 \| Votes 0 \| Views 71017951	VTB	2019.07.08	0	71017951
20582	European Testing Conference 2019 VTB \| 2019.07.08 \| Votes 0 \| Views 70989339	VTB	2019.07.08	0	70989339
20581	Automation Guild Online Conference 2019 VTB \| 2019.07.08 \| Votes 0 \| Views 71615457	VTB	2019.07.08	0	71615457
20580	Software Quality Days 2019 : 15 Jan 2019 (1) VTB \| 2019.07.08 \| Votes 0 \| Views 70732230	VTB	2019.07.08	0	70732230
20579	Skills required to become a Software Tester (1) IT-Tester \| 2019.07.08 \| Votes 0 \| Views 71406766	IT-Tester	2019.07.08	0	71406766
20578	Automated Unit Testing with Randoop, JWalk and µJava versus Manual JUnit Testing IT-Tester \| 2019.07.08 \| Votes 0 \| Views 69703380	IT-Tester	2019.07.08	0	69703380
20577	Scrum Testing Guide Book (2) IT-Tester \| 2019.06.26 \| Votes 0 \| Views 70287636	IT-Tester	2019.06.26	0	70287636
20576	Acceptance Testing Definition in Testing vs Scrum IT-Tester \| 2019.06.26 \| Votes 0 \| Views 71021839	IT-Tester	2019.06.26	0	71021839
20575	User Acceptance Testing Checklist VTB \| 2019.06.20 \| Votes 0 \| Views 71206977	VTB	2019.06.20	0	71206977
20574	Firewalls and Types (1) VTB \| 2018.11.14 \| Votes 0 \| Views 69814888	VTB	2018.11.14	0	69814888
20573	Senior Test Engineer (1) VTB \| 2018.11.05 \| Votes 0 \| Views 71134359	VTB	2018.11.05	0	71134359
20572	Junior Test Analyst kornadian2 \| 2018.11.04 \| Votes 0 \| Views 71259076	kornadian2	2018.11.04	0	71259076
20571	Senior Test Engineer kornadian2 \| 2018.11.04 \| Votes 0 \| Views 70764824	kornadian2	2018.11.04	0	70764824
20570	Programme Test Manager, 12m, Immed Start, $NEG kornadian2 \| 2018.11.04 \| Votes 0 \| Views 72050487	kornadian2	2018.11.04	0	72050487
20569	Junior Test Analyst kornadian2 \| 2018.11.04 \| Votes 0 \| Views 71413635	kornadian2	2018.11.04	0	71413635
20568	Dev & Test Manager kornadian2 \| 2018.11.04 \| Votes 0 \| Views 71718822	kornadian2	2018.11.04	0	71718822
20567	Senior Test Analyst (Performance Tester) kornadian2 \| 2018.11.04 \| Votes 0 \| Views 71730610	kornadian2	2018.11.04	0	71730610
20566	QA Automation Test Analyst kornadian2 \| 2018.11.04 \| Votes 0 \| Views 70623603	kornadian2	2018.11.04	0	70623603
20565	Software/Field Testing Engineer kornadian2 \| 2018.11.04 \| Votes 0 \| Views 70816451	kornadian2	2018.11.04	0	70816451

Articles

Database Testing using SQL