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.

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 💰 2024-07-23 👁 718

1. A About SQL Tutorial

      Article 4 Questions

2. S SQL Basic Overview

      Article 11 Questions

3. Q Query Language

      Article 2 Questions

4. M Microsoft SQL Server

      Article

5. M MySQL

      Article

6. O Oracle Database

      Article

1. S SQL*Plus

      Article

2. C Connect with System User

      Article

3. C Create a new Database User

      Article

4. L Log into new User

      Article

1. C Create Database in SQL Server

      Article

2. R Rename Database

      Article

3. C Create Database

      Article 2 Questions

4. D Delete or Drop Database

      Article

5. U Use Database

      Article

1. S Select Distinct

      Article

2. S Select Top

      Article

3. W Where Clause

      Article

4. A AND, OR, NOT

      Article

5. O Order By

      Article

6. U Update Table

      Article 1 Questions

7. I IN

      Article

8. B Between

      Article

9. A Aliases

      Article

10. G Group By

      Article

11. H Having

      Article

12. E Exists

      Article

13. A ANY and ALL

      Article

14. C CASE Statement

      Article

15. S Select Into

      Article

16. A Alter Table

      Article

17. C Create Table in SQL Server

      Article

18. O Order of execution of a Query

      Article

19. C Create table

      Article 2 Questions

20. D Delete or Drop table

      Article 1 Questions

21. I Insert Data into table

      Article

1. C Constraints Introduction

      Article

2. N Not Null

      Article

3. U Unique

      Article 1 Questions

4. P Primary Key

      Article 1 Questions

5. F Foreign Key

      Article 1 Questions

6. C Check

      Article

7. D Default

      Article

8. I Index

      Article 5 Questions

9. A Auto Increment Field

      Article

10. C Cascading referential integrity constraint

      Article

11. I Identity Column in SQL Server

      Article 1 Questions

1. K Keywords Introduction

      Article

1. D Data Types Introduction

      Article

1. O Operators Introduction

      Article

1. W Wildcard Introduction

      Article

2. L Like

      Article

1. J Joins Introduction

      Article 2 Questions

2. I Inner Join

      Article 1 Questions

3. L Left Join

      Article 2 Questions

4. R Right Join

      Article 2 Questions

5. F Full Join

      Article 1 Questions

6. S Self Join

      Article 1 Questions

7. U Union

      Article

8. C Cross Join

      Article

9. A Advanced Join

      Article

1. I Introduction

      Article

2. M Min

      Article

3. M Max

      Article

4. C Count

      Article

5. A Avg

      Article

6. S Sum

      Article

1. V Views Introduction

      Article 1 Questions

2. A Advantages of View

      Article

3. U Updateable Views

      Article

4. L Limitations of views

      Article

1. D Dates Introduction

      Article

1. S Stored Procedures Introduction

      Article 3 Questions

2. A Advantages of Stored Procedures

      Article

3. S Simple Store Procedure

      Article

4. S Stored procedure with input parameters

      Article

5. S Stored Procedure with OUTPUT Parameters

      Article

6. A Alter Procedure

      Article

1. F Functions Introduction

      Article 4 Questions

2. T Table Valued Functions

      Article 1 Questions

3. S Scalar Valued Functions

      Article

4. S Stored Procedure VS Function

      Article

5. M Multi-Statement Table Valued Functions

      Article

6. F Function WITH ENCRYPTION

      Article

7. F Function WITH SCHEMABINDING

      Article

1. A Ascii()

      Article

2. C Char()

      Article

3. L Ltrim()

      Article

4. R Rtrim()

      Article

5. L Lower()

      Article

6. U Upper()

      Article

7. R Reverse()

      Article

8. L Len()

      Article

9. L Left()

      Article

10. R Right()

      Article

11. C CharIndex()

      Article

12. S SubString()

      Article

13. F Function Real time Example

      Article

14. R Replicate()

      Article

15. S Space()

      Article

16. P Patindex()

      Article

17. R Replace()

      Article

18. S Stuff()

      Article

1. I ISDATE()

      Article

2. D DAY()

      Article

3. M MONTH()

      Article

4. Y YEAR()

      Article

5. D DATENAME()

      Article

6. D DATEPART()

      Article

7. D DATEADD ()

      Article

8. D DATEDIFF()

      Article

9. R Real time Example

      Article

1. C Cast()

      Article

2. C Convert()

      Article

1. M Mathematical Functions in SQL

      Article MCQ 1 Questions

1. L Local Temporary tables

      Article

2. G Global Temporary tables

      Article

1. C Clustered Index

      Article

2. N Non Clustered Index

      Article

3. U Unique Index

      Article

4. A Advantages and disadvantages of indexes

      Article

1. T Triggers in SQL Server

      Article

2. A After update trigger

      Article

3. I Instead of insert trigger

      Article

4. I Instead of update triggers

      Article

5. I Instead of delete trigger

      Article 1 Questions

6. C Common table expression (CTE)

      Article

1. B Backup in SQL Server

      Article

2. D Database Restore

      Article

Course Reviews

.$subject_description.SQL

  •  Course Language: Uncategorized
  •  Skill Level: Beginner
  •  Course Duration: 00:00:00 (HH:MM:SS)
  •  Sections: 23    Sub Sections: 129
  •  Total MCQ: 0    Total Questions: 52


All Subjects

  •   SQL  SQL