SQL aggregate function is used to perform the calculation on multiple rows of single column of a table. It returns a single value. There are basically 5 SQL Aggregate Function:

SQL is a standard language for storing, manipulating and retrieving data in databases. Lets go step by step on how to learn SQL effectively- 1. Understand the fundamental · What is Data, Database and RDBMS? · What is SQL and purpose of using SQL? · How Data is stored in RDBMS? 2. Learn SQL Commands · DDL Commands …

Source credit- techTFQ Learn and practice SQL for free with LearnSQL.com- https://learnsql.com/ · This is a great place to learn SQL · It offers interactive courses that range in difficulty from beginners to advanced. · Choose from full learning track , mini-tracks to sharpen targeted skills, and individual courses. Reason why LearnSQL.com is one the best platform – ·…

Before understanding the term star schema ; its important to know what is schema- It is like a skeletal structure representing a logical view of whole database. Whenever organization engage in data modelling, it leads to a schema. Star schema - · The star schema is a simple data warehouse diagram which resembles…

As a beginner, most of the people faces problem while collecting dataset for their portfolio or projects. So, in this article I will provide you some free website from where you can collect dataset very easily. But before that there are some key points to remember while collecting the dataset- …

As a Data Analyst , you should know some of the important Python libraries that we need to use daily to solve variety of problems which occur in decision-making for industries. So, Today in my article I will let you know some of the libraries used for Data Analyst during…

Nowadays, Heart disease is the leading cause of death and according to the Centers for Disease Control and Prevention (CDC)Trusted Source, in the United States, 1 in every 4 deaths in is the result of a heart disease. Common heart disease symptoms include: dizziness paleness shortness of breath or shallow…

Data Analyst really need to write a lot of code for Exploratory data analysis (EDA) but using kilb library makes really easier in many ways. Klib library- · It is a python library · Helps in importing, cleaning and analyzing and preprocessing data. You can check out this video below to know…

These days everybody wants to learn programming and when programming word comes , mostly people think about python. So here I will recommend you top youtube channels to learn python from basic to advanced. …