SQL Basics Tutorial for Students

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 data in relational databases, and SQL is the language that lets you access, filter, and analyse it in seconds.

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

📊 INDUSTRY STAT: SQL appears in over 75% of data analyst job postings on LinkedIn India (most recent available data) — more than Power BI, Tableau, or Python. Source: LinkedIn India Job Postings Analysis, most recent available data | Stack Overflow Developer Survey 2024

This guide is for complete beginners — no coding experience needed. By the end, you'll understand how databases work and how to write queries, JOINs, and aggregate functions that real analysts use every day.

🔍 What is SQL? The standard language for communicating with relational databases — create, retrieve, update, and delete data using commands like SELECT, INSERT, UPDATE, and DELETE. It's the core skill for data analysts, business analysts, data engineers, and developers worldwide.

What is SQL and Why Should You Learn It?

SQL (Structured Query Language) lets you communicate with relational databases — organized systems that store data in tables of rows and columns. It's a way to ask precise questions of a database — "show all customers who ordered in the last 30 days," "find employees earning more than ₹50,000/month," "calculate Q1 revenue by category." Instead of manually searching thousands of spreadsheet rows, SQL retrieves exactly what you need in milliseconds.

Why Learn SQL in 2026?

Reason	Details
High Job Demand	75%+ of data analyst listings require it
Easy to Learn	Reads like plain English
Universal Tool	Works across MySQL, PostgreSQL, SQL Server, Oracle, BigQuery
Saves Time	Millions of rows in seconds
Career Gateway	Needed for Analyst, BI, Data Engineer, DBA roles

Planning a career in analytics? Explore our guide on Data Analytics Course Eligibility and Career Opportunities. SQL also opens doors beyond analytics — see our SQL Developer Career Opportunities guide for roles, salaries, and growth.

How Databases Work — Key Terminology

Database: An organised collection of related information — e.g., a college database storing student details, faculty records, course lists, attendance, and marks.

A table stores data in rows and columns, like a spreadsheet:

Row (Record): one complete entry, e.g., all of Rahul's info.

Column (Field): one type of information, e.g., all student names.

Primary Key: uniquely identifies each record (e.g., Student_ID = 101).

Foreign Key: links two tables — e.g., a Marks table's Student_ID refers back to Students, enabling JOINs.

Popular SQL Database Systems

Choosing and Installing a SQL Database

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 (Recommended) — Download 'MySQL Community Server' (free) from dev.mysql.com, run installer with 'Developer Default' setup, set a root password, and use MySQL Workbench as your editor.

Option 2: PostgreSQL — Download from postgresql.org, install pgAdmin 4 as your visual editor. Default port is 5432.

Option 3: SQLite (Easiest) — No installation needed; download a single file from sqlite.org and use DB Browser for SQLite.

🔶 BEGINNER TIP: If unsure, start with SQLite + DB Browser. You can be writing queries in under 10 minutes.

4. SQL Command Categories

5. Writing Your First SQL Queries

For more beginner-friendly examples with SELECT, WHERE, ORDER BY, and other common commands, read our complete guide on SQL Queries Explained Easily.

-- Step 1: Create a database

CREATE DATABASE StudentDB;

-- Step 2: Select it

USE StudentDB;

-- Step 3: Create a table

CREATE TABLE Students (

    Student_ID   INT PRIMARY KEY,

    Name         VARCHAR(50),

    Age          INT,

    City         VARCHAR(30),

    Course       VARCHAR(50)

);

-- 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;

🔶 REMEMBER: SELECT = what you want | FROM = where it lives | * = all columns — the foundation of every SQL query.

Use column names instead of * when you only need specific fields — it improves performance on large datasets: SELECT Name, Course FROM Students;

6. Filtering, Sorting, and Limiting Data

WHERE — Filter Records

SELECT * FROM Students WHERE City = 'Delhi';

SELECT * FROM Students WHERE Age > 20;

SELECT * FROM Students WHERE City = 'Delhi' AND Age > 20;