SQL Server Tutorial

The SQL Server (Structured Query Language) is the set of instructions used to interact with a relational database. SQL statements are aimed to Insert, Update or Manipulate, and Extract data from the Relational Database Management Systems.

SQL Server

1. Installing Software
2. Install Adventure Works Database
3. Data Types
4. Create, Rename, and Delete a Database
5. Create Table
6. ALTER Table
7. SELECT Statement
8. WHERE Clause
9. ALIAS Column
10. ORDER BY Clause
11. TOP Clause
12. SELECT DISTINCT Statement
13. SELECT INTO Statement
14. INSERT INTO SELECT Statement
15. INSERT Statement
16. UPDATE Statement
17. DELETE Statement
18. TRUNCATE TABLE
19. GROUP BY Clause
20. HAVING Clause
21. BULK INSERT Statement
22. Query Builder
23. PIVOT
24. UNPIVOT
25. MERGE
26. SUBQUERY
27. CASE Statement
28. Common Table Expressions (CTE)
29. COALESCE
30. IS NULL
31. IS NOT NULL
32. Local and Global Temporary Tables
33. Table Variable
34. Derived Tables

Constraints

1. Primary Key
2. Check Constraint
3. Default Constraint
4. Unique Constraint

Joins

1. Joins
2. CROSS Join
3. FULL Join
4. INNER Join
5. LEFT Join
6. RIGHT Join
7. SELF Join

Operators

1. AND & OR Operators
2. Arithmetic Operators
3. BETWEEN Operator
4. Comparison Operators
5. EXISTS
6. EXCEPT
7. INTERSECT
8. IN Operator
9. LIKE Operator
10. NOT EXISTS
11. NOT IN Operator
12. UNION
13. UNION ALL

Decision Making Statements

1. If Else Statement
2. Else If Statement
3. While Loop
4. Nested While Loop
5. Break Statement
6. Continue Statement
7. GOTO Statement
8. IIF Function
9. CHOOSE Function

SQL Advanced

1. Change Data Capture
2. TRY CATCH
3. Transactions
4. Nested Transactions
5. VIEWS
6. User Defined Functions
   1. Alter User Defined Functions
7. Stored Procedures
   1. Introduction to Stored Procedures
   2. Select Statement Inside the Stored procedure Example
   3. Insert Statement Inside the Stored Procedure Example
   4. Update Statement within the Stored Procedure Example
8. Triggers
   1. Introduction to Triggers
   2. AFTER INSERT
   3. INSTEAD OF INSERT
   4. AFTER UPDATE
   5. INSTEAD OF UPDATE
   6. AFTER DELETE
   7. INSTEAD OF DELETE
9. Cursors
   1. STATIC CURSOR
   2. DYNAMIC CURSOR
   3. FORWARD_ONLY CURSOR
   4. FAST_FORWARD CURSOR
   5. KEYSET

SQL Server Management Studio

1. Create Login – SQL Server Authentication
2. Create Windows Login
3. Creating Server Roles
4. Back Up Database
5. Maintenance Plan

SQL Server Built-in Functions

Following are the built-in functions available in T-SQL Server 2014

Ranking Functions

The List of available Ranking functions are:

1. Introduction to Ranking Functions
2. RANK
3. DENSE_RANK
4. NTILE
5. ROW_NUMBER

Mathematical Functions

The following are the list of mathematical function in SQL Server

String Functions

The following are the list of available string function in SQL Server:

Aggregate Functions

Below table will show you the list of aggregate function available in SQL Server

Date Functions

1. CURRENT_TIMESTAMP
2. DATEADD
3. DATEPART
4. DATENAME
5. DATEDIFF
6. DAY
7. EOMONTH
8. GETDATE
9. GETUTCDATE
10. MONTH
11. SYSDATETIME
12. SYSDATETIMEOFFSET
13. SYSUTCDATETIME
14. YEAR
15. Standard Date and Time Format Strings

Logical Functions

1. IIF Function
2. CHOOSE Function

Analytic Function

1. FIRST_VALUE
2. LAST_VALUE
3. LAG
4. LEAD
5. PERCENT_RANK

Conversion Function

1. Cast
2. Try_Cast
3. Convert
4. Try_Convert
5. Parse
6. Try_Parse

System Functions

1. @@IDENTITY
2. ISNULL
3. ISNUMERIC
4. ERROR_LINE
5. ERROR_NUMBER
6. ERROR_MESSAGE
7. ERROR_SEVERITY
8. ERROR_STATE

SET Statements

1. NOCOUNT ON
2. ROWCOUNT

XML Functions

1. FOR XML RAW
2. FOR XML AUTO
3. XML PATH

SQL Interview Questions

1. Create ODBC Connection
2. Create ODBC Connection- Using Native Client
3. Calculating Running Total
4. Connecting to R programming
5. Configure Database Mail
6. Create Native Client 11.0 Connection
7. Cross Join Vs Inner Join
8. Concatenate Rows into String
9. Converting Rows into Columns without using PIVOT
10. Converting Column Names into Rows without using UNPIVOT
11. Count Records in a Group
12. Difference between DATEPART and DATENAME
13. Difference between UNION and UNION ALL
14. Differentiate among CTE, Temp Tables, Derived tables, Table Variables
15. Delete Duplicate Rows
16. Export Data to CSV
17. Extract Domain From Email
18. Formatting DATE
19. Get Column Names from Table
20. How to Swap Column Values
21. How to check if a Table exists
22. Nth Highest Salary
23. Inserting values into Identity Column using IDENTITY INSERT
24. Insert Stored Procedure result into Temporary Table
25. Insert Images into Table
26. Replace String in a Table Column
27. Reverse String Words
28. Rename Table Name, and Column Name
29. Return Date Part Only from a Datetime datatype
30. Select First Row in each group
31. UPDATE Table Columns from SELECT Statement
32. Backup Database Automatically
33. Find all Dependencies on Table
34. Find all Tables that Contain Specific Column Name

Thank You for Visiting Our Blog