PinnedNam AmtaHow Does SQL Actually Execute Your Query?Does SQL execute as another programming language?Jul 9Jul 9
Nam AmtaUnderstanding Calculated Columns vs. Measures on Power BI: When to Use Which?Both of them possibly able to show the same value in your report. But which one needs to be used? Calculated Columns or Measures?Aug 19Aug 19
Nam AmtainTowards DevHow Joins and Subqueries Team Up to Tackle Tough Data?Sometimes, a simple sql join is enough to manage your data. But, sometimes it doesn’t. Imagine you deal with pretty huge of data, and…Aug 10Aug 10
Nam AmtainTowards DevHAVING vs. WHERE in SQL: Understanding the Key DifferencesSQL (Structured Query Language) is the backbone of database management and data analysis. Among its many powerful features, filtering data…Jul 11Jul 11
Nam AmtaWhy SQL Gurus Start with Excel, and Why You Should too?Imagine this situation, you are sitting at your desk, surrounded by all of your spreadsheets and pivot tables and VLOOKUP formulas. You…Jul 10Jul 10