SQL Introduction

Welcome to the introduction to SQL! In this module, you'll learn the fundamentals of Structured Query Language (SQL), the standard language for managing and manipulating databases.

What is SQL?

SQL stands for Structured Query Language. It's a domain-specific language used in programming and designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS).

With SQL, you can:

• Query data from a database (retrieve information).
• Insert new data into a database.
• Update existing data in a database.
• Delete data from a database.
• Create and modify database structures (tables, schemas, etc.).

Why Learn SQL?

Databases are at the core of most applications and businesses. Understanding SQL is a crucial skill for:

• Developers: To interact with application databases.
• Data Analysts: To extract and analyze data.
• Data Scientists: To prepare and manipulate datasets.
• Business Professionals: To gain insights from business data.

Key Concepts

Databases, Tables, and Rows

Think of a database as a digital filing cabinet. Inside the cabinet, you have folders, which are like tables. Each table stores specific types of information. For example, you might have a Customers table or an Orders table.

Each row in a table represents a single record. If you have a Customers table, each row would represent one customer.

Columns (Fields)

Columns define the types of data stored in a table. In the Customers table, columns might be CustomerID, FirstName, LastName, Email, and City.

Your First SQL Query: SELECT

The most fundamental SQL command is SELECT, used to retrieve data from a database.

Selecting All Columns

To retrieve all columns and all rows from a table named Employees, you would use:

SELECT *
FROM Employees;

• SELECT *: This tells the database to return all columns.
• FROM Employees: This specifies which table to retrieve data from.

Selecting Specific Columns

You can also select only the columns you need. For example, to get just the FirstName and Email of all employees:

SELECT FirstName, Email
FROM Employees;

Filtering Data: WHERE Clause

The WHERE clause is used to filter records based on specific conditions.

To find all employees who work in the 'Sales' department:

SELECT FirstName, LastName, Department
FROM Employees
WHERE Department = 'Sales';

You can use various operators in the WHERE clause:

• = (Equal)
• > (Greater than)
• < (Less than)
• >= (Greater than or equal to)
• <= (Less than or equal to)
• <> or != (Not equal)
• LIKE (Search for a pattern)
• IN (Specify multiple possible values)

Common SQL Commands

INSERT INTO

Used to add new records to a table:

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

UPDATE

Used to modify existing records:

UPDATE Customers
SET Email = 'alice.s@example.com'
WHERE CustomerID = 101;

DELETE

Used to delete records:

DELETE FROM Customers
WHERE CustomerID = 101;

Next Steps

This introduction covers the very basics. SQL is a vast and powerful language with many more features, including joining tables, aggregation functions, subqueries, and more. Practice these commands on a sample database to solidify your understanding.