1. SQL Introduction
1. About SQL Tutorial
2. SQL Basic Overview
3. Query Language
4. Microsoft SQL Server
5. MySQL
6. Oracle Database
2. SQL Database User
1. SQL*Plus
2. Connect with System User
3. Create a new Database User
4. Log into new User
3. SQL Database
1. Create Database
2. Delete or Drop Database
3. Use Database
4. Create Database in SQL Server
5. Rename Database
4. SQL Table
1. Create table
2. Group By
3. Having
4. Exists
5. ANY and ALL
6. CASE Statement
7. Select Into
8. Alter Table
9. Create Table in SQL Server
10. Aliases
11. Between
12. IN
13. Delete or Drop table
14. Insert Data into table
15. Select Distinct
16. Select Top
17. Where Clause
18. AND, OR, NOT
19. Order By
20. Update Table
21. Order of execution of a Query
5. SQL Constraints
1. Constraints Introduction
2. Cascading referential integrity constraint
3. Auto Increment Field
4. Index
5. Default
6. Check
7. Foreign Key
8. Primary Key
9. Unique
10. Not Null
11. Identity Column in SQL Server
6. SQL Keywords
1. Keywords Introduction
7. SQL Data Types
1. Data Types Introduction
8. SQL Operators
1. Operators Introduction
9. SQL Wildcard Characters
1. Wildcard Introduction
2. Like
10. SQL Joins
1. Joins Introduction
2. Inner Join
3. Left Join
4. Right Join
5. Full Join
6. Self Join
7. Union
8. Cross Join
9. Advanced Join
11. SQL Aggregate Function
1. Introduction
2. Min
3. Max
4. Count
5. Avg
6. Sum
12. SQL Views
1. Views Introduction
2. Advantages of View
3. Updateable Views
4. Limitations of views
13. SQL Dates
1. Dates Introduction
14. SQL Stored Procedures
1. Stored Procedures Introduction
2. Advantages of Stored Procedures
3. Simple Store Procedure
4. Stored procedure with input parameters
5. Stored Procedure with OUTPUT Parameters
6. Alter Procedure
15. SQL Functions
1. Functions Introduction
2. Table Valued Functions
3. Scalar Valued Functions
4. Stored Procedure VS Function
5. Multi-Statement Table Valued Functions
6. Function WITH ENCRYPTION
7. Function WITH SCHEMABINDING
16. String Functions in SQL Server
1. Ascii()
2. Replace()
3. Patindex()
4. Space()
5. Replicate()
6. Function Real time Example
7. SubString()
8. CharIndex()
9. Right()
10. Left()
11. Len()
12. Reverse()
13. Upper()
14. Lower()
15. Rtrim()
16. Ltrim()
17. Char()
18. Stuff()
17. SQL Server Date Functions
1. ISDATE()
2. DAY()
3. MONTH()
4. YEAR()
5. DATENAME()
6. DATEPART()
7. DATEADD ()
8. DATEDIFF()
9. Real time Example
18. Other Functions in SQL Server
1. Cast()
2. Convert()
19. Mathematical Functions in SQL Server
1. Mathematical Functions in SQL
20. Temporary tables
1. Local Temporary tables
2. Global Temporary tables
21. Indexes
1. Clustered Index
2. Non Clustered Index
3. Unique Index
4. Advantages and disadvantages of indexes
22. SQL Server Trigger
1. Triggers in SQL Server
2. After update trigger
3. Instead of insert trigger
4. Instead of update triggers
5. Instead of delete trigger
6. Common table expression (CTE)
23. Backup and Restore
1. Backup in SQL Server
2. Database Restore
SQL