Blog Archives
1 2 3 4

00: 18+ SQL best practices interview Q&As

It is a must to know the order in which the SQL clauses are executed. This is demonstrated with an example below in #5. Have this order of execution visibly pinned and understood.

Read more ›



00: 25+ SQL interview questions & answers – beginner

SQL interview Questions & Answers is a must for any developer as all non-trivial applications need to talk to a database with CRUD operations. Q3 – Q15 are very popular with the interviewers.

Read more ›



00: 25+ SQL interview questions & answers – intermediate to experienced

This continues 25+ SQL interview questions & answers – beginner Q16. Why do you have CASE statements in SQL? A16. … Read more ›...



01: 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 to convert a given business requirement into a query takes lots of practice.

Read more ›



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 practice these in SQLs by setting up the data on db-fiddle MySQL V8.0 or...



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 functions”...



02: SQL analytic functions interview questions – Part 2

This extends SQL window function for analytical queries interview questions – Part 1 Analytic function construct The analytic function names can be RANK(), … Read more ›...



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? … Read more ›...



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.

Read more ›



1 2 3 4
Answers are detailed to be useful beyond job interviews. A few Q&As each day will make a huge difference in 3 to 24 months to go places depending on your experience.
Top