1. Goal

How to efficiently use MaxCompute (ODPS) SQL and apply basic SQL syntax to the extreme.

In today's world where big data is so popular, it is not just professional data professionals who need to deal with SQL frequently. Even non-technical students such as products and operations will use SQL to a greater or lesser extent. It has become particularly important to efficiently leverage the power of SQL and then leverage the power of data.

MaxCompute (ODPS) SQL has become quite mature today. As a dialect of SQL, it has complete SQL syntax support, rich built-in functions, and supports many advanced features such as windowing functions, user-defined functions, and user-defined types. It can be efficiently applied in various data processing scenarios.

How to fully leverage SQL capabilities and emphasize the use of flexible and divergent data processing thinking to solve complex data scenarios with the most basic syntax.

2. Target group

This article may be helpful for both beginners and seasoned readers, but it is more suitable for intermediate and advanced readers to read.

Learners can learn to have data processing thinking, learn to call functions, grammar and other characteristics based on their own situation. Advanced grammar should be learned step by step, and if they have not mastered the basics, they should not try.

3. Content structure

The content learning revolves around topics such as sequence generation, interval transformation, permutation and combination, and continuous discrimination. There are slight dependencies between each topic, and familiarity and proficiency are required.

4. Prompt information

The SQL statement only utilizes the basic syntax features of MaxCompute (ODPS) SQL. In theory, all SQL can be run in the latest version, and it is specifically noted that running environment, compatibility, and other issues are not within the scope of this article.