This post documents my journey into backend web developer as I focus on mastering Python programming, databases, and key backend modules. Along the way, I'll share the tutorials and resources I'm u...

Explore more details inside the StackOverflow 2023 Developer Survey, especially focus on Data Analyst field, and try to find out the jobs and skills related to top-paying and high-demanded opportun...

Date and time functions are essential when working with dates, times, and durations in Excel, offering a wide range of capabilities for handling temporal data. In this article, I list top 10 most u...

There are hundreds of functions in Excel, and playing different roles in manipulating cells in Excel. I listed the most important functions to help me and viewers to get familia with them.

Let's talk about the Window Functions in SQL, including 'Ranking Functions', 'Distribution Function', 'Analytic Functions' and 'Aggregate Functions'. Meanwhile, I will also show some example codes ...