1
00:00:00,060 --> 00:00:01,690
‫Hey, what is going on, guys?

2
00:00:01,710 --> 00:00:08,700
‫It is really absolutely amazing how this course became so popular and you guys love it.

3
00:00:08,700 --> 00:00:09,600
‫Absolutely love it.

4
00:00:09,960 --> 00:00:11,850
‫Thank you so much for the great ratings.

5
00:00:12,150 --> 00:00:14,100
‫I appreciate every single one of you.

6
00:00:14,370 --> 00:00:21,420
‫And so I decided to invest more into adding more content to this scores and reorganize the sections.

7
00:00:21,420 --> 00:00:25,710
‫And I would just want to go through some of the stuff that I have been adding every month.

8
00:00:25,710 --> 00:00:28,050
‫I have to add a few more content.

9
00:00:28,350 --> 00:00:33,390
‫And really, really, it's been it's been an amazing experience.

10
00:00:33,390 --> 00:00:41,010
‫You guys ask fantastic questions, which essentially lead to more content to the course and then the

11
00:00:41,010 --> 00:00:41,820
‫course is growing.

12
00:00:41,820 --> 00:00:44,430
‫I would say it's at 14 hours right now.

13
00:00:44,440 --> 00:00:46,890
‫Obviously, you cannot finish it in one sitting.

14
00:00:47,140 --> 00:00:54,660
‫You have to take it slowly digested and read through, get ideas, ask questions which which will lead

15
00:00:54,660 --> 00:00:55,500
‫to discussions.

16
00:00:55,530 --> 00:00:56,610
‫It's it's beautiful.

17
00:00:56,610 --> 00:00:57,100
‫Really beautiful.

18
00:00:57,120 --> 00:01:00,360
‫Let's go let's go through the stuff that I recently added.

19
00:01:00,760 --> 00:01:03,090
‫Here's the course content I created.

20
00:01:05,370 --> 00:01:11,520
‫The first section is basically all the courses, updates, last update I made, just physically updating

21
00:01:11,520 --> 00:01:14,130
‫you guys making a video, what it was October 23.

22
00:01:14,160 --> 00:01:19,500
‫But every month after that, I kept adding more content without explicitly making videos of all of them,

23
00:01:19,640 --> 00:01:23,340
‫essentially tweet about it and and talk about in my YouTube channel.

24
00:01:23,340 --> 00:01:27,540
‫But essentially that I'm going to add a new video here, too.

25
00:01:28,410 --> 00:01:32,750
‫This is for April twenty twenty one acid.

26
00:01:32,760 --> 00:01:43,140
‫I created this specific section for all the acid videos, you know, just because this is a very interesting

27
00:01:43,140 --> 00:01:43,900
‫topic.

28
00:01:44,550 --> 00:01:50,190
‫The idea of having atomistic on sustenance, isolation, enteropathy, I believe every engineer should

29
00:01:50,190 --> 00:01:51,810
‫understand this.

30
00:01:52,710 --> 00:01:59,940
‫So that's why I started adding more content to this examples and even more stuff coming in and fits

31
00:01:59,940 --> 00:02:00,720
‫into this section.

32
00:02:00,720 --> 00:02:05,100
‫So I believe it deserves its own s.m database indexing.

33
00:02:05,100 --> 00:02:10,950
‫Man My God, I've been adding more and more content to this and exclusive content.

34
00:02:10,950 --> 00:02:17,100
‫And I have videos coming here with Postcrisis Explain and so much other stuff as well.

35
00:02:17,100 --> 00:02:20,760
‫So database indexing definitely keep a watch for this.

36
00:02:21,060 --> 00:02:22,440
‫I'll keep adding more content.

37
00:02:22,440 --> 00:02:27,060
‫And you guys have been asking me to make more content on the database indexing space.

38
00:02:27,660 --> 00:02:30,240
‫So it's really, really huge partitioning.

39
00:02:30,240 --> 00:02:35,100
‫Obviously another underrated feature of the DMS we don't talk about.

40
00:02:35,100 --> 00:02:36,360
‫What do we talk about sharding.

