Introduction to SQL Syntax and Command Structure

📊 Speak the language of databases

SQL (Structured Query Language) is the standard language used to communicate with relational databases like SQL Server, MySQL, and SQLite. Whether you’re building desktop apps, websites, or data-driven tools, SQL is the bridge between your code and the stored data.

In this guide, you’ll learn the basic syntax, command structure, and how to perform the most common SQL operations like querying, inserting, and filtering data.

📁 What is SQL Used For?

• 📄 Creating and modifying databases and tables
• 📥 Inserting new records
• 🔍 Querying and filtering data
• ✏️ Updating existing records
• ❌ Deleting records
• 🔐 Managing access and structure

🧱 SQL Syntax Basics

SQL commands follow a clear, readable structure, and are not case-sensitive (but best practice is to capitalise keywords):

SELECT column1, column2
FROM TableName
WHERE condition;

💡 Statements always end with a semicolon (;).

🔹 SQL Statement Categories

For beginners, DML and DDL are your main focus.

📌 Creating Tables

CREATE TABLE Customers (
    CustomerID INT PRIMARY KEY,
    FirstName VARCHAR(50),
    LastName VARCHAR(50),
    Email VARCHAR(100),
    Age INT
);

💡 Each column has a name and a data type (like INT, VARCHAR, DATE, etc.)

📥 Inserting Data

INSERT INTO Customers (CustomerID, FirstName, LastName, Email, Age)
VALUES (1, 'Alice', 'Smith', 'alice@example.com', 28);

You can add one row at a time or multiple:

INSERT INTO Customers VALUES 
(2, 'Bob', 'Jones', 'bob@example.com', 35),
(3, 'Clara', 'White', 'clara@example.com', 22);

🔍 Reading Data – SELECT

The SELECT statement is the most commonly used command in SQL.

SELECT * FROM Customers;

🎯 Examples:

SELECT FirstName, LastName FROM Customers
WHERE Age > 30
ORDER BY LastName ASC;

SELECT COUNT(*) FROM Customers WHERE Email LIKE '%@gmail.com';

✏️ Updating Data

UPDATE Customers
SET Age = 29
WHERE CustomerID = 1;

💡 Always use WHERE to avoid updating every row!

❌ Deleting Data

DELETE FROM Customers
WHERE CustomerID = 3;

Without a WHERE clause, it would delete every row.

🔐 Common Data Types

🧪 Quick SQL Challenge

1. Create a table called Books with:
   • BookID, Title, Author, Year, InStock (boolean)
2. Insert three books into the table
3. Select all books published after 2010
4. Update the stock of one book to false
5. Delete a book by BookID

🧠 Best Practices

✅ Use capital letters for SQL keywords (SELECT, FROM, etc.)
✅ Always include WHERE when updating or deleting
✅ Use meaningful column names
✅ Keep column types appropriate to the data
✅ Format your queries for readability

📚 Summary Table

🔜 What’s Next?

SQL is a core skill in full-stack development — learning it well sets you up for APIs, web apps, reports, and more. Join our SQL Essentials course to further your understanding.