Meeting Title: Uttam <> Akshay Date: 2024-06-18 Meeting participants: Akshay, Uttam Kumaran
WEBVTT
1 00:09:35.850 ⇒ 00:09:36.770 Uttam Kumaran: Hey! Actually.
2 00:09:42.100 ⇒ 00:09:43.067 Akshay: Yeah. Hi, good morning.
3 00:09:43.790 ⇒ 00:09:45.589 Uttam Kumaran: Hey? Good evening! How are you?
4 00:09:46.610 ⇒ 00:09:47.390 Akshay: Yeah, I’m fine.
5 00:09:49.000 ⇒ 00:09:50.510 Uttam Kumaran: Okay, tell me, how’s it going?
6 00:09:50.770 ⇒ 00:09:53.120 Uttam Kumaran: How did you? What did you think about the sequel? Zoo.
7 00:09:54.680 ⇒ 00:10:00.520 Akshay: Yeah, actually, it’s good, like, the excess are like brushing up the concepts which I learned earlier. Yeah, it’s actually
8 00:10:00.710 ⇒ 00:10:02.759 Akshay: like, good good way to learn from.
9 00:10:03.480 ⇒ 00:10:09.320 Uttam Kumaran: Yeah. So where? What have you learned so far? And what’s been? What’s been interesting.
10 00:10:12.610 ⇒ 00:10:16.119 Akshay: Okay in that like a sequel. Zoo, you’re asking.
11 00:10:16.780 ⇒ 00:10:17.500 Uttam Kumaran: Yes.
12 00:10:18.660 ⇒ 00:10:24.850 Akshay: Yeah, I just went up with select and few basics. And then I learned some few functions actually like.
13 00:10:26.320 ⇒ 00:10:32.489 Akshay: like around something you can say, like pattern matching something like something use like like. And those functions I learned, and few mathematics.
14 00:10:32.490 ⇒ 00:10:33.310 Uttam Kumaran: Yeah.
15 00:10:33.750 ⇒ 00:10:38.230 Akshay: How you match things like based on the characters and those things.
16 00:10:39.130 ⇒ 00:10:55.110 Uttam Kumaran: Yeah. So you know, like, and that there’s there’s also another function called I like are very common, you know, to do matches, and also. When you go learn about joins. It’s pretty common to try to join on different strings and things like that, and you’ll need.
17 00:10:55.220 ⇒ 00:11:00.209 Uttam Kumaran: you know, to use I like. And then it’s also pretty. We use a lot of different math functions. So we use like average.
18 00:11:00.350 ⇒ 00:11:01.690 Uttam Kumaran: We round.
19 00:11:02.030 ⇒ 00:11:07.090 Uttam Kumaran: we do like adding subtracting division percentiles. All that stuff.
20 00:11:07.310 ⇒ 00:11:12.560 Uttam Kumaran: So that’s all pretty. It’s all not too difficult. I think the toughest part about
21 00:11:13.180 ⇒ 00:11:16.739 Uttam Kumaran: toughest part about SQL, really is just knowing the formatting.
22 00:11:17.090 ⇒ 00:11:20.250 Uttam Kumaran: But it’s quite nice, because it’s almost like English, right?
23 00:11:20.560 ⇒ 00:11:21.030 Uttam Kumaran: So.
24 00:11:21.030 ⇒ 00:11:21.710 Akshay: Yes.
25 00:11:22.130 ⇒ 00:11:28.740 Uttam Kumaran: It’s not. It’s not like Python or Java, where or if you’ve done like CAD or other things, where
26 00:11:29.444 ⇒ 00:11:44.559 Uttam Kumaran: or Matlab, where it’s it’s like quite a kind of complicated. It’s mainly just like a structure of thinking where you’re selecting a certain amount on a rows with some logic. And then you’re filtering those things, and that’s it. You’ll, you’ll learn a little bit about
27 00:11:44.650 ⇒ 00:11:50.599 Uttam Kumaran: adding like structuring different queries and having multiple queries in one select statement.
28 00:11:50.870 ⇒ 00:11:53.549 Uttam Kumaran: But overall like, that’s the basic. So
29 00:11:53.600 ⇒ 00:11:57.550 Uttam Kumaran: I’m glad that you’re able to kind of walk through that and and continue that. So.
30 00:11:59.110 ⇒ 00:11:59.949 Akshay: Yeah, yeah, sure.
31 00:12:01.990 ⇒ 00:12:04.290 Uttam Kumaran: So? Which which step are you on
32 00:12:04.360 ⇒ 00:12:05.370 Uttam Kumaran: so far?
33 00:12:08.610 ⇒ 00:12:10.940 Akshay: Like in Z, like 0 to renovation.
34 00:12:12.160 ⇒ 00:12:12.880 Uttam Kumaran: Yak!
35 00:12:14.430 ⇒ 00:12:20.289 Akshay: Actually, I’m in the 3, rd you can see, like the I’m actually add doing those pieces also. So I’m in 3, rd actually.
36 00:12:20.960 ⇒ 00:12:22.139 Uttam Kumaran: Okay, okay.
37 00:12:23.160 ⇒ 00:12:23.850 Uttam Kumaran: okay, so.
38 00:12:23.850 ⇒ 00:12:25.169 Akshay: So let’s continue.
39 00:12:25.390 ⇒ 00:12:27.990 Akshay: I didn’t spend like much time like today. I’ll be doing
40 00:12:28.300 ⇒ 00:12:29.200 Akshay: vacant.
41 00:12:31.120 ⇒ 00:12:37.150 Uttam Kumaran: Okay, yeah, let’s continue that. And then I wanna have a discussion on Wednesday with
42 00:12:37.190 ⇒ 00:12:45.430 Uttam Kumaran: with you and and Priya and and Jared on some data analysis work. But I just wanted everybody to kind of have a baseline of
43 00:12:45.640 ⇒ 00:12:46.980 Uttam Kumaran: SQL. Zoo.
44 00:12:47.170 ⇒ 00:12:51.499 Uttam Kumaran: so that I can walk through some example code of things that we’ve done
45 00:12:52.314 ⇒ 00:12:57.480 Uttam Kumaran: and begin to share, like some of the problems that we’re solving. Basically with SQL,
46 00:12:57.830 ⇒ 00:13:03.329 Uttam Kumaran: it’s the stuff we do is a little bit advanced. So you need to have a baseline understanding.
47 00:13:03.600 ⇒ 00:13:06.380 Uttam Kumaran: Let’s have. My suggestion is to go through SQL. Zoo.
48 00:13:06.390 ⇒ 00:13:13.749 Uttam Kumaran: and then I want to kind of have a review session where I can answer any questions or give any any examples. So that’s
49 00:13:13.930 ⇒ 00:13:20.069 Uttam Kumaran: that’s my that’d be my preference. So if you wanna continue, I want everybody to get to the end. Basically.
50 00:13:20.630 ⇒ 00:13:26.250 Uttam Kumaran: even if some parts are challenging. That’s okay. Just note down which parts in particular
51 00:13:26.350 ⇒ 00:13:30.877 Uttam Kumaran: are difficult. And we will review and and walk through.
52 00:13:31.520 ⇒ 00:13:32.650 Uttam Kumaran: It’s no problem.
53 00:13:34.810 ⇒ 00:13:46.150 Akshay: Yeah, actually, like, it’s as you said, like, SQL is something like you should remember, like basically structuring and something like, so basically, it’s more of remembering than the. There’s no like actual logic in this. So like
54 00:13:46.210 ⇒ 00:13:49.230 Akshay: predefined things, you are just learning right? So
55 00:13:49.430 ⇒ 00:13:53.620 Akshay: then, now, I don’t face any difficulties, or something like if I face anything. I don’t ask.
56 00:13:54.510 ⇒ 00:13:56.589 Uttam Kumaran: Okay, okay? And then,
57 00:13:57.210 ⇒ 00:14:04.630 Uttam Kumaran: yeah. The the other thing is, there’s no loops or anything. Right? So it’s mainly just selecting. And I I don’t know if you’ve used. You’ve used Microsoft. Excel before.
58 00:14:06.210 ⇒ 00:14:10.970 Akshay: Yeah, like, not into the actual functions. Susan, like, I’m like, quite familiar with
59 00:14:11.020 ⇒ 00:14:12.119 Akshay: like the vision. Yeah.
60 00:14:12.120 ⇒ 00:14:12.820 Uttam Kumaran: It’s it’s
61 00:14:13.140 ⇒ 00:14:16.299 Uttam Kumaran: all the way I think about SQL. Is. It’s just like Excel.
62 00:14:16.700 ⇒ 00:14:21.720 Uttam Kumaran: kind of like juiced up, meaning everything is just like rows and columns.
63 00:14:21.750 ⇒ 00:14:28.450 Uttam Kumaran: So if you’re I don’t know if you’re think more visually, or you don’t think as visually. But for me it helps to think about it as like.
64 00:14:28.530 ⇒ 00:14:33.209 Uttam Kumaran: you’re just selecting different rows and columns and kind of transforming that.
65 00:14:33.250 ⇒ 00:14:35.799 Uttam Kumaran: That’s how sometimes I also go through. And I
66 00:14:36.160 ⇒ 00:14:43.090 Uttam Kumaran: I try to debug how we do sequel is, I think, about the rows and the columns and what we’re going for.
67 00:14:43.100 ⇒ 00:14:45.650 Uttam Kumaran: and I’m able to kind of map it out that way
68 00:14:45.800 ⇒ 00:14:46.990 Uttam Kumaran: versus.
69 00:14:47.150 ⇒ 00:14:48.300 Uttam Kumaran: you know, like
70 00:14:49.080 ⇒ 00:14:53.959 Uttam Kumaran: in other languages, it’s kind of hard to think about what you’re doing to the data linearly.
71 00:14:53.980 ⇒ 00:14:57.589 Uttam Kumaran: You can always rely on excel to kind of like, test things out
72 00:14:57.650 ⇒ 00:15:08.070 Uttam Kumaran: and get a good understanding of what you want to go for. All of this is, it’s gonna be hard to kind of gain a grasp just through examples. So what I’m going to be doing is giving each of you guys some real
73 00:15:08.180 ⇒ 00:15:09.809 Uttam Kumaran: problems to solve
74 00:15:09.990 ⇒ 00:15:12.060 Uttam Kumaran: that will go to customers
75 00:15:12.240 ⇒ 00:15:16.509 Uttam Kumaran: that you can actually test and push some code and set everything up.
76 00:15:16.994 ⇒ 00:15:20.270 Uttam Kumaran: It may take a week or 2 to kind of get the hang of things. But
77 00:15:20.410 ⇒ 00:15:22.709 Uttam Kumaran: it all starts from the basic. So
78 00:15:22.780 ⇒ 00:15:27.469 Uttam Kumaran: sequel Zoo is the best. I’ll send a couple more other resources, and we’ll kind of work from there.
79 00:15:29.780 ⇒ 00:15:30.629 Akshay: Yeah, I should.
80 00:15:31.960 ⇒ 00:15:36.696 Uttam Kumaran: Okay, so how about we talk? We talk tomorrow, maybe this time or a little bit earlier.
81 00:15:37.464 ⇒ 00:15:47.250 Uttam Kumaran: And then tomorrow, I want to see if you wanna like kind of where you’re at with sequel. Zoo again, if you can do you see if you think you can make it through the whole thing. That’d be great
82 00:15:47.410 ⇒ 00:15:52.040 Uttam Kumaran: cause. I want to schedule some meetings for everybody tomorrow morning to kind of review.
83 00:15:52.340 ⇒ 00:15:54.489 Uttam Kumaran: If not, it’s also fine.
84 00:15:54.962 ⇒ 00:15:58.599 Uttam Kumaran: You’ll have that resource, and you can go through it at your own pace. So.
85 00:15:59.580 ⇒ 00:16:03.640 Akshay: Yeah, sure, I’ll try to complete it, like at least that 0 to 9. I’ll be trying to complete.
86 00:16:04.300 ⇒ 00:16:06.080 Uttam Kumaran: Okay, okay, okay, okay.
87 00:16:06.430 ⇒ 00:16:08.859 Uttam Kumaran: anything else? I can answer.
88 00:16:09.940 ⇒ 00:16:14.260 Akshay: Like. For now, I think, actually like, like, I need help from inside, like.
89 00:16:14.680 ⇒ 00:16:28.989 Akshay: like in my college. Actually, this like there will be, they are going to connect something called internship drive or something. So basically, they need resume like they, they wants us to submit in advance, like some. It’s going to happen around like
90 00:16:29.060 ⇒ 00:16:35.779 Akshay: next 2 months is so basically, they need resume. So like, I want this internship like
91 00:16:35.860 ⇒ 00:16:38.150 Akshay: to be added in my receiving. So like.
92 00:16:38.150 ⇒ 00:16:46.090 Uttam Kumaran: Yeah, yeah, yeah, perfect. So I actually got the same question from Jared yesterday. Let me let me send a note to everybody in the intern group.
93 00:16:46.160 ⇒ 00:16:49.620 Uttam Kumaran: I’ll give you exactly like kind of like the things to write, and then
94 00:16:49.967 ⇒ 00:17:01.809 Uttam Kumaran: of course, like we’re only starting now, so you’ll probably have more content by the end, but definitely for your resume and for Linkedin, I think you could totally add, and I can give you any Logos or any information you need. So that’s totally fine.
95 00:17:02.370 ⇒ 00:17:09.829 Akshay: Yeah, like, actually like that description, something like I can ask, because, like, it’s anyways going to the drive is going to happen anyways, like after 2 months. So
96 00:17:09.849 ⇒ 00:17:15.259 Akshay: will that like I’ll be doing some some things over there, and also like one thing is like
97 00:17:15.633 ⇒ 00:17:21.580 Akshay: they for this like as a proof they name something like acknowledgement mail from your side, like stating that.
98 00:17:21.589 ⇒ 00:17:22.179 Uttam Kumaran: Totally.
99 00:17:23.069 ⇒ 00:17:29.210 Akshay: Dating my name, and like you are offering an intensive to me. And it’s actually going on like, so something like that.
100 00:17:30.010 ⇒ 00:17:34.509 Uttam Kumaran: Okay, great. And do you wanna write both of those things down and the dates?
101 00:17:35.110 ⇒ 00:17:36.710 Uttam Kumaran: In the notion document?
102 00:17:36.930 ⇒ 00:17:39.079 Uttam Kumaran: And then I’ll get that over to you.
103 00:17:39.850 ⇒ 00:17:46.960 Akshay: Yeah, sure, like, I’ll actually the things like description, like within 2 days I should be submitting. SMS. So
104 00:17:47.110 ⇒ 00:17:49.809 Akshay: yeah, actually, I will send you a message like
105 00:17:49.900 ⇒ 00:17:53.830 Akshay: what they actually need as opposed something like a single mail stating like
106 00:17:53.940 ⇒ 00:17:58.590 Akshay: you are, you are offered an internship on like it’s actually ongoing. So something like that.
107 00:17:58.590 ⇒ 00:18:02.629 Uttam Kumaran: Okay, okay, perfect. Yeah. Put every put everything in the notion and then I’ll get it to you tomorrow.
108 00:18:03.540 ⇒ 00:18:04.390 Akshay: Yeah, sure. Yeah, sure.
109 00:18:05.050 ⇒ 00:18:06.669 Uttam Kumaran: Okay. Okay. Great.
110 00:18:07.900 ⇒ 00:18:08.950 Akshay: Yeah. Yeah. Sure. Thanks.
111 00:18:09.890 ⇒ 00:18:15.970 Uttam Kumaran: Okay, perfect. So let’s plan on chatting tomorrow. Send me a slack if you need anything, and then yeah, if you can get through the sequel. Zoom! That’d be great.
112 00:18:17.060 ⇒ 00:18:18.869 Akshay: Yeah, sure, I’ll come. Try to complete that.
113 00:18:19.470 ⇒ 00:18:22.230 Uttam Kumaran: Okay. Okay, alright. Good. Thanks.
114 00:18:22.600 ⇒ 00:18:24.010 Uttam Kumaran: Thanks. Actually. Talk to you tomorrow.
115 00:18:25.260 ⇒ 00:18:26.020 Akshay: Yeah, but.