SQLBeginner#fundamentals

What is SQL?

Structured Query Language, the standard language for defining, manipulating and querying data in relational databases. It covers DDL (CREATE/ALTER/DROP), DML (INSERT/UPDATE/DELETE), DQL (SELECT), DCL (GRANT/REVOKE) and TCL (COMMIT/ROLLBACK).

Example
CREATE TABLE students (id INT PRIMARY KEY, name VARCHAR(50));
INSERT INTO students VALUES (1, 'Anu');
SELECT * FROM students;

Related Questions

1
SQLBeginner#fundamentals

What is the difference between DBMS and RDBMS?

Open
2
SQLBeginner#ddl#dml

Difference between DELETE, TRUNCATE and DROP?

Open
3
SQLIntermediate#joins

Explain all types of JOIN with an example.

Open