SQL

In this tutorial you will learn about SQL. Here you will get all the programs with explanations also you will get all MCQ question and answers for your examination also you will get all interview questions and answers chapterwise.

Share Syllabus 💰 Free 📅 Tuesday, July 23, 2024 at 8:28 PM

Module 1. SQL Introduction

🕐 00:00:00

1. About SQL Tutorial

Article 4 Questions

2. SQL Basic Overview

Article 11 Questions

3. Query Language

Article 2 Questions

4. Microsoft SQL Server

Article

5. MySQL

Article

6. Oracle Database

Article

Module 2. SQL Database User

🕐 00:00:00

1. SQL*Plus

Article

2. Connect with System User

Article

3. Create a new Database User

Article

4. Log into new User

Article

Module 3. SQL Database

🕐 00:00:00

1. Create Database in SQL Server

Article

2. Rename Database

Article

3. Create Database

Article 2 Questions

4. Delete or Drop Database

Article

5. Use Database

Article

Module 4. SQL Table

🕐 00:00:00

1. Select Distinct

Article

2. Select Top

Article

3. Where Clause

Article

4. AND, OR, NOT

Article

5. Order By

Article

6. Update Table

Article 1 Questions

7. IN

Article

8. Between

Article

9. Aliases

Article

10. Group By

Article

11. Having

Article

12. Exists

Article

13. ANY and ALL

Article

14. CASE Statement

Article

15. Select Into

Article

16. Alter Table

Article

17. Create Table in SQL Server

Article

18. Order of execution of a Query

Article

19. Create table

Article 2 Questions

20. Delete or Drop table

Article 1 Questions

21. Insert Data into table

Article

Module 5. SQL Constraints

🕐 00:00:00

1. Constraints Introduction

Article

2. Not Null

Article

3. Unique

Article 1 Questions

4. Primary Key

Article 1 Questions

5. Foreign Key

Article 1 Questions

6. Check

Article

7. Default

Article

8. Index

Article 5 Questions

9. Auto Increment Field

Article

10. Cascading referential integrity constraint

Article

11. Identity Column in SQL Server

Article 1 Questions

Module 6. SQL Keywords

🕐 00:00:00

1. Keywords Introduction

Article

Module 7. SQL Data Types

🕐 00:00:00

1. Data Types Introduction

Article

Module 8. SQL Operators

🕐 00:00:00

1. Operators Introduction

Article

Module 9. SQL Wildcard Characters

🕐 00:00:00

1. Wildcard Introduction

Article

2. Like

Article

Module 10. SQL Joins

🕐 00:00:00

1. Joins Introduction

Article 2 Questions

2. Inner Join

Article 1 Questions

3. Left Join

Article 2 Questions

4. Right Join

Article 2 Questions

5. Full Join

Article 1 Questions

6. Self Join

Article 1 Questions

7. Union

Article

8. Cross Join

Article

9. Advanced Join

Article

Module 11. SQL Aggregate Function

🕐 00:00:00

1. Introduction

Article

2. Min

Article

3. Max

Article

4. Count

Article

5. Avg

Article

6. Sum

Article

Module 12. SQL Views

🕐 00:00:00

1. Views Introduction

Article 1 Questions

2. Advantages of View

Article

3. Updateable Views

Article

4. Limitations of views

Article

Module 13. SQL Dates

🕐 00:00:00

1. Dates Introduction

Article

Module 14. SQL Stored Procedures

🕐 00:00:00

1. Stored Procedures Introduction

Article 3 Questions

2. Advantages of Stored Procedures

Article

3. Simple Store Procedure

Article

4. Stored procedure with input parameters

Article

5. Stored Procedure with OUTPUT Parameters

Article

6. Alter Procedure

Article

Module 15. SQL Functions

🕐 00:00:00

1. Functions Introduction

Article 4 Questions

2. Table Valued Functions

Article 1 Questions

3. Scalar Valued Functions

Article

4. Stored Procedure VS Function

Article

5. Multi-Statement Table Valued Functions

Article

6. Function WITH ENCRYPTION

Article

7. Function WITH SCHEMABINDING

Article

Module 16. String Functions in SQL Server

🕐 00:00:00

1. Ascii()

Article

2. Char()

Article

3. Ltrim()

Article

4. Rtrim()

Article

5. Lower()

Article

6. Upper()

Article

7. Reverse()

Article

8. Len()

Article

9. Left()

Article

10. Right()

Article

11. CharIndex()

Article

12. SubString()

Article

13. Function Real time Example

Article

14. Replicate()

Article

15. Space()

Article

16. Patindex()

Article

17. Replace()

Article

18. Stuff()

Article

Module 17. SQL Server Date Functions

🕐 00:00:00

1. ISDATE()

Article

2. DAY()

Article

3. MONTH()

Article

4. YEAR()

Article

5. DATENAME()

Article

6. DATEPART()

Article

7. DATEADD ()

Article

8. DATEDIFF()

Article

9. Real time Example

Article

Module 18. Other Functions in SQL Server

🕐 00:00:00

1. Cast()

Article

2. Convert()

Article

Module 19. Mathematical Functions in SQL Server

🕐 00:00:00

1. Mathematical Functions

Article

Module 20. Temporary tables

🕐 00:00:00

1. Local Temporary tables

Article

2. Global Temporary tables

Article

Module 21. Indexes

🕐 00:00:00

1. Clustered Index

Article

2. Non Clustered Index

Article

3. Unique Index

Article

4. Advantages and disadvantages of indexes

Article

Module 22. SQL Server Trigger

🕐 00:00:00

1. Triggers in SQL Server

Article

2. After update trigger

Article

3. Instead of insert trigger

Article

4. Instead of update triggers

Article

5. Instead of delete trigger

Article 1 Questions

6. Common table expression (CTE)

Article

Module 23. Backup and Restore

🕐 00:00:00

1. Backup in SQL Server

Article

2. Database Restore

Article

SQL

Sections: 23 Sub Sections: 129
Total MCQ: 0
Course Duration: 00:00:00
Language: Uncategorized

All Subjects