This fridge is the data warehouse. Means, in short all types of (be it unstructured or structured) raw data are stored in the data lake, whereas only structured data are stored inside the data warehouse

Think of it like you are buying some vegetables, and for the first time, you are keeping those in a basket without cleaning or cutting them into pieces. This basket is your data lake. But, after this, you are washing and cutting it into pieces before keeping it in the fridge.

Recently, I was brushing up my basic data concepts where I got an idea about what exactly a difference between a datalake and a data warehouse. Video: https://t.co/t6Pa6Cdk7z #DataScience #Analytics

https://t.co/66AvlNSSMz I recently continued solving SQL probs. after a few weeks, and this is something which was a bit challenging. It made me write 2 temp inter-linked queries followed by applying final conditions to get the expected output. #SQL #Analytics

Dear @LinkedInHelp, was going through my feed and suddenly noticed all my activities got disapperead and checked few other profiles as well, where I found the same. Could you please recheck if this a server issue from @LinkedIn or not. Looking forward to hear from you. #Linkedin

Generally if we see, this problem can be done using RANK(), ROW_NUMBER(), DENSE_RANK() window function but I have done it without using any window functions.

https://t.co/QH32Bw8ugv After a long time, tried solving a medium level SQL prob. which was asked in @Dropbox and @amazon . It was quite easy and it got finished in just 5 seconds. Sometimes, what I have seen is that not all medium level problems are not actually medium. #SQL

Think of AWS CloudShell like a fully set up laptop for coding purpose that AWS hands you inside your browser with access to it's AWS tools, pre-installed software, and safe cloud storage, all we need to do is start typing and that's it. Like for example, $ aws s3 ls or $ aws help

Recently, I am diving into AWS Fundamentals from @nealkdavis . What I found there is a browser based command line tool that @awscloud gives us for free. It provides a command line interface in the cloud. #learning #AWSCommunityBuilders

the front of the list, in their original order. After placing all the non-zero elements, this loop fills the rest of the list with zeros, starting from the non_zeros_pos to the end of the list.

Here, I created a pointer to track non zero elements in the array. This loop goes through each element in the list nums. If the current element is not zero, it is placed at index non_zeros_pos, and non_zeros_pos is incremented. This effectively shifts all non-zero elements to

Check out this coding interview problem on LeetCode! https://t.co/KVtqWRnL17 I tried to solve this problem on my own. This actually takes O(n) time complexity, which shows 0 ms/1 ms after submitting in the platform. Have a look. on my approach. #pythonlearning

The best developer tools, free for students: https://t.co/EeJhzWr7oO via @githubeducation It's a great resource for current graduate and undergraduate students. #learning

Here, set function creates an empty set. isdigit() function checks if the character is a digit or not. If yes, then it will append those integers using .add() function. Then, using sorted(digits, reverse=True)[1], I am able to extract the second highest number.

Check out this coding interview problem on LeetCode! https://t.co/ezJyyUnaF9 I tried to solve this problem in leetcode, it was little tricky but the way it is solved was quite insightful. Got to learn about some of new functions. I have shared my approach in the comments.

https://t.co/hPINimsEGR I just solved a medium level SQL question which was asked in Tesla and Salesforce. It was both tricky and straightforwad in my opinion. I prefered 2 temp. tables followed by finding the net difference. #SqLArt

Here, set() function is used for fast membership checking. Like it will convert the string to list. Then in the .subset() function, it is checking if the word in the user's array is present in the first row, second row, or third row or not.

Check out this coding interview problem on LeetCode! https://t.co/nc6auhLyGU I just solved an easy level python - string problem. I have mentioned exactly what I got to know something new here which I have shared in the comments. #pythonprogramming

I tried to make a temporary table using CTE after joining the two tables on the basis of the primary key (customer_id). Then, I used some filters based on the expected output by sorting and limiting the rows.

https://t.co/98yhzRzcUM After so many days, I have started to continue my SQL hands-on practice. This was a medium level SQL question from stratascratch. I have shared my approach in the comments. #SQL