- 14 hours ago
Hi, this video will help you to SQL interview preparation.
Whatsapp Group Link- https://chat.whatsapp.com/Ck0eUZzs2FJBNhopD0B0Gt
SQL Script file : -
https://drive.google.com/file/d/12yz3ch_civ-5iPhGTRfhKk_gHE3cqNLe/view?usp=sharing
Whatsapp Group Link- https://chat.whatsapp.com/Ck0eUZzs2FJBNhopD0B0Gt
SQL Script file : -
https://drive.google.com/file/d/12yz3ch_civ-5iPhGTRfhKk_gHE3cqNLe/view?usp=sharing
Category
📚
LearningTranscript
00:00look, I am building a database, so I need to write create database
00:10emp, sorry, I am going to write it on October 5th, 2025
00:20I have run this database, I need to use it
00:25then we will do this, we will write it here, it will be used
00:30see, it is a master, I will click on it, it will go
00:35and I have some issues in my computer, I don't know, it will be restarted
00:41I am frustrated
00:44now I have created a table here
00:49now this table is blank
00:53I will go here and write select star from emp
00:58then it is blank
01:00now I am going to insert record
01:03this file has created a script
01:06it has come
01:08now I have done it
01:11it has come
01:13it has come
01:18this is a table
01:20I have done it
01:21I have done it
01:22I have done it
01:23I have done it
01:24I have done it
01:25I have done it
01:26I am going to test data, so I will test data.
01:30What should you do with this?
01:33Whatever question is, any question is,
01:36whether you know or not,
01:38you just have to ask them,
01:40and I will guide them.
01:42I would like to say,
01:44I have to say,
01:46I have to say,
01:48I have to say,
01:50I have to say,
01:52I have to say,
01:54but I have to say,
01:56I have to say,
01:58but I am sure
02:00I am ready to be like this.
02:02I can say that
02:04I have to say,
02:06I do not have to say that
02:08I have to say that
02:10all of them,
02:12I have to say that
02:14if you are reading,
02:16everything is called,
02:18I have to say it,
02:20but if there is something from this table,
02:23if you think about this table,
02:26you can see the table
02:29in the implied EMP table
02:32and it has 14 records.
02:35If you think about this from 14 records,
02:40I want to remove all the details
02:43which is a salesman's job role.
02:47So here we can write select,
02:52it's basic, select star,
02:54star means all,
02:56all columns,
02:57from,
02:58EMP,
02:59EMP table.
03:01If you want to write job role salesman,
03:04then you have to write higher.
03:07Higher job is equal to,
03:11here you have to write salesman.
03:16Is it?
03:17Is it?
03:18Yes.
03:19Here we go and execute it.
03:21Then we have 14 records,
03:23we have 4 records,
03:25which is the job role salesman.
03:31but here we have 8 columns.
03:38But I want to write the name,
03:43sorry,
03:44imply id and name.
03:46So here we have to write the code,
03:49here we have to write the heading,
03:51EMP,
03:52EMP,
03:53EMP,
03:54EMP,
03:55EMP,
03:56EMP,
03:57EMP,
03:58EMP,
03:59EMP.
04:00however that I have to write the heading,
04:01I will give the heading,
04:02but if I should again start,
04:06what will do?
04:07It will show you the numbers of the columns,
04:09and then I will show you the numbers from the column column,
04:13and then I have to write the column.
04:14All of these columns were shown in the beginning, because I have taken a star and the rest of these columns.
04:34Is it clear here?
04:36Yes, it is clear.
04:38Okay, so please ask your requirements.
04:44If we have another girl, then we have to bring some other departments to the other department.
04:56How do we bring some other departments?
04:58Other departments?
05:01Yes, it is clear that we have to bring some other departments to the other department.
05:13Okay, stop.
05:15Let me search the department of the other department.
05:19Let me search the department.
05:21Let me search the department.
05:23Let me search the department.
05:25Let me search the department of the department.
05:39This is my heart table, this is the department's table, I went to this table, I closed this table, and I closed this table.
05:52Who was that? Sorry, this is not the table.
05:59Now we have two tables, select star from EMP and select star from DEPT.
06:20Okay, now I will show you the data.
06:24In the top of the table, there is a department.
06:29In the first one, you will see the last one.
06:33There is a department's ID.
06:35And the second one, there is a department's ID.
06:41Yes.
06:42Yes.
06:43But if I have...
06:45Yes.
06:46Now I have selected the table, I have selected the header.
06:51I went to Excel and came here.
06:54Yes.
06:55Okay.
06:56If I have asked you to tell Excel, tell me,
07:04who is working in the account department?
07:09If I have asked you, who is working in the account department,
07:14then you will go here and go to the account filter.
07:18What?
07:19What?
07:20What?
07:21The account code is 10.
07:24And go to the department and go to the filter.
07:29These are three girls who work in account.
07:33Yes.
07:34Yes.
07:35Okay.
07:36This is done in Excel.
07:37Now I will show you how to do SQL in SQL.
07:40How to do SQL?
07:41How to do SQL in SQL?
07:42Let's see.
07:43We have two tables.
07:46We have to show you who works in account.
07:48We have to show you who works in account.
07:51So I will go here and use this table.
07:55There is an accounting department.
07:58Here I have copied this.
08:01And I will show you how to do it.
08:03And here you have to show you.
08:04Where?
08:05Where?
08:06Where is the department?
08:07This is where?
08:08Where is the department?
08:09This is where?
08:10What?
08:11Accounting?
08:12The name.
08:13The name.
08:14Department name is equal to accounting.
08:18This is the 10.
08:20This is 10, but I need all the time, I just need department number, DEPTNO, see.
08:33This is a little bit of exit, so I need to join again, okay?
08:40Yes.
08:41Now, let's see, this is telling us, what is the 10 number of department, it is what is it?
08:46Accounting.
08:48Accounting.
08:49Now, I went to select table, and I wrote it here, and I wrote it here, and I wrote it here,
08:57and here, my partner has a number 10, so I wrote it here, DEPT, NO is equal to 10, now you can
09:07see here, where is the driver?
09:16Yeah, where should you be captured?
09:17Yeah, where.
09:18Where, where should you be located?
09:20Where?
09:21Department of Order.
09:22Yes, where, where Am I.
09:23Where, where department should you be talking?
09:24I have 10. Yes, sir.
09:26But I have 10 types of code.
09:28I have manually typed it.
09:30But from this query we have removed the code.
09:38So I will copy this query.
09:42I will write where department is equal to this.
09:46What is this query?
09:52The accounts department is wrong.
09:58This query is giving us 10.
10:04What do you understand?
10:06I have taken the account.
10:10I have taken the account.
10:12This query will give us 10.
10:16This query will give us 10.
10:18But the query will give us 10.
10:22Sub query.
10:24And inside query.
10:26This is the inner query.
10:28This is the outer query.
10:30Now, when you do this,
10:34there are 3 people who are working on the account department.
10:38We are doing a manual, so if we know that this is a department ID, then it will be a manual,
10:54then we will write the entire query.
10:58I am sure you need cells.
11:02Everything will be like this.
11:05We will write cells here.
11:12All the people...
11:15It's a little bit...
11:18No, it's okay.
11:23All the people are cells in the cells.
11:28But the department number is different than 30, 30, 30, 30.
11:33Where is?
11:34It's different than 30, 30, 30, 30.
11:38Now, when you go to the department, you can see that the sales are 30.
11:48And now you can see that the sales are 30, 30, 30, 30, 30, 30.
12:10And this is my SQL table.
12:15I can also call this table in Power BI.
12:23How do you apply this?
12:25I'm opening Power BI here.
12:29Suppose I can log in Power BI.
12:37I will import data from the other source into blank report.
12:43It's more than 100 to the database.
12:47Where I will do it in Excel.
12:50Here is the data you have to do from Excel.
12:54If you want to do it in SQL server, I will go here.
12:58I am asking the name of the server, so I am going to go to the server, and here I am going to get connected to the database engine.
13:12This is my server name. This is the name of the server, and this is the name of the server.
13:19This is the name of the server, and the name of the server is the name of the server.
13:30Have you done it?
13:32Yes.
13:33I have done it.
13:36Let's see what happens.
13:40Let's see what happens.
13:47Let's see what happens.
13:50We have created two tables.
13:55Is it coming?
13:57Yes.
13:58I am coming.
14:00I have loaded it.
14:02Load.
14:10I have loaded them.
14:11Yes.
14:12All of us.
14:13Have you loaded a load?
14:14Yes.
14:15It has been the same.
14:16This is my department and the employee.
14:17There is a lot of records in the employee.
14:19I have gone to the SQL and there is one record.
14:23I are going to the SQL and there is another record.
14:33I had only copied that record.
14:36I copied this record and copied it here and here I gave it 1, 2, 3, 4 and here I gave it to your name.
14:49I gave it to the department and here I gave it to your manager.
15:03I gave it to the Tel Aviv and the Numbers was $13,000.
15:17I gave it to the department and this record was $3,000.
15:22This record was made by the SQL.
15:26Clear?
15:29Here, when you saw the first one, there was 14 records.
15:37Now, this one record will increase.
15:41I have inserted it.
15:44Now, I have done it in the implied table.
15:47So, it was 15 records.
15:50Now, there is no record record in Power BI.
15:56Do you have any?
15:59No.
16:00Now, I have done it in the implied table.
16:04I have done it in the reference data.
16:07Look, this one is coming from the Ravivala.
16:13Yes, it is coming.
16:15Okay, this is the SPLM.
16:17This one is Power BI.
16:20This one is a module.
16:23We have created a link.
16:26Yes, it is a link.
16:27So, here, the module means?
16:30It is created a relationship.
16:33Here, the department is created.
16:36If I go to the report view,
16:42from the report view and I will add the name of the implied table.
16:49Yes, it is.
16:50Do you have the name of the implied table?
16:52Yes, it is.
16:53Yes, it is.
16:54And here, I will add a filter.
16:57Take a slicer.
16:59Do you have the slicer?
17:00Yes, it is.
17:01And the slicer is going to the department.
17:05I will add the name of the department.
17:07Do you have the name of the department?
17:09the name of the company
17:11yes
17:13now
17:15see
17:17whatever I click on the name of the department
17:19the person of the company
17:21there is no one in the operation
17:23there is no one in the operation
17:25see
17:27there is something in the accounting
17:29there is no one
17:31there is no one in the account
17:33there is no one
17:35so this is the power of the company
17:37we work with data
17:39yes
17:415
17:434
17:451
17:472
17:493
17:514
17:531
17:552
17:573
17:594
18:015
18:035
18:055
18:075
18:095
18:115
18:135
18:155
18:175
18:195
18:215
18:236
18:255
18:275
18:296
18:316
18:336
18:356
18:376
18:397
18:416
18:437
18:457
18:477
18:498
18:518
18:538
18:559
18:579
18:599
19:0110
19:0310
19:0510
19:0710
19:0910
19:2310
19:2510
19:2710
19:2911
19:3111
19:3312
19:3512
19:3712
19:3910
19:4112
19:4312
19:4514
19:4715
19:4914
19:5115
19:5315
19:5415
19:5515
19:5615
19:5715
19:5815
19:5915
20:0015
20:0115
20:0216
20:0315
20:0415
20:0515
20:06I don't know
20:08I
20:10I
20:12I
20:14I
20:16I
20:18I
20:20I
20:22I
20:24I
20:26I
20:28I
20:30I
20:32I
20:34I
20:36I
20:38I
20:40I
20:42I
20:44I
20:46I
20:48I
20:50I
20:52I
20:54I
20:56I
20:58I
21:00I
21:02I
21:04I
21:06I
21:08I
21:10I
21:12I
21:14I
21:16I
21:18I
21:20I
21:22I
21:24I
21:26I
21:28I
21:30I
21:32I
21:34I
21:36I
21:38I
21:40I
21:42I
21:44I
21:46I
21:48I
21:50I
21:52I
21:54I
21:56I
21:58I
22:00I
22:02I
22:04I
22:06I
22:08I
22:10I
22:12I
22:14I
22:16I
22:18I
22:32I
22:34I
22:36I
22:38I
22:40I
22:42I
22:44I
22:46I
22:48I
22:50I
22:52I
22:54I
22:56I
22:58I
23:00I
23:02I
23:04I
23:06I
23:08I
23:14I
23:16I
23:18I
23:20I
23:22I
23:24I
23:26I
23:28I
23:30I
23:32I
23:34I
23:36I
23:38I
23:40I
23:42I
23:52I
23:54I
23:56I
23:58I
24:00I
24:02I
24:04I
24:20I
24:22I
24:24I
24:26I
24:28I
24:30I
24:32I
24:34I
24:36I
24:38I
24:40I
24:42I
24:44I
24:46I
24:48I
24:50I
24:52I
24:54I
24:56I
24:58I
25:00I
25:02I
25:04I
25:06I
25:08I
25:10I
25:12I
25:14I
25:16I
25:18I
25:20I
25:22I
25:24I
25:26I
25:28I
25:30I
25:32I
25:34I
25:36I
25:38I
25:40I
25:42I
25:44I
25:46I
25:48I
25:50I
25:52I
25:54I
25:56I
25:58I
26:00I
26:02I
26:06I
26:08I
26:10I
26:16I
26:18I
26:20I
26:22I
26:24I
26:26I
26:28I
26:30I
26:32I
26:34I
26:36I
26:38I
26:40I
26:42I
26:44I
26:46I
26:48I
26:50I
26:52I
26:54I
26:56I
26:58I
27:00I
27:02I
27:04I
27:06I
27:08I
27:10I
27:12I
27:14I
27:16I
27:18I
27:20I
27:22I
27:24I
27:26I
27:28I
27:30I
27:32I
27:34I
27:36I
27:38I
27:40I
27:42I
27:44I
27:46I
27:48I
27:50I
27:52I
27:54I
28:00I
28:02I
28:04I
28:06I
28:08I
28:10I
28:12I
28:14I
28:16I
28:18I
28:20I
28:22I
28:24I
28:26I
28:28I
28:30I
28:32I
28:34I
28:36I
28:38I
28:40I
28:42I
28:44I
28:46I
28:48I
28:50I
28:52I
28:54I
28:56I
28:58I
29:00I
29:02I
29:04I
29:06I
29:08I
29:10I
29:12I
29:16I
29:18I
29:20I
29:22I
29:24I
29:26I
29:28I
29:30I
29:32I
29:34I
29:36I
29:38I
29:40I
29:42I
29:48I
29:50I
29:52I
29:54I
29:56I
29:58I
30:00I
30:02I
30:04I
30:06I
30:08I
30:09I
30:11I
30:13I
30:15I
30:17I
30:19I
30:21I
30:23I
30:33I
30:35I
30:37I
30:39I
30:41I
30:43I
30:45I
30:47I
30:49I
30:51I
30:53I
30:55I
30:57I
30:59I
31:01I
31:03I
31:05I
31:07I
31:09I
31:11I
31:13I
31:15I
31:17I
31:19I
31:21I
31:23I
31:25I
31:27I
31:29I
31:31I
31:37I
31:39I
31:41I
31:43I
31:45I
31:47I
31:49I
31:51I
31:53I
31:55I
31:57I
31:59I
32:01I
32:03I
32:05I
32:07I
32:09I
32:11I
32:13I
32:15I
32:17I
32:19I
32:21I
32:23I
32:25I
32:27I
32:29I
32:31I
32:33I
32:47I
32:49I
32:51I
32:53I
32:55I
32:57I
32:59I
33:01I
33:03I
33:05I
33:07I
33:09I
33:11I
33:13I
33:15I
33:17I
33:19I
33:21I
33:23I
33:25I
33:27I
33:29I
33:31I
33:33I
33:35I
33:37I
33:39I
33:41I
33:43I
33:45I
33:47I
33:49I
33:51I
33:53I
33:55I
33:57I
33:59I
34:01I
34:03I
34:05I
34:07I
34:09I
34:11I
34:13I
34:15I
34:17I
34:19I
34:21I
34:23I
34:25I
34:27I
34:29I
34:31I
34:33I
34:35I
34:37I
34:39I
34:41I
34:43I
34:45I
34:47I
34:49I
34:51I
34:53I
34:55I
34:57I
34:59I
35:01I
35:03I
35:05I
35:07I
35:09I
35:11I
35:13I
35:15I
35:17I
35:19I
35:21I
35:23I
35:25I
35:27I
35:29I
35:31I
35:33I
35:35I
35:37I
35:39I
35:41I
35:43I
35:49I
35:51I
35:53I
35:55I
35:57I
35:59I
36:01I
36:03I
36:05I
36:07I
36:09I
36:11I
36:13I
36:15I
36:17I
36:19I
36:21I
36:23I
36:25I
36:27I
36:29I
36:31I
36:33I
36:35I
36:37I
36:39I
36:41I
36:43I
36:45I
36:47I
36:49I
36:51I
36:53I
36:55I
36:57I
36:59I
37:01I
37:03I
37:05I
37:07I
37:09I
37:11I
37:13I
37:15I
37:17I
37:19I
37:21I
37:23I
37:25I
37:27I
37:29I
37:31I
37:33I
37:35I
37:37I
37:39I
37:41I
37:43I
37:45I
37:47I
37:49I
37:51I
37:53I
37:55I
37:57I
37:59I
38:01I
38:03I
38:05I
38:07I
38:09I
38:11I
38:13I
38:15I
38:17I
38:19I
38:21I
38:23I
38:25I
38:27I
38:29I
38:31I
38:33I
38:35I
38:37I
38:39I
38:41I
38:43I
38:45I
38:47I
38:49I
38:51I
38:53I
38:55I
38:57I
38:59I
39:01I
39:03I
39:05I
39:07I
39:09I
39:11I
39:13I
39:15I
39:17I
39:19I
39:21I
39:23I
39:25I
39:27I
39:29I
39:31I
39:33I
39:35I
39:37I
39:39I
39:41I
39:43I
39:45I
39:47I
39:49I
39:51I
39:53I
39:55I
39:57I
39:59I
40:01I
40:03I
40:05I
40:07I
40:09I
40:11I
40:13I
40:15I
40:17I
40:19I
40:21I
40:23I
40:25I
40:27I
40:29I
40:31I
40:33I
40:35I
40:37I
40:39I
40:41I
40:43I
40:45I
40:47I
40:57I
40:59I
41:01I
41:03I
41:05I
41:07I
41:09I
41:11I
41:13I
41:15I
41:17I
41:19I
41:21I
41:23I
41:25I
41:27I
41:29I
41:31I
41:33I
41:35I
41:37I
41:39I
41:45I
41:47I
41:49I
41:51I
41:55I
41:57I
41:59I
42:01I
42:03I
42:05I
42:07I
42:09I
42:11I
42:13I
42:15I
42:17I
42:19I
42:21I
42:23I
42:25I
42:27I
42:29I
42:31I
42:33I
42:35I
42:37I
42:39I
42:41I
42:43I
42:45I
42:47I
42:49I
42:51I
42:53I
42:55I
42:57I
42:59I
43:01I
43:03I
43:05I
43:07I
43:09I
43:11I
43:13I
43:15I
43:17I
43:19I
43:21I
43:23I
43:25I
43:27I
43:29I
43:31I
43:33I
43:35I
43:37I
43:39I
43:41I
43:43I
43:45I
43:47I
43:49I
43:51I
43:53I
43:55I
43:57I
43:59I
44:01I
44:03I
44:05I
44:07I
44:09I
44:19I
44:20I
44:22I
44:24I
44:26I
44:28I
44:30I
44:32I
44:34I
44:36I
44:38I
44:40I
44:42I
44:44I
44:46I
44:48I
44:50I
44:52I
44:54I
44:56I
44:58I
45:00I
45:02I
45:04I
45:06I
45:08I
45:10I
45:12I
45:14I
45:16I
45:18I
45:20I
45:22I
45:24I
45:26I
45:28I
45:30I
45:32I
45:34I
45:36I
45:38I
45:40I
45:42I
45:44I
45:46I
46:00I
46:02I
46:04I
46:06I
46:08I
46:10I
46:12I
46:14I
46:16I
46:18I
46:20I
46:22I
46:24I
46:26I
46:28I
46:30I
46:32I
46:34I
46:36I
46:38I
46:40I
46:42I
46:44I
46:46I
46:48I
46:50I
46:52I
46:54I
46:56I
46:58I
47:00I
47:02I
47:04I
47:06I
47:08I
47:10I
47:12I
47:14I
47:16I
47:18I
47:20I
47:22I
47:24I
47:26I
47:28I
47:30I
47:32I
47:34I
47:36I
47:38I
47:40I
47:42I
47:44I
47:46I
47:48I
47:50I
47:52I
47:54I
47:56I
47:58I
48:00I
48:02I
48:04I
48:06I
48:08I
48:10I
48:12I
48:14I
48:16I
48:18I
48:20I
48:22I
48:24I
48:26I
48:28I
48:30I
48:32I
48:34I
48:36I
48:38I
48:40I
48:42I
48:44I
48:46I
48:48I
48:50I
48:52I
48:54I
48:56I
48:58I
49:00I
49:02I
49:04I
49:06I
49:08I
49:10I
49:12I
49:14I
49:16I
49:18I
49:20I
49:22I
49:24I
49:26I
49:28I
49:30I
49:32I
49:34I
49:36I
49:38I
49:40I
49:42I
49:44I
49:46I
49:48I
49:50I
49:52I
49:54I
49:56I
49:58I
50:00I
50:02I
50:04I
50:06I
50:08I
50:10I
50:12I
50:14I
50:16I
50:18I
50:20I
50:22I
50:24I
50:26I
50:28I
50:30I
50:32I
50:34I
50:36I
50:38I
50:40I
50:42I
50:44I
50:46I
50:48I
50:50I
50:52I
50:54I
50:56I
50:58I
51:00I
51:02I
51:04I
51:06I
51:08I
51:10I
51:12I
51:14I
51:20I
51:22I
51:24I
51:26I
51:28I
51:30I
51:32I
51:46I
51:48I
51:50I
51:52I
51:56I
51:58I
52:00I
52:02I
52:04I
52:06I
52:08I
52:10I
52:12I
52:14I
Recommended
35:08
|
Up next
16:02
1:26:15
1:27:55
46:52
1:30:13
1:17:44
1:50:38
1:11:49
1:31:40
1:08:19
0:48
1:43
1:08:26
1:08:17
1:44:20
19:03
1:03:00
1:31:31
Be the first to comment