i
Pristyn Care
Filter interviews by
SQL is a programming language used for managing and manipulating relational databases.
SQL stands for Structured Query Language.
It is used to communicate with databases to retrieve, insert, update, and delete data.
Common SQL commands include SELECT, INSERT, UPDATE, and DELETE.
SQL is used in various database management systems like MySQL, PostgreSQL, and Oracle.
Example: SELECT * FROM customers WHERE city = 'New York';
A left join is a type of join in SQL that returns all records from the left table and the matched records from the right table.
Left join is used to retrieve all records from the left table and the matched records from the right table.
If there is no match, NULL values are returned for the columns from the right table.
Types of joins in SQL include inner join, outer join (left, right, full), cross join, and self join.
Normal distribution is a probability distribution that is symmetric and bell-shaped.
It is also known as Gaussian distribution.
It is characterized by mean and standard deviation.
Many natural phenomena follow normal distribution, such as height and weight of individuals.
68% of the data falls within one standard deviation of the mean, 95% within two standard deviations, and 99.7% within three standard deviations.
It is wid...
SQL jobs include database administrator, data analyst, data scientist, business intelligence analyst, and software developer.
Database Administrator
Data Analyst
Data Scientist
Business Intelligence Analyst
Software Developer
I applied via Job Portal
SQL and Python data analysis questions
Matching data in different columns involves comparing the values in the columns and identifying similarities or patterns.
Use string matching techniques like exact match, partial match, or fuzzy matching.
Apply data cleaning and preprocessing techniques to standardize the data before matching.
Utilize advanced algorithms like Levenshtein distance or Jaccard similarity for more complex matching.
Consider using database join...
I applied via Referral and was interviewed in Aug 2023. There were 2 interview rounds.
SQL query optimisation
I applied via Referral and was interviewed before Sep 2023. There were 3 interview rounds.
Quant, LR, puzzles, cat based level 2 questions
Tuple is immutable and ordered, while list is mutable and ordered in Python.
Tuple is created using parentheses () while list is created using square brackets []
Tuple elements cannot be changed once assigned, while list elements can be modified
Tuple is faster than list for iteration and accessing elements
Example: tuple = (1, 2, 3) and list = [1, 2, 3]
I have a strong background in data analysis with experience in various industries.
Bachelor's degree in Statistics with a focus on data analysis
Proficient in SQL, Python, and data visualization tools like Tableau
Experience working with large datasets and conducting statistical analysis
Completed internships at XYZ Company and ABC Organization
Presented findings at industry conferences
I have learned to effectively analyze and interpret data to derive meaningful insights and make informed decisions.
Developed strong analytical skills through hands-on experience with various data analysis tools and techniques
Improved ability to identify trends, patterns, and outliers in data sets
Enhanced communication skills by presenting findings and recommendations to stakeholders
Learned to collaborate with team memb
I applied via Approached by Company and was interviewed in Apr 2023. There were 2 interview rounds.
To calculate cumulative sum for a given table
Sort the table in ascending order based on the column you want to calculate the cumulative sum for
Add a new column to the table to store the cumulative sum
Iterate through each row of the table and calculate the cumulative sum by adding the current row's value to the previous row's cumulative sum
Store the cumulative sum in the new column for each row
Yes, I have experience in both operations and data entry roles.
I have worked as a data entry operator for a pharmaceutical company where I was responsible for entering patient data into the system.
In my previous role as an operations analyst, I was responsible for analyzing data and creating reports for the management team.
I have experience using various data entry software such as Microsoft Excel and Google Sheets.
I a...
Yes, I can do data entry work as a data analyst.
Data entry work is a part of data analysis process.
I have experience in data entry work and can perform it efficiently.
Data entry work includes entering data into spreadsheets, databases, or other software.
I understand the importance of accurate data entry for effective analysis.
I applied via Approached by Company and was interviewed in Apr 2023. There were 6 interview rounds.
Operation questions like vlookups, Hlookups, xlookups etc,.
Reporting questions like pivot tables, typing speed, power pivots, pricing sheet preparation
SQL queries like joins, aggregation functions, filters etc,.
I can prepare a bar chart with product operations data within a few minutes.
I have experience using data visualization tools like Tableau, Power BI, or Excel to quickly create bar charts.
I am proficient in organizing and cleaning data to ensure accurate representation in the chart.
I can customize the chart with relevant labels, colors, and titles to make it visually appealing and easy to understand.
You can merge multiple Excel files together using the 'Consolidate' feature in Excel.
Open Excel and go to the 'Data' tab
Click on 'Consolidate' in the 'Data Tools' group
Select the files you want to merge and choose the desired options
Click 'OK' to merge the files together
I applied via Company Website and was interviewed in Apr 2024. There was 1 interview round.
HackerRank Test - Python, SQL
I applied via Job Portal and was interviewed before Jun 2022. There were 2 interview rounds.
I applied via Company Website and was interviewed before Feb 2023. There was 1 interview round.
Types of join in SQL include inner join, left join, right join, and full outer join.
Inner join returns only the matching records from both tables.
Left join returns all records from the left table and the matching records from the right table.
Right join returns all records from the right table and the matching records from the left table.
Full outer join returns all records when there is a match in either the left or rig
A left join is used to combine data from two tables based on a common column, including all records from the left table.
Left join returns all rows from the left table and the matching rows from the right table.
It is useful when you want to retrieve all records from the left table, even if there are no matches in the right table.
The result of a left join will have NULL values in the columns from the right table where th...
The number of rows after applying join operations depends on the type of join used and the data in the tables being joined.
Inner join retains only the rows that have matching values in both tables
Left join retains all rows from the left table and the matched rows from the right table
Right join retains all rows from the right table and the matched rows from the left table
Full outer join retains all rows when there is a
VLOOKUP in Excel is used to search for a value in a table and return a corresponding value, while SQL functions like JOIN and WHERE are used to retrieve data from multiple tables based on specified conditions.
VLOOKUP is specific to Excel and works on a single table, while SQL functions can work on multiple tables.
VLOOKUP requires the table to be sorted in ascending order, while SQL functions do not have this requiremen...
based on 1 interview
Interview experience
based on 4 reviews
Rating in categories
Business Development Manager
679
salaries
| ₹3 L/yr - ₹7.3 L/yr |
Team Lead
229
salaries
| ₹4 L/yr - ₹9 L/yr |
Category Manager
139
salaries
| ₹7 L/yr - ₹18.6 L/yr |
Senior Associate
126
salaries
| ₹3 L/yr - ₹8 L/yr |
Senior Manager
80
salaries
| ₹9.5 L/yr - ₹30 L/yr |
Udaan
Swiggy
BlackBuck
Ninjacart