SQL (Structured Query Language) is a widely used programming language designed for managing relational databases. It provides a standardized way to interact with databases, allowing users to create, retrieve, update, and delete data stored in tables. SQL offers powerful features such as querying data using various conditions, aggregating data, joining multiple tables, and defining relationships between tables through primary and foreign keys. It is known for its declarative nature, where users specify what data they want, and the database engine determines the most efficient way to retrieve it.
📌 𝐃𝐃𝐋 - Used to create, modify and delete database objects like tables, databases, and views but not data.
📌 𝐃𝐌𝐋 - Used to add, remove or modify data from database tables
📌 𝐃𝐂𝐋 - commands include GRANT (provide access privileges) and REVOKE (remove access privileges).
📌 𝐓𝐂𝐋 - Transactions are a group of tasks that execute as a single unit. Each transaction begins with a specific task and ends when all the tasks in the group successfully complete. If any of the tasks fail, the transaction fails. Therefore, a transaction has only two results: success or failure.
📌 𝐃𝐐𝐋 - SELECT used to fetch or view data from the database
