Free Programming Books MSSQL

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
  1. SQL NULL Values
    1. What is a NULL Value?
    2. NULL Syntax & Examples
  2. SQL UPDATE Statement
    1. UPDATE Syntax & Examples
  3. SQL DELETE Statement
    1. DELETE Syntax & Examples
  4. SQL TOP, LIMIT or ROWNUM Clause
    1. SQL TOP, LIMIT and ROWNUM Examples
  5. SQL MIN() and MAX() Functions
    1. Syntax & Examples
  6. SQL COUNT(), AVG() and SUM() Functions
    1. Syntax & Examples
  7. SQL LIKE Operator with Wildcards
    1. Syntax & Examples
  8. SQL IN, EXISTS, ANY & ALL Operator
    1. Syntax & Examples
  9. SQL Moving AVG & Cumulative Total
    1. Syntax & Examples
  10. SQL BETWEEN Operator
    1. Syntax & Examples
  11. SQL Aliases
    1. Column, Table Syntax & Examples
  1. 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

  1. SQL UNION & UNION ALL Operator
    1. Syntax & Examples
  2. SQL GROUP BY Clause
    1. Syntax & Examples
  3. SQL HAVING Clause
    1. Syntax & Examples
  4. SQL SELECT INTO Statement & Linked Server
    1. Syntax & Examples
  5. SQL CASE Statement
    1. Syntax & Examples
  6. SQL NULLIF(), ISNULL() & COALESCE() Functions
    1. Syntax & Examples
  7. SQL Stored Procedures
    1. Syntax & Examples
  8. SQL Comments
    1. Single Line Comments
    2. Multi-line Comments
  1. 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
  2. SQL CREATE DATABASE Statement
    1. Syntax & Examples
  3. SQL DROP DATABASE Statement
    1. Syntax & Examples
  4. SQL BACKUP DATABASE
    1. Syntax & Examples
  5. SQL CREATE TABLE Statement
    1. Syntax & Examples
  6. SQL DROP & Truncate TABLE Statement
    1. Syntax & Examples
  7. SQL ALTER TABLE Statement
    1. Syntax & Examples
  1. 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
  1. 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()






Leave a Comment