1:1 SQL Interview Session | Basics of SQL | SQL training | MySQL | IvyProSchool

Common SQL Interview Questions (Basic) are as follows:

1. How to import files in MySQL?
2. What is Normalization?
3. What is One to Many and Many to Many relationship?
4. Types of SQL statements?
5. How to find Unique names from a list?
6. Difference between where and having?
7. How to find second highest scorer?
8. Difference between Dense Rank and Rank?
9.How to find names containing single "e"?
10.Which Join would you prefer for a particular question?

Liked the video?

Subscribe to Our Channel to get regular updates on amazing Data Science Industry Talks, Interviews, and Webinars.

0:00 Introduction
1:21 What have you done in MySQL database?
1:51 What kind of data have you imported?
2:06 Why did you choose MySQL?
2:42 Focus on DB Management Platform or Language?
3:10 What did you like and dislike about SQL?
4:38 Workbench/Command prompt to import files?
5:13 Normalization
6:55 Where should we place foreign key?
7:13 One to many relationship
10:46 Many to many relationship
14:43 Types of SQL statements
15:29 Examples of DDL & DML statements
19:37 Select statements
19:46 How to find unique names?
21:28 Difference between where and having?
22:04 2nd Highest Scorer
24:57 Dense Rank vs Rank
27:22 Names containing single 'e'
29:23 Joins

[dawnhuttoe]

I am just finishing my Masters in healthcare informatics and I have not yet worked in the field. I am grateful for these interview questions.... I was able to answer quite of the question a correctly for a few for a beginner👍

[abhimanyutiwari]

We want more real interview session like this.

[upalroy]

I have to admit this is very helpful. Instead of going through those long videos, this kind of content is very helpful when comes to revise

[ssunny]

I laugh so hard on the line- am I taking your interview or you are taking my interview ;🤣🤣🤣🤣😀😀

[sahilbhuwad]

For finding the name with just a single e can we write this query - select fullname
from student
where fullname like '%e%' and fullname not like '%e%e%';

[swastman]

Well explained. This video is helpful for preparing interviews.

[Ujwala]

Excellent video for who is preparing for interview 👍

[qasimbinabrarsyed]

Very good from Pakistan. Productivity has no regional bounds

[daswanthkumar]

good questions and good explanation as well ..

[Ganeshay-]

I have one year experience but I facing problem in interview sql interview..what should I do

[SagarKumar-dbxy]

Wow. Instant subscribe. What you guys doing is just awesome

[cavin]

This is basic please bring some high level interview questions also

[winnumber]

Thank you, very excellent interviewer

[fattofit]

Sir i want to mock with you tell me procedure

[dovyraj]

shud have seen this before my goldman sachs interview, i just messed it up

[sriramch]

Can u any one give charity about query in joins

[DeepakGupta-yxng]

Can anyone please tell me how to write a query for list of names that contain single 'e'. Please....

[abhayjadon]

Hi sir , , i am a dropout but i have knowlege in SQL, ,can I get ajob, ,, i really need a job

[rvd]

Guarantee ke saath selection nhi hua iskaaa