Mohamad AshourHow 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…Jun 25, 2023Jun 25, 2023
Mohamad AshourHow 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…Jun 17, 20237Jun 17, 20237
Mohamad AshourHow to perform data analysis using SQL part 2 — Intermediate SQL.SQL Aggregate FunctionsJun 11, 2023Jun 11, 2023
Mohamad AshourHow 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…Jun 10, 20231Jun 10, 20231
Mohamad AshourFact table definition and its types in data warehousing with examplesWhat is a Fact Table?Jun 7, 2023Jun 7, 2023
Mohamad AshourWhy 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…May 8, 2023May 8, 2023
Mohamad AshourHow 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…May 8, 2023May 8, 2023
Mohamad AshourWhy 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…May 8, 2023May 8, 2023
Mohamad AshourThe 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…Apr 11, 2023Apr 11, 2023