Chapter # 11 || Function || SQL Server Interview Question Bank (2020)

Published: 26 April 2020
on channel: SQL Mastermind Circle

SQL Server Interview Question Bank|| Best for fundamental knowledge and interview preparation (2020)

Video-book means Complete Book in form of video
--------------------------------------------
Chapter 1: TSQL Selection
--------------------------------------------
1.1 Record Selection
1.2 Record Alias
1.3 Record Ordering
1.4 Select Top N/ Top N percent record
1.5 Record Distinct

------------------------------------
Chapter 2: TSQL Filter
------------------------------------
2.1 Record filter on Numeric column
2.2 Record filter on Date column
2.3 Record filter on String column
2.4 GROW YOURSELF MIX PROBLEMS

---------------------------------------------------
Chapter 3. TSQL Multiple Filter
---------------------------------------------------
3.1 Record filter using AND operator
3.2 Record filter using OR operator
3.3 Record filter using NOT operator
3.4 GROW YOURSELF MIX PROBLEMS

------------------------------------------
Chapter 4. TSQL Grouping
------------------------------------------
4.1 Get Count, Count Distinct, Min, Max, Sum and Average of a table
4.2 Group Records and then Get Count, Min, Max, Sum and Average of a Table
4.3 Group Records and then Get Count, Min, Max, Sum and Average of a Table and finally filter the grouped data
4.4 GROW YOURSELF MIX PROBLEMS

-----------------------------------------
Chapter 5. TSQL Joining
-----------------------------------------
5.1 Two Tables record join
5.2 Keyword Exists and Not Exists
5.3 Keyword ANY / ALL
5.4 GROW YOURSELF MIX PROBLEMS

---------------------------------------------------------
Chapter 6. TSQL Various Operation
---------------------------------------------------------
6.1 Working with Date
6.2 String Operation
6.3 Keyword ISNULL
6.4 Keyword CASE
6.5 Keyword IIF
6.6 Converting column value to other Data Type
6.7 Sequencing on Table records
6.8 GROW YOURSELF MIX PROBLEMS

----------------------------------------------------------------
Chapter 7. Working with two result sets
----------------------------------------------------------------
7.1 Keyword INTERSECT
7.2 Keyword EXCEPT
7.3 Keyword UNION ALL
7.4 Keyword UNION
7.5 GROW YOURSELF MIX PROBLEMS

---------------------------------------------
Chapter 8. DDL Operations
---------------------------------------------
8.1 Working on Database
8.2 Working on Table
8.3 Working on Various Keys
8.4 Working on Index

---------------------------------------------
Chapter 9. DML Operations
---------------------------------------------
9.1 Record Insertion
9.2 Record Insertion using Select INTO
9.3 Record Update
9.4 Record Delete
9.5 Truncate Table

------------------------------------------------
Chapter 10. Stored Procedure
------------------------------------------------
10.1 Working with variable
10.2 Create Stored Procedure
10.3 Alter Stored Procedure
10.4 Working with Temporary Table/ Table Variable
10.5 Working with If Else statement
10.6 Working with Loop
10.7 Exception Handling
10.8 Transaction Management

-----------------------------------
Chapter 11. Function
-----------------------------------
11.1 Declare and call Scalar Value Function
11.2 Declare and call Inline Table Valued Function
11.3 Declare and call Multi-Statement Table Valued Function

----------------------------------
Chapter 12. Trigger
----------------------------------
12.1 After Trigger: INSERT
12.2 After Trigger: UPDATE
12.3 After Trigger: DELETE
12.4 After Trigger: MAGIC TABLES
12.5 Instead Of Trigger: INSERT
12.6 Instead Of Trigger: UPDATE
12.7 Instead Of Trigger: DELETE
12.8 DDL Trigger

------------------------------
Chapter 13. View
------------------------------
13.1 Create View
13.2 Alter View

----------------------------------------------------------------------------
Chapter 14. Troubleshooting and Performance
----------------------------------------------------------------------------

Music: www.bensound.com

On this page of the site you can watch the video online Chapter # 11 || Function || SQL Server Interview Question Bank (2020) with a duration of hours minute second in good quality, which was uploaded by the user SQL Mastermind Circle 26 April 2020, share the link with friends and acquaintances, this video has already been watched 11 times on youtube and it was liked by 1 viewers. Enjoy your viewing!

4,559