mirror of
https://github.com/ByteByteGoHq/system-design-101.git
synced 2026-04-01 16:57:23 -04:00
ee4b7305a2
This PR adds all the guides from [Visual Guides](https://bytebytego.com/guides/) section on bytebytego to the repository with proper links. - [x] Markdown files for guides and categories are placed inside `data/guides` and `data/categories` - [x] Guide links in readme are auto-generated using `scripts/readme.ts`. Everytime you run the script `npm run update-readme`, it reads the categories and guides from the above mentioned folders, generate production links for guides and categories and populate the table of content in the readme. This ensures that any future guides and categories will automatically get added to the readme. - [x] Sorting inside the readme matches the actual category and guides sorting on production
785 B
785 B
title, description, image, createdAt, draft, categories, tags
| title | description | image | createdAt | draft | categories | tags | |||
|---|---|---|---|---|---|---|---|---|---|
| Visualizing a SQL Query | Understand the logical order of operations in a SQL query. | https://assets.bytebytego.com/diagrams/0114-sql-query-logical-order.png | 2024-03-14 | false |
|
|
SQL statements are executed by the database system in several steps, including:
-
Parsing the SQL statement and checking its validity
-
Transforming the SQL into an internal representation, such as relational algebra
-
Optimizing the internal representation and creating an execution plan that utilizes index information
-
Executing the plan and returning the results