SQL Course Syllabus
1. SQL Introduction
1. About SQL Tutorial
2. SQL Basic Overview
3. Query Language
4. 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. Create Table in SQL Server
3. Delete or Drop table
4. Insert Data into table
5. Select Distinct
6. Select Top
7. Where Clause
8. Aliases
9. Update Table
10. AND, OR, NOT
11. IN
12. Between
13. Order By
14. Group By
15. Having
16. Exists
17. ANY and ALL
18. CASE Statement
19. Select Into
20. Alter Table
21. Order of execution of a Query
5. SQL Constraints
1. Constraints Introduction
2. Not Null
3. Unique
4. Primary Key
5. Foreign Key
6. Check
7. Default
8. Index
9. Auto Increment Field
10. Cascading referential integrity constraint
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. Char()
3. Ltrim()
4. Rtrim()
5. Lower()
6. Upper()
7. Reverse()
8. Len()
9. Left()
10. Right()
11. CharIndex()
12. SubString()
13. Function Real time Example
14. Replicate()
15. Space()
16. Patindex()
17. Replace()
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
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
Welcome to TOUQEER LEARNING SOLUTION'S, we have a commitment to deliver world-class IT & ES professional talent and staffing services to all our clients and world-class careers to our business professionals. Whether you are a business professional seeking your next career challenge or an organization seeking to source top-tier talent, explore our business disciplines below or contact us to find out how we can work together.
