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

#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

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

3.SQL SERVER IN Telugu-----

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

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

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

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

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

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

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

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

20.How to Create a View in SQL Server

Learners Home Page

SQL server Telugu Tutorials

Big Data Tools Tutorials in Tutorials

Tableau Tutorials in Telugu

Complete Advance Excel Tutorials in Telugu

Stock Edge - Stock market Scanner & Analyzer Telugu

SHAREPOINT Introduction Tutorial IN Telugu | SHAREPOINT Beginners Tutorials

What is Database and How to Create/Drop Database in SQL?

Data Analysis Tool in Excel

SIX SIGMA IN TELUGU |SIX SIGMA QUALITY TOOLS | DMADV |DMAIC

EXCEL IN TELUGU: IMPORT DATA FROM SQL TO EXCEL

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

Excel Formula Auditing in Telugu

Pareto Chart Analysis Excel in Telugu

Big Data Tool R Installation in Telugu

Tableau Public in Telugu

[Abdulruba]

Amazing Explanation bro.. Very useful Content from You ♥️

[kotaarun]

keep doing sir it is more help full to us Tq sir it is very simple to understand 😊

[gouthamganesh]

Nice Video Sir a, More Usefull for me

[gouthamganesh]

Keep Doing Sir we Will will support You Sure

[maheshlingampalli]

bro function and triggers and cursor
medha video cheyadii bro
in sql server

[siddhartharao]

Sir. DML operations support cheyadhu Multiple views lo annaru kada.. Endukani support cheyadhu?

[saiprasadpappula]

how to insert 100 different records at a time with SP plz tell me sir

[NaveenKumar-fqsb]

bro what about clusterd view and non clusted vie????

[kavithareddy]

SQL server application is separate power bi desktop is separate aa pls reply