BigQuery Course — Google Cloud Platform
Master modern data warehousing. Learn commands, concepts, and best practices to analyze massive datasets with Google's planetary-scale analytics engine.
📁 Datasets in BigQuery
Create a Dataset in BigQuery
Learn how to create and configure datasets inside your BigQuery project.
Delete a Dataset in BigQuery
Understand how to safely delete datasets and manage dependencies.
List Datasets in BigQuery
View and manage all datasets available within your project.
Copy a Dataset in BigQuery
Replicate datasets across projects or regions efficiently.
📊 Tables and Operations in BigQuery
Create a Table in BigQuery
Define schema and create tables using SQL or the console.
Delete a Table in BigQuery
Remove tables safely while understanding data implications.
Delete a Column in BigQuery
Modify table structure by removing unnecessary columns.
Rename a Column in BigQuery
Change column names while maintaining schema integrity.
Rename a Table in BigQuery
Update table names correctly without losing metadata.
Cluster Columns in BigQuery
Improve query performance and optimize storage costs.
Information Schema in BigQuery
Query metadata using INFORMATION_SCHEMA views.
Create Table from GCS using SQL in BigQuery
Load external data from Google Cloud Storage into BigQuery.
🧾 Basic SQL Commands in BigQuery
Comments in BigQuery
Understand how to document SQL queries using single-line and multi-line comments.
SELECT Statement in BigQuery
Retrieve and filter data efficiently using the SELECT statement.
INSERT INTO Statement in BigQuery
Add new records into existing tables using SQL.
DELETE Command in BigQuery
Remove specific records safely using conditions.
GROUP BY Clause in BigQuery
Aggregate data and group results based on column values.
ORDER BY Clause in BigQuery
Sort query results in ascending or descending order.
DISTINCT Keyword in BigQuery
Eliminate duplicate records from query results.
Aliases in BigQuery
Rename columns or tables temporarily within queries.
UPDATE Command in BigQuery
Modify existing records using conditional logic.
📈 Aggregate Functions in BigQuery
SUM Function in BigQuery
Calculate total values across grouped records.
COUNT Function in BigQuery
Count rows or non-null values in datasets.
AVG Function in BigQuery
Compute average values for numeric columns.
MIN Function in BigQuery
Identify the smallest value within a dataset.
MAX Function in BigQuery
Retrieve the largest value from grouped data.
🔀 Set Operators in BigQuery
UNION Operator in BigQuery
Combine results from multiple queries while removing duplicates.
UNION ALL Operator in BigQuery
Merge result sets including duplicate rows.
INTERSECT Operator in BigQuery
Return common rows between multiple queries.
EXCEPT Operator in BigQuery
Return rows present in the first query but not in the second.
🔤 Text Functions in BigQuery
LOWER Function in BigQuery
Convert text values to lowercase format.
LEFT Function in BigQuery
Extract characters from the left side of a string.
RIGHT Function in BigQuery
Extract characters from the right side of a string.
REVERSE Function in BigQuery
Reverse the order of characters within a string.
LENGTH Function in BigQuery
Determine the number of characters in a string.
CONCAT Function in BigQuery
Combine multiple text values into a single string.
UPPER Function in BigQuery
Convert text values to uppercase format.
REPLACE Function in BigQuery
Substitute specific characters or substrings within text.
⚙️ Condition Clauses and Functions in BigQuery
AND Operator in BigQuery
Combine multiple conditions within WHERE clauses.
OR Operator in BigQuery
Return results that satisfy at least one condition.
NOT Operator in BigQuery
Exclude records based on specified criteria.
IN and NOT IN Operator in BigQuery
Filter records based on a predefined value list.
LIKE Operator in BigQuery
Search for patterns within text fields.
WHERE Clause in BigQuery
Apply conditional filtering to query results.
LIMIT Keyword in BigQuery
Restrict the number of rows returned in query results.
CASE WHEN Statement in BigQuery
Implement conditional logic directly within SQL queries.
BETWEEN Operator in BigQuery
Filter values within a specified range.
HAVING Clause in BigQuery
Filter grouped results after aggregation.
COALESCE Function in BigQuery
Return the first non-null value from a list of expressions.
📅 Date Functions in BigQuery
🔢 Numeric Functions in BigQuery
🪟 Window Functions in BigQuery
Window Function in BigQuery
Understand analytic functions that operate across row partitions.
LAG Function in BigQuery
Access data from previous rows within the same partition.
LEAD Function in BigQuery
Access data from subsequent rows within the same partition.
RANK Function in BigQuery
Assign ranking values based on ordered partitions.
DENSE_RANK Function in BigQuery
Assign consecutive ranking numbers without gaps.
ROW_NUMBER Function in BigQuery
Generate unique sequential numbers within partitions.
FIRST_VALUE Function in BigQuery
Return the first value in a window frame.
LAST_VALUE Function in BigQuery
Return the last value in a window frame.
🔗 Join Operations in BigQuery
LEFT JOIN in BigQuery
Return all records from the left table with matching rows from the right.
INNER JOIN in BigQuery
Return matching records between two tables.
FULL JOIN in BigQuery
Combine results from both tables including unmatched rows.
RIGHT JOIN in BigQuery
Return all records from the right table with matching left rows.