20.SQL Server View in Telugu || How to Create VIEW in SQL

Опубликовано: 09 Июль 2026
на канале: Learners Page

20,245

535

#SQLINTELUGU #VIEW #SQLVIEW #SQLVIEWINTELUGU #SSISintelugu #TABLEAUINTELUGU #Learnerspage #Ckola #Chandrasekkhar #SQL #Telugu

TYPES OF VIEWS:
1) SIMPLE VIEW:
2) COMPLEX VIEW
SIMPLE VIEWS IN SQL:
VIEW IS VIRTUAL / LOGICAL TABLE FOR THE BASE TABLE.
WILL NOT STORE DATA BUT SELECT QUERY STATEMENT IS ONLY STORE.
IT WILL CREATE WITH HELP OF "SELECT STATEMENT" .

COMPLEX VIEW:
WHEN WE ACCESS THR REQ.DATA FROM MULTIPLE BASE TABLES.
IT DOES NOT SUPPORTS ALL DML OPERATIONS ON MULTIPLE BASE TABLES.
IT Also Called as Nonupdatable View

Advantages of views in SQL Server
1.Hiding the complexity of a Complex SQL Query
2.Implementing Row Level Security
3.Implementing Column Level Security
4.Presenting the Aggregated data by Hiding Detailed data

The disadvantage of views in SQL Server
1.The Views cannot be created based on Temporary Tables in SQL Server
2.We cannot pass parameters to SQL Server views
3.We cannot associate Rules and Defaults with SQL Server views

Follow us on https://t.me/Learnerspage

1SQL: What is Database and How to Create/Drop Database in SQL?-----    • 1SQL: What is Database and How to Create/D...

2. SQL in Telugu: SQL Server Installation-----
   • 2. SQL in Telugu: SQL Server Installation

3.SQL SERVER IN Telugu-----
   • 3.SQL SERVER IN Telugu

4 SQL in Telugu:How to Import Data to SQL Server-----    • 4 SQL in Telugu:How to Import Data to SQL ...

5.SQL IN TELUGU :Literal string ,Arithmetic Expressions & IS NULL FUNCTION-----    • 5.SQL IN TELUGU :Literal string ,Arithmeti...

6.SQL in Telugu: DRL Select Alias Column Data-----    • 6.SQL in  Telugu: DRL -Select- Alias Colum...

7. How to take Database/Table Backup in SQL SERVER Script (Telugu)-----    • 7. How to take Database/Table  Backup in S...

8.SQL SERVER WHERE Clause in Telugu-----
   • 8.SQL SERVER WHERE Clause in Telugu
9.SQL Server: Insert Data Into Table |Copy Table Data| Clone Tabel (Telugu)-----
   • 9.SQL Server: Insert Data Into Table |Copy...

10.SQL for Beginners in Telugu || SQL UPDATE Statement || SQL Tutorial ||-----
   • 10.SQL for Beginners in Telugu || SQL UPDA...
11.Delete Dupicate Records in SQL Server Telugu || How to Find Dupicate Records in SQL /Mysql/oracle-----
   • 11.Delete Dupicate Records in SQL Server T...

12.SQL Server Interview Questions & Answers-----    • 12.SQL Server Interview Questions & Answers

13.Merge Statement in SQL Telugu | How to Merge Statements in SQL | Learners Page-----
   • 13.Merge Statement in SQL Telugu | How to ...

14.Delete vs Drop vs Truncate Sql Server in Telugu-----    • 14.Delete vs Drop vs Truncate Sql Server i...

15.How to change font size in sql server management studio? SQL in Telugu-----
   • 15.How to change font size in sql server m...

16.Difference between NOT IN vs != in SQL server statements | SQL in Telugu-----
   • 16.Difference between NOT IN vs !=  in SQL...

17.How to Use ROLLBACK (UNDO) & TRUNCATE /DROP SQL SERVER in Telugu-----
   • 17.How to Use ROLLBACK (UNDO) & TRUNCATE /...

18.Varchar Vs nVarchar || ascii vs unicode || insert multi languages data ||SQL IN TELUGU-----
   • 18.Varchar Vs nVarchar  || ascii vs unicod...

19.Restore Database in SQL || Telugu-----
   • 19.Restore Database in  SQL || Telugu

20.How to Create a View in SQL Server
   • 20.SQL Server View in Telugu || How to Cre...

Learners Home Page
   / @learnerspage

SQL server Telugu Tutorials
   • 1SQL: What is Database and How to Create/D...

Big Data Tools Tutorials in Tutorials
   • 2.Tableau  in Telugu: Import data from Exc...

Tableau Tutorials in Telugu
   • 12.Tableau in Telugu: How to Create Top 10...

Complete Advance Excel Tutorials in Telugu
   • Excel in Telugu: Population Pyramid Chart

Stock Edge - Stock market Scanner & Analyzer Telugu
   • Stock Edge - Stock market Scanner & Analyz...

SHAREPOINT Introduction Tutorial IN Telugu | SHAREPOINT Beginners Tutorials
   • SHAREPOINT Introduction Tutorial  IN Telug...

What is Database and How to Create/Drop Database in SQL?
   • 1SQL: What is Database and How to Create/D...

Data Analysis Tool in Excel
   • Data Analysis Tool in Excel

SIX SIGMA IN TELUGU |SIX SIGMA QUALITY TOOLS | DMADV |DMAIC
   • SIX SIGMA IN TELUGU |SIX SIGMA QUALITY TOO...

EXCEL IN TELUGU: IMPORT DATA FROM SQL TO EXCEL
   • EXCEL  IN TELUGU:  IMPORT DATA  FROM SQL T...

PIVOT TABLE IN తెలుగు
   • PIVOT TABLE IN  తెలుగు
R Programming in Telugu:How to Write CVS files and Extract Data from data.[Lesson-3]
   • R Programming in Telugu:How to Write CVS f...

Excel Formula Auditing in Telugu
   • Excel Formula Auditing in Telugu

Pareto Chart Analysis Excel in Telugu
   • Pareto Chart Analysis Excel in Telugu

Big Data Tool R Installation in Telugu
   • Big Data Tool R Installation in Telugu

Tableau Public in Telugu
   • 6.Tableau Public in Telugu