41
00:02:36,360 --> 00:02:41,310
‫A lot of partying is as important, as powerful of a concept.

42
00:02:41,310 --> 00:02:44,970
‫I've been adding content to that database sharding.

43
00:02:45,330 --> 00:02:49,710
‫Obviously, this is the main more mainstream and buzzword that we hear over there.

44
00:02:49,710 --> 00:02:51,690
‫So I try to demystify it.

45
00:02:51,930 --> 00:02:57,480
‫Whatever you get to learn here, as essentially I don't use tools or anything like that.

46
00:02:57,480 --> 00:02:59,730
‫I try to build it from scratch.

47
00:02:59,730 --> 00:03:02,850
‫So you have full understanding of what sharding really means.

48
00:03:03,150 --> 00:03:05,700
‫And that's that's basically the key here.

49
00:03:06,810 --> 00:03:17,880
‫Concurrency control locks, the idea of deadlocks, two phase locking, how to transactions are concurrently

50
00:03:17,880 --> 00:03:22,680
‫trying to execute things, isolation that comes of isolation, database replication.

51
00:03:22,680 --> 00:03:30,060
‫Another also underrated feature where you have a kind of a master primary database and you have other

52
00:03:30,990 --> 00:03:34,590
‫replicas that can take these reads.

53
00:03:34,590 --> 00:03:35,310
‫Right.

54
00:03:35,550 --> 00:03:37,140
‫Then you can hit them directly.

55
00:03:37,200 --> 00:03:41,900
‫Very, very powerful concept for horizontal scalability.

56
00:03:42,210 --> 00:03:44,460
‫A lot of people say, hey, you know, that it was doesn't scale.

57
00:03:44,640 --> 00:03:45,810
‫That is absolutely wrong.

58
00:03:45,930 --> 00:03:48,060
‫You can scale them right.

59
00:03:48,240 --> 00:03:53,550
‫You can do all these kind of things before jumping to other database systems.

60
00:03:54,000 --> 00:03:55,710
‫You got to solve.

61
00:03:56,010 --> 00:03:59,370
‫You have you have a lot of tools to solve your problem.

62
00:03:59,370 --> 00:04:01,260
‫You don't have to move to another database.

63
00:04:01,590 --> 00:04:06,810
‫Obviously, I am planning to make videos for Schoolcraft databases.

64
00:04:07,020 --> 00:04:11,970
‫I don't think it fits into this course is probably going to be another court, but I want to give the

65
00:04:11,970 --> 00:04:13,110
‫relational databases.

66
00:04:13,110 --> 00:04:18,570
‫It's essentially it's justice because it's not given this justice.

67
00:04:19,320 --> 00:04:24,030
‫A lot of videos from YouTube, I think free available here, ad free for you, like a system designed

68
00:04:24,030 --> 00:04:25,640
‫that I've been doing on my YouTube channel.

69
00:04:25,650 --> 00:04:28,950
‫This is available for you here to watch Ad Free.

70
00:04:28,950 --> 00:04:34,100
‫Obviously, I've been I went through a software system designed a short URL system design.

71
00:04:34,650 --> 00:04:41,480
‫It's all available here, Blanning to make more exclusive content for the course right here and introduce

72
00:04:41,550 --> 00:04:46,410
‫the database engines to be three engines, three engines.

73
00:04:46,410 --> 00:04:52,140
‫I know guys you asked me to make specific videos for these are upcoming, so watch out for that.

74
00:04:52,770 --> 00:04:55,890
‫But essentially the engines, the database engines are so powerful.

75
00:04:55,890 --> 00:04:59,460
‫This is the underlining cogs that.

76
00:05:00,000 --> 00:05:02,230
‫Executes anything that above the database.

77
00:05:02,700 --> 00:05:09,270
‫It's very, very critical to understand this and you will appreciate what the Dabis does when you actually

78
00:05:09,270 --> 00:05:14,270
‫do this, obviously go through a demo that was Courcelles, another underwriting feature.

79
00:05:14,280 --> 00:05:15,560
‫We don't talk about this stuff.

