SQL Tutorial

• What is SQL
• SQL Syntax
• SQL Data Types
• SQL Operators

SQL Database

• SQL CREATE Database
• SQL DROP Database
• SQL RENAME Database
• SQL SELECT Database

SQL Table

• What is Table
• SQL CREATE TABLE
• SQL DROP TABLE
• SQL DELETE TABLE
• SQL RENAME TABLE
• SQL TRUNCATE TABLE
• SQL COPY TABLE
• SQL TEMP TABLE
• SQL ALTER TABLE

SQL Select

• SELECT Statement
• SQL SELECT UNIQUE
• SQL SELECT DISTINCT
• SQL SELECT COUNT
• SQL SELECT TOP
• SQL SELECT FIRST
• SQL SELECT LAST
• SQL SELECT RANDOM
• SQL SELECT AS
• SQL SELECT IN
• SQL SELECT Multiple
• SQL SELECT DATE
• SQL SELECT SUM
• SQL SELECT NULL

SQL Clause

• SQL WHERE
• SQL AND
• SQL OR
• SQL WITH
• SQL AS

SQL Order By

• ORDER BY Clause
• ORDER BY ASC
• ORDER BY DESC
• ORDER BY RANDOM
• ORDER BY LIMIT
• ORDER BY Multiple Cols

SQL Insert

• INSERT Statement
• INSERT INTO Values
• INSERT INTO SELECT
• INSERT Multiple Rows

SQL Update

• UPDATE Statement
• SQL UPDATE JOIN
• SQL UPDATE DATE

SQL Delete

• DELETE Statement
• SQL DELETE TABLE
• SQL DELETE ROW
• SQL DELETE All Rows
• DELETE Duplicate Rows
• SQL DELETE DATABASE
• SQL DELETE VIEW
• SQL DELETE JOIN

SQL Join

• SQL JOIN
• SQL Outer Join
• SQL Left Join
• SQL Right Join
• SQL Full Join
• SQL Cross Join

SQL Keys

• Primary Key
• Foreign Key
• Composite Key
• Unique Key
• Alternate Key

Difference

• SQL vs NoSQL
• IN vs EXISTS
• Group By vs Order By
• WHERE vs HAVING
• Where condition in SQL

SQL Injection

• SQL Injection

Misc

• SQL Formatter
• SQL group by
• SQL add/drop/update column operation
• SQL CAST Function
• SQL Comments
• SQL CONCAT Function
• CTE SQL
• How to use distinct in SQL
• Joining Three or More Tables in SQL
• What is Web SQL
• How to create functions in SQL
• How to run SQL Script
• How to Delete Duplicate Rows in SQL
• Nth Highest salary
• 12 Codd's Rules
• SQL EXCEPT
• Types of SQL JOIN

SQL MCQ

• SQL MCQ

PL/SQL Tutorial

• PL/SQL Tutorial

Interview

• SQL Interview
• PL/SQL Interview