Sign in to save your place.
What is a database? What is Microsoft SQL Server? Why do companies use it? Let's break it down from zero!
A database is an organized place where we store data so we can add, change, and look it up later. Instead of millions of text files or spreadsheets, we use a database management system (DBMS) to keep everything in tables and views.
Imagine a huge filing cabinet. Each drawer has folders (tables), and each folder has rows of information (like one row per customer or one row per order). When you want to find something, you don't flip every page—you ask the cabinet in a special language: "Give me all customers from New York." That's what a database does!
Organizations store data in tables (rows and columns) and often use views (saved queries that look like tables). Microsoft SQL Server is one of the most popular DBMSs in the world.
Microsoft SQL Server is a database management system by Microsoft. Companies use it to store data in tables and views, manage it with the SQL language, and run enterprise applications with high availability and security.
SQL Server = The kitchen (the engine that stores and serves data).
Tables = Shelves and fridges (where ingredients/data live).
SQL (T-SQL) = The recipe language you use to ask for food: "Give me all tomatoes" (SELECT) or "Add a new tomato" (INSERT).
SSMS = The control panel where the chef (you) runs those recipes and sees results.
SQL Server supports many of the ANSI/ISO SQL standards, so what you learn here is portable. It runs on Windows and Linux, and scales from a single laptop to huge clusters and the cloud (Azure).
Microsoft offers different editions. For learning and development, you only need to know two:
Free, full-featured like Enterprise, but licensed only for development and test—not production. Perfect for learning and building projects.
Free, smaller version with limits on database size and features. Great for lightweight learning and small apps.
Other editions (Standard, Enterprise) are for production and have licensing costs. For this course, Developer or Express is enough.
SQL is used to manage databases through three types of commands:
| Type | Full Name | What It Does | Example Commands |
|---|---|---|---|
| DDL | Data Definition Language | Creates and changes the structure (tables, columns, indexes) | CREATE, ALTER, DROP |
| DML | Data Manipulation Language | Adds, changes, and reads data | SELECT, INSERT, UPDATE, DELETE |
| TCL | Transaction Control Language | Controls transactions (save or undo a set of changes) | BEGIN, COMMIT, ROLLBACK |
DDL = shape of the database. DML = the data inside. TCL = making sure multiple changes succeed or fail together. You'll use DML (especially SELECT) every day; DDL when you design or change tables; TCL when you need safe multi-step updates.
Companies use SQL Server for:
SQL Server powers core systems at banks, hospitals, retailers, and tech companies. Stack Overflow, for example, uses SQL Server to serve millions of developers with sub-second search and high uptime. Learning SQL Server opens doors to jobs in data, backend development, and database administration.
From you to the data and back:
You type a command → SQL Server runs it → You see rows (or a message)
Data lives in tables; SQL Server reads/writes them and returns results to you.
CREATE TABLE, ALTER TABLE, DROP TABLE. Changes the "shape" of the database (columns, keys), not the data inside.
SELECT, INSERT, UPDATE, DELETE. Reads and changes the actual rows in tables. This is what you'll use most.
BEGIN, COMMIT, ROLLBACK. Groups several changes into one unit: either all succeed or all are undone.
You don't run these in Module 1—they're just a preview of what DDL, DML, and TCL look like.
-- DDL: create a table (structure) CREATE TABLE Customers ( CustomerID INT PRIMARY KEY, CustomerName VARCHAR(100), City VARCHAR(50) ); -- DML: add and read data INSERT INTO Customers VALUES (1, 'Alice', 'New York'); SELECT * FROM Customers; -- TCL: wrap changes in a transaction BEGIN TRANSACTION; UPDATE Customers SET City = 'Boston' WHERE CustomerID = 1; COMMIT;
In later modules you'll create real tables, run SELECT queries, and use transactions. For now, just notice: DDL defines structure, DML touches data, TCL controls commits.
In one sentence, what is the main job of DML? (Answer: to read and change the data inside tables—SELECT, INSERT, UPDATE, DELETE.)
Which edition of SQL Server is free and full-featured for learning? (Answer: Developer Edition.)
If you want to "undo" a set of changes so nothing is saved, which TCL command do you use? (Answer: ROLLBACK.)
When you're ready, move to Module 2: Installation & SSMS to install SQL Server and run your first query in SSMS!
Correct! DDL defines structure (CREATE, ALTER, DROP).
Not quite. DDL = Data Definition Language—it defines the structure of the database.
Correct! Developer Edition is free and has the same features as Enterprise for dev/test.
Developer Edition is the free, full-featured one for development. Express is free but limited.
Correct! SELECT, INSERT, UPDATE, DELETE are Data Manipulation Language.
They are DML—Data Manipulation Language—used to read and change data.
Correct! Data is stored in tables; views are saved queries that look like tables.
SQL Server stores data in tables (and uses views as saved queries over that data).
Checked against Microsoft's lifecycle pages on 13 October 2026. SQL Server 2025 became supported on 18 November 2025 (mainstream through 7 January 2031). SQL Server 2022 is in mainstream support through 12 January 2028. SQL Server 2019 is in extended support through 9 January 2030. SQL Server 2017 is in extended support through 13 October 2027. SQL Server 2016 extended support ended on 15 July 2026. Paid Extended Security Updates are not a reason to start a new lab there.
Microsoft Fabric is a different analytics product. This course teaches SQL Server, T-SQL, and SSMS, and it says how Azure SQL differs. It does not teach Fabric, and finishing a lesson does not mean you have Fabric tools or should claim them.
SELECT @@VERSION;Try this. Write the major version of the instance you can actually open. If you cannot open one, say which supported major you would install, and why it is not SQL Server 2016.
Is Microsoft Fabric the SQL Server installer?