In a world of artificial intelligence, machine learning, and computer science, there’s a lot of power available for an individual with a computer. As per IBM’s audit of the world’s AI state, 60-80 percent of companies surveyed in 2021-2022 were either exploring AI or had… Continue Reading
Work smarter, not harder – is a good proverb to think by. While coding in Python, Java, C++, C# or any OOP web development language can seem daunting, what makes it so fundamentally sound is the fact that’s a language. This means you can solve… Continue Reading
This solution was fun to solve. It has it all, loops, conditionals, string manipulation, variables and functions. While you may be able to use the function swapcase(), I think it’s a great way to show Jr. Python developers how to mix everything together! While it… Continue Reading
A fun little problem with Tuples where you shouldn’t over think the execution of this. Less code is better! Note, I’ve noticed that nothing actually works in Python 3, so stick to PyPy3 instead for this question. While this isn’t harder than any particular SQL,… Continue Reading
Machine learning (ML) is growing in popularity, and with it – languages like R and Python have also exploded in usage and adoption. That being said, it’s incredibly hard to start a career in machine learning due to how many skills you need. A machine… Continue Reading
If you are looking to learn Java (the programming language not coffee 🙂 ), there is no better place than Udemy. With an array of top-notch tutorials, projects and apps to build in the platform, it’s easy to find a java course that suits your… Continue Reading
Joins, joins, joins – nothing but joins! Four tables that need to be joined together and uniquely filtered for specific things. Really think about how you want to structure your joins as if you’re joining. While this was not as hard as occupations, it’s easier… Continue Reading
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
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
