A great question with the need to do multiple joins or pivot the data. Don’t overthink this one as it can get messy if you decide to try to do PIVOT or GROUP(CONCATENATE). What I learned from this problem is, you can Google or ChatGPT… Continue Reading
Another interesting query, with very unique criteria that you need to pay attention to. There’s multiple was you can attack this, but the most common way seems to be creation of a CTE, VIEW or function and using ROW_NUMBER(), PARTITION() to help number and organize… Continue Reading
As we continue to navigate the challenges of the pandemic, online classes have become a necessary part of education, and online presentations are an essential part of the learning experience in online classes. Creating an engaging and informative animation presentation can be challenging, but it… Continue Reading
A great SQL problem, that needs a high level of attention to detail. This problem is not as technically complicated as some of the previous problems like Draw the Triangle 1 or Draw the Triangle 2. The use of CONCAT is advised for this challenge,… Continue Reading
One of the most widely used and sought-after programming languages in the world, Python will be here to stay. But how can one learn Python the best? Well, by using Udemy of course! If you could start over, you might follow the instructions provided in the… Continue Reading
Business in the 21st century is an extremely complicated concept. The days are gone when the only thing you could do is graduate from a business school and be completely oblivious to the fundamental skills of other departments and teams. With the advent of online… Continue Reading
You’ve probably found this article because you want to rank on the first page of Google for some keyword. In this modern age, Google search result is one of the main ways for people to get access to information they wouldn’t have 30 years ago…. Continue Reading
With the digital marketing industry is set to be as large as $860 billion dollars by 2026, it’s no wonder that there are hundreds of thousands of marketers across the world working with ad budgets, copywriters, content and video producers, to develop, optimize and grow… Continue Reading
Most likely, you’ve stumbled on this post because you’re trying to find cheaper ACP resource to pass the exam. Like me, you’ve Googled and Googled for ways to pass the exam and come across hundreds of different bootcamps and other training strategies. Many of these… Continue Reading
It’s not a secret that Python is a popular coding language. With the capability to automate repetitive tasks, extract information for files and even build websites – Python is an incredibly powerful language that is the backbone of AI, ML and a large majority of… Continue Reading