80
00:05:16,020 --> 00:05:20,910
‫Stateful versus stateless cursors, client server side, curser versus server side.

81
00:05:20,970 --> 00:05:22,620
‫So what is the benefit of both?

82
00:05:23,040 --> 00:05:24,690
‫Why should I use this over the other?

83
00:05:24,700 --> 00:05:26,510
‫I give examples of Python here.

84
00:05:27,420 --> 00:05:33,210
‫Database security, again, another very powerful feature like what does it mean for the database to

85
00:05:33,210 --> 00:05:33,940
‫be secure?

86
00:05:34,160 --> 00:05:35,430
‫Really, what does it mean?

87
00:05:35,850 --> 00:05:38,190
‫So we try to demystify some of the stuff here.

88
00:05:38,940 --> 00:05:42,960
‫This is a you will not find any anything about this anywhere.

89
00:05:43,320 --> 00:05:47,440
‫This is technically really exclusive home, morphic encryption.

90
00:05:47,460 --> 00:05:52,830
‫This is a very fresh concept that let's go through the problem first.

91
00:05:52,830 --> 00:05:58,680
‫The problem is when you store data on two database, it's also most of the plaintext.

92
00:05:58,680 --> 00:06:01,740
‫You don't you never store encrypted data right.

93
00:06:01,740 --> 00:06:04,040
‫In your besides password.

94
00:06:04,050 --> 00:06:08,130
‫I'm talking right like a profiler who is a customer that is all plaintext and decrypt it.

95
00:06:08,130 --> 00:06:08,400
‫Right.

96
00:06:09,000 --> 00:06:14,580
‫So that means if your data is leaked, everybody got all the information on encryption, allows you

97
00:06:14,580 --> 00:06:19,610
‫to store the data is encrypted and don't even have the key.

98
00:06:19,650 --> 00:06:21,690
‫Let the key belong to the user.

99
00:06:21,690 --> 00:06:24,750
‫So you don't really stick to the key because that's just pointless.

100
00:06:24,750 --> 00:06:24,960
‫Right.

101
00:06:24,960 --> 00:06:31,500
‫If you store the key in the database is just as Beutler's database Merfolk encryption is that is technologies

102
00:06:31,500 --> 00:06:39,630
‫are being researched now to allow you to perform database searches or operations on encrypted data without

103
00:06:39,630 --> 00:06:40,470
‫actually looking.

104
00:06:41,160 --> 00:06:42,450
‫It's mind boggling.

105
00:06:42,600 --> 00:06:43,410
‫Take a look at this.

106
00:06:43,440 --> 00:06:45,030
‫This is beautiful stuff.

107
00:06:45,780 --> 00:06:48,330
‫I use it and there's examples and stuff like that.

108
00:06:48,330 --> 00:06:50,820
‫So it's at its infancy now.

109
00:06:51,270 --> 00:06:53,790
‫And there's obviously various there's been discussions.

110
00:06:53,790 --> 00:07:03,330
‫I try to pull whatever useful stuff here decide between Bosco's MySQL distributed transactions and discussions.

111
00:07:03,340 --> 00:07:09,420
‫That is like if you willing to go florham beyond and we have a discussion right here, we can have these

112
00:07:09,420 --> 00:07:16,950
‫discussions like how do you how does DASK what kind of protocols becomes really beneficial?

113
00:07:16,950 --> 00:07:20,940
‫If I store, if I use in my database and all of stuff?

114
00:07:20,940 --> 00:07:22,950
‫Guys, keep up the good work.

115
00:07:23,430 --> 00:07:24,830
‫Thank you so much.

116
00:07:24,840 --> 00:07:25,820
‫Appreciate you.

117
00:07:25,830 --> 00:07:27,120
‫Thank you for the support.

118
00:07:27,780 --> 00:07:32,220
‫Thank you for checking out the scores and make sure to read the course if you like it.

119
00:07:32,670 --> 00:07:35,030
‫And I'm going to see you on the next one, you guys.

120
00:07:35,040 --> 00:07:36,090
‫The awesome goodbye.