SQL TUTORIAL
SQL TUTORIAL
SQL stands for Structured Query Language, a standard programming language designed to manage, manipulate, and retrieve data stored in relational database management systems (RDBMS).
SQL Structured Query Language
➔ SQL commands are classified based on their functionality.
➔ Data Definition Language (DDL): Defines database structure (CREATE, ALTER, DROP).
➔ Data Manipulation Language (DML): Manages data within tables (INSERT, UPDATE, DELETE).
➔ Data Query Language (DQL): Retrieves data (SELECT).
➔ Data Control Language (DCL): Controls data access (GRANT, REVOKE).
➔ Transaction Control Language (TCL): Manages transactions (COMMIT, ROLLBACK).
SQL Example
SELECT * FROM Products;
Copy the code and try it out practically in your learning environment.
SQL Example
SELECT Customers.CustomerName, Orders.OrderID
FROM Customers
LEFT JOIN Orders
ON Customers.CustomerID=Orders.CustomerID
ORDER BY Customers.CustomerName;
Copy the code and try it out practically in your learning environment.
SQL Database
➔ Relational database management systems use Structured Query Language (SQL) to store and manage their data.
➔ Oracle, MS SQL Server, MySQL, or MS Access are the most popular examples of relational database management systems.
➔ An SQL table is the basic element of a relational database where data is primarily stored.