SQL Basics Tutorial for Students

SQL Basics Tutorial: A Complete Beginner's Guide (2026)

SQL is one of the most valuable technical skills you can learn in 2026. Every company — from hospitals and banks to e-commerce platforms and startups — stores its data in relational databases. SQL is the language that lets you access, filter, and analyse that data in seconds.

If you're completely new to analytics, it's helpful to first understand What is Data Analytics? Beginner Guide before learning SQL. It explains how SQL fits into the overall analytics workflow and why it is one of the most important skills for aspiring analysts.It explains how SQL fits into the overall data analytics workflow and why it is one of the most important skills for aspiring analysts.

This guide is designed for complete beginners — no prior coding experience needed. By the end, you will understand how databases work, how to write your first SQL queries, and how to use advanced features like JOINs and aggregate functions that real analysts use every day.

What is SQL and Why Should You Learn It?

SQL stands for Structured Query Language. It is a programming language used to communicate with relational databases — organised systems that store data in tables made up of rows and columns.

Think of SQL as a way to ask precise questions to a database:

• Show all customers who placed an order in the last 30 days
• Find employees earning more than ₹50,000 per month
• Calculate total revenue by product category for Q1 2026
• Display patients admitted to a hospital in Delhi this week

Instead of manually searching through thousands of spreadsheet rows, SQL retrieves exactly what you need in milliseconds.

Why Learn SQL in 2026?

Learning SQL opens doors to careers beyond data analytics. If you're wondering what job roles, salaries, and growth opportunities SQL professionals have, read our detailed guide on SQL Developer Career Opportunities.

If you're planning to build a career in analytics after learning SQL, explore our guide on Data Analytics Course Eligibility and Career Opportunities to understand the qualifications, job roles, and future career paths in this field. 

How Databases Work — Key Terminology

Before writing queries, you need to understand how databases store information. Here are the essential terms every beginner must know.

Database: A database is an organised collection of related information. A college database, for example, stores student details, faculty records, course lists, attendance, and marks — all structured and connected.

A table stores data in rows and columns, similar to a spreadsheet. Each table stores one specific type of information.

Student_ID	Name	Class	City
101	Rahul	12	Delhi
102	Priya	11	Mumbai
103	Aman	12	Jaipur

Row and Column

• Row (Record): One complete entry — e.g., all information about student Rahul
• Column (Field): One type of information — e.g., all student names, or all cities

Primary Key: A Primary Key uniquely identifies every record in a table. No two rows can share the same Primary Key value. Example: Student_ID = 101 belongs to only one student.

A Foreign Key links two tables together. For example, a Marks table contains a Student_ID column that refers back to the Students table — this connection allows SQL to combine data from both tables using a JOIN.

Popular SQL Database Systems

Choosing and Installing a SQL Database

To practice SQL, you need a database management system (DBMS) installed on your computer. Here are the top beginner-friendly options with installation steps.

SQL is one of the most essential tools for working with data. Discover other must-have technologies in our guide on Data Analytics Tools You Must Know to build a complete analytics skill set.

Option 1: MySQL Community Edition (Recommended for Beginners)

• Download from: dev.mysql.com/downloads/mysql/ (search "MySQL Community Download" on Google)
• Choose 'MySQL Community Server' — it is completely free
• Run the installer and select 'Developer Default' setup type
• Set a root password during setup — remember this password
• Use MySQL Workbench (included) as your visual query editor

Option 2: PostgreSQL

• Download from: postgresql.org/download/ (search "PostgreSQL Download" on Google)
• Run the installer for your operating system (Windows/Mac/Linux)
• Install pgAdmin 4 (included) — this is your visual query editor
• Default port is 5432 — keep this unless you have a conflict

Option 3: SQLite (Easiest to Start With)

• No installation needed — download a single file from sqlite.org (search "SQLite Download" on Google)
• Use DB Browser for SQLite (search "DB Browser for SQLite" on Google) as your visual editor
• Perfect for learning SQL fundamentals without any server setup

SQL Command Categories

SQL commands are grouped into categories based on what they do. As a beginner, you will mostly work with DQL and DML commands.

Writing Your First SQL Queries

Let's create a database, build a table, add data, and write your first SELECT query If you'd like more beginner-friendly examples and hands-on practice with SELECT, WHERE, ORDER BY, and other common commands, read our complete guide on SQL Queries Explained Easily. — step by step.

If you would like more beginner-friendly examples and real-world query practice, our guide on SQL Queries Explained Easily covers common SQL commands with simple examples that are easy to understand. 

Step 1: Create a Database

CREATE DATABASE StudentDB;

This creates a new database named StudentDB where all your tables will live.

Step 2: Select the Database

USE StudentDB;

This tells SQL to work inside StudentDB for all subsequent commands.

Step 3: Create a Table

CREATE TABLE Students (
    Student_ID   INT PRIMARY KEY,
    Name         VARCHAR(50),
    Age          INT,
    City         VARCHAR(30),
    Course       VARCHAR(50)
);

Each line defines one column — its name and the type of data it will hold (INT for numbers, VARCHAR for text).

Step 4: Insert Records

INSERT INTO Students VALUES
(101, 'Rahul', 21, 'Delhi',  'SQL'),
(102, 'Priya', 20, 'Mumbai', 'Excel'),
(103, 'Aman',  22, 'Jaipur', 'Python');

Step 5: Your First SELECT Query

SELECT * FROM Students;