Top 10 SQL Interview Questions and Answers | SQL Interview Questions 2023 |
VloĹžit
- Äas pĹidĂĄn 3. 08. 2024
- #sql #interviewquestionsandanswers #interviewquestions
Top 10 SQL Interview Questions and Answers | SQL Interview Questions 2023 | #sql
đSQL Interview All Query PDF - drive.google.com/drive/folder...
âQ5 - Watch This Video - ⢠Most Asked SQL Intervi...
â¤ď¸Like, Share and Commentâ¤ď¸
âââââââââââââ
â¤ď¸Subscribe Now - / @datatutorials1
Do you want to become a Data Analyst or learn data analytics ? This channel is all about learning data science skills, tips and projects. My goal is to help you learn everything you need to start or switch your career into data science :)
đBook a 1:1 Call with me (Career Guidance, Mock Interviews, Resume Review, etc.) - topmate.io/data_tutorials
đFor Important Data Analyst Materials and Other Resources - topmate.io/data_tutorials
đFollow me on Facebook - profile.php?...
âââââââââââââ
âContent
00:00 Introduction
01:20 What You will Learn?
02:16 Creating Database and Tables
10:56 SQL Interview Question 1
18:42 SQL Interview Question 2
21:34 SQL Interview Question 3
27:01 SQL Interview Question 4
31:09 SQL Interview Question 5
33:22 SQL Interview Question 6
40:38 SQL Interview Question 7
47:04 SQL Interview Question 8
51:08 SQL Interview Question 9
57:28 SQL Interview Question 10
01:01:54 Outro
âââââââââââââ
âData Analyst Material available at very minimal cost of Rs. 999. This will include a complete Data Analyst Syllabus with video links, important pdf's, Q&A, this will also include Complete project on Excel (2 Projects), Tableau (3 Projects) and Power BI (1 Project). And the projects will be different from that uploaded on You Tube. If you are interested to buy contact me on my mail or WhatsApp.
For More info watch this Roadmap 2.0 video - ⢠Data Analyst Roadmap 2...
Details mentioned below-
email- swapnjeet555@gmail.com
WhatsApp - +91 9579005495
âââââââââââââ
âMore SQL Videos
SQL Most Asked Interview Questions - ⢠Most Asked SQL Intervi...
SQL Project 1- ⢠Data Analysis SQL Proj...
SQL Project 2 - ⢠SQL & Excel Portfolio ...
âââââââââââââ
Reach out to me for any personal or Business related Dashboard/ Report development on my email- swapnjeet555@gmail.com
WhatsApp - +91 9579005495
âââââââââââââ
â Data Modelling - ⢠Data Modeling in Power...
â Data Cleaning - ⢠Data Cleaning in Power...
â Data Analyst Portfolio Projects - ⢠SQL & Excel Portfolio ...
â Power BI Projects - ⢠Power BI Dashboard fro...
â Tableau Projects - ⢠Tableau Dashboard from...
â Excel Projects - ⢠Dynamic Excel Dashboar...
â SQL Projects - ⢠Data Analysis SQL Proj...
â Power BI Interview Questions with Answers - ⢠Power BI Scenario base...
â Tableau Interview Questions with Answers - ⢠Tableau Scenario Based...
âHashtagsâ
#sql #sqlinterviewquestions #sqlinterviewquestionsandanswers #sqlquestions
Related keywords
sql interview questions
sql interview questions and answers
sql interview
sql questions and answers
top sql questions
data tutorials
swapnjeet
data tutorial
sql interview questions for freshers
sql interview questions for beginners
sql interview questions for experienced
intermediate level sql interview questions
sql queries interview questions and answers
sql interview preparation
sql basic questions
sql questions
sql query
interview questions sql
interview question sql join
interview questions sql basic
Advanced SQL Interview Questions Answer
Top 10 SQL Interview Questions Answer
SQL Interview Questions in hindi
SQL Interview Questions and answers for Freshers and Experienced
Top 10 SQL Interview Questions Answer
SQL Interview Questions Answer
SQL Interview hindi
SQL Interview Questions for freshers
SQL Interview Questions and answers for freshers
SQL Roadmap 2023
SQL Interview Questions 2023
SQL Interview Experience Interview questions for SQL Experienced
BEST SQL Interview Questions
Top 10 SQL interview Questions and Answers | SQL Interview Questions
SQL interview questions and answers
SQL interview questions
SQL interview questions and answers for freshers
SQL interview questions and answers for experienced
SQL queries interview questions and answers
SQL interview questions for freshers
interview questions SQL
SQL questions and answers
sql interview questions and answers query
sql interview questions for beginners
sql interview questions for experienced
intermediate level sql interview questions
You're really Awesome!!
Thanks for your effort and creating content like this to help the data community, really appreciated your help
Thanks i've prepared my interview test with your video. am so greatful for you to provide such a content. i wish i could have you as a mentor.
great lots of lv from sri lanka
Tq
thanks boss, please make more video on SQL , deeply explain joins,subqueries,store procedure . thanks well done
As soon as possible
you are a great mentor - i am continuously learning a lot from your tutorial videos. Thank you so much !!!
Glad you like them!
man you doing great work for us !!! god bless you
on Q3, I am confused that from the 'select count...' we can only get get the counts and for sure it can be compared with 5, but why can we use the count to filter e1 as should be no such 'count' columns in e1, right?
Can you share with us the query for REGION WISE SALES , TOP 5 CATEGORY WISE SALES, COUNTRY WISE SALES etc im bit confused by using group by functions
Hi. For question 6, I couldn't understand why 3-1 is used to get 3rd highest salary. I mean, how can 3-1 give us 3rd highest salary. Could you please clear up my doubts? Thanks a ton for these videos.
Please make videos on advance SQL required power bi to create data model
Sure
In first question solution it is deleting all the duplicate records, as per me it should be keep 1 record in table and need to delete other one which is duplicate. What your thought?
I agree with you. To solve this Question Rank Function is Better option.
Row_Number also works
Row_Number also works
Sir, I tried running it and it is showing error (An expression of non-boolean type specified in a context where a condition is expected, near ','.)
Is this question for fresher or experienced person ?
Which one better career wise software testing or power BI..give me suggestion
In wich you are good enough or having interest... ask yourself
In my sql sutdio management limit clause can't use instead of what we will use sir?
I think Top
Hi, can we get sample data which you used to explain in the video
You can fire the create table query to get data, query dox available in description box
If n=3rd highest salary from employee---------- select * from ( select e_name ,e_salary, dense_rank() over(order by e_salary desc) as RN from employee ) as X where RN=3
give same o/p
Yes this works, as i said there are multiple ways to achieve it
Hi,I found error 1630 function count does not exist error please help me I fresher
IN QUESTION 10 WHY R&D RETURNS TWO TIMES
Q10 select d.dname, e ename, e salary from dept d inner join emp e on d.deptno=e.deptno
Where (e.deptno, e salary) IN (select e2.deptno, MAX( e2.salary) from emp e2 group by e2.deptno);
It not working throw an error
An expression of non-boolean type specified in a context where a condition is expected, near ','
Start from 1:21
Hello Swapnjeet. I have tried but it showing me error while creating the emp table. so what should i do?
And error is-Msg 102, Level 15, State 1, Line 9
Incorrect syntax near ','.
You are missing a comma somewhere
salary FLOAT, -- Change from DOUBLE to FLOAT
make this change in the creation script for emp table
Thanks its run@@aishwaryapattnaik3082