i
Dilyt
Filter interviews by
I applied via Naukri.com and was interviewed in Jan 2024. There were 2 interview rounds.
Different types of commands include data manipulation, data definition, data control, and transaction control commands.
Data manipulation commands: SELECT, INSERT, UPDATE, DELETE
Data definition commands: CREATE, ALTER, DROP
Data control commands: GRANT, REVOKE
Transaction control commands: COMMIT, ROLLBACK, SAVEPOINT
Inner join returns only the matching rows between two tables, while outer join returns all rows from both tables.
Inner join only includes rows that have matching values in both tables
Outer join includes all rows from both tables, filling in missing values with NULL if there is no match
Examples: Inner join - SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id; Outer join - SELECT * FROM table1 LEFT OUTER JOI
SQL query to retrieve the second highest salary from a table
Use the ORDER BY clause to sort salaries in descending order
Use the LIMIT clause to retrieve the second row
Numpy is a library for numerical operations in Python, while Pandas is used for data manipulation and analysis.
Numpy is used for numerical operations like linear algebra, Fourier transform, etc.
Pandas is used for data manipulation tasks like data cleaning, merging, reshaping, etc.
Numpy works with arrays, while Pandas works with dataframes.
Numpy is more efficient for numerical computations, while Pandas is more user-fri...
Top trending discussions
I was interviewed before May 2022.
Pivot table is a data summarization tool in Excel.
Pivot table allows users to summarize and analyze large datasets.
It can be used to group data by categories, calculate totals, and create custom calculations.
Users can easily change the layout of the table to view data in different ways.
Pivot table is a powerful tool for data analysis and reporting.
Example: A sales manager can use pivot table to analyze sales data by re
To count data in Excel, use the COUNT function or select the data and look at the status bar.
Use the COUNT function to count the number of cells that contain numbers or dates
Use the COUNTA function to count the number of cells that are not empty
Select the data and look at the status bar to see the count of selected cells
Use the COUNTIF function to count cells that meet a specific criteria
I applied via Job Portal and was interviewed before Dec 2023. There were 3 interview rounds.
SQL Test with 5 questions
I applied via Referral and was interviewed before Nov 2020. There were 3 interview rounds.
posted on 28 Feb 2024
I applied via Company Website and was interviewed before Feb 2023. There was 1 interview round.
posted on 23 Sep 2024
I applied via Campus Placement and was interviewed in Aug 2024. There were 3 interview rounds.
Basic aptitude questions but less time to solve.
Basic topics given such as social media and work life balance.
I chose your company because of its reputation for innovation and commitment to employee development.
Impressed by the company's track record of successful projects
Positive reviews from current and former employees
Opportunities for growth and advancement within the company
SQL test on Select query, insert, create
I applied via Referral and was interviewed before Oct 2023. There was 1 interview round.
based on 1 interview
Interview experience
BI Developer
19
salaries
| ₹0 L/yr - ₹0 L/yr |
ETL Developer
9
salaries
| ₹0 L/yr - ₹0 L/yr |
Business Intelligence Developer
7
salaries
| ₹0 L/yr - ₹0 L/yr |
Software Engineer
5
salaries
| ₹0 L/yr - ₹0 L/yr |
Business Development Executive
4
salaries
| ₹0 L/yr - ₹0 L/yr |
HCL Infosystems
Accel Frontline
Diverse Lynx
Pitney Bowes