https://www.gcreddy.com/2021/08/introduction-to-sql.html
Introduction to SQL | Structured Query Language | Database Testing | Relatioal Databases |
1. What is SQL?
2. Purpose of SQL
3. Who should learn SQL?
4. What are the subsets of SQL?
5. Data Definition Language
6. Data Manipulation Language
7. Data Control Language
• SQL is used to Create New Databases
• SQL is used to Create New Tables in a Database
• SQL is used to Insert records in a Database
• SQL is used to Update records in a Database
• SQL is used to Delete records in a Database
• SQL is used to Retrieve data from a Database
• SQL is used to execute queries against a Database
• SQL can set permissions on tables, procedures and views
• SQL is used to Create stored procedures in a Database
• SQL is used to Create views in a Database
What are the subsets of SQL?
i. Data Definition Language
ii. Data Manipulation Language
iii. Data Control Language