Mohamad Ashour·Jun 25, 2023How SQL Views are important in the role of data analysis?What if you written a SQL query to perform some statements like select name of the customers and the category and join this with the sales…
Mohamad Ashour·Jun 17, 2023How to speed your SQL queries and write clean SQL code?In the article, we are going to examine how to optimize SQL queries and improve query performance by using SQL query optimization tips and…A response icon7A response icon7
Mohamad Ashour·Jun 11, 2023How to perform data analysis using SQL part 2 — Intermediate SQL.SQL Aggregate Functions
Mohamad Ashour·Jun 10, 2023How to perform data analysis using SQL?SQL is short for Structured Query Language and as the name suggests, it is a standardized language that is used to query or retrieve data…A response icon1A response icon1
Mohamad Ashour·Jun 7, 2023Fact table definition and its types in data warehousing with examplesWhat is a Fact Table?
Mohamad Ashour·May 8, 2023Why learn about the distribution of data?Let’s take a look at the distribution of data. Or, in other words, the frequency with which different values appear in our dataset. Let’s…
Mohamad Ashour·May 8, 2023How to check quality of data using SQL?Let’s look at types of data quality checks. There are two types of data quality checks we should apply. Missing or invalid data checks and…
Mohamad Ashour·May 8, 2023Why check data?In the ideal world, the data sets we work with are complete and accurate. In the real world, this is rarely the case. The more complicated…
Mohamad Ashour·Apr 11, 2023The Power of Operating System!An Operating System (OS) is a vital software that manages a computer’s resources and provides a platform for running applications. In this…