The concept of SQL and its cheatsheet

SQL common grammar

The website you can refer

1. Complete SQL Mastery https://codewithmosh.com/ (USD 19 per course)
2. pirate version of complete SQL mastery https://www.bilibili.com/video/BV1UE41147KC
3. https://www.w3schools.com/sql/sql_intro.asp

What is SQL?

SQL is called a structured query language. SQL is a standard language for accessing and manipulating databases.

What Can SQL do?

1. SQL can execute queries against a database
2. SQL can retrieve data from a database
3. SQL can insert records in a database
4. SQL can update records in a database
5. SQL can delete records from a database
6. SQL can create new databases
7. SQL can create new tables in a database
8. SQL can create stored procedures in a database
9. SQL can create views in a database
10. SQL can set permissions on tables, procedures, and views

Database Management System (DBMS) software

1. MySQL
2. Microsoft SQL Server
3. Microsoft Access DBMS
4. Oracle2
5. IBM DB2
6. FoxPro
7. SAP Sybase ASE