Subsets of SQL

Data Control Language

by
Data Control Language

Data Control Language commands (Grant, Revoke, and Deny) are used for access control and permission management for users in the database. Data Control Language (DCL): These SQL commands are used to implement security on database objects like table, view, stored procedure etc. DCL commands are used to enforce database security in a multiple user database … Read more

Introduction to SQL

by
Introduction to SQL

Introduction to SQL, What is SQL, Purpose of SQL, Who should learn SQL?, Subsets of SQL, SQL Language Elements, and SQL Environment Setup. Introduction to SQL 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. … Read more