EY Global Delivery Services ( EY GDS) Associate Technical Consultant Interview Questions and Answers

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 tables

• Common SQL commands include SELECT, INSERT, UPDATE, DELETE

• SQL is used in various database management systems such as MySQL, PostgreSQL, Oracle

SQL joints are used to combine rows from two or more tables based on a related column between them.

• INNER JOIN: Returns rows when there is a match in both tables

• LEFT JOIN: Returns all rows from the left table and the matched rows from the right table

• RIGHT JOIN: Returns all rows from the right table and the matched rows from the left table

• FULL JOIN: Returns rows when there is a match in one of the tables

• CROSS JOIN: Retur