Posts

Automatic Water level Controller Installation

Types of cables

LIST vs TUPLE vs SET vs Dictionary

Strings Format in Python

Multi Bagger stock Filters

GROUP BY vs Window Functions in SQL

Using Window Functions Instead of Aggregate Functions in SQL CASE Statements

Advantages of CTE

RANK VS DENSE_RANK VS ROW_NUMBER

Why NOT LIKE Returned Only 28 Records Instead of 44,000 in SQL

Why a FULL OUTER JOIN Returned Fewer Records Than Expected in SQL

Providing Workspace-Level and RLS Access to an External Vendor in Power BI

HPE VBA/SQL Interview questions

OLE DB vs ODBC vs ADODB

Connecting VBA to SQL

AI Stack

Index Investing

Factor investing

Facts vs Dimensions

Recursive CTE

HCL Tech interview questions

Interview Questions-CAPCO

SQL Interview Questions Deloitte

Python Interview Questions

Purpose of SELF JOIN

Python Data Types