Different database design approaches Star schema and Relational schema.
The Analyst Geek
Command Palette
Search for a command to run...
Archive
12 posts published so far
Just Steps to Append and Merge data using Power Query in Power BI
The Analyst Geek
Difference between Fact and Dimension tables in SQL/Power BI with example.
The Analyst Geek
Exploring the WITHIN GROUP Clause in PostgreSQL
The Analyst Geek
How to Handle Null Values in SQL
The Analyst Geek
Using SQL with Python & R for Data Analysis
The Analyst Geek
Optimized SQL Queries for Daily Use !
The Analyst Geek
Performing Change Data Capture (CDC) without Timestamp Columns using SQL
The Analyst Geek
Create Library DB from scratch go through these queries & appear for interview !
The Analyst Geek
Understand over() clause in comparison with group by and equivalent code [using inner join and subquery].
The Analyst Geek
All about Order of Execution in SQL
The Analyst Geek
Interview Ready Questions on Group By and Window Functions in SQL: Exploring the World Population Dataset.
The Analyst Geek