List: Sql interview | Curated by Data Saint Consulting Inc

Nov 3, 2023
36 stories
Sql interview
Igor Comune
How I Documented an Entire Database From Scratch (Without DB Diagram)Privacy
Jun 22, 2023
8
Jun 22, 2023
8
In
TDS Archive
by
Madison Schott
How to Use SQL RANK and DENSE_RANK FunctionsIf you’ve been practicing your SQL religiously, like I suggested in Top Skills to Ace Every SQL Interview Question, then you’ve probably…
Apr 23, 2021
5
Apr 23, 2021
5
In
Tributary Data
by
Dunith Danushka
CDC-based Upserts with Debezium, Apache Kafka, and Apache PinotHow to build a streaming data pipeline to capture MySQL database changes and stream them to Apache Pinot via Debezium and Kafka
Jul 26, 2022
Jul 26, 2022
Gunjan Sahu
Difference between GROUP BY and PARTITION BYIn SQL, GROUP BY and PARTITION BY are used to group data based on some criteria. While both clauses do grouping, there are key differences…
Aug 1, 2023
Aug 1, 2023
In
Data Engineer Things
by
Balu Rama Chandra
3 Ways to Handle NULL Values in SQLNULLS in a table/column are annoying and present challenges for data management, reporting and querying. Here are 3 ways to handle them.
Sep 16, 2023
5
Sep 16, 2023
5
In
Level Up Coding
by
Sarang S. Babu
SQL Commands Cheat Sheet for your Next Job InterviewOverview
May 18, 2023
2
May 18, 2023
2
 This story is no longer available
 This story is no longer available
Taylor Brownlow
Why people don’t trust your numbers and what you can do about it“Those numbers aren’t right.”
May 9, 2023
3
May 9, 2023
3
In
Level Up Coding
by
Stan Chen
Common Data Modeling TechniquesIntroduction
May 2, 2023
May 2, 2023
Rafiul Sabbir
What I have learned by solving (almost) all the SQL problems in LeetcodeThis is my first post in medium and I will share some of the things I have learned throughout my journey of solving the SQL problems in…
Apr 12, 2023
Apr 12, 2023
In
TDS Archive
by
Antonello Benedetto
7 Fundamental SQL Concepts To Master Before Your Next Coding InterviewPractice by solving problems from real interviews and finally get the job you deserve.
Oct 21, 2020
5
Oct 21, 2020
5
Davide Mauri
CTEs, Views or Temp Tables?I’ve just finished watching the video from the @GuyInACube about Common Table Expressions
Jan 20, 2023
3
Jan 20, 2023
3
Nader Fares
Top 20 SQL Query Optimization Techniques for Improved PerformanceSQL query optimization is essential for improving the performance and efficiency of your database operations. Here, we’ll explore 20…
Mar 15, 2023
3
Mar 15, 2023
3
Kelvin Gakuo
3 techniques to write highly optimized queries for BigQueryIn the first part of this series on how to optimize BigQuery for faster (and less costly) querying, we looked at how BigQuery separates…
Apr 2, 2023
1
Apr 2, 2023
1
In
Data Engineer Things
by
Xinran Waibel
Crack SQL InterviewsThe ultimate guide to SQL interviews for data science jobs.
Mar 9, 2020
6
Mar 9, 2020
6
In
TDS Archive
by
Ryan Quigley
Processing a Slowly Changing Dimension Type 2 Using PySpark in AWSWith the emergence of new technologies that make data processing lightening fast, and cloud ecosystems which allow for flexibility, cost…
Apr 17, 2019
17
Apr 17, 2019
17
Stan
How to 10x Speed up SQL Queriesby using query sequence, star schema, query indexing and pandas
Feb 17, 2023
2
Feb 17, 2023
2
In
Dev Genius
by
Amit Singh Rathore
Recursive CTE — DemystifiedSolving SQL problems recursively
Aug 9, 2022
Aug 9, 2022
Nathan Rosidi
Wine Magazine SQL Interview Question on RANK functionAn exhaustive walkthrough to a hard-level SQL question involving windows functions, PARTITION BY clauses, CASE statements, and Common Table…
Mar 14, 2023
1
Mar 14, 2023
1