SQL -Introduction
(1) What Is SQL?
- SQL Stands for Structured Query Language.
- SQL is a query language which helps us to send queries to the database and get our results back.
- Language allows us to talk to another person and get connected with each other.
- Similarly, SQL language helps us to connect with the SQL database and get our results.
(2) What SQL Can Do?
- SQL can execute queries against a database
- SQL can retrieve data from a database
- SQL can insert records into a database
- SQL can update records in a database
- SQL can delete records from a database
- SQL can create new databases
- SQL can create new tables in a database
- SQL can create stored procedures in a database
- SQL can create views in a database
- SQL can set permissions on tables, procedures, and views