SQL Tutorial 11: Create Views

Publié le: 04 mai 2015
sur la chaîne: Jerry Esperanza

1,275

View is another object that you could store in database.

As pre-cursor in preparing reports, view is an effective simplified table from SELECT JOINed query. You don’t need to re-execute a SELECT JOIN that you have defined in the past. Once you have set the correct join, save it on a view.

This video tutorial shows on how to create views from given SELECT LEFT JOINs. You may see the structure of a view as if you are describing a table. You can distinguish view from other objects inside a database as you list it with tables.

It also shows the work around on how to sort in a specified ORDER BY clause and save it on a view. Normally, view does not accept script with an order by.

It includes on how to join table with itself by simply setting up a different alias name.

Sur cette page du site, vous pouvez voir la vidéo en ligne SQL Tutorial 11: Create Views durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur Jerry Esperanza 04 mai 2015, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 1,275 fois et il a aimé 5 téléspectateurs. Bon visionnage!

994