Grokking the SQL Interview : Master SQL, Excel in Interviews, Elevate Your Career

Table of Content
Overview
	Why Prepare for SQL and Database for Interviews?
	How to prepare SQL for Interviews?
	Which SQL and Database topics to Prepare for Interviews?
CHAPTER 1:
SQL and Database Telephonic Interview Questions
	Question 1
		1. UNION:
		2. UNION ALL:
			Example:
			1. employees table:
			2. contractors table:
			1. Using UNION:
			Result:
			2. Using UNION ALL:
			Result:
	Question 2
		1. WHERE Clause:
		2. HAVING Clause:
			Example:
		1. Using WHERE clause:
			Result:
		2. Using HAVING clause:
			Result:
	Question 3
		1. Clustered Index:
			Example:
		2. Non-Clustered Index:
			Example:
	Question 4
	Question 5
	Question 6
		1. Non-Correlated Subquery:
		2. Correlated Subquery:
	Question 7
	Question 8
		1. PRIMARY Key Constraint:
			Example:
		2. UNIQUE Key Constraint:
			Example:
	Question 9
		1. View:
		2. Materialized View:
	Question 10
		1. TRUNCATE:
		2. DELETE:
		3. DROP:
	Question 11
		1. Primary Key - Foreign Key Relationship:
		2. Maintaining Data Integrity:
		3. Enforcing Constraints:
		4. Cascading Actions:
	Question 12
		Normalization Process:
			Step 1: First Normal Form (1NF)
			Step 2: Second Normal Form (2NF)
			Step 3: Third Normal Form (3NF)
			Step 4: Boyce-Codd Normal Form (BCNF)
			Step 5: Fourth Normal Form (4NF)
			Step 6: Fifth Normal Form (5NF)
	Question 13
		1. First Normal Form (1NF):
		2. Second Normal Form (2NF):
		3. Third Normal Form (3NF):
	Question 14
		1. ISNULL() Function:
		2. COALESCE() Function:
	Question 15
	Question 16
		1. CHAR Data Type:
			Example of CHAR:
		2. VARCHAR Data Type:
			Example of VARCHAR:
	Question 17
	Question 18
	Question 19
	Question 20
		Example:
		Example:
	Question 21
	Question 22
		Explanation:
	Question 23
		1. COUNT(*):
			Example:
		2. COUNT(1):
			Example:
		3. COUNT(column_name):
			Example:
	Question 24
		Pro tip
	Question 25
	Question 26
	Question 27
	Question 28
		1. Index Seek:
		2. Index Scan:
		3. Table Scan:
	Question 29
		For example:
	Question 30
	Question 31
		1. Local Temporary Table:
		2. Global Temporary Table:
	Question 32
	Question 33
	Question 34
	Question 35
		1. Using the RETURN Statement:
		2. Using OUTPUT Parameters:
	Question 36
	Question 37
	Question 38
	Question 39
	Question 40
	Question 41
		1. Local Temporary Table:
		2. Global Temporary Table:
	Question 42
		1. Using SELECT INTO Statement:
		2. Using INSERT INTO Statement:
	Question 43
	Question 44
	Question 45
	Question 46
	Question 47
	Question 48
	Question 49
	Question 50
		1. READ UNCOMMITTED:
		2. READ COMMITTED:
		3. REPEATABLE READ:
		4. SERIALIZABLE:
		5. SNAPSHOT:
		6. READ COMMITTED SNAPSHOT:
	Question 51
	Question 52
	Question 53
	Question 54
	Question 55
		Key Differences:
CHAPTER 2
SQL JOIN
	Question 1
	Question 2
		For example:
	Question 3
		For example:
	Question 4
		For example:
	Question 5
	Question 6
		For example:
	Question 7
	Question 8
		For example:
	Question 9
	Question 10
	Question 11
	Question 12
		For example:
	Question 13
	Question 14
		For example:
	Question 15
		For example:
	Question 16
	Question 17
		For example:
	Question 18
	Question 19
		For example:
	Question 20
	Question 21
	Question 22
		For example:
	Question 23
	Question 24
		For example:
	Question 25
		For example:
	Question 26
	Question 27
	Question 28
		For example:
	Question 29
		For example:
	Question 30
		For example:
