SQL Tutorial Index 

1.1 Relational Database Management Systems
1.2 SQL
1.3 Data Definition Language(DDL)
1.4 Data Manipulation Language(DML)
1.5 Data Control Language(DCL)
2.1 Creating Database
2.2 Creating Table in SQL
2.2.1 Schema
2.2.2 Data Types
2.2.3 Keys & Constraints
2.2.4 Create a table
2.2.5 View table structure


SQL Tutorial - 2
3.1 Alter a table
3.1.1 Renaming a table
3.1.2 Renaming a column
3.1.3 Changing a Column's Datatype
3.1.4 Adding a Constraint
3.1.5 Removing a Constraint
3.1.6 Adding a column
3.1.7 Removing a column
3.1.8 Dropping a table
4.1 Inserting Data into a Table
4.1.1 Adding Rows of data
5.1 Creating multiple table
5.1.1 Normalization
5.2.1 Database Design
5.2.2 Keys
5.2.3 Primary Keys
5.2.4 Foreign Keys
5.2.5 Creating Multiple Tables


SQL Tutorial - 3
6 Operator/ Clause/ Function
6.1 Select
6.2 Distinct
6.3 Where
6.4 Like
6.5 Between
6.6 In & Not in
6.7 Order by
6.8 Limit
6.9 Offset
6.10 Group by
6.11 Describe
6.12 Case
6.13 Aliases
6.14 Top
6.15 And & Or
7 Function
7.1 Aggregate Function
7.2 Windows Function
7.2.1 Aggregate Function as Windows Function
7.2.2 Ranking Windows Function
7.2.3 Positional Windows Function


8 View
8.1 Creating View
8.2 Deleting View
9 Stored Procedure
10 Date Time Functions (36 functions)