Introduction to Databases — Complete Guide

Introduction to Databases — Complete Guide: free step-by-step lesson with examples, common mistakes, and interview tips — part of SQL Server Tutorial on Toolliyo Academy.

8 min read Updated 8/21/2026

On this page

SQL Server Tutorial · Lesson 1 of 100

Introduction to Databases

SQL basics → Queries → Advanced

SQL basics · 1 — SELECT · ~6 min · SQL — Foundations

What is this?

A database is organized storage for app data — customers, orders, balances — so many users can read and write safely at once. Files and spreadsheets fall apart when traffic and rules grow.

Why should you care?

Flipkart cannot keep stock and prices in Excel. One shared database keeps catalog, cart, and payments consistent across millions of shoppers.

See it live — copy this example

Run in SQL Server Management Studio (SSMS) or Azure Data Studio.

-- Concept check: list databases on this SQL Server
SELECT name, database_id, create_date
FROM sys.databases
ORDER BY name;

What happened?

sys.databases is a system catalog view.
Each row is one database on the instance.
You see names and when they were created — the starting map of what lives on the server.

Practice next

Open SSMS and connect to your local SQL Server.
Open a New Query window and paste the example.
Press F5 and note which databases appear (master, tempdb, yours).
Filter: WHERE name LIKE N'%Data%'.
Select only name and state_desc from sys.databases.

Remember

Databases hold structured app data for concurrent access. SQL Server hosts many databases on one instance. sys.databases shows what exists on your server.