TCS AST Consultant Interview Questions, Process, and Tips

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 perform tasks such as querying data, updating data, and creating databases.

• SQL statements are used to perform tasks like selecting data from a database table, inserting new records, updating existing records, and deleting records.

• Examples of SQL comma...read more

Joins in Excel are used to combine data from different tables based on a common column.

• Joins in Excel are performed using the VLOOKUP, INDEX/MATCH, or Power Query functions.

• Common types of joins include inner join, left join, right join, and full outer join.

• Joins help in merging data from multiple tables to create a single, unified dataset.

• For example, you can use VLOOKUP to combine sales data from one table with custo

Rank, dense rank, and ntile functions are used in SQL to assign a ranking to rows based on a specified criteria.

• Rank function assigns a unique rank to each row based on the specified criteria.

• Dense rank function assigns a unique rank to each row, but does not leave gaps in the ranking sequence.

• Ntile function divides the result set into a specified number of groups and assigns a group number to each row.

• Example: SELECT ...read more