This page demonstrates fundamental data manipulation concepts. Let's begin!
Data Transformation
We'll use a simple example to illustrate transformation.
- Extract: Retrieve the 'FirstName' column from the 'Customers' table.
- Transform: Convert the data type to VARCHAR.
- Extract: Retrieve the 'Email' column from the 'Customers' table.
- Transform: Clean up any extra spaces.
Data Filtering
We'll filter data based on a condition.
Let's filter customers with a name containing 'John'.
- Filter: SELECT * FROM Customers WHERE FirstName LIKE '%John%';
Data Aggregation
Calculate the average age of customers.
We'll calculate the average age of customers from the 'Customers' table.
- Aggregation: SELECT AVG(Age) FROM Customers;