Faster and better experience!
i
Internshala
Filter interviews by
I applied via LinkedIn and was interviewed in Feb 2024. There was 1 interview round.
Left Join is a type of join operation in SQL that returns all rows from the left table and the matched rows from the right table.
Left Join combines rows from two tables based on a related column between them.
It includes all rows from the left table, even if there are no matches in the right table.
If there are no matches, NULL values are included for columns from the right table.
Example: SELECT * FROM table1 LEFT JOIN t
SQL queries are executed in a specific order to ensure accurate results.
SQL queries are executed in the following order: FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY.
The FROM clause specifies the tables involved in the query.
The WHERE clause filters the rows based on specified conditions.
The GROUP BY clause groups the rows based on specified columns.
The HAVING clause filters the grouped rows based on specified condi...
Developed a predictive analytics model for customer churn in a telecom company.
Collected and cleaned customer data from various sources
Performed exploratory data analysis to identify patterns and trends
Built a machine learning model to predict customer churn
Evaluated the model's performance using metrics like accuracy and precision
Provided actionable insights to reduce customer churn rate
I took a structured approach by first defining the problem, collecting relevant data, analyzing the data, and then presenting findings.
Defined the problem statement clearly to understand the scope of analysis
Collected relevant data from various sources such as databases, surveys, and external research
Analyzed the data using statistical tools and techniques to derive insights
Presented findings in a clear and concise man
I have experience with various machine learning models such as linear regression, decision trees, random forests, and neural networks.
Linear regression is used for predicting continuous outcomes.
Decision trees are used for classification and regression tasks.
Random forests are an ensemble method that combines multiple decision trees for improved accuracy.
Neural networks are used for complex pattern recognition and pred
Top trending discussions
A general apti round
Data analysis assignment
In SQL, data is grouped by a specified column or expression using the GROUP BY clause.
Data is grouped based on the values in the specified column or expression
Aggregate functions like SUM, COUNT, AVG can be used with GROUP BY to perform calculations on each group
GROUP BY is often used in conjunction with the SELECT statement
Example: SELECT department, AVG(salary) FROM employees GROUP BY department
Lists are ordered collections of items, while dictionaries are unordered collections of key-value pairs.
Lists are accessed by index, dictionaries are accessed by key
Lists maintain the order of elements, dictionaries do not guarantee order
Lists use square brackets [], dictionaries use curly braces {}
Example: list - [1, 2, 3], dictionary - {'a': 1, 'b': 2}
Lambda functions are anonymous functions in Python that can have any number of arguments but only one expression.
Lambda functions are defined using the lambda keyword.
They are commonly used for small, one-time tasks.
Lambda functions can take any number of arguments, but can only have one expression.
Example: add = lambda x, y: x + y
I applied via LinkedIn and was interviewed before Oct 2023. There were 2 interview rounds.
Around sql/python and other da tools
Stats and probability with focus on puzzles
I applied via Referral and was interviewed before Nov 2020. There was 1 interview round.
I applied via Company Website and was interviewed in Aug 2021. There was 1 interview round.
I can promote Coding Ninjas courses by organizing coding events, sharing course details on social media, and collaborating with college clubs.
Organize coding events in college and invite Coding Ninjas as a sponsor or guest speaker
Share course details on social media platforms like Facebook, LinkedIn, and Twitter
Collaborate with college clubs like coding clubs, tech clubs, and entrepreneurship clubs to promote the cours...
I applied via LinkedIn and was interviewed in Sep 2023. There were 3 interview rounds.
Medium level coding question
All the logical Qustions
I applied via Company Website and was interviewed before May 2022. There were 2 interview rounds.
I am a hardworking and enthusiastic individual with a passion for learning and making a positive impact.
I have a strong work ethic and am always willing to go the extra mile to achieve my goals.
I am a quick learner and enjoy taking on new challenges.
I am a team player and believe in the power of collaboration to achieve success.
I am passionate about making a positive impact in the world and strive to do so in everythin
I am very active in my campus societies and have held leadership positions in multiple clubs.
I have been a member of the debate club for 3 years and served as the president last year.
I am also a member of the environmental club and have organized multiple events and campaigns.
In addition, I am a part of the student government association and have helped plan and execute various campus-wide events.
I believe being involv...
based on 1 interview
Interview experience
Marketing Associate
17
salaries
| ₹5 L/yr - ₹6 L/yr |
Product Manager
16
salaries
| ₹7 L/yr - ₹15 L/yr |
Associate Product Manager
16
salaries
| ₹5.4 L/yr - ₹7 L/yr |
Software Development Engineer
16
salaries
| ₹5.4 L/yr - ₹20 L/yr |
Data Scientist
14
salaries
| ₹6 L/yr - ₹8 L/yr |
Acadecraft
Coding Ninjas
Globus Infocom
SpeedLabs