Series

SQL

This series of articles will focus on SQL concepts and interview questions, covering basic to advanced topics. The interview series will include fundamental, intermediate, and advanced questions.

Articles in this series

SQL Function: DATE_TRUNC()

Dec 25, 20243 min read

About SQL Function: DATE_TRUNC When working with date and time data in SQL, it's often necessary to truncate a timestamp to a specific precision. The...

SQL Function: COALESCE()

Dec 24, 20243 min read

About SQL Function: COALESCE() In SQL, dealing with NULL values is a common task, and having a function that helps manage these NULLs efficiently can...

SQL Operator : 𝗨𝗡𝗣𝗜𝗩𝗢𝗧

Dec 24, 20242 min read

About 𝗦𝗤𝗟 𝗢𝗽𝗲𝗿𝗮𝘁𝗼𝗿: 𝗨𝗡𝗣𝗜𝗩𝗢𝗧 When working with relational databases, data often needs to be transformed to meet specific...