Open in app
Home
Notifications
Lists
Stories

Write
Amit Singh Rathore
Amit Singh Rathore

Home

Published in Dev Genius

·2 days ago

Recursive CTE — Demystified

Solving SQL problems recursively CTE Common Table Expression(CTE) is a temporary result set, that can be referenced by DML statements that immediately follow the CTE. The syntax for CTE is as follows: WITH cte AS ( SELECT a, b FROM table1 ) SELECT * FROM cte We can even create more…

Database

4 min read

Recursive CTE — Demystified
Recursive CTE — Demystified

Published in Dev Genius

·3 days ago

Duplicates in SQL

All you need to know for handling duplicates in SQL. Identifying the duplicate entries The first step should be to define which column or combination of columns forms the unique row. Once we have the set of columns that decide the uniqueness of the row we can use the following two strategies to find…

Data

3 min read

Duplicates in SQL
Duplicates in SQL

Published in Dev Genius

·4 days ago

Data Processing Architectures

Lambda & Kappa Modern data processing platforms need to process real-time streaming events in addition to more traditional data pipelines. Deciding on the right architecture, Lambda or Kappa is an important step in the direction of a good platform strategy. Design goals for Data processing Architectures: Read consistent data Read incrementally from large tables/datasets Rollback Capability…

Data Engineering

3 min read

Data Processing Architectures
Data Processing Architectures

Published in Geek Culture

·5 days ago

Open Lakehouse — A journey

SQL on anything with Dremio Nowadays every company relies on data to make decisions. So every company needs a data infrastructure that will handle their use cases over time. And the use cases have evolved over time. With changing use cases we saw different solutions like a data warehouse, Hadoop…

Data

4 min read

Open Lakehouse — A journey
Open Lakehouse — A journey

Published in Dev Genius

·Aug 4

Change Data Capture — Intro!

A basic introduction to CDC CDC Change Data Capture (CDC) is a data integration design pattern that allows us to track row-level changes in database tables in response to CREATE, UPDATE and DELETE operations. CDC allows us to treat the changes in DB as events and respond to them. Using this…

Change Data Capture

3 min read

Change Data Capture — Intro!
Change Data Capture — Intro!

Published in Dev Genius

·Aug 2

Data Engineer — Learning Path

Skills you need to become a data engineer Programming Language Data engineering leads to various roles in the future like Data Analyst, Data Scientist, ML Engineer, and BI Developer. So choosing the right language is important. Python is more diverse in the sense that it is used widely in all the previously…

Data Engineering

3 min read

Data Engineer — Learning Path
Data Engineer — Learning Path

Jul 25

SQL Window function

Dissecting the window function Window functions compute the result based on a sliding window frame. A window frame is a set of rows that are related to the current row. The relation is that all the rows have the same value for all terms of the PARTITION BY clause in…

Sql

5 min read

SQL Window function
SQL Window function

Published in Dev Genius

·Jul 23

Shortest Path Algorithm — Floyd Warshall & Johnson’s

Part III of Graph traversal algorithm series. Read Part I and Part II In the last blog we learned about two Single Source Shortest Path algorithms, In this blog, we will see two algorithms for finding the shortest path among all node pairs. Floyd Warshall Algorithm This algorithm takes a dynamic programming approach…

Python

3 min read

Shortest Path Algorithm — Floyd Warshall & Johnson’s
Shortest Path Algorithm — Floyd Warshall & Johnson’s

Published in Dev Genius

·Jul 20

Shortest path algorithms — Dijkstra & Bellman-Ford

Part II of Graph traversal algorithm series. Read Part I and Part III

Algorithms

4 min read

Shortest path algorithms — Dijkstra & Bellman-Ford
Shortest path algorithms — Dijkstra & Bellman-Ford

Published in Dev Genius

·Jul 18

Databricks Notebook Widgets

Reusable Databricks notebook with parameters Input widgets are utility in Databricks that allow us to add parameters to our Dashboards and Notebooks. The Widget API provides methods for creating getting values and removing them. In this blog, we will see how we can use those APIs. Help All the APIs for…

Databricks

3 min read

Databricks Notebook Widgets
Databricks Notebook Widgets
Amit Singh Rathore

Amit Singh Rathore

Cloud | Big Data | ML

Following
  • Nitin Labhishetty

    Nitin Labhishetty

  • Tony

    Tony

  • adrian cockcroft

    adrian cockcroft

  • Crack FAANG

    Crack FAANG

  • Pinterest Engineering

    Pinterest Engineering

Help

Status

Writers

Blog

Careers

Privacy

Terms

About

Knowable