CHAPTER 3
SQL QUERIES
	SQL Script to create a table and Populate data
	SQL scripts to create tables
	Question 1
	Question 2
	Question 3
	Question 4
	Question 5
	Question 6
	Question 7
	Question 8
	Question 9
	Question 10
	Question 11
	Question 12
CHAPTER 4
Indexes
	Question 1
	Question 2
	Question 3
	Question 4
	Question 5
	Question 6
	Question 7
	Question 8
	Question 9
	Question 10
	Question 11
	Question 12
CHAPTER 5
GROUP BY
	1. Group By clause Example 1 - Finding duplicate
	2. Group By clause Example 2 - Calculating Sum
	3. How to calculate average using group by clause
	4. Group By example 4 - Counting records
	5. How to use Group By clause with more than one column
	Important points about Group By clause in SQL
CHAPTER 6
SQL Date and Time Interview Questions
	Key Topics and Concepts to Prepare:
	Question 1
	Question 2
		For example:
	Question 3
		For example:
	Question 4
		For example:
	Question 5
	Question 6.
	Question 7
	Question 8
		For example:
	Question 9
		For example:
	Question 10
		For example:
	Question 11
		For example:
	Question 12
		For example:
	Question 13
	Question 14
	Question 15
		For example:
	Question 16
	Question 17
	Question 18
	Question 19
	Question 20
CHAPTER 7
Aggregate Functions
	Question 1
	Question 2
	Question 3
	Question 4
	Question 5
	Question 6
	Question 7
	Question 8
	Question 9
	Question 10
	Question 11
	Question 12
	Question 13
	Question 14
	Question 15
	Question 16
	Question 17
	Question 18
	Question 19
	Question 20
CHAPTER 8
Stored Procedure
	Question 1
	Question 2
	Question 3
	Question 4
	Question 5
	Question 6
	Question 7
	Question 8
	Question 9
	Question 10
	Question 11
	Question 12
	Question 13
	Question 14
	Question 15
	Question 16
	Question 17
	Question 18
	Question 19
	Question 20
CHAPTER 9
Triggers and Views
	Question 1
	Question 2
	Question 3
	Question 4
	Question 5
	Question 6
	Question 7
	Question 8
	Question 9
	Question 10
	Question 11
	Question 12
	Question 13
	Question 14
	Question 15
	Question 16
	Question 17
	Question 18
	Question 19
	Question 20
CHAPTER 10
Normalization
	Question 1
	Question 2
	Question 3
	Question 4
	Question 5
	Question 6
	Question 7
	Question 8
	Question 9
	Question 10
	Question 11
	Question 12
	Question 13
	Question 14
	Question 15
	Question 16
		For example:
	Question 17
	Question 18
	Question 19
	Question 20
Chapter 11
Transaction
	Question 1
	Question 2
	Question 3
	Question 4
	Question 5
	Question 6
	Question 7
	Question 8
	Question 9
	Question 10
	Question 11
	Question 12
CHAPTER 12
Window Function and CTE
	Question 1
	Question 2
		For example:
	Question 3
	Question 4
	Question 5
		For example:
	Question 6
	Question 7
		For example:
	Question 8
	Question 9
		For example:
	Question 10
	Question 11
	Question 12
	Question 13
	Question 14
		For example:
	Question 15
	Question 16
	Question 17
		For example:
	Question 18
	Question 19
	Question 20
	Question 21
	Question 22
	Question 23
	Question 24
	Question 25
		For example:
	Question 26
	Question 27
		For example:
	Question 28
		For example:
	Question 29
	Question 30
	Question 31
	Question 32
	Question 33
		For example:
	Question 34
	Question 35
		For example:
	Question 36
	Question 37
	Question 38
		For example:
	Question 39
		For example:
	Question 40
		For example:
