SQL and Database Interview Resources - mrohit829/Programming-Resources GitHub Wiki

Top 10 SQL Interview Questions for Programmers

A mini thread🧵

10 Popular SQL Queries from Interviews

Top 10 Frequently asked SQL Query Interview QuestionsJava Programming tutorials and Interview Questions, book and course recommendations from Udemy, Pluralsight, Coursera, edX etc https://www.java67.com/2013/04/10-frequently-asked-sql-query-interview-questions-answers-database.html

50+ SQL Server Questions for telephonic interviews

Top 50 Microsoft SQL Server Telephonic Interview Questions with AnswersJava Programming tutorials and Interview Questions, book and course recommendations from Udemy, Pluralsight, Coursera, edX etc https://www.java67.com/2019/08/microsoft-sql-server-phone-interview-questions-answers.html

Difference between UNION and UNIONALL in SQL

Difference between UNION vs UNION ALL in SQL? ExampleJava Programming tutorials and Interview Questions, book and course recommendations from Udemy, Pluralsight, Coursera, edX etc https://www.java67.com/2014/09/difference-between-union-vs-union-all-in-SQL.html

Difference between table scan and index scan

Difference between table scan, index scan, and index seek in SQL Server Database? ExampleJava Programming tutorials and Interview Questions, book and course recommendations from Udemy, Pluralsight, Coursera, edX etc https://www.java67.com/2017/12/difference-between-table-scan-index.html

How to find Nth highest salary in SQL

How to Find Nth Highest Salary in MySQL and SQL Server? Example LeetCode SolutionJava Programming tutorials and Interview Questions, book and course recommendations from Udemy, Pluralsight, Coursera, edX etc https://www.java67.com/2020/05/nth-highest-salary-in-mysql-and-sql-server-example.html

Difference between CHAR and VARCHAR in SQL?

**Difference between VARCHAR and CHAR data type in SQL Server? [Explained]**Java Programming tutorials and Interview Questions, book and course recommendations from Udemy, Pluralsight, Coursera, edX etc https://www.java67.com/2019/06/difference-between-varchar-and-char-data-type-in-sql-server.html

How to remove duplicates from table?

3 Ways to Remove Duplicates from a table in SQL - Query ExampleA blog about Java, Programming, Algorithms, Data Structure, SQL, Linux, Database, Interview questions, and my personal experience.https://javarevisited.blogspot.com/2016/07/how-to-remove-duplicate-rows-from-table-SQL-database.html

Difference between EXISTS and NOT EXISTS

How to use EXISTS and NOT Exists in SQL? Example Query and TutorialA blog about Java, Programming, Algorithms, Data Structure, SQL, Linux, Database, Interview questions, and my personal experience.https://javarevisited.blogspot.com/2016/01/sql-exists-example-customers-who-never-ordered.html

Difference between WHERE and HAVING in SQL?

Difference between WHERE vs HAVING clause in SQL - GROUP BY Comparison with ExampleThough both WHERE and HAVING clause is used to specify filtering condition, main difference between them comes from the fact, when they are used in GROUP BY clause. WHERE clause is used to filter row ...https://javarevisited.blogspot.com/2013/08/difference-between-where-vs-having-clause-SQL-databse-group-by-comparision.html

Difference between Primary Key and Foreign Key

Difference between Primary key vs Foreign key in table -- SQL Tutorial ExampleMain difference between primary and foreign key in database is that, primary key in one table act as foreign key in other table. They are used to enforce Referential Integrity constraints.https://javarevisited.blogspot.com/2012/12/foreign-key-vs-primary-key-table-sql-database-difference.html

Difference between clustered and non-clustered index in SQL?

Difference between Clustered Index and Non Clustered Index in SQL Server - ExampleKey difference between clustered and nonclustered index in database is that clustered index decides physical order of data in disk, while nonclustered index just contain reference of where data is.https://javarevisited.blogspot.com/2013/08/difference-between-clustered-index-and-nonclustered-index-sql-server-database.html

If you like these questions the please share the first tweet of this thread so that more people can find it. If you need resources to learn SQL here best websites to learn SQL

10 Best Places to Learn SQL Online for FREEThese are my favorite websites to learn SQL Query and Database fundamentals online it includes SQLZoo, SQLBolt, Khan Academy and Udemy https://medium.com/javarevisited/8-best-resources-to-learn-sql-online-for-free-b00506d88c