Blog Archives
1 2 3 4

0: 20+ SQL best practices & optimisation interview Q&As

SQL is very easy to learn, but lots of hands-on experience is required to master to perform the below tasks.

1) Translating any business requirements into SQL.

2) Writing efficient, …



0: 50+ SQL scenarios based interview Q&As – What is wrong with this SQL code?

This extends 18+ SQL best practices & optimisation interview Q&As. You can practice these SQLs by setting up the data on db-fiddle MySQL V8.0 or a database server & …



00: 50+ SQL scenarios based interview Q&As on identifying & deleting duplicate records

50+ SQL interview questions and answers to solve real business scenarios. SQL is widely used in building microservices & Big Data projects. Learning SQL syntax is easy, but being able …



02: 50+ SQL scenarios based interview Q&As on joins, CDC and recursive CTE

This extends 50+ SQL scenarios based interview questions answered on identifying & deleting duplicate records. You can practice these in SQLs by setting up the data on db-fiddle MySQL V8.0 …



02: SQL analytic functions interview questions – Part 1

Data Engineers & analysts must know the analytic functions applied over a window of rows is a powerful tool to analyse the data. This post compliments “Apache Spark window



02: SQL analytic functions interview questions – Part 2

This extends SQL window function for analytical queries interview questions – Part 1 Analytic function construct



02: SQL analytic functions interview questions – Part 3

This extends SQL analytic functions interview questions – Part 2 and SQL analytic functions interview questions – Part 1. The below example was created in IMPALA SQL engine with Common …



03: 50+ SQL scenarios based interview Q&As on familiarising various features

This extends 50+ SQL scenarios based interview Q&As on joins, CDC and recursive CTE. Q01 In What order the SELECT SQL statements are executed? A01 Here is the the order …



04: 50+ SQL scenarios based interview Q&As on Nth value

This SQL scenarios based interview questions & answers focus on nth highest value or nth lowest value. These examples were done on MySQL v8.0 at www.db-fiddle.com. This …



05: 50+ SQL scenarios based interview Q&As on N items per group

This extends 15+ SQL scenarios based interview Q&As on Nth value – part 4. This SQL scenarios based interview questions & answers focus on N items per group. These examples …



06: 50+ SQL scenarios based interview Q&As on unique N items per group

This extends 15+ SQL scenarios based interview Q&As on N items per group – part 5 This SQL scenarios based interview questions & answers focus on N items per group. …



07: 50+ SQL scenarios based interview Q&As on Pivot Vs. Unpivot

Q01 Often you will have a requirement to report on a certain dimension, which requires you to convert rows into columns or columns into rows. How will you go about …



08: 50+ SQL scenarios based interview Q&As on CASE statements & NULL safe join

Below question is popular in SQL coding interviews. SQL syntaxes are very easy to learn, but lots of practice is required to be able to understand the business intent, and …



1 2 3 4

300+ Big Data Interview Questions - FAQs

300+ Java Interview Questions - FAQs

Tutorials on Java & Big Data