Tutorial Gateway

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. Data Types
  3. Create, Rename, and Delete a 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. 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. 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
  7. Back Up Database

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

  1. Introduction
  2. ABS
  3. ACOS
  4. ASIN
  5. ATAN
  6. ATN2
  7. CEILING
  8. COS
  1. COT
  2. DEGREES
  3. EXP
  4. FLOOR
  5. LOG
  6. LOG10
  7. PI
  8. POWER
  1. RADIANS
  2. RAND
  3. ROUND
  4. SIGN
  5. SIN
  6. SQRT
  7. SQUARE
  8. TAN

String Functions

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

  1. Introduction
  2. ASCII
  3. CHAR
  4. CHARINDEX
  5. CONCAT
  6. DIFFERENCE
  7. FORMAT
  8. LEN
  9. LEFT
  1. LTRIM
  2. LOWER
  3. NCHAR
  4. QUOTENAME
  5. REPLACE
  6. REPLICATE
  7. REVERSE
  8. RIGHT
  9. RTRIM
  1. PATINDEX
  2. SOUNDEX
  3. SPACE
  4. STR
  5. STRING_ESCAPE
  6. STRING_SPLIT
  7. SUBSTRING
  8. UNICODE
  9. UPPER

Aggregate Functions

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

  1. Introduction
  2. AVG
  3. CHECKSUM_AGG
  4. COUNT
  5. COUNT_BIG
  1. GROUPING
  2. GROUPING_ID
  3. MAX
  4. MIN
  5. STDEV
  1. STDEVP
  2. SUM
  3. VAR
  4. VARP

 

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

Thank You for Visiting Our Blog

Comments

Leave a Reply

Follow Us

Follow Us

RECENT POSTS

Trending