Day 9. CTE, recursion and cloud calculations

I divided the study of the video into several days due to its long length.

CTE stands for Common Table Expression in SQL. It is a temporary named result set that you can reference within a SELECT, INSERT, UPDATE, or DELETE statement.

A CTE allows you to define a subquery expression that can be used multiple times within a single SQL statement. This can help simplify complex queries by breaking them down into smaller, more manageable pieces.

Recursion functions are described in examples standard Fibonacci task and knight traversing chessboard exercise.

Сloud calculations are considered by Google Cloud service in descriptive style without structured guideline or any instructions. This part of the video is completely useless.


 

Комментарии

Популярные сообщения из этого блога

MapBox-compatible file formats and limitations