PinnedJagadesh 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 15Jul 15
PinnedJagadesh JamjalaData Engineering VocabularyHere , I am providing the key concepts and terms used in Data engineering in one Page for easy reference.Aug 31Aug 31
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 Genius9 SQL Mistakes to Avoid for Effective QueriesPhoto by CHUTTERSNAP on UnsplashMar 38Mar 38
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 Genius50 Questions Every New Data Engineer and Analyst Should AskStarting a new job as a Data Engineer or Data Analyst can be both exciting and overwhelming. With so much to learn and adapt, asking the…1d ago1d ago
Jagadesh JamjalainDev GeniusData Structure Interview Question on SQL Table DesignAssume you have select SQL like below how would you design the table and optimize both the time and space complexity of the given SQL…2d ago2d ago
Jagadesh JamjalainDev GeniusKey notes on PostgreSQL Full-Text SearchImagine you are using an online library to find books. You might type in “adventure stories.” Full-text search will look through all the…6d ago6d ago
Jagadesh JamjalaThe Journey of a Mediocre Data EngineerWe talk about data, we often hear about the those data engineers who craft intricate pipelines and solve problems.Sep 25Sep 25
Jagadesh Jamjala11 Steps of Building a Data PipelineRemember that exiciting moment when you first realized the potential of data to transform your world?Sep 23Sep 23