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 11Apr 11
PinnedJagadesh JamjalainDev Genius5 Advanced SQL Interview QuestionsPhoto by Ilya Pavlov on UnsplashMay 13May 13
PinnedJagadesh JamjalainDev Genius9 SQL Mistakes to Avoid for Effective QueriesPhoto by CHUTTERSNAP on UnsplashMar 37Mar 37
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 JamjalaDifferences between additive, non-additive, and semi-additive measures in a fact tableIn a data warehouse, measures in a fact table can be classified into three categories:15h ago15h ago
Jagadesh JamjalaCloud Computing BasicsCloud computing has revolutionized how we store, access, and process data.2d ago2d ago
Jagadesh JamjalaData Engineering VocabularyHere , I am providing the key concepts and terms used in Data engineering in one Page for easy reference.4d ago14d ago1
Jagadesh JamjalainDev GeniusSQL Partition by and Order by FunctionsPARTITION BY and ORDER BY are both important clauses used in SQL window functions, but they serve different purposes.6d ago6d ago
Jagadesh JamjalainDev GeniusBasics of Materialized Views in DatabaseA materialized view is a database object that stores the results of a query as a physical table. Unlike regular views, which are virtual…Jul 31Jul 31