What Are SQL Views And How Can You Create Them?

In SQL, a view is an object on the database. It can help you simplify queries, improve security, allow for a layer of abstraction (leading to easier development), and more.
This video shows how to create a view in SQL and how to use it. The demonstration uses MySQL, but the SQL and concept also works in Oracle, SQL Server, and PostgreSQL (as well as other vendors that support views).

[OscarLopez-owsb]

Didn't know about SQL Views befores, now realized how useful they are. Thanks for sharing!

[michaelkoumpanis]

A View is just a saved SELECT statement in the Database --> That's what I wanted to hear!!! Thanks

[tharu]

Oh man, what a great explanation . This is so frikkin simple and easy to understand.I really appreciate this, thank u so much.

[GreenSlugg]

Thank you! I needed this for my class.

[magikjob]

thanks for a very simple and clear video

[danialsharifi]

You really make it very simple and clear. thank you.

[manduzera]

Simple and clean explanation! Thanks for sharing 😘

[YancenLi]

At first, I get lost when you say "Tyboos". Later I realized that you are talking about "Tables". Different accents are SO different in English just like the Chinese language. :D LOL

[tarvinder]

Thank u very much. Liked that the view is a saved sql query

[brendonkoum]

Wow, this is an amazing and efficienct explanation! Thank you!

[grantsmith]

Worked great for me. Thanks for the video!

[stoneage]

thanks for the demo, just a quick question, when people use Power BI or tableau, normally its connecting with the VIEW right ? If the tables are very big, does connect via the view = extracting all data of that(view, or table) from data warehouse and store them in laptop's memory ? that is why there are lots of performance issues ?

[bukvajzr]

thank you sir, its so fucking simple man after this

[OscarFromIndia]

Can you still create views if you have read-only access in oracle?

[tumelowaheng]

Did you have to have a flashing background