1
00:00:00,720 --> 00:00:08,130
And to this day, we will learn about a court in poverty, so let's go to the poverty created by clicking

2
00:00:08,130 --> 00:00:08,670
on Tosspot.

3
00:00:09,690 --> 00:00:13,860
So first we will need to know that what's the difference between list and.

4
00:00:15,560 --> 00:00:23,600
Records so list is based on a single column, like, for example, if we want to make a list for the

5
00:00:23,630 --> 00:00:34,100
ship date, what we have to do is we just need to click effects and then we need to write the name of

6
00:00:34,100 --> 00:00:36,040
the column ship date.

7
00:00:38,120 --> 00:00:39,920
So this is a list, right?

8
00:00:39,950 --> 00:00:47,660
And list always based on the single column and all the roles within a single column.

9
00:00:49,640 --> 00:00:56,120
And what is record record consist of more than one columns.

10
00:00:56,490 --> 00:00:56,860
Right?

11
00:00:56,960 --> 00:01:07,660
Like if I click here like four and here you can see this is the record, the record that is available

12
00:01:07,780 --> 00:01:08,890
at 44.

13
00:01:09,320 --> 00:01:09,730
Right.

14
00:01:10,040 --> 00:01:11,720
And if I click on 28.

15
00:01:12,200 --> 00:01:21,610
So here we are getting the data for this row and it contains all the columns, as you can see here.

16
00:01:21,740 --> 00:01:22,090
Right.

17
00:01:23,540 --> 00:01:28,370
So let's try to create a one simple record by our own.

18
00:01:29,000 --> 00:01:31,370
Just we just need to.

19
00:01:31,700 --> 00:01:32,090
Right.

20
00:01:32,090 --> 00:01:35,330
Click here and go to the blank here.

21
00:01:35,340 --> 00:01:36,020
We have to write.

22
00:01:37,740 --> 00:01:40,190
Bracket and then.

23
00:01:42,510 --> 00:01:50,040
The name of the column will be like employed, employed, it's equal to one.

24
00:01:51,310 --> 00:02:01,480
Here and here, you can see this is the single record, like we have one attribute, the head of the

25
00:02:01,480 --> 00:02:05,260
column, and this is the value, and then we can write one more

26
00:02:08,140 --> 00:02:16,300
like a name is equal to first and this is the second.

27
00:02:18,410 --> 00:02:24,860
And then we we can right here, like, um, great.

28
00:02:35,020 --> 00:02:37,880
This is consultant, right?

29
00:02:38,440 --> 00:02:44,750
So this is on the court, so if you're free.

30
00:02:45,220 --> 00:02:47,350
So what will happen if we're right here?

31
00:02:48,690 --> 00:02:55,050
The curly bracket and then close the so-called they.

32
00:02:56,670 --> 00:02:57,930
So what we will get.

33
00:02:59,150 --> 00:03:02,040
We will get one list right?

34
00:03:02,480 --> 00:03:08,870
So here you can see the list and this list is consist of one record here.

35
00:03:09,790 --> 00:03:22,400
Right, and because everything that goes right in between the Carlebach, it is called list, and let's

36
00:03:22,400 --> 00:03:24,710
try to add one more record here.

37
00:03:26,560 --> 00:03:40,560
So what you can do is we just need to copy this record and then comma and here and right, so here they

38
00:03:40,780 --> 00:03:46,360
employ the name is to the ideas to and the name is Testa.

39
00:03:47,050 --> 00:03:47,920
And this is.

40
00:03:50,170 --> 00:03:51,190
Like a manager.

41
00:03:56,980 --> 00:03:57,400
So.

42
00:03:58,870 --> 00:04:03,610
We have one list that consists of two records.

43
00:04:03,700 --> 00:04:11,910
So now we need to confirm it and here you can see we are getting two records and you click here.

44
00:04:12,280 --> 00:04:16,900
You can see this is the first record that can one and this is the second record.

45
00:04:17,200 --> 00:04:17,620
Right.

46
00:04:19,630 --> 00:04:31,330
And then we can convert this list into table if we want to perform some type of functions on it.

