Creating a table.

CREATE TABLE table_name (
    column1 datatype,
    column2 datatype,
    column3 datatype,
   ....
);

Putting up criteria in a table
CREATE TABLE Persons (
    PersonID int,
    LastName varchar(255),
    FirstName varchar(255),
    Address varchar(255),
    City varchar(255) 
);

Inserting in a table

INSERT INTO table_name (column1,column2, column3, ...)
VALUES (value1, value2, value3, ...);

Road map to learn SQL
https://t.me/sqlanalyst/3

SQL (Structured Query Language), which is used to manage and manipulate relational databases. Here's a beginner-friendly introduction:

SELECT columns
FROM table
WHERE condition;

The SELECT statement retrieves data from a table

SELECT * FROM customers;

--This retrieves all columns from the "customers" table.

You can use the WHERE clause to filter rows based on conditions.

To limit the number of rows returned, you can use the LIMIT clause.

SELECT * FROM products LIMIT 10;

--This retrieves the first 10 rows from the "products" table.

Use the ORDER BY clause to sort the results in ascending or descending order.

The INSERT INTO statement adds new records to a table

INSERT INTO employees (first_name, last_name) VALUES ('John', 'Doe');

--This inserts a new employee named John Doe into the "employees" table.

The UPDATE statement modifies existing records in a table.

UPDATE customers SET email = 'new@email.com' WHERE customer_id = 123;

--This updates the email address for the customer with ID 123.

Joins allow you to combine data from multiple tables based on related columns

SQL Notes Part-1

Like if you need more content on SQL 😄❤️

SQL Notes Part-2
Window Functions