Based on how the view is constructed and the techniques that are allowed for accessing the view data, there are four sorts of views. Database Views, Projection Views, Maintenance Views, and Helps Views are the four types.
Only views with the same owner as the relevant table or tables can have indexes generated. An intact ownership-chain between the view and the table is also known as this (s). When a table and a view are both part of the same schema, the same schema-owner applies to all of the schema's objects.
Views have a benefit over tables in that they can represent a subset of the data in a table. As a result, a view can limit the extent to which the underlying tables are exposed to the outside world: a user may be allowed to query the view but not the remainder of the base database.
SQL Server examines the code in the view BEFORE dealing with the WHERE clause or any joins in the outer query when processing a SELECT from a view. When more tables are combined, it will take longer to get the same results as a SELECT from base tables.
Views make it easier to create queries, but they don't increase query performance.
Very Good trainer
you guys are doing nice job. thanks
Not too much interactive
Well Explained in Every Chapters..
GAJANAN DIGAMBAR MODE
very easy to understand SQL its was dream to learn SQL. Thanx for Learnvern
Why you didn't teach/learn how to write select query, even you shared 15 question for practice :(
I have found the course to be interesting with plenty of valuable information provided as part of the course and through interaction with fellow teachers and trainers from a wide range of disciplines
Share a personalized message with your friends.