Create Database SQL Query |
Drop Database |
Select Databases – Use Database |
Create Table |
Drop Table |
Truncate Table in SQL |
Example of creating DB in SQL |
Insert Query in SQL |
Select Query in SQL |
Where Clause in SQL |
AND & OR Clauses in SQL |
Update Query in SQL |
Delete Query in SQL |
Like Clause in SQL |
Top Clause in SQL |
Order By / Sorting Results in SQL |
Group By in SQL |
Distinct Keyword in SQL |
SQL Constraints in SQL |
Joins in SQL |
Union Clause in SQL |
NULL Values in SQL |
Alias Syntax in SQL |
Indexes in SQL |
Alter Command in SQL |
Using Views in SQL |
Having Clause in SQL |
SQL Transactions in SQL |
Wildcards in SQL |
Date Functions in SQL |
Temporary Tables in SQL |
Sub Queries In SQL |
Using Sequences in SQL |
Handling Duplicates in SQL |
SQL Injection in SQL |
Normalization in SQL |