SQL Optimization Patterns

Create, edit, and analyze spreadsheet files (.xlsx, .xlsm, .csv, .tsv) with formulas, formatting, and financial modeling conventions.

Design database schemas, plan data migrations, optimize queries, and model data relationships using expert analysis and automated tools.

Run machine learning and generative AI tasks directly in BigQuery SQL using built-in functions for forecasting, anomaly detection, key driver analysis, and text generation.

Perform CRUD operations, run queries, and manage containers on Azure Cosmos DB NoSQL API using the Python SDK.

Write correct, efficient Kusto Query Language queries with coverage of syntax, joins, dynamic types, datetime pitfalls, regex, serialization, memory management, and advanced functions.

Define, track, and interpret product metrics across discovery, growth, and mature product stages using frameworks like AARRR, North Star, and HEART.