SQL-SQL Learning Platform

Example

SELECT * FROM Customers WHERE Country = 'Germany';

Scenario

A business analyst retrieves all customer records from Germany to analyze market penetration.

Example

UPDATE Products SET Price = Price * 1.1 WHERE CategoryID = 2;

Scenario

A retail manager increases the price of all products in category 2 by 10% ahead of a seasonal sale.

Example

CREATE TABLE Employees (ID INT PRIMARY KEY, Name VARCHAR(100), Position VARCHAR(50));

Scenario

An HR department sets up a new table to manage employee records, including their ID, name, and position.

Example

GRANT SELECT ON Employees TO User_Jane;

Scenario

The database administrator grants a user, Jane, the permission to query data from the Employees table.

Example

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

Scenario

A banking application transfers $100 from account 1 to account 2, ensuring both operations complete successfully before committing the transaction.