47
00:04:33,590 --> 00:04:41,870
So we just need to click the we need to click the source and then convert to table.

48
00:04:41,890 --> 00:04:48,810
So we are getting a table with one column and it contains two records, this one and this one.

49
00:04:48,940 --> 00:04:50,680
Let's go back to the source again.

50
00:04:52,250 --> 00:05:06,140
And so let's make a copy, particularly two and we can write here, query three and we can remove the

51
00:05:06,180 --> 00:05:09,550
the list and the the second record.

52
00:05:11,710 --> 00:05:17,980
So here you can see this is the single record right now.

53
00:05:18,040 --> 00:05:26,500
We have to learn how we can access the individual attribute like I mean, to say in grade, then what

54
00:05:26,500 --> 00:05:32,410
I can do, as I know that this is a record, it is returning me on record.

55
00:05:32,410 --> 00:05:40,810
And if I want to fetch the trade consultant, then what I have to do is what I need right here.

56
00:05:41,440 --> 00:05:44,290
PRICKETT And then the name of the header.

57
00:05:44,290 --> 00:05:46,720
That is great.

58
00:05:52,810 --> 00:05:55,730
And here you can see this is a consultant, right?

59
00:05:56,920 --> 00:06:06,760
So in this way, we can get anything like employee employee I.D. and here this is the employer, right?

60
00:06:08,360 --> 00:06:16,820
So if we have a record, then we can get to any particular item from that record with the help of.

61
00:06:18,570 --> 00:06:32,730
It's happening, so let's go to the first temple, said Setara, and I can control state control copy

62
00:06:34,500 --> 00:06:46,400
and this is the name of this is Zelada three and I am entrusted to fetch the this order number one one

63
00:06:46,440 --> 00:06:48,310
seven so high.

64
00:06:48,330 --> 00:06:50,820
How can I fetch this record?

65
00:06:51,540 --> 00:06:55,890
So always remember this thing when we will talk about our record.

66
00:06:57,840 --> 00:07:02,670
The index will start from zero zero percent, one, two and so on.

67
00:07:03,330 --> 00:07:04,440
So how we can.

68
00:07:05,970 --> 00:07:10,920
Get this value, this record that is available on the 17th position.

69
00:07:13,160 --> 00:07:23,720
We just need to click effects here, we have to write it, and as we are in 2017, then the index for

70
00:07:23,720 --> 00:07:25,130
this one will be 16.

71
00:07:28,170 --> 00:07:37,320
So here you can see we are able to fetch the record that is available at 16th position, and if we are

72
00:07:37,320 --> 00:07:43,350
entrusted to fetch wholesale for what we will do, we just need to.

73
00:07:44,720 --> 00:07:49,040
Right here, Prickett, and then the name of the header is General.

74
00:07:52,650 --> 00:07:55,630
You can see they say we are interested in.

75
00:07:56,890 --> 00:07:59,330
We are entrusted to fetch wholesale.

76
00:08:00,130 --> 00:08:02,190
So the name of the call will be channel.

77
00:08:04,120 --> 00:08:06,570
So this is wholesale, right.

78
00:08:08,080 --> 00:08:13,060
So in the same way, we can fetch anything for the people I delayed.

79
00:08:13,070 --> 00:08:13,800
Question one.

80
00:08:14,350 --> 00:08:15,850
So we are interested here.

81
00:08:16,150 --> 00:08:17,490
Number 81.

82
00:08:18,760 --> 00:08:23,320
So what you can do is we just need to click effect's.

83
00:08:27,520 --> 00:08:31,090
And here we have the right curly bracket.

84
00:08:32,350 --> 00:08:32,860
And.

85
00:08:37,030 --> 00:08:45,100
The index will be 80 and then we need to write the header, so which way we are we want to fetch.

86
00:08:45,730 --> 00:08:51,370
So the name of the terrorist column, header or number?

87
00:08:55,510 --> 00:09:00,190
So camera, so you can see we are getting 181.

88
00:09:03,800 --> 00:09:15,800
So that's all about list and records and poverty and the next will you will try to to do one practical

89
00:09:15,800 --> 00:09:19,550
example for how we can use records in real life.