Learn SQL: The Complete Beginner’s Guide

SQL (Structured Query Language) is the standard language for working with databases. It lets you store, retrieve, and manage information efficiently. SQL powers everything from small apps to enterprise systems.

---

Why Learn SQL?

• Work with relational databases like MySQL, PostgreSQL, SQLite, SQL Server.
• Essential for backend, data analysis, and business intelligence.
• Universal skill across industries.

Basic SQL Syntax

-- Comments start with --
SELECT column1, column2
FROM table_name
WHERE condition;

Creating a Database & Table

CREATE DATABASE School;

USE School;

CREATE TABLE Students (
    StudentID INT PRIMARY KEY,
    Name VARCHAR(50),
    Age INT,
    Grade CHAR(1)
);

Inserting Data

INSERT INTO Students (StudentID, Name, Age, Grade)
VALUES (1, 'Alice', 20, 'A');

Selecting Data

-- Select all
SELECT * FROM Students;

-- Select specific columns
SELECT Name, Age FROM Students;

-- Filtering with WHERE
SELECT * FROM Students WHERE Grade = 'A';

Updating & Deleting

-- Update
UPDATE Students
SET Age = 21
WHERE StudentID = 1;

-- Delete
DELETE FROM Students
WHERE StudentID = 1;

Filtering & Sorting

-- Sorting
SELECT * FROM Students ORDER BY Age DESC;

-- Filtering with AND/OR
SELECT * FROM Students
WHERE Grade = 'A' AND Age > 18;

Aggregate Functions

SELECT COUNT(*) FROM Students;
SELECT AVG(Age) FROM Students;
SELECT MAX(Age), MIN(Age) FROM Students;

Grouping Data

SELECT Grade, COUNT(*)
FROM Students
GROUP BY Grade;

Joins

-- Inner Join
SELECT Students.Name, Courses.CourseName
FROM Students
INNER JOIN Courses
ON Students.StudentID = Courses.StudentID;

Primary & Foreign Keys

CREATE TABLE Courses (
    CourseID INT PRIMARY KEY,
    StudentID INT,
    CourseName VARCHAR(50),
    FOREIGN KEY (StudentID) REFERENCES Students(StudentID)
);

Creating Views

CREATE VIEW TopStudents AS
SELECT Name, Grade
FROM Students
WHERE Grade = 'A';

Mini Project: Student Database

-- Create
CREATE TABLE Teachers (
    TeacherID INT PRIMARY KEY,
    Name VARCHAR(50)
);

-- Insert
INSERT INTO Teachers VALUES (1, 'Mr. Smith');

-- Join Example
SELECT Students.Name, Teachers.Name AS Teacher
FROM Students
JOIN Teachers ON Students.StudentID = Teachers.TeacherID;

Best Practices

• Always use primary keys for unique rows.
• Normalize data to avoid duplication.
• Use LIMIT or TOP for large queries.
• Index frequently searched columns for faster queries.

Next Steps

1. Learn advanced joins and subqueries.
2. Practice writing complex queries.
3. Explore stored procedures and triggers.
4. Work with real-world datasets.

Conclusion

SQL is the backbone of data-driven applications. Whether you’re building a web app, analyzing data, or managing enterprise systems, SQL gives you the tools to store and query data effectively. 🚀