If you work with data, SQL functions are your toolkit for unlocking powerful insights. Whether you’re crafting detailed reports or uncovering business-changing analytics, SQL is the backbone for data doers in every industry. This guide explores 27 SQL functions that every data analyst, data engineer, or analytics enthusiast should know. These functions are grouped into five categories for easier understanding and practical use.
Continue readingCategory Archives: SQL
SQL to Hive — Commonly Used Hive Syntax and Features
I recently encountered a project that uses HIVE table, coming from microsoft sql , mysql background, I had a little struggle with different sql syntax and behavior, thought I’d write this article on some common SQL to Hive conversions in case you are ever in similar situation.
Continue readingSQL Is SQL? Really? Comprehensive review on differences between ANSI-SQL, T-SQL
In the world of databases, SQL is a foundational language that serves as the backbone for interacting with relational databases. However, when delving deeper into SQL, you will come across terms like ANSI SQL and T-SQL, which may seem confusing at first. In this article, we’ll explore what SQL, ANSI SQL, and T-SQL are, how they differ, and their specific use cases.
Continue readingSlowly Changing Dimensions(SCD) with Microsoft Fabric — What are they and How to Implement
Data warehousing and business intelligence are crucial for modern enterprises, enabling them to make informed decisions based on historical data. One key aspect of data warehousing is handling changing data over time, especially when tracking historical changes in dimensions. This is where Slowly Changing Dimensions (SCD) come into play. In this blog post, we’ll delve into what SCDs are, the different types of SCDs, and how to implement them effectively.
Continue reading