SQL Basics

Welcome to the basics of SQL! SQL, which stands for Structured Query Language, is a programming language used for managing and manipulating relational databases. Whether you're a beginner or looking to refresh your knowledge, this guide will cover the fundamental concepts of SQL.

Understanding SQL

SQL is used to perform various operations on a database, such as:

Creating a database and tables
Inserting, updating, and deleting data
Querying data using SELECT statements
Modifying database structure using ALTER and DROP statements

Creating a Database and Tables

To create a database and tables, you can use the following SQL statements:

CREATE DATABASE my_database;
USE my_database;

CREATE TABLE users (
    id INT PRIMARY KEY,
    name VARCHAR(50),
    email VARCHAR(100)
);

Inserting Data

Inserting data into a table is done using the INSERT INTO statement:

INSERT INTO users (id, name, email) VALUES (1, 'John Doe', 'john@example.com');

Querying Data

Querying data from a table is done using the SELECT statement:

SELECT * FROM users;

Updating and Deleting Data

Updating data is done using the UPDATE statement:

UPDATE users SET email = 'john.doe@example.com' WHERE id = 1;

Deleting data is done using the DELETE statement:

DELETE FROM users WHERE id = 1;