SQL tutorial for beginners and professionals with examples on Basics, Structured, Programming, Language, Syntax, Database, Clauses, database concepts, SQL Syntax, SELECT, INSERT, DELETE, UPDATE, DROP, TRUNCATE, DISTINCT, ORDER BY, GROUP BY, WHERE and more.
SQL Tutorial:
-
- SQL Syntax
- SQL data type
- SQL operators
- SQL CREATE Database
- SQL SHOW Database List
- SQL SELECT Database
- SQL DROP Database
- SQL CREATE Table
- SQL ALTER Table
- SQL COPY Table
- SQL RENAME Table
- SQL DROP Table
- SQL DELETE from table
- SQL TRUNCATE Table
- SQL CONSTRAINTS
- SQL PRIMARY KEY Constraint
- SQL FOREIGN KEY
- SQL NOT NULL Constraint
- SQL UNIQUE Constraint
- SQL INDEX Constraint
- SQL INSERT statement
- SQL UPDATE statement
- SQL SELECT statement
- SQL UNIQUE keyword
- SQL DISTINCT keyword
- SQL SELECT TOP
- SQL SELECT IN Operator
- SQL NOT IN Operator
- SQL BETWEEN Operator
- SQL NOT BETWEEN Operator
- SQL ALIAS Statement
- SQL WHERE Clause
- SQL AND Clause
- SQL OR Clause
- SQL UNION Operator
- SQL LIKE operator
- SQL ORDER BY Clause
- SQL GROUP BY clause
- SQL HAVING clause
- SQL JOIN clause
- SQL INNER JOIN
- SQL LEFT OUTER JOIN
- SQL RIGHT OUTER JOIN
- SQL FULL OUTER JOIN
- SQL SELF JOIN
- SQL CARTESIAN JOIN
- SQL Functions
SQL interview questions: