MSSQL Server Tutorial For beginners

In this Tutorial You will Learn about Complete About  SQL (Structure Query Language) From basic To Advance. Microsoft Structure Query Language is Relational Database Developed By Microsoft. You can Download Complete PDF.You will Learn These Following Topic In detail 

SQL SERVER – Complete Series

1. Introduction to SQL Server

 

1. SQL Syntax
   1. Database Tables
   2. SQL Statements
   3. Most Important SQL Commands
2. SQL SELECT Statement
   1. SELECT Syntax & Examples
   2. SELECT DISTINCT Syntax & Examples
3. SQL WHERE Clause
   1. WHERE Syntax & Examples
   2. Text Fields vs. Numeric Fields
   3. Operators in The WHERE Clause
4. SQL AND, OR and NOT Operators
   1. AND Syntax & Examples
   2. OR Syntax & Examples
   3. NOT Syntax & Examples
   4. Combining AND, OR and NOT
5. SQL ORDER BY Keyword & Execution Order
   1. ORDER BY Syntax & Examples
6. SQL INSERT INTO Statement
   1. INSERT INTO Syntax & Examples

8. SQL NULL Values
   1. What is a NULL Value?
   2. NULL Syntax & Examples
9. SQL UPDATE Statement
   1. UPDATE Syntax & Examples
10. SQL DELETE Statement
    1. DELETE Syntax & Examples
11. SQL TOP, LIMIT or ROWNUM Clause
    1. SQL TOP, LIMIT and ROWNUM Examples
12. SQL MIN() and MAX() Functions
    1. Syntax & Examples
13. SQL COUNT(), AVG() and SUM() Functions
    1. Syntax & Examples
14. SQL LIKE Operator with Wildcards
    1. Syntax & Examples
15. SQL IN, EXISTS, ANY & ALL Operator
    1. Syntax & Examples
16. SQL Moving AVG & Cumulative Total
    1. Syntax & Examples
17. SQL BETWEEN Operator
    1. Syntax & Examples
18. SQL Aliases
    1. Column, Table Syntax & Examples

19. SQL Joins
    1. Different Types of SQL JOINs
       1. INNER JOIN Syntax & Examples
       2. LEFT JOIN Syntax & Examples

• RIGHT JOIN Syntax & Examples

1. FULL JOIN Syntax & Examples
2. SELF JOIN Syntax & Examples

20. SQL UNION & UNION ALL Operator
    1. Syntax & Examples
21. SQL GROUP BY Clause
    1. Syntax & Examples
22. SQL HAVING Clause
    1. Syntax & Examples
23. SQL SELECT INTO Statement & Linked Server
    1. Syntax & Examples
24. SQL CASE Statement
    1. Syntax & Examples
25. SQL NULLIF(), ISNULL() & COALESCE() Functions
    1. Syntax & Examples
26. SQL Stored Procedures
    1. Syntax & Examples
27. SQL Comments
    1. Single Line Comments
    2. Multi-line Comments

28. DATA TYPES
    1. CHAR, NCHAR, VARCHAR, NVARCHAR, TEXT, NTEXT
    2. BINARY, VARBINARY, IMAGE
    3. BIT
    4. TINYINT, SMALLINT, INT, BIGINT, DECIMAL, NUMERIC, SMALLMONEY, MONEY, FLOAT, REAL
    5. DATETIME, DATETIME2, SMALLDATETIME, DATE, TIME, DATETIMEOFFSET, TIMESTAMP
    6. SQL_VARIANT
    7. UNIQUEIDENTIFIER
    8. XML
    9. CURSOR
    10. TABLE
29. SQL CREATE DATABASE Statement
    1. Syntax & Examples
30. SQL DROP DATABASE Statement
    1. Syntax & Examples
31. SQL BACKUP DATABASE
    1. Syntax & Examples
32. SQL CREATE TABLE Statement
    1. Syntax & Examples
33. SQL DROP & Truncate TABLE Statement
    1. Syntax & Examples
34. SQL ALTER TABLE Statement
    1. Syntax & Examples

35. SQL Constraints
    1. NOT NULL Constraint
       1. Syntax & Examples
    2. UNIQUE Constraint
       1. Syntax & Examples
    3. PRIMARY KEY Constraint
       1. Syntax & Examples
    4. FOREIGN KEY Constraint
       1. Syntax & Examples
    5. CHECK Constraint
       1. Syntax & Examples
    6. DEFAULT Constraint
       1. Syntax & Examples
    7. INDEX Constraint
       1. Syntax & Examples
    8. SQL AUTO INCREMENT Field
       1. Syntax & Examples
    9. SQL Working With Dates
       1. Syntax & Examples
    10. SQL Views
        1. Syntax & Examples

39. SQL Server Functions
    1. String Functions
       1. ASCII()
       2. CHAR() & NCHAR()

• CHARINDEX() & PATINDEX()

1. CONCAT()
2. DATALENGTH()
3. DIFFERENCE() & SOUNDEX()

• FORMAT()
• CAST()

1. CONVERT()
2. LEFT(), RIGHT() & SPACE()
3. LOWER() & UPPER()

• LTRIM() & RTRIM()
• QUOTENAME()
• SUBSTRING(), REPLACE() & STUFF()

1. REPLICATE()

• REVERSE()
• STR()
• UNICODE()

1. Numeric Functions
   1. ABC()
   2. ACOS()

• SIN() & ASIN()

1. TAN() & ATAN()
2. ATN2()
3. AVG()

• CEILING(), FLOOR() & ROUND()
• COUNT()

1. COS()
2. COT()
3. DEGREES(), RADIANS() & PI()

• EXP(), LOG() & LOG10()
• MIN() & MAX()
• POWER()

1. RAND()

• SIGN()
• SQRT()
• SQUARE()
• SUM()

1. ISNUMERIC()
2. Date Functions
   1. CURRENT_TIMESTAMP, GETDATE(), GETUTCDATE() & SYSDATETIME()
   2. DATEADD()

• DATEDIFF()

1. DATEFROMPARTS()
2. DATENAME()
3. DATEPART()

• DAY(), MONTH() & YEAR()
• ISDATE()

1. Advanced Functions
   1. CURRENT_USER
   2. IIF()

• SESSION_USER, SYSTEM_USER & USER_NAME

1. SESSIONPROPERTY
   1. ANSI_NULLS
   2. ANSI_PADDING
   3. ANSI_WARNINGS
   4. ARITHABORT
   5. COCAT_NULL_YIELDS_NULL
   6. NUMERIC_ROUNDABOUT
   7. QUOTED_IDENTIFIER
2. TRY_CAST(), TRY_PARSE() & TRY_CONVERT()