mirror of
https://github.com/ByteByteGoHq/system-design-101.git
synced 2026-04-15 14:07:24 -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
33 lines
1.2 KiB
Markdown
33 lines
1.2 KiB
Markdown
---
|
|
title: "What is the Best Way to Learn SQL?"
|
|
description: "A guide to efficiently learn SQL and its components for different roles."
|
|
image: "https://assets.bytebytego.com/diagrams/0031-how-to-learn-sql.png"
|
|
createdAt: "2024-03-16"
|
|
draft: false
|
|
categories:
|
|
- computer-fundamentals
|
|
tags:
|
|
- "SQL"
|
|
- "Databases"
|
|
---
|
|
|
|
|
|
|
|
In 1986, SQL (Structured Query Language) became a standard. Over the next 40 years, it became the dominant language for relational database management systems. Reading the latest standard (ANSI SQL 2016) can be time-consuming. How can I learn it?
|
|
|
|
## SQL Components
|
|
|
|
There are 5 components of the SQL language:
|
|
|
|
* **DDL**: data definition language, such as CREATE, ALTER, DROP
|
|
|
|
* **DQL**: data query language, such as SELECT
|
|
|
|
* **DML**: data manipulation language, such as INSERT, UPDATE, DELETE
|
|
|
|
* **DCL**: data control language, such as GRANT, REVOKE
|
|
|
|
* **TCL**: transaction control language, such as COMMIT, ROLLBACK
|
|
|
|
For a backend engineer, you may need to know most of it. As a data analyst, you may need to have a good understanding of DQL. Select the topics that are most relevant to you.
|