PinnedJagadesh Jamjala8 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…·4 min read·Apr 1, 2024----
PinnedJagadesh JamjalainDev Genius5 Advanced SQL Interview QuestionsPhoto by Ilya Pavlov on Unsplash·3 min read·May 1, 2024--2--2
PinnedJagadesh JamjalainDev Genius9 SQL Mistakes to Avoid for Effective QueriesPhoto by CHUTTERSNAP on Unsplash·3 min read·Mar 3, 2024--5--5
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…·4 min read·Mar 7, 2024--3--3
PinnedJagadesh Jamjala7 Data Engineering Interview-Key Questions to Ask Your RecruiterPhoto by Matt Walsh on Unsplash·4 min read·Feb 25, 2024----
Jagadesh JamjalaModern Data Warehouses — What , What and Key ComponentsThe term Data warehouse is been there for more than 3 decades . It has evolved so much with the increase of data that is being collected …·3 min read·20 hours ago----
Jagadesh JamjalaData Engineering Scenario Question Weekly: Issue #2Hello All, Welcome back !!·3 min read·2 days ago----
Jagadesh JamjalaClustered vs Non-Clustered Indexes in SQLYou go to a store for a particular product , you search them everywhere and you cant find it.·4 min read·3 days ago----
Jagadesh JamjalaKey concepts of Surrogate KeysYou are working on a fact table and you see some columns which don’t make any sense by just looking at it , but when you join with some…·3 min read·5 days ago----
Jagadesh Jamjala5 Advanced SQL Interview Questions — SolutionIf you are directly seeing this post I suggest you to check out the 5 Advanced SQL Interview Questions post first so you can test you…·5 min read·May 3, 2024--3--3