技能档案

Advanced SQL

此技能定义了各角色和级别的期望。

Database Management Relational Databases

角色数

包含此技能的角色

级别数

结构化成长路径

必要要求

其余 5 个可选

Database Management

Relational Databases

2026/2/22

选择当前级别并对比期望。下方卡片显示晋升所需掌握的内容。

各级别期望

表格展示从初级到首席的技能深度变化。点击行查看详情。

角色	必要性	描述
Data Scientist		Writes SQL queries for data extraction and analysis: JOIN, GROUP BY, HAVING, subqueries. Conducts EDA via SQL in data warehouses. Works with aggregate functions and basic window functions for analytical queries.

角色	必要性	描述
Data Scientist		Writes complex analytical SQL queries with window functions: LAG, LEAD, RANK, running totals. Creates CTE-based queries for feature engineering in data warehouses. Optimizes queries through EXPLAIN ANALYZE and proper indexing.

角色	必要性	描述
Data Scientist		Designs SQL-based feature pipelines for production ML systems. Optimizes queries for BigQuery/Redshift/Snowflake with partitioning, clustering, materialized views. Creates dbt models for reproducible data transformations.

角色	必要性	描述
Data Scientist		Defines SQL development standards for the data science team. Establishes shared SQL models and naming conventions. Coordinates data engineering and data science for effective data warehouse workflows.

角色	必要性	描述
Data Scientist		Shapes data warehouse strategy for ML workloads at organizational level. Defines architecture for feature computation: SQL-first vs Python-first approach. Evaluates emerging SQL engines and their fit for ML use cases.

Junior 1 要求

Data Scientist

Writes SQL queries for data extraction and analysis: JOIN, GROUP BY, HAVING, subqueries. Conducts EDA via SQL in data warehouses. Works with aggregate functions and basic window functions for analytical queries.

Middle 1 要求

Data Scientist

Writes complex analytical SQL queries with window functions: LAG, LEAD, RANK, running totals. Creates CTE-based queries for feature engineering in data warehouses. Optimizes queries through EXPLAIN ANALYZE and proper indexing.

Senior 1 要求

Data Scientist

Designs SQL-based feature pipelines for production ML systems. Optimizes queries for BigQuery/Redshift/Snowflake with partitioning, clustering, materialized views. Creates dbt models for reproducible data transformations.

Lead / Staff 1 要求

Data Scientist

Defines SQL development standards for the data science team. Establishes shared SQL models and naming conventions. Coordinates data engineering and data science for effective data warehouse workflows.

Principal 1 要求

Data Scientist

Shapes data warehouse strategy for ML workloads at organizational level. Defines architecture for feature computation: SQL-first vs Python-first approach. Evaluates emerging SQL engines and their fit for ML use cases.

👁 关注 ✏️ 建议修改

正在加载评论...