| How to Create a Table in BigQuery | SQL Table Creation Made Easy |
| Upload Data from Google Sheets to BigQuery | Easy Step-by-Step Guide |
| How to Delete a Table in BigQuery | Step-by-Step Guide |
| Using Multiple WITH Clauses in BigQuery | Advanced SQL Techniques |
| Mastering the SQL WITH Clause in BigQuery | Simplify Your Queries |
| How to Select Specific Columns in BigQuery | SQL Query Basics |
| How to Rename Columns in BigQuery Using AS | SQL Alias Tutorial |
| How to Aggregate Columns in BigQuery | SQL Aggregation Functions Explained |
| Mastering Subqueries in BigQuery | SQL Subquery Tutorial for Beginners |
| Using GROUP BY in BigQuery | SQL Grouping and Aggregation Explained |
| How to Use WHERE Filter in BigQuery | SQL Filtering Explained |
| Using WHERE Filter with AND & OR Operators in BigQuery | SQL Filtering Tutorial |
| Converting Text to Lowercase & Uppercase in BigQuery | SQL String Functions |
| Understanding Table Schema in BigQuery | SQL Data Structure Explained |
| How to Change Data Schema or Data Types in BigQuery | SQL Schema Modification |
| Extract Date, Month, and Year from a Column in BigQuery | SQL Date Functions Tutorial |
| Master SQL IN and NOT IN Operators in BigQuery | SQL Filtering Techniques |
| Master SQL LIKE and NOT LIKE Operators in BigQuery | Advanced SQL Filtering |
| Master the SQL BETWEEN Operator in BigQuery | Simplify Data Filtering |
| Eliminate Duplicates with SQL DISTINCT in BigQuery | Clean Your Data Effortlessly |
| Count Unique Values in SQL Columns with BigQuery | Quick and Easy Guide |
| Master SQL HAVING Clause in BigQuery | Filter Aggregated Data Like a Pro |
| Sort Data Like a Pro - Master the ORDER BY Clause in SQL with BigQuery |
| Master the LIMIT Clause in SQL with BigQuery | Fetch Top Results Efficiently |
| Understand SQL Execution Order - How Queries Are Processed in BigQuery |
| Master the OFFSET Keyword in SQL - Skip Rows Efficiently in BigQuery |
| How to Append or Insert Data into an Existing Table in BigQuery |
| How to Append or Insert Multiple Rows into an Existing Table in BigQuery |
| How to Update or Change Values in an Existing Table in BigQuery |
| How to Delete Data from a Table in BigQuery |
| How to Delete All Data and Drop a Table in BigQuery |
| Null vs Blank Values in SQL - Understanding the Difference |
| How to Exclude NULL or Blank Values in SQL Queries |
| Mastering CASE WHEN Statements in SQL on BigQuery |
| Replace NULL Values Using IFNULL and COALESCE in BigQuery SQL |
| Aggregation Functions on NULL Values in BigQuery SQL |
| Handling NULL Values in SUM Function in BigQuery SQL |
| Master String Functions in BigQuery SQL |
| Mastering Integer and Float Functions in BigQuery SQL |
| Working with Booleans in BigQuery SQL - A Complete Guide |
| Master Date Functions in SQL - Essential Techniques for Data Manipulation |
| Add or Subtract Days in BigQuery SQL - Date Arithmetic Simplified |
| Current Date and Time Functions in BigQuery SQL - Mastering Time-Based Queries |
| Add or Subtract Date and Time in BigQuery SQL - Essential Date Manipulation Techniques |
| Round Off and Truncate DateTime Values in BigQuery SQL - Master DateTime Precision |
| Master Time Functions in BigQuery SQL - Work with Time Data Like a Pro |
| Mastering Timestamp Functions in BigQuery SQL - Complete Guide |
| Mastering Left Join in SQL - Complete Guide to Combining Data |
| Mastering INNER JOINs in BigQuery SQL |
| Mastering RIGHT JOIN in BigQuery SQL |
| Mastering FULL JOIN in BigQuery SQL |
| Mastering CROSS JOIN in BigQuery SQL |
| Mastering Self JOIN in BigQuery SQL |
| How to CAST or Change Data Type in SQL |
| CAST vs SAFE_CAST in SQL BigQuery - Key Differences & When to Use Each |
| Mastering Aggregate Functions in SQL BigQuery - SUM, AVG, COUNT & More! |
| Using UNION ALL in SQL BigQuery - Combining Data from Multiple Tables |
| EXCEPT Keyword in SQL BigQuery - How to Exclude Data from Results |
| ROW_NUMBER() Window Function in SQL BigQuery - Ranking and Ordering Data |
| RANK() Window Function in SQL BigQuery - Ranking Data with Precision |
| DENSE_RANK() Window Function in SQL BigQuery - Ranking Without Gaps |
| LEAD() & LAG() Window Functions in SQL BigQuery - Moving Data Forward and Backward |
| FIRST_VALUE() & LAST_VALUE() Window Functions in SQL BigQuery - Extracting First and Last Rows |
| SUM() & CUMSUM() in Window Functions - Calculating Running Totals in SQL BigQuery |
| AVERAGE() in Window Functions - Calculating Moving Averages in SQL BigQuery |
| COUNT() in Window Functions - Counting Rows Within Specific Windows in SQL BigQuery |
| CUME_DIST() in SQL - Understanding Cumulative Distribution in BigQuery |
| Understanding PERCENT_RANK() in SQL - How to Calculate Percent Rank in BigQuery |
| Calculating Standard Deviation in SQL - A Step-by-Step Guide for BigQuery |
| Calculating Variance in SQL - A Comprehensive Guide for BigQuery |
| Understanding Correlation in SQL - A Step-by-Step Guide with BigQuery |
| Mastering Array Aggregations in SQL - Techniques and Best Practices |
| Mastering String Aggregations in SQL - Concatenate, Group, and Analyze Text Data |
| Unnesting Arrays in SQL - Transform Array Data into Rows |
| Understanding Query Execution Details in SQL - Optimize Performance |
| How to Schedule and Automate Table Workflows in SQL |
| Mastering Pivot Tables in SQL - Transform Your Data with Ease |
| Unpivoting in SQL - Transform Data from Columns to Rows |
| Working with Arrays in SQL - A Comprehensive Guide |
| Mastering Array Functions in SQL - Essential Techniques and Use Cases |
| Using Array Subqueries in SQL - Advanced Techniques and Best Practices |
| Preferred Method for UNNESTing Arrays in SQL - Best Practices |
| Unnest Arrays in SQL the Unpreferred Way - Scalar Approach Explained |
| Understanding Struct Data Types in SQL - Usage and Best Practices |
| Working with Nested Data Types - Arrays of Structs in SQL |
| Using Structs within Arrays in SQL - A Deep Dive |
| Using Structs in Query Results in SQL - Simplifying Complex Data |
| Modifying Data Inside Structs in SQL - Tips and Techniques |
| Working with Multiple Nested Structs in SQL - Advanced Techniques |
| Using Aggregate Functions with Structs in SQL - Advanced Data Analysis |
| Understanding Partitioned Tables in SQL - Optimize Query Performance |
| Clustering Tables in SQL- Boost Query Performance and Storage Efficiency |
| Estimated Hours for training |
Best,
Rajiv Pujala
Iamrajivpujala@gmail.com
+91 7013699612
View this Course
Certified
You have 
