What is the best way to learn SQL? #SQLStandard, #BackendEngineering, #DataAnalyst #edmtdev
580 بار بازدید -
6 ماه پیش
-
In 1986, SQL (Structured Query
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?
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.
#SQLStandard, #ANSISQL, #DatabaseManagement, #DDL, #DQL, #DML, #DCL, #TCL, #BackendEngineering, #DataAnalyst, #SQLQuery, #StructuredQueryLanguage, #DatabaseLanguage
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.
#SQLStandard, #ANSISQL, #DatabaseManagement, #DDL, #DQL, #DML, #DCL, #TCL, #BackendEngineering, #DataAnalyst, #SQLQuery, #StructuredQueryLanguage, #DatabaseLanguage
6 ماه پیش
در تاریخ 1402/12/10 منتشر شده
است.
580
بـار بازدید شده