IPG Mediabrands Data Analyst Interview Questions and Answers for Freshers

SQL Joins are used to combine rows from two or more tables based on a related column between them.

• SQL Joins are used to retrieve data from multiple tables based on a related column between them.

• Common types of SQL Joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column;

Python numpy provides various functions for numerical operations on arrays.

• numpy.sum() - calculates the sum of array elements

• numpy.mean() - calculates the mean of array elements

• numpy.max() - returns the maximum value in an array

• numpy.min() - returns the minimum value in an array

• numpy.std() - calculates the standard deviation of array elements