Define MSSQL

SQL Data Types

SQL Commands

SQL Create Database

SQL Create Table

SQL Insert Into

SQL Select Query

SQL Orderby

SQL Update Command

Truncate Delete Drop

SQL Select Top

SQL Constraints

SQL Alias

SQL Joins

SQL Union, intersect

SQL Select Into

SQL Insert Into Select

SQL Indexes

SQL Alter Table

SQL AutoIncrement

SQL View

SQL Date Functions


SQL Aggregate Functions

SQL Group By

SQL Scalar functions

Stored Procedure

Define MS-SQL

SQL ("Sequel") stands for Structured Query Language. SQL is used to communicate with a database. SQL statements are used to perform tasks such as insert, update, or retrieve data from a database. Some common relational database management systems that use SQL are: Oracle, Sybase, MSSQL Server, MySQL, Access, etc.

To Store information we need to Create:
Database - A database is a data structure that stores information in an organized manner. Databases contain multiple tables.
Table - A Table organizes the information into rows and columns. It is a collection of related records.
Record - A record is a collection of related data items or fields.
Field/Data item - A data item is the smallest data element. Each data item has a value and is referenced by a data item name

Note: SQL is NOT a case sensitive language.