SQL Server Database Tutorial

What is SQL Server?

-> It is a software, developed by Microsoft, which is implemented from the specification of RDBMS.

-> It is also an ORDBMS.

-> It is platform dependent.

-> It is both GUI and command based software.

-> It supports SQL (SEQUEL) language which is an IBM product, non-procedural, common database and case insensitive language.

Usage of SQL Server:

-> To create databases.

-> To maintain databases.

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

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

-> To carry out ETL operations through SQL Server Integration Services (SSIS).

SQL Server Components:

SQL Server works in client-server architecture, hence it supports two types of components: (a) Workstation and (b) Server.

-> Workstation components are installed in every device/SQL Server operator’s machine. These are just interfaces to interact with Server components. Example: SSMS, SSCM, Profiler, BIDS, SQLEM etc.

-> Server components are installed in centralized server. These are services. Example: SQL Server, SQL Server Agent, SSIS, SSAS, SSRS, SQL browser, SQL Server full text search etc.