CHAPTER 13
Deep Dive
	Difference between ROW_NUMBER(), RANK(), and DENSE_RANK()
		SQL to build schema
		ROW_NUMBER() Example
		RANK() Example
		DENSE_RANK() Example
	Difference between row_number vs rank vs dense_rank
	Difference between VARCHAR and NVARCHAR in SQL Server?
	What is difference between SQL, T-SQL and PL/SQL?
		Why do you need T-SQL or PL/SQL?
	Differences between SQL, T-SQL and PL/ SQL
		1. Full form
		2. Supported Database
		3. Performance
		4. SQL Query Requirement
		5. Data Types and Keyword
	How to check for Null in SQL Query?
		The right way to compare values in a column that allows NULL
		How to test for not null values in SQL? IS NOT NULL Example
	Difference between CAST, CONVERT, and PARSE function in Microsoft SQL Server?
		CAST vs CONVERT vs PARSE Exam in SQL Server
			1. ANSI SQL Standard
			2. .NET and CLR Dependency
			3. Optional USING Clause
			4. Syntax
			5. Examples
		CAST Function Example
		CONVERT Function Example
		PARSE Function Example
	Difference between UNION vs UNION ALL in SQL
		UNION and UNION ALL Example in Microsoft SQL Server
	Difference between UNION and UNION ALL command in SQL
		1. Combining Results
		2. Duplicates
		3. Execution time
		4. Speed and Bandwith Usage
		5. Number of Columsn on ResultSet
	Difference between table scan, index scan, and index seek in SQL Server Database
	Difference between table scan, index scan, and index seek in Database
		1. What is a Table Scan in a database?
		2. What is the Index Scan in a database?
		3. What is Index Seek in SQL?
	Difference between table scan, index scan, and index seek in SQL
	Difference between ISNULL() and COALESCE() function in SQL?
	Difference between ISNULL() vs COALESCE() in SQL Server
		1.  COALESCE promotes its argument to the higher data type.
		2. COALESCE allows multiple values but ISNULL allows only one value
		3. Length of Result
		4. The behavior of COALESCE and ISNULL when used in SELECT INTO
	How to Find Nth Highest Salary in MySQL and SQL Server? Example LeetCode Solution
		Nth Highest Salary in MySQL and SQL Server - LeetCode Solution
		1. Accepted Solution
		2. Alternate Solution
		3. How to create own Employee table for testing?
		4. SQL query to find the Nth highest salary
	Difference between VARCHAR and CHAR data type in SQL Server?
	Similarities between CHAR vs. VARCHAR in SQL
		CHAR vs. VARCHAR in SQL Server
			1. Fixed vs Variable storage
			2.Usage
			3. Storage
			4. Space Overhead
			5. Padding
			6. Null
			7. Reservation
			8. Index
	Difference between WHERE and HAVING clause in SQL? Example
	Difference between WHERE vs. HAVING in SQL
		When to use WHERE and HAVING clauses?
	Difference between Primary key vs Candidate Key in SQL Database?
	Difference between Correlated and Non-Correlated Subquery in SQL
	Difference between Correlated and Regular Subquery in SQL
		1. Working
		2. Dependency
		3.Speed and Performance
	Difference between Self and Equi Join in SQL
	How to remove duplicates from a table?
		3 Ways to Remove duplicate values from a table using SQL Query
			1. How to remove duplicate in SQL using temp table  - Example
			2. Delete Duplicates using row_number() and derived table - Example
			3. How to remove duplicates using CTE (Common Table Expression)
	How to Find Customers Who Never Order using EXISTS in SQL
	How to find Duplicate emails in a table?
		1. Finding Duplicate elements By using GROUP BY
		2. Finding Duplicate values in a column by using Self Join
		3. Finding duplicate emails By using Sub-query with EXISTS:
CHAPTER 14
Conclusion