MS SQL Server Classroom Training and Certification Classes

MS SQL Server is a relational database management system developed by Microsoft Corporation. Its primary function is to store and retrieve data as requested by other software applications, on the same computer or other computers across the network

A relational database is basically composed of tables that contain related data. Normalization is the process of organizing this data into tables.

SQL Server runs on port 1433 but we can also change it for better security.

There are basically two types of indexes that we use with the SQL Server - Clustered and the Non-Clustered.

DBCC means Database Consistency Checker. These commands are used to check the consistency of the databases, i.e., maintenance, validation task and status checks.

Join actually puts data from two or more tables into a single result set.

Inner Join, Outer Join and Cross Join

•  MS SQL SERVER SERVICE
• SQL AGENT SERVICE
• DTC (Distribution transac co-ordinator)

•  SQL SERVER is for running the databases
• SQL AGENT is for automation such as Jobs and DB Maintenance
• Backups DTC is for linking and connecting to other SQL Servers