Nokia
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Clear (1)
Join in SQL is used to combine rows from two or more tables based on a related column between them.
Join is used to retrieve data from multiple tables based on a related column
Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column
Primary key is a unique identifier for each record in a database table.
Primary key ensures each record in a table is uniquely identified
It must contain unique values and cannot have NULL values
Primary key can be a single column or a combination of columns
Example: 'ID' column in a 'Users' table can be a primary key
I applied via Approached by Company and was interviewed in Jan 2023. There were 3 interview rounds.
These are the general questions which we had studied upto 10th and likely to be coding ....i had never attempted to this aptitude test...just read by my seniors of btech
Coding is the favorite part of my life.....i started...no ..no..my coach started to taught me from C...then to C++, in the final year I'm impressed on Java and python for data science and machine learning......and much more interesting was IOT ....the world much better and with IOT without effecting the species by 5G and 4G networks
I rate myself 8/10 in Advanced Excel and 9/10 in SQL.
Advanced Excel: proficient in pivot tables, VLOOKUP, macros, and data visualization
SQL: skilled in writing complex queries, joins, subqueries, and stored procedures
Experience in using Excel and SQL together to analyze large datasets
To work with dynamic data, remove duplicates and fix errors, use data cleaning techniques.
Use software tools like OpenRefine or Excel to clean data
Identify and remove duplicate data using unique identifiers
Fix errors by standardizing data formats and using regular expressions
Use data validation to ensure accuracy and completeness
Create a data cleaning plan and document all changes made
Test the cleaned data to ensure it
Formula is a mathematical expression while function is a pre-built formula that performs a specific task.
Formula is a combination of mathematical operators and values used to calculate a result.
Function is a pre-built formula that performs a specific task, such as finding the average of a range of numbers.
Formulas can be customized and modified, while functions are fixed and cannot be changed.
Examples of functions incl
I applied via AmbitionBox and was interviewed before Apr 2023. There were 2 interview rounds.
Good but very tough and difficult not easy to crack
Skil set for My relevant job update
Communication discussion
I applied via Approached by Company and was interviewed in Mar 2024. There were 2 interview rounds.
Python language requried
based on 1 interview
Interview experience
based on 9 reviews
Rating in categories
Technical Lead
509
salaries
| ₹0 L/yr - ₹0 L/yr |
Software Engineer
494
salaries
| ₹0 L/yr - ₹0 L/yr |
Technical Specialist
486
salaries
| ₹0 L/yr - ₹0 L/yr |
R&D Engineer
460
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Technical Specialist
236
salaries
| ₹0 L/yr - ₹0 L/yr |
Samsung
Apple
Huawei Technologies
Xiaomi