Introduction SQL Server

What is Data?

Data is nothing but meaningful information.

What is Database  (DBMS)?

Collection of Data that is called Database.

ex. .txt, .doc, .xls

Limitation of DBMS

1. We store less amount of data 

2. There is no relation in between data

What is RDBMS?

• RDBMS is nothing but a collection of tables and table related information.

• By using RDBMS we can store a huge number of data as well as extract data.

What is table?
- Collection of row and column called table

What is SQL server?

SQL - Structured Query language

SQL server is relational database system. 

By using it we can create a database and maintain database.

SQL Server Editions

• Enterprise 

• Standard

• Developer

• Express

SQL Server Component

• Workstation

     -  By using a workstation we can connect to the server. Eg. SSMS (SQL server management studio)

• Server 

   -  Server is nothing but a providing response to every request send to it.

Eg. SQL server 

• What is SQL server?

       - SQL server  is relational database management system.

       - Also It is a backend Application.

Types of Application:
  1. Front End Application

• Means users directly interact with it. 

Example: Jave,.net are front end lang

  2. Backend Application

• It means the user does not directly interact with it. because of security. Application data is sensitive data 

• Purpose of the backend application is to store data.

• example Oracle,MS SQL,MySQL

SQL server is Platform dependent and Independent?

Platform is nothing but combination of OS(Operating System) and processor(intel,AMD,Apple m1 chip)

They both(os,process) create an environment for us to perform tasks.

Types of Platform:

1. Platform Independent (Any OS, Any Processor) 

Good example of is Oracle

2. Platform Dependent (One OS,Any Processor) 

Good example is SQL Server Why because it required Window OS is compulsory

 How to install SQL server on linux/Mac OS?

Directly we do not install my sql on the above OS because it only supported Windows OS. So to install it we need to take some help from other applications.