Is the SQL与数据建模助理 certificate verifiable?

Yes. Every issued Hootix Academy certificate carries a unique credential code that anyone can verify online.

How is the SQL与数据建模助理 exam structured?

It is a 100-minute proctored multiple-choice exam of 72 questions; you need 72% to pass.

Do I need to buy the course to take the exam?

You can purchase the certification exam on its own, or bundle it with the full study course at a reduced price.

How long does the SQL与数据建模助理 course take?

About 22 hours of self-paced study.

SQL与数据建模助理 Certification

自信地编写查询，设计在高负载下依然稳健的模式

Key facts

Level: Associate
Field: Data Engineering & Analytics
Estimated study time: about 22 hours
Credential price: $79
Exam: 72 questions · 100 minutes · pass mark 72%

About the SQL与数据建模助理 certification

一项助理级认证，将SQL语法转化为真实的查询与建模判断力。你将学习如何编写带有过滤、排序和限制的精确SELECT语句；使用GROUP BY和HAVING进行聚合；通过各类JOIN（INNER、LEFT、RIGHT、FULL、SELF、CROSS）关联表；用子查询和CTE分解问题；使用窗口函数（ROWNUMBER、RANK、LAG、LEAD、滚动合计）进行排名、偏移和累积；用UNION、INTERSECT和EXCEPT合并结果集；以及安全地通过INSERT、UPDATE和DELETE修改数据。在设计层面，你将掌握关系模型、实体关系建模（实体、属性、关系、基数）、保护数据完整性的约束（主键、外键、UNIQUE、CHECK、NOT NULL）、索引与查询性能基础、事务与ACID、NULL的微妙之处、1NF/2NF/3NF/BCNF规范化与有意识的反规范化、面向分析的星型与雪花型模式，以及代理键与自然键。这些技能与数据库引擎无关——每个概念都能清晰地映射到PostgreSQL、MySQL、SQL Server和Oracle——无论数据存储在何处都可迁移应用。

What you will learn

The official SQL与数据建模助理 study course covers:

Querying with SELECT — Reading data precisely: SELECT/WHERE/ORDER BY/LIMIT, operators and NULL handling, and the logical order the database actually evaluates a query in.
Aggregation and Joins — Summarising data with GROUP BY/HAVING and combining tables with every JOIN type — the heart of multi-table SQL.
Subqueries, CTEs, Windows, and Sets — Composing advanced queries: nested and correlated subqueries, CTEs (including recursion), window functions, and set operations.
Relational Design and Integrity — The relational model and ER modelling, the constraints that protect data, indexes and performance, and transactions with ACID.
Normalization and Analytics Modeling — Normal forms 1NF-BCNF and when to denormalize, plus dimensional modelling: fact and dimension tables, star vs snowflake schemas.

Prerequisites

数据分析基础

Frequently asked questions

Is the SQL与数据建模助理 certificate verifiable?: Yes. Every issued Hootix Academy certificate carries a unique credential code that anyone can verify online.
How is the SQL与数据建模助理 exam structured?: It is a 100-minute proctored multiple-choice exam of 72 questions; you need 72% to pass.
Do I need to buy the course to take the exam?: You can purchase the certification exam on its own, or bundle it with the full study course at a reduced price.
How long does the SQL与数据建模助理 course take?: About 22 hours of self-paced study.