hello everyone, this is AWS ETL project using Spark and AWS glue. in this project I have basically performed 3 steps Extract, Transform and load that’s why we called it ETL project. i performed these steps with AWS various services like AWS S3, AWS Glue, AWS IAM. with the help of below image you can […]
Data Engineer ETL Project Using Spark with AWS Glue Read More »
This is a LeetCode medium-level SQL problem, but if you have a strong understanding of window functions, this question will be quite easy for you. In this post, I will be solving this question using various approaches. So, let’s get started. Rank Scores Question Table: Scores Column Name Type id int score decimal id is the
LeetCode 178. Rank Scores (SQL Solutions) Read More »
182. Duplicate Emails is a LeetCode easy question, but sometimes, when we encounter this type of question for the first time, it can be challenging to solve. In this post, I have provided solutions in three different ways, along with proper explanations. after reading this post you will learn a lot and become capable of solving
LeetCode 182. Duplicate Emails (SQL Solution) Read More »
This is a LeetCode medium-level SQL question. To successfully solve this SQL question, you should have a good understanding of advanced SQL concepts such as window functions, common table expressions (CTE), and various types of joins. Additionally, it’s crucial to practice these types of questions to develop the ability to identify patterns within them. Let’s
LeetCode 184. Department Highest Salary (SQL Solution) Read More »
This is hard LeetCode question, and if you can solve it, it means you are among the top 10% of people who possess a deep understanding of SQL and have hands-on experience—I am one of them. To become proficient at solving such questions, it’s essential to have a strong grasp of SQL as a whole.
LeetCode 185. Department Top Three Salaries – SQL Solution Read More »
(1378. Replace Employee ID With The Unique) This is a LeetCode easy question. However, if you are not familiar with joins, it can become tricky. This question primarily requires knowledge of joins, and if you don’t know when to use which join, you may find it challenging even though it’s considered an easy question. I have
leetcode 1378. Replace Employee ID With The Unique Identifier (SQL Solution) Read More »
The Weather Observation Station 20 question may be challenging, but tackling such questions can help improve your problem-solving skills. This question involves multiple advanced coding concepts, such as nested queries and more. If you’re unable to solve it, don’t worry; we can help you understand the solution so that you can handle similar problems in
Weather Observation Station 20 – HackerRank SQL Solution Read More »
To solve this HackerRank SQL question (The PADS), you should have a good understanding of concepts like concatenation, group by, and union.If you know these concepts well, this question will be quite easy. So, let’s get started and solve this question. Problem (The PADS) Generate the following two result sets: There are a total of
HackerRank SQL – The PADS Solution with Explanation (MySQL, MS SQL Server) Read More »
Hackerrank Problem – Draw The Triangle 1 P(R) represents a pattern drawn by Julia in R rows. The following pattern represents P(5): * * * * * * * * * * * * * * * Write a query to print the pattern P(20). The Solution Output * * * * * * *
Hackerrank – Draw The triangle 1 (SQL Solution with Explanation) Read More »
