PinnedUnderstanding SQL Window FunctionsWindow functions in SQL provide a window of opportunity for data engineers to minimize effort and time by quickly wiring SQL queries to…Jan 6, 2021Jan 6, 2021
Delete Duplicates in a Table using SnowflakeDuplicate data refers to multiple records in a dataset that have the same values in specific fields, such as names, IDs, or other key…Feb 19Feb 19
MOM Analysis Various SQL MethodsMonth over month (MoM) is a financial metric used to compare the performance of a particular variable or indicator between two consecutive…Feb 11Feb 11
CTE and Recursive CTE in SnowflakeA Common Table Expression (CTE) is a temporary, named result set that you can use within a query. Defined using the WITH clause, a CTE acts…Feb 10Feb 10
AWS CLF-C02(Cloud Practitioner) Summary & Steps to PassAWS CLF-C02 is foundational certification offered by AWS which evaluates the fundamental understanding of oneself on cloud computing and…Jan 281Jan 281
Social Media- A modern marketplaceSocial media was initially designed to connect people — a digital platform where friends and families could share moments, milestones, and…Jan 19Jan 19
Lead & Lag in SnowflakeLead & Lag is used to access data in a subsequent/previous row in the same result set without having to join the table to itself.They allow…Jan 2Jan 2
Living Life as a Data EngineerWhat comes to my mind when I hear the word Data Engineer?Nov 29, 2024Nov 29, 2024
What,Why, How EC2 ?EC2 is a compute service in AWS that lets you rent virtual machines (called instances). These instances are fully customizable to your…Nov 26, 2024Nov 26, 2024