"Everything is okay in the end, if it's not ok, then it's not the end."
Additional Information
All your information will be kept confidential according to EEO guidelines.
Company Description
Company Description:
LinkTag is a dynamic firm, where all of us here have a single motivation to succeed and our success is defined by our clients, making that as our ultimate objective. We extend our services to hiring resources on staffing basis- fulltime, contracting and consulting and/or working on fixed price proposals for deployment of teams. These technical and skilled teams are flexible to work from any locations – your clients, or ours. We also help you fulfill your needs at other global locations as well.
This guide is for Indian job seekers preparing for SQL rounds in data analyst, data engineer, backend developer and database roles, from freshers to experienced professionals. It has 60 questions in three levels: easy covers joins, grouping and NULLs; medium covers window functions, CTEs, indexes and isolation levels; hard covers locking, MVCC, query tuning and classic puzzles such as login streaks and medians. Answers use ANSI SQL, with MySQL 8 and PostgreSQL notes where the two differ. Write each query against your own sample tables first, then compare your result with the sample answer.
Questions you may be asked
What is the difference between WHERE and HAVING?
What is the difference between DELETE, TRUNCATE and DROP?
What is the difference between an INNER JOIN and a LEFT JOIN?
What is the difference between a primary key and a unique key?
