Part1: SQL Query Interview Questions & Answers

Topic : SQL Query Interview Questions & Answers

#########################
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
**************************

#SQLInterview
#SQLQuery
#SQLQuestions
#SQLAnswers
#SQLCoding
#SQLChallenges
#SQLPuzzles
#SQLExpert
#SQLSkills
#SQLTips
#SQLTricks
#SQLSolutions
#SQLExercises
#SQLDeveloper
#DatabaseInterview
#DatabaseQuestions
#DatabaseAnswers
#SQLServerInterview
#MySQLInterview
#OracleInterview
#PostgreSQLInterview
#DBMSInterview
#DataAnalysisInterview
#DataManipulation
#DataQuery
#SQLPerformance
#SQLNormalization
#SQLJoins
#SQLSubqueries
#SQLGroupBy
#SQLAggregations
#SQLViews
#SQLIndexes
#SQLTransactions
#SQLConstraints
#SQLOptimization
#SQLStoredProcedures
#SQLFunctions
#SQLDataTypes
#SQLDataModeling
#SQLInterviewPrep
#SQLInterviewTips
#SQLQueryTuning
#SQLQueryExamples
#SQLQueryProblems
#SQLInterviewSuccess
#SQLInterviewSkills
#SQLQueryLanguage
#SQLQuiz
#SQLInterviewSeries

[cuitlahuaccorona]

Hi sir, I would like to thank to you for the knowledge that you share. I am understanding many concepts. Greetings from México.

[KarthickKings]

Employee Table:

create table employee(Empid int, name varchar(10), ManagerId int, DOJ date, city varchar(10));

insert into employee values(121, 'John', 321, '2016-01-31', 'Hyd');
insert into employee values(321, 'David', 986, '2018-01-30', 'Chennai');
insert into employee values(421, 'Scott', 876, '2020-11-27', 'Mumbai');

[ncasmeer]

3rd question also can write
select count(EmpId) from salary where project='p1';

[vincyantony]

Thanks a lot sir . All your videos are very useful.

[andrewgray]

Good stuff my man - keep doing your thing homie! This stuff helps greatly!!

[AnuRadha-nznx]

Thanks a lot sir for making video on sql interview questions

[dharma]

Thank you so much sir.
10 days before I started learning SQL from your channel sir.

[MoizAnsari-jbim]

Thank you so much sir for sharing helpful videos

[kingsheruyt]

Thank you sir, please make videos for cloud testing

[jobisha]

Really a helpful session! Thanks for this video! :)

[sushkak]

Thank you sir. Please do Java interview questions also.🙏

[harishankar]

question 3. select count(empid) as employeecount from salary
where project ='p1'
so is this correct sir?

[shalinigajjela]

Thank you so much for understanding the concepts

[shravank]

Sir in question number 8. If i write
SELECT DISTICT FROM salary where NOT Project='P1';
Like this then it is correct or not.?

[siyaramsingh]

Thanx a lot for these wonderful sessions.

[vijaybhaskarravipati]

Please do video on manual testing sir it help us lot sir

[sekharreddy]

Hi Pawan, its a very useful session, thanks a lot this this video. Can you please do the same for Java, Selenium as well please (based on your available time)

[shashb]

Sir it’s very helpful thank you so much sir

[vaibhavshinde]

Please do a fresh series on Java interview questions as well. Thanks.

[WilsonTandeka]

Wow this is so helpful, thank you so much!