SQL PROJECT
SQL is the most common language for extracting and organising data that is stored in a relational database. A database is a table that consists of rows and columns. SQL is the language of databases. It facilitates retrieving specific information from databases that are further used for analysis.
This programming language has various uses for data analysts & data science professionals. It is particularly helpful because it can:
- Execute queries against a database
- Retrieve data from a database
- Insert records into a database
- Update records in a database
- Delete records from a database
- Create new databases, or new tables in a database
- Create stored procedures & views in a database
- Set permissions on tables, procedures, and views