Filter interviews by
Clear (1)
I applied via LinkedIn and was interviewed in Jun 2021. There were 3 interview rounds.
Distinct returns unique values while group by groups and aggregates data based on a column.
Distinct returns only unique values from a single column.
Group by groups and aggregates data based on a column.
Distinct can be used to count the number of unique values in a column.
Group by can be used to group data by a column and perform aggregate functions like sum, count, avg, etc.
Distinct is used to remove duplicates from a ...
Right join and right outer join are the same thing.
Right join and right outer join are interchangeable terms.
Both return all the rows from the right table and matching rows from the left table.
If there is no match, the result will contain NULL values for the left table columns.
Used to combine data from two tables based on a common column.
Syntax: SELECT * FROM table1 RIGHT JOIN table2 ON table1.column = table2.column;
Special characters in columns can be handled by replacing or removing them.
Identify the special characters in the column
Replace the special characters with a suitable alternative
Remove the special characters if they are not necessary
Use regular expressions to handle complex special characters
Ensure that the data type of the column is appropriate
Top trending discussions
I applied via Referral and was interviewed before Sep 2021. There were 2 interview rounds.
Analytics process involves data collection, cleaning, analysis, and interpretation to derive insights and make data-driven decisions.
Identify the problem and define the objective
Collect relevant data from various sources
Clean and preprocess the data to remove errors and inconsistencies
Analyze the data using statistical and machine learning techniques
Interpret the results and derive insights
Communicate the findings to s
Power BI is a business analytics service by Microsoft that provides interactive visualizations and business intelligence capabilities.
Power BI allows users to connect to various data sources and create interactive reports and dashboards.
It provides a wide range of visualization options such as charts, graphs, maps, and tables.
Users can also create custom visuals using the Power BI developer tools.
Power BI integrates wi...
I applied via Walk-in and was interviewed before Jun 2020. There was 1 interview round.
I applied via Company Website and was interviewed before Jun 2020. There were 4 interview rounds.
MongoDB database algorithms are used for efficient data storage, retrieval, and processing.
MongoDB uses various algorithms for indexing, sharding, and aggregation.
Indexing algorithms include B-tree, hash, and text search indexes.
Sharding algorithms include range-based, hash-based, and zone-based sharding.
Aggregation algorithms include map-reduce and aggregation pipeline.
MongoDB also uses algorithms for query optimizati
I applied via Recruitment Consultant and was interviewed in Aug 2020. There were 4 interview rounds.
I applied via Naukri.com and was interviewed before Aug 2021. There were 2 interview rounds.
Structured Query Language (SQL) is a programming language used to manage and manipulate relational databases.
SQL is used to create, modify, and delete databases, tables, and data
It is used to retrieve data from databases using queries
SQL is used to perform operations on data such as sorting, filtering, and grouping
Examples of SQL-based database management systems include MySQL, Oracle, and Microsoft SQL Server
I appeared for an interview in Aug 2017.
I appeared for an interview in Sep 2016.
I appeared for an interview before Nov 2016.
Software Engineer
207
salaries
| ₹2.3 L/yr - ₹12 L/yr |
Senior Software Engineer
190
salaries
| ₹6.2 L/yr - ₹23 L/yr |
Technical Lead
47
salaries
| ₹11.1 L/yr - ₹37 L/yr |
Softwaretest Engineer
46
salaries
| ₹3 L/yr - ₹12.6 L/yr |
Senior QA Engineer
42
salaries
| ₹6 L/yr - ₹18 L/yr |
Hurix Systems
Aptara
Serosoft Solutions
Magic Edtech