SQL Exercise: Let’s practice Filtering with Multiple Predicates
In this exercise, I will be using AdventureWorks 2008 Database and will write my SQL queries using SSMS 18. All the exercises are from the …
Place for collecting all my knowledge and ideas
In this exercise, I will be using AdventureWorks 2008 Database and will write my SQL queries using SSMS 18. All the exercises are from the …
In this exercise, I will be using AdventureWorks 2008 Database and will write my SQL queries using SSMS 18. All the exercises are from the …
In this exercise, I will be using AdventureWorks 2008 Database and will write my SQL queries using SSMS 18. All the exercises are from the …
Facing a dataset with missing values is very common in any project. Let’s take a look at how can we tackle such a situation using …
A common problem with Python dictionaries is trying to access or modify a key that doesn’t exist. If we try to access or modify a …
The data usually contains multiple levels of hierarchies, which can be grouped in multiple ways for our analysis. Pandas offer a method for tackling such …
Binary Diagnostic: Part 1 The submarine has been making some odd creaking noises, so you ask it to produce a diagnostic report just in case. …
Dive: Part 1 Now, you need to figure out how to pilot this thing. It seems like the submarine can take a series of commands …
Pivot Tables are one of the most powerful tools provided in MS Excel and Pandas offers the same. We can create custom hierarchies, aggregate data, …
Sonar Sweep: Part 1 You’re minding your own business on a ship at sea when the overboard alarm goes off! You rush to see if …