SQL Server Tutorial

SQL Server Home

• SQL Server - Overview
• SQL Server - Setup and installation
• SQL Server - Create Database
• SQL Server - Select Database
• SQL Server - Drop Database
• SQL Server - Create Table
• SQL Server - Select Table
• SQL Server - Alter Table
• SQL Server - Drop Table
• SQL Server - Local Temp Tables
• SQL Server - Globle Temp Tables

SQL Server Scalar functions

• SQL Server - UPPER()
• SQL Server - LOWER()
• SQL Server - SUBSTRING()
• SQL Server - LEN()
• SQL Server - ROUND()
• SQL Server - FORMAT()

SQL Server Aggregate Functions

• COUNT Function
• SUM Function
• MIN Function
• MAX Function
• AVG Function

SQL Server - Clauses

• DISTINCT Clause
• FROM Clause
• WHERE Clause
• ORDER BY Clause
• GROUP BY Clause
• HAVING Clause

SQL Server Conditions

• AND Condition
• OR Condition
• AND and OR
• LIKE Condition
• IN Condition
• NOT Condition
• IS NULL Condition
• IS NOT NULL Condition
• BETWEEN Condition
• EXISTS Condition

SQL Server -prgramming/object

• SQL Server - Functions
• SQL Server - Strored Procedures
• SQL Server - Cursor
• SQL Server - Trigger
• SQL Server - Index
• SQL Server - Joins
• SQL Server - View
• SQL Server - Injectoin
• SQL Server - Error Handaling

SQL Server - CLR

• SQL CLR - Introduction and Setup
• SQL CLR - Stored Procedures
• SQL CLR - User defined aggregates
• SQL CLR - Triggers
• SQL CLR - User defined types

SQL Server- Others

• SQL Server - Data Types
• SQL Server Reserved Keywords