Master SQL interviews (Top Interview questions & answers)

Biswajit Nanda

Reed Courses Certificate of Completion

Digital certificate - Included

• Most important SQL Questions and answers 2:12:59

  • 1: Q1. What is a Database? 00:10
  • 2: Q2. What is the difference between a database and DBMS? 00:47
  • 3: Q3. What is the difference between DBMS and RDBMS? 00:32
  • 4: Q4. What is the difference between DDL,DML and DCL commands? 00:52
  • 5: Q5. What is SQL? 00:10
  • 6: Q6. How do you create a table? 01:43
  • 7: Q7. What is the difference between CHAR and VARCHAR2 datatype in sql? 02:21
  • 8: Q8. How do you create a table from another table? 03:48
  • 9: Q9. How do you insert values into a table? 03:59
  • 10: Q10. Can you insert data into the same table? 01:13
  • 11: Q11. What will happen if you insert a bigger value into a varchar column? 01:03
  • 12: Q12. How do you select data from a table? 01:30
  • 13: Q13. How do you select data from a table using WHERE clause? 02:02
  • 14: Q14. How do you delete all data from a table? 00:41
  • 15: Q15. How do you delete data from a table based on a condition? 01:15
  • 16: Q16. What is the difference between DELETE and TRUNCATE statements? 01:10
  • 17: Q17. How do you drop a table? 01:47
  • 18: Q18. What is the difference between Delete and Drop? 01:34
  • 19: Q19. What are constraints and what is their importance? 01:46
  • 20: Q20. What is a primary key? 01:12
  • 21: Q21. How do you create a Primary key while creating a table? 00:53
  • 22: Q22. How do you create a table level Primary Key? 00:44
  • 23: Q23. How do you create Unique key while creating a table? 01:11
  • 24: Q24. How do you create a table level Unique Key? 01:29
  • 25: Q25. What is the difference between a Primary Key and Unique Key? 02:30
  • 26: Q26. How do you create a Check constraint while creating a table? 01:53
  • 27: Q27. How do you create a table level check constraint? 02:49
  • 28: Q28. Create a check constraint to restrict values to a range 01:09
  • 29: Q29. Create a check constraint to start with A 02:06
  • 30: Q30. How do you create a foreign key on a table? 02:44
  • 31: Q31. How do you create a table level foreign key on a table? 01:46
  • 32: Q32. What is meant by a nullable column? 01:00
  • 33: Q33. What are aggregate functions? 00:25
  • 34: Q34. Write a SQL statement to count the total number of rows of a table 00:42
  • 35: Q35. Write a SQL statement to count number of rows matching a condition 00:57
  • 36: Q36. Write a SQL statement where column matches with a string (LIKE operator) 01:29
  • 37: Q37. How do you calculate the AVG, MIN and MAX salary from employee table? 00:42
  • 38: Q38. How do you calculate total salary for employees grouped by employee ID? 01:18
  • 39: Q39. How do you select data in a table in sorted order(Ascending and descending) 01:16
  • 40: Q40. How do you specify a condition with a GROUP BY clause? 02:03
  • 41: Q41. Can you have both HAVING and WHERE clauses in the same SELECT statement? 01:06
  • 42: Q42. Write a query to display schema of a table 01:43
  • 43: Q43. Alter a table to add a new column to a table 00:56
  • 44: Q44. Alter a table to modify the column of a table 01:18
  • 45: Q45. Alter a table to drop a column of a table 00:54
  • 46: Q46. What is a JOIN? 01:10
  • 47: Q47. Explain different types of joins 00:49
  • 48: Q48. What is the difference between an outer join and inner join? 02:36
  • 49: Q49. What is the difference between Left Inner Join and Left Outer join? 01:28
  • 50: Q50. What is cross join? Where can it be used? 02:40
  • 51: Q51. What is full join? 01:40
  • 52: Q52. What is self join? 02:40
  • 53: Q53. Write a sql statement to display current date and time 00:30
  • 54: Q54. Write a sql statement to display the server and database name 00:35
  • 55: Q55. Write a sql statement to display the user name 00:27
  • 56: Q56. Write a sql statement to display the number of tables present in a database 01:50
  • 57: Q57. Write a sql statement to display the second highest salary from a table 02:02
  • 58: Q58. Write a SQL query to return a substring from a string.mp4 01:36
  • 59: Q59. Write a SQL query to return the no of characters of a given string 00:41
  • 60: Q60. Write sql query to return the numeric position of a character in a string 01:05
  • 61: Q61. Write a SQL statement to display distinct salaries from a table 00:54
  • 62: Q62. How do you concatenate two strings in sql? 01:08
  • 63: Q63. How can you create an empty table with the same structure as another table 01:20
  • 64: Q64. How can you return first 3 characters(right and middle also) of a string? 01:37
  • 65: Q65. What are indexes? Why they are used? 01:59
  • 66: Q66. What are clustered indexes? 02:28
  • 67: Q67. What is a non-clustered index? .mp4 02:28
  • 68: Q68. What is a Unique index? Write a sql to create one 02:29
  • 69: Q69. What is a view? Write a sql statement to create a view 01:43
  • 70: Q70. Write sql to display the number of views present in a database .mp4 01:39
  • 71: Q71. What is a sub-query? 02:12
  • 72: Q72. Write a query to remove spaces present in a string from sides .mp4 01:34
  • 73: Q73. Difference between Union and Union all operators 02:04
  • 74: Q74. What is Except or Minus operator? 01:49
  • 75: Q75. What is intersect operator? 00:55
  • 76: Q76. What is temp table in sql.mp4 01:06
  • 77: Q77. What are global temp tables?.mp4 01:13
  • 78: Q78. How to get nth highest salary.mp4 03:13
  • 79: Q79. How to get nth highest salary when there are duplicates.mp4 04:22
  • 80: Q80. What is coalesce function? 01:36
  • 81: Q81. What is OLTP?.mp4 01:24
  • 82: Q82. What is the difference between OLTP and OLAP? 01:21
  • 83: Q83. What are the different types of relationship can exist in RDBMS? 01:02
  • 84: Q84. How do we create a temp table in SQL Server? 00:41
  • 85: Q85. How do we write a case statement in SQL server? .mp4 02:23
  • 86: Q86. How do we delete duplicate rows 01:52

What you will learn?

• Will be able to revise all important SQL concepts like RDBMS, Joins, Indexes, various constraints etc.

• Will learn top SQL interview questions and their answers.

• Will learn SQL programming questions and answers like top nth salary from table and ranks

• Multiple approaches to tackle the same interview question

This course has been intended for programmers and testers who want to master SQL interview questions and answers.

• Basic SQL knowledge will be beneficial

Few possible roles are:

1. SQL Developer

   • Role: Design, implement, and maintain SQL databases; write and optimize SQL queries
   • Salary: £35,000 - £55,000 per year

2. Data Analyst

   • Role: Analyze complex data; create reports and visualizations using SQL
   • Salary: £30,000 - £50,000 per year

Currently there are no Q&As for this course. Be the first to ask a question.