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 2014

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

Constraints

1. Primary Key
2. Default Constraint
3. 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. TRY CATCH
2. VIEWS
3. User Defined Functions
   1. Alter User Defined Functions
4. 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
5. 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
6. Cursors
   1. STATIC CURSOR
   2. DYNAMIC CURSOR
   3. FORWARD_ONLY CURSOR
   4. FAST_FORWARD CURSOR
   5. KEYSET

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. PARSE
3. TRY_PARSE

System Functions

1. @@IDENTITY
2. ISNULL
3. ISNUMERIC
4. ERROR_LINE
5. ERROR_NUMBER
6. ERROR_MESSAGE

SET Statements

1. NOCOUNT ON
2. ROWCOUNT

SQL Interview Questions

1. Calculating Running Total
2. Connecting to R programming
3. Create Native Client 11.0 Connection
4. Cross Join Vs Inner Join
5. Concatenate Rows into String
6. Converting Rows into Columns without using PIVOT
7. Converting Column Names into Rows without using UNPIVOT
8. Count Records in a Group
9. Difference between DATEPART and DATENAME
10. Difference between UNION and UNION ALL
11. Delete Duplicate Rows
12. Extract Domain From Email
13. Formatting DATE
14. Get Column Names from Table
15. How to check if a Table exists
16. Inserting values into Identity Column using IDENTITY INSERT
17. Insert Stored Procedure result into Temporary Table
18. Replace String in a Table Column
19. Reverse String Words
20. Return Date Part Only from a Datetime datatype
21. Select First Row in each group
22. UPDATE Table Columns from SELECT Statement

Thank You for Visiting Our Blog