Part1: SQL Query Interview Questions & Answers
HTML-код
- Опубликовано: 20 авг 2024
- Topic : SQL Query Interview Questions & Answers
#########################
Udemy Courses:
#########################
Manual Testing+Agile with Jira Tool
************************************
► shorturl.at/xNXZ4
Selenium with Java+Cucumber
********************************
► shorturl.at/aIKMW
Selenium with Python & PyTest
********************************
► shorturl.at/ELW09
Selenium with python using Robot framework
****************************************
► shorturl.at/bcDPZ
API Testing(Postman, RestAssured & SoapUI)
*****************************************
► shorturl.at/uAWY7
Web & API Automation using Cypress with Javascript
********************************************
► rb.gy/4uum2n
Playwright with Javascript
**************************
► shorturl.at/gALZ1
Jmeter-Performance Testing
************************
► rb.gy/ocj7r2
SDET Essencials(Full Stack QA)
*************************
► rb.gy/hlnf2v
Appium-Mobile Automation Testing
************************************
► rb.gy/wmzv64
Java Collections
*****************
► bit.ly/3S66ezE
Python Programming
*********************
► urlis.net/gdsf...
Cucumber BDD Framework
***************************
► bit.ly/3F7d69r
Protractor with Javascript
***************************
► urlis.net/4udd...
####################################
RUclips Playlists:
####################################
Manual Testing & Agile
***********************
► bit.ly/3ujvaYa
► bit.ly/3OYzxQj
SQL
*************************
► bit.ly/3R6XjeG
► bit.ly/3nE0a1s
► bit.ly/3IeKuuJ
linux & Shell Scripting
**********************
► bit.ly/3up1Z6a
► bit.ly/3nzvGxx
Java
**********************
► bit.ly/3R9QfOs
► bit.ly/3AoRMKM
► bit.ly/3IbTTDn
► bit.ly/3ybXInv
► bit.ly/3yCoHdw
Selenium With Java+Cucumber
********************************
► bit.ly/3P2FMm4
► bit.ly/3yhiIt4
► bit.ly/3uokzet
► bit.ly/3a7XIND
► bit.ly/3umN2S9
► bit.ly/3aar7GW
► bit.ly/3y9kD2S
► bit.ly/3uhLskn
Python
********************************
► bit.ly/3agNgU0
► bit.ly/3NJNnoy
► bit.ly/2CTQ4mR
► bit.ly/3OIYWh1
Selenium With Python,Pytest&Behave
***************************************
► bit.ly/3OHHoC9
► bit.ly/3IeNLdv
► bit.ly/2J4tPeT
► bit.ly/3ydSkAq
Selenium With Python Using Robert Framework
(Web&API Testing)
*************************************************
► bit.ly/3nUvlpr
► bit.ly/3nUvE3z
API Testing (Postman,SoapUi,&Rest Assured)
**********************************************
► bit.ly/3OXacWY
► bit.ly/3yh0UhE
► bit.ly/3nC9DWQ
► bit.ly/3yGfhNS
► bit.ly/3OJa11H
► bit.ly/3P2slCC
Mobile App Testing Appium
****************************
► bit.ly/3Al49HG
Performance Testing Jmeter
*******************************
► bit.ly/3nz4fE7
Maven,Jenkins,Git,Github,CI/CD
*******************************
► bit.ly/3P16HPj
► bit.ly/3yhlUVA
► bit.ly/3afYfwT
► bit.ly/3yGzweG
► bit.ly/3yF73Ws
► bit.ly/3NCOmH7
SQL,DB Testing&ETL,Bigdata
*******************************
► bit.ly/3NKOcNY
► bit.ly/3OVpDyI
► bit.ly/3NEvUy0
► bit.ly/3IryxlT
► bit.ly/3RkWBLh
JavaScript Based Automation Tools
********************************
► bit.ly/3nUx51X
► bit.ly/3AqI6Q0
► bit.ly/3yeurbT
► bit.ly/3ujzpTK
Selector Hub Tools
********************
►rb.gy/h3h424
GraphQL
******************
► rb.gy/sj3gys
Cypress API Testing
********************
► shorturl.at/fjKPX
Cypress Web Testing
**********************
► shorturl.at/agjlK
Playwright with Javascipt
**************************
► shorturl.at/adSTY
#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
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');
3rd question also can write
select count(EmpId) from salary where project='p1';
Hi sir, I would like to thank to you for the knowledge that you share. I am understanding many concepts. Greetings from México.
very helpful........thank you for uploading...............
Most welcome
Thank you so much sir for sharing helpful videos
Most welcome
Thank you sir. Please do Java interview questions also.🙏
Yes guys please comments all of you for starting java interview questions sk that sir can make video on that
Thank you so much sir.
10 days before I started learning SQL from your channel sir.
Thank sir your encourage ment
Hello Hai bro u got this sql job bro.?
Very useful
Thanks
Big thanks from Russia
You’re welcome
Thanks you sir
Welcome
Nice and useful video
Thanks
you are doing a great job sir
Thank you so much for understanding the concepts
Welcome
Sir it’s very helpful thank you so much sir
Most welcome
Thank u so much sir for this video
Most welcome
Thanks a lot sir for making video on sql interview questions
Salary Table:
create table salary(Empid int, Project varchar(10), salary int, variable int);
insert into salary values (121, 'P1', 20000, 0);
insert into salary values (321, 'P2', 35000, 1000);
insert into salary values (421, 'P1', 50000, 3000);
what is the datatype we should use for p1,p2,p3 because for p1 we have varchar and integer right
Please do a fresh series on Java interview questions as well. Thanks.
Sure
Thanks lot sir ,
welcome
Thanks sir.. waiting 4 next part
Wow this is so helpful, thank you so much!
Welcome
thanks a lot sir
Most welcome
Thanks a lot sir . All your videos are very useful.
question 3. select count(empid) as employeecount from salary
where project ='p1'
so is this correct sir?
Very easy questions.
easily understandable.
Thanks
Please do video on manual testing sir it help us lot sir
Sir in question number 8. If i write
SELECT DISTICT FROM salary where NOT Project='P1';
Like this then it is correct or not.?
Thank you and keep up the good work.
Thank you
You're welcome
You are great
thanks
Pavan Sir please make a vedio on tcp ip protocol and network testing
Hi sir
We need more videos, please update in RUclips
Thank you sir , please make videos for cloud testing
Good stuff my man - keep doing your thing homie! This stuff helps greatly!!
Thanx a lot for these wonderful sessions.
Most welcome!
Thank you Sir.. But now day Interviewer asking most of SQL complex queries... Please do some videos on complex queries....
Thank you Again Pavan sir
for 8:27 do you need to select all 3 fields or just the EmpId?
Really a helpful session! Thanks for this video! :)
Welcome
You make our life easy. Thanks a lot🙏
Please post interview questions on experience post on pl/sql
Sir please do java interview questuons...
Sir please explain about Serenity bdd framework
Movie table
CREATE TABLE "MOVIE" (
"Id" int(11) NOT NULL DEFAULTS "0",
"name" VARCHAR (100) DEFAULTNULL
"year" int(11) DEFAULT NULL
"rank" float DEFAULT NULL
PRIMARY KEY "Id"
Considering the above table. How many movies does the dateset have for the year ? Write a ur query below...........
SQL practice sathi konte best platform ahet.... please reply
Could you please share this questions and answers in ppt sir
i have 3 tables
01) table employee (columns are empid,empname , depid)
02) table Department ( columns are depid, dep name)
03) table salary (columns are empid,amount,month).
Q) get the empname , how don't get the salary in the month of December
please let me know the ans for this questions ,its my request
SELECT EMPNAME
FROM EMPLOYEE
WHERE EMPID IN (SELECT EMPID FROM SALARY
WHERE AMOUNT IS NULL AND MONTH IN 'DEC');
Sir did you post the any SQL database videos in basic version
too much mic blow, I can't stand it
is this series help for interview preaparation
Sir will u provide online classes for selenium??
hello sir where do i get this ppt?
Sir, I want a sample hr database for practice please help me for the same. i'm not getting it on your websites.
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)
Hi Sir,
If I join the channel by clicking in JOIN button, can I get one to one class from you?
No
It should be Select Distinct Project from Salary and not Distinct (Project). Some times it can give rejection in interview
Thans
Sir please upload on mechanical diploma students please sir
What is the difference between mssql and sql
Hello sir, is there any paid classes for Autometion testing?
Hello gdevng sir actually which is best course in software like with out programming sir devops sql etc please reply me sir
Hello sir , do u have udemy course for Sql
THE LAST DATE FORMATE IS INCORRECT WHERE EMPID IS 421
Hi, could you please tell me what will be the SQL command in case I want the last 10 rows from the column ? Thanks in advance !!
You can use Salary Desc Limit 10
plz provide pdf of all this questions
Your recent videos have very low volume. Very hard to hear.
😍
Hi sir .. I completed M -Tech in MECHANICAL ENGINEERING.. & Working as a Asst Professor in Enginnering college since from last 10 years .. But now I want to switch in to IT field .. NOW I am learning SQL in RUclips only ... Is there any chance of getting job into IT field.. please suggest me sir.. Waiting for your reply sir...
Hi Pavan sir your explanation is superb!! But I don't get exact diff of distinct and group by
Distinct fetches unique values, Group by groups by any columns.
Sir, how many videos will be there in total as a part of this series?
Hello Sir , Where we can get sql notes ?
Hi Pavan, As said at your website, we have paid 21999 rs for QA Oct 6th batch classes. I have already sent mail where the payment details attached to the concern mail. We havent got any update or payment received confirmation mail or any sought of concern. We have even tried if we can get any contact but couldnt succeed. How should we approach you and make sure about our slot with bacth or How we will be knowing about the payment confirmation. Kindly please let us know at your earliest convenience.
Sir, I'm looking out for training on ETL testing, May I know contact number to discuss and join the course.. Thank you
Hi Pavan Sir, I am Learning manual testing and automation testing from ur channel. But SQL is important for testers. I am in a bit confusion to learn which SQL first. In Your channel there is mysql. Is that enough for testers
Any sql is fine .. there are almost similar veery slight difference. . So. If you learn. One you can do other sql aswell
Thank you sir
Welcome
Thank you
thank you so much sir