SQL - SQL Learning and Practice

Example

SELECT * FROM Customers WHERE Country = 'Germany';

Scenario

A retail company retrieves a list of all customers based in Germany to target them with a new marketing campaign.

Example

UPDATE Products SET Price = Price * 1.1 WHERE Category = 'Electronics';

Scenario

An electronics retailer increases the prices of all products in the 'Electronics' category by 10%.

Example

CREATE TABLE Employees (ID INT, Name VARCHAR(255), Position VARCHAR(255));

Scenario

A startup creates a new table to store employee records, including their IDs, names, and positions.

Example

GRANT SELECT ON Employees TO User_John;

Scenario

A company grants an employee named John the permission to query the Employees table, enhancing data security by restricting access.

Example

BEGIN TRANSACTION; UPDATE Account SET Balance = Balance - 100 WHERE ID = 1; UPDATE Account SET Balance = Balance + 100 WHERE ID = 2; COMMIT;

Scenario

A bank transfers $100 from one account to another, ensuring both operations complete successfully before committing the transaction to maintain data integrity.