Part6 : Database Testing | Stored Procedure Testing | How To Automate SQL Stored Procedures

Topics:
-----------
1) How To Automate SQL Stored Procedures
2) Stored Procedures with No Parameters
3) Stored Procedures with Input Parameters

#########################
Udemy Courses:
#########################

Manual Testing+Agile with Jira Tool
************************************

Selenium with Java+Cucumber
********************************

Selenium with Python & PyTest
********************************

Selenium with python using Robot framework
****************************************

API Testing(Postman, RestAssured & SoapUI)
*****************************************

Web & API Automation using Cypress with Javascript
********************************************

Playwright with Javascript
**************************

Jmeter-Performance Testing
************************

SDET Essencials(Full Stack QA)
*************************

Appium-Mobile Automation Testing
************************************

Java Collections
*****************

Python Programming
*********************

Cucumber BDD Framework
***************************

Protractor with Javascript
***************************

####################################
Youtube Playlists:
####################################

Manual Testing & Agile
***********************

SQL
*************************

linux & Shell Scripting
**********************

Java
**********************

Selenium With Java+Cucumber
********************************

Python
********************************

Selenium With Python,Pytest&Behave
***************************************

Selenium With Python Using Robert Framework
(Web&API Testing)
*************************************************

API Testing (Postman,SoapUi,&Rest Assured)
**********************************************

Mobile App Testing Appium
****************************

Performance Testing Jmeter
*******************************

Maven,Jenkins,Git,Github,CI/CD
*******************************

SQL,DB Testing&ETL,Bigdata
*******************************

JavaScript Based Automation Tools
********************************

Selector Hub Tools
********************

GraphQL
******************

Cypress API Testing
********************

Cypress Web Testing
**********************

Playwright with Javascipt
**************************

#DatabaseTesting
#StoredProcedureTesting
#SQLAutomation
#DatabaseQualityAssurance
#DataTesting
#DatabaseQA
#StoredProcedures
#SQLTesting
#AutomatedTesting
#DatabaseManagement
#TestAutomation
#DatabasePerformance
#DatabaseValidation
#StoredProcValidation
#SQLQueries
#DataQuality
#DatabaseAutomation
#TestingTools
#DataIntegrity
#StoredProcQualityAssurance
#SQLBestPractices
#DatabaseOptimization
#TestingTechniques
#DataSecurity
#StoredProcOptimization
#SQLServerTesting
#AutomatingSQL
#DatabaseDesign
#TestFrameworks
#DataReliability
#StoredProcPerformance
#SQLDeveloper
#DatabaseMaintenance
#TestCoverage
#DataConsistency
#StoredProcDebugging
#SQLCoding
#DatabaseHealthCheck
#AutomationTools
#DataScrubbing
#StoredProcTuning
#SQLQueryOptimization
#DatabaseSecurity
#ContinuousIntegration
#DataValidation
#StoredProcSecurity
#SQLServerManagement
#TestScripts
#DataBackup
#AutomatingStoredProcedures

[foddiebyage]

Nice to. See database testing, more tutorials pls

[meghashreebanerjee]

got the error: what am I missing?

No goals have been specified for this build. You must specify a valid lifecycle phase or a goal in the format <plugin-prefix>:<goal> or Available lifecycle phases are: validate, initialize, generate-sources, process-sources, generate-resources, process-resources, compile, process-classes, generate-test-sources, process-test-sources, generate-test-resources, process-test-resources, test-compile, process-test-classes, test, prepare-package, package, pre-integration-test, integration-test, post-integration-test, verify, install, deploy, pre-clean, clean, post-clean, pre-site, site, post-site, site-deploy. -> [Help 1]
[ERROR]
[ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.
[ERROR] Re-run Maven using the -X switch to enable full debug logging.
[ERROR]

[Visible_]

In my eclipse ide, where I have created database testing in that icon and pom.xml icon theirs a red cross Mark,
Can anyone solve this ?

[amankumarsrivastava]

Hi Sir, Please make some videos for automation of web email testcases(how we read email or verify attachements in email or reply of email) like have created for excel reading

[koppuladattatreya]

Sir, if possible pls make videos on devops, AWS or azure, kubernates, docer etc related to devops engineering jobs

[sharathyerroju]

Hi sir could you do video about TOSCA BI

[hasvithad]

Is this for automation testing for stored procedures

[karthikj]

Hi sir, Could you please teach us the same using Python?

[jdhanrajzepherin]

I don't understanding the idea of automating a stored procedure query with sql query. Prevalently it will provide same results thus will always pass unless you make a mistake in creating stored procedure query with wrong sql query.