Database Testing using SQL

Bug/Defect

Author

belu

Date

2013-09-18 04:51

Views

60372398

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 1250512	Bobbytrern	2026.07.10	0	1250512
20613	SileniusStor is specialized in reselling Cheap Aquafadas software online. Softwareces \| 2022.09.15 \| Votes 0 \| Views 60257710	Softwareces	2022.09.15	0	60257710
20612	CSStore is specialized in reselling Cheap Steinberg software online. Softwareces \| 2022.09.04 \| Votes 0 \| Views 60380683	Softwareces	2022.09.04	0	60380683
20611	Software Tester Community Website ItSeTsQtBer \| 2021.04.11 \| Votes 0 \| Views 60786425	ItSeTsQtBer	2021.04.11	0	60786425
20610	SoapUI Certification Course Content Steveskok \| 2021.02.08 \| Votes 0 \| Views 61737755	Steveskok	2021.02.08	0	61737755
20609	JavaScript Course Content Steveskok \| 2021.02.08 \| Votes 0 \| Views 60710508	Steveskok	2021.02.08	0	60710508
20608	Why most mobile testing is not continuous? (TestExpert) \| 2021.02.04 \| Votes 0 \| Views 61289493	(TestExpert)	2021.02.04	0	61289493
20607	8 Common Mistakes When Planning and Documenting Your Tests (TestExpert) \| 2021.02.04 \| Votes 0 \| Views 62805533	(TestExpert)	2021.02.04	0	62805533
20606	Types of Performance Testing Jamessmith \| 2021.01.17 \| Votes 0 \| Views 61950467	Jamessmith	2021.01.17	0	61950467
20605	How to Build E2E Test Cases (1) tanthanh \| 2020.05.28 \| Votes 0 \| Views 61566836	tanthanh	2020.05.28	0	61566836
20604	[White Paper] Delivering better software using Test Automation tanthanh \| 2020.05.28 \| Votes 0 \| Views 61399200	tanthanh	2020.05.28	0	61399200
20603	[Whitepaper] How to choose the right API Testing Solution tanthanh \| 2020.05.28 \| Votes 0 \| Views 60975694	tanthanh	2020.05.28	0	60975694
20602	[Whitepaper] How to choose the right API Testing Solution tanthanh \| 2020.05.28 \| Votes 0 \| Views 60853504	tanthanh	2020.05.28	0	60853504
20601	TestOps Introduction VTB \| 2020.03.23 \| Votes 0 \| Views 60200349	VTB	2020.03.23	0	60200349
20600	TestOps Implementation Case Study VTB \| 2020.03.23 \| Votes 0 \| Views 60998522	VTB	2020.03.23	0	60998522
20599	Selenium Automation Tester Certification Sample Exam Set 3 (TestExpert) \| 2020.02.03 \| Votes 0 \| Views 61653208	(TestExpert)	2020.02.03	0	61653208
20598	Selenium Automation Tester Certification Sample Exam Set 2 (TestExpert) \| 2020.02.03 \| Votes 0 \| Views 61609211	(TestExpert)	2020.02.03	0	61609211
20597	Selenium Automation Tester Certification : Sample Exam Set 1 (TestExpert) \| 2020.02.03 \| Votes 0 \| Views 60940594	(TestExpert)	2020.02.03	0	60940594
20596	What is agile testing? why is agile testing? and what is the benefits? (20) oishichip \| 2019.12.26 \| Votes 0 \| Views 60056077	oishichip	2019.12.26	0	60056077
20595	Crowd Testing — Vantagens para testadores, plataformas e clientes [pt-br] soikmd2 \| 2019.12.14 \| Votes 0 \| Views 60331150	soikmd2	2019.12.14	0	60331150
20594	Software Testing Industry Report (Turkey) 2018-2019 (2) ItSeTsQtB \| 2019.08.08 \| Votes 0 \| Views 61400467	ItSeTsQtB	2019.08.08	0	61400467
20593	How to bypass security in integration tests in ASP.Net Core ItSeTsQtB \| 2019.08.08 \| Votes 0 \| Views 62489091	ItSeTsQtB	2019.08.08	0	62489091
20592	For agile testing, fail fast with test impact analysis ItSeTsQtB \| 2019.08.08 \| Votes 0 \| Views 61328344	ItSeTsQtB	2019.08.08	0	61328344
20591	Career Path in Software Testing ^Software^ \| 2019.07.28 \| Votes 0 \| Views 61487753	^Software^	2019.07.28	0	61487753
20590	Challenges in Big Data Testing ^Software^ \| 2019.07.22 \| Votes 0 \| Views 61622004	^Software^	2019.07.22	0	61622004
20589	Essential Necessities In Big Data Testing ^Software^ \| 2019.07.22 \| Votes 0 \| Views 59668029	^Software^	2019.07.22	0	59668029
20588	5 Test Data Generation Techniques ^Software^ \| 2019.07.22 \| Votes 0 \| Views 61492368	^Software^	2019.07.22	0	61492368
20587	CI and CD for ETL (Extract-Transform-Load) testing. ^Software^ \| 2019.07.22 \| Votes 0 \| Views 61225310	^Software^	2019.07.22	0	61225310
20586	Quest for Quality Conference : 5-6 Nov 2019 at Dublin, Ireland VTB \| 2019.07.08 \| Votes 0 \| Views 60618475	VTB	2019.07.08	0	60618475
20585	TestBash Essentials Conference 2019 VTB \| 2019.07.08 \| Votes 0 \| Views 61082461	VTB	2019.07.08	0	61082461
20584	UKSTAR Conference : 11-03-2019 VTB \| 2019.07.08 \| Votes 0 \| Views 60202561	VTB	2019.07.08	0	60202561
20583	Testing in Context Conference Australia (TiCCA) 2019 VTB \| 2019.07.08 \| Votes 0 \| Views 60734367	VTB	2019.07.08	0	60734367
20582	European Testing Conference 2019 VTB \| 2019.07.08 \| Votes 0 \| Views 61016400	VTB	2019.07.08	0	61016400
20581	Automation Guild Online Conference 2019 VTB \| 2019.07.08 \| Votes 0 \| Views 62262515	VTB	2019.07.08	0	62262515
20580	Software Quality Days 2019 : 15 Jan 2019 (1) VTB \| 2019.07.08 \| Votes 0 \| Views 61162687	VTB	2019.07.08	0	61162687
20579	Skills required to become a Software Tester (1) IT-Tester \| 2019.07.08 \| Votes 0 \| Views 61354283	IT-Tester	2019.07.08	0	61354283
20578	Automated Unit Testing with Randoop, JWalk and µJava versus Manual JUnit Testing IT-Tester \| 2019.07.08 \| Votes 0 \| Views 59730973	IT-Tester	2019.07.08	0	59730973
20577	Scrum Testing Guide Book (2) IT-Tester \| 2019.06.26 \| Votes 0 \| Views 60351164	IT-Tester	2019.06.26	0	60351164
20576	Acceptance Testing Definition in Testing vs Scrum IT-Tester \| 2019.06.26 \| Votes 0 \| Views 61138149	IT-Tester	2019.06.26	0	61138149
20575	User Acceptance Testing Checklist VTB \| 2019.06.20 \| Votes 0 \| Views 61678172	VTB	2019.06.20	0	61678172
20574	Firewalls and Types (1) VTB \| 2018.11.14 \| Votes 0 \| Views 59974467	VTB	2018.11.14	0	59974467
20573	Senior Test Engineer (1) VTB \| 2018.11.05 \| Votes 0 \| Views 61114865	VTB	2018.11.05	0	61114865
20572	Junior Test Analyst kornadian2 \| 2018.11.04 \| Votes 0 \| Views 61195469	kornadian2	2018.11.04	0	61195469
20571	Senior Test Engineer kornadian2 \| 2018.11.04 \| Votes 0 \| Views 60866614	kornadian2	2018.11.04	0	60866614
20570	Programme Test Manager, 12m, Immed Start, $NEG kornadian2 \| 2018.11.04 \| Votes 0 \| Views 62348398	kornadian2	2018.11.04	0	62348398
20569	Junior Test Analyst kornadian2 \| 2018.11.04 \| Votes 0 \| Views 61427946	kornadian2	2018.11.04	0	61427946
20568	Dev & Test Manager kornadian2 \| 2018.11.04 \| Votes 0 \| Views 61816864	kornadian2	2018.11.04	0	61816864
20567	Senior Test Analyst (Performance Tester) kornadian2 \| 2018.11.04 \| Votes 0 \| Views 61775566	kornadian2	2018.11.04	0	61775566
20566	QA Automation Test Analyst kornadian2 \| 2018.11.04 \| Votes 0 \| Views 60883190	kornadian2	2018.11.04	0	60883190
20565	Software/Field Testing Engineer kornadian2 \| 2018.11.04 \| Votes 0 \| Views 60679052	kornadian2	2018.11.04	0	60679052

Articles

Database Testing using SQL