-
SQL Introduction
-
Database Overview
-
Creating a Database
-
Dropping a Database
-
Table Fundamentals
-
Table Types
-
Datatypes in SQL
-
DDL, DML, TCL & DCL
-
Null & Not Null Values
-
Creating Tables
-
SQL - Constraints
-
SQL - Index
-
SQL Inserting Data
-
SQL Identity Columns
-
Selecting Data
-
Using Distinct
-
SQL in NOT IN
-
Using Top Clause
-
Where Clause
-
Group By
-
Order By
-
Having
-
Exists
-
Offset
-
SQL - Operators
-
Between
-
Update
-
Delete
-
SQL - Aggregate Functions
-
SQL - Introductions to Joins
-
Table Alias
-
SQL - Inner Join
-
SQL - Left Join
-
SQL - Right Join
-
Full Join
-
Self Join
-
SQL Union
-
Pivot
-
Alter Command
-
Limit Clause
-
Truncate
-
Drop
-
Table Backup
-
SQL - Normalization
-
Subquery
-
SQL - Views & Materialized Views
-
Case Statement
-
SQL Transactions
-
SQL - Scaler Functions
-
Working with Dates
-
Grant revoke
-
SQL - Performance Tunning
-
Stored Procedure Basics
-
Stuff function
-
Keyword
-
SQL - Miscellaneous