Chapter 1 – Introduction of MS SQL Server | Create SQL Database | Restore database in Hindi

MS SQL Server is a relational database management system (RDBMS) developed by Microsoft. It is used for store and retrieve data. Microsoft SQL Server is a highly scalable product that can be run on anything from a single laptop, to a network of high-powered cloud servers, and anything in between.

Features of MS SQL Server MS SQL Server can be run on a single laptop or a network of cloud servers. MS SQL Server is both a GUI and command based software. MS SQL Server supports SQL (SEQUEL) (Structured Query Language) language which is an IBM product, non-procedural, common database and case insensitive language. What is SQL? SQL is Structured Query Language, which is a computer language for storing, manipulating and retrieving data stored in a relational database.

Usage of SQL (Structured Query Language) Server

– To create new databases.

– Can Create new table into database.

– Can Insert data into database.

– Can update data into database.

– Can delete data in database.

– To analyze the data through SQL Server Analysis Services (SSAS).

– To generate reports through SSRS (SQL Server Reporting Services).