PinnedJagadesh JamjalaTips and Resources to crack Data Engineering InterviewThe data engineering field is exploding! As companies collect ever-increasing amounts of data, the demand for skilled individuals who can…May 27May 27
PinnedJagadesh JamjalainDev Genius8 SQL Window Functions Do’s and Don’tsSQL window functions provide powerful tools for performing calculations across sets of rows that are related to the current row. While they…Apr 1Apr 1
PinnedJagadesh JamjalainDev Genius5 Advanced SQL Interview QuestionsPhoto by Ilya Pavlov on UnsplashMay 12May 12
PinnedJagadesh JamjalainDev Genius9 SQL Mistakes to Avoid for Effective QueriesPhoto by CHUTTERSNAP on UnsplashMar 36Mar 36
PinnedJagadesh JamjalaTricky Scenario Question for Senior Data EngineerScenario: You are the Senior data engineer responsible for the company’s sales data pipeline running on AWS. The pipeline extracts data…Mar 73Mar 73
Jagadesh JamjalainDev Genius3 Advanced SQL Interview Questions using LEAD/LAGIn this post we will explore 3 SQL questions which requires LEAD/LAG function to solve it.20h ago20h ago
Jagadesh JamjalaData Engineering Scenario Question Weekly: Flawed Sales Data Model -Issue #6Data models serve as the architectural blueprint that guides how information is structured, stored, and accessed.2d ago2d ago
Jagadesh JamjalainDev GeniusBasics of Working with JSON FilesHere I am sharing the very basics of what a JSON file is and how to understand it.Jul 3Jul 3
Jagadesh JamjalainDev Genius4 Ways in SQL to find Duplicate rowsDuplicate data in databases is a common issue that can have significant impacts on data integrity, storage efficiency, and overall system…Jul 1Jul 1