# SQL
(Structured Query Language)
*What is SQL*:
used to interact databases
**RDBMS** (Relational Database Management System)
Used to interface with a database
Examples:
Oracle
Postgres SQL
[[Microsoft SQL Server]]
My SQL
%%
```dataview
LIST
WHERE contains(fileClass,"Program") and contains(program-type,"RDBMS")
```
%%
## Guides
[W3](https://www.w3schools.com/sql/default.asp)
[video tutorial](https://www.youtube.com/watch?v=h0nxCDiD-zg&t=216s)
## Set-up
[[Microsoft SQL Server]]
- runs server
- database engine
[[SQL Server Management Studio]] (SSMS)
- graphical front end
- allows you to write queries against database
### Benefits of SQL [^1]
- SQL is a standard database query language that enables users to manipulate and query data in a database quickly.
- SQL is widely used in many applications and environments, such as web applications, data warehouses, and e-commerce applications.
- SQL provides many benefits over other database query languages, such as improved performance, better data integrity, and more accessible data manipulation.
### Cons of SQL [^1]
- If you are unfamiliar with programming or database concepts, SQL can be challenging to learn.
- SQL can be slow compared to other languages, mainly when working with large databases.
- And SQL is not well suited for certain types of tasks, such as complex mathematical calculations or machine learning.
[^1]:https://www.simplilearn.com/best-programming-languages-start-learning-today-article
## Resources
[SQL Tutorial for Beginners, *YouTube*](https://www.youtube.com/watch?v=h0nxCDiD-zg&t=216) ^49b784
- really good first look
- walks thru basic explanation, downloads
- Stopped at 9:30 (44 min long)
Unexplored:
- https://www.simplilearn.com/tutorials/sql-tutorial/what-is-sql
- https://www.simplilearn.com/tutorials/mysql-tutorial/mysql-workbench
- https://www.datacamp.com/cheat-sheet/sql-basics-cheat-sheet
## Inbox
[Microsoft explanation and info](https://learn.microsoft.com/en-us/sql/sql-server/what-is-sql-server?view=sql-server-ver16https://learn.microsoft.com/en-us/sql/sql-server/what-is-sql-server?view=sql-server-ver16)