INTRODUCTION

Server:

Server is physical computer dedicated to running one or more services to serve the needs of the other computer users on the network.

SQL Server:

As a database, it is a software product whose primary function is to store and retrieve data as requested by other software applications, be it those on the same computer or those running on another computer across a network.

Database:

A database is a collection of information that is organized so that it can easily be accessed, managed, and updated.

Database objects:

            You can create new data objects such as database, schema, table, column, primary key, and foreign key directly in the Data Definition view.

Table:

            A table is a container that holds the information.

Database normalization:

Normalization usually involves dividing large tables into smaller (and less redundant) tables and defining relationships between them.

DML, DDL, DCL and TCL Commands:

1.      DDL (Data Definition Language):-

2.      DML (Data Manipulation Language):-

3.      DCL (Data Control Language):-

4.      TCL (Transactional Control Language):-