Introduction to SQL Server

Estimated study time: 9 minutes. Everything you need to know before you write your first query.

SQL Server is a relational database management system (RDBMS) developed by Microsoft. It's used to store, retrieve, and manage data for everything from small applications to massive enterprise systems.

What Does SQL Server Do?

At its core, SQL Server organizes data into tables made up of rows and columns, and lets you interact with that data using Transact-SQL (T-SQL), Microsoft's extension of standard SQL.

Core Components

• Database Engine — handles storage, processing, and security of data.
• SQL Server Management Studio (SSMS) — the graphical tool used to write queries and manage databases.
• SQL Server Agent — schedules and automates jobs like backups.
• Reporting & Integration Services — for reports (SSRS) and ETL workflows (SSIS).

Editions of SQL Server

Microsoft offers several editions to suit different needs — Enterprise (full-featured, for production workloads), Standard (mid-tier), Developer (all Enterprise features, free for non-production use), and Express (free, with size and feature limits, ideal for learning).

A Simple Example

CREATE DATABASE SchoolDB;
GO

USE SchoolDB;
CREATE TABLE Students (
    StudentID INT PRIMARY KEY,
    Name VARCHAR(100),
    Grade INT
);

INSERT INTO Students VALUES (1, 'Aditi Sharma', 10);
SELECT * FROM Students;