#09. View Table (Table views in SQL)
In today's lesson, we'll look at working with table views in SQL. The so-called View or View Table.
Video timestamps:
00:00 Introduction
00:10 Select in relation to a view
00:27 The difference between a View Table and regular tables
01:31 Creating a View Table
03:29 Modifying and deleting existing views
04:35 Using views
07:18 Disadvantages of using views
08:50 Modifiable views
10:02 Materialized views
The SQL commands mentioned in the video are available at the link: https://pastebin.com/yxEDeGUg
Suggest a new topic for the video: https://vdsr7ufo2in.typeform.com/to/H...
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Also, a reminder. Within the framework of this course, there is a group in Telegram, in which I answer all questions of participants online, help them during the training.
Entry to the group is free, via the invitation link (indicated below). There are currently no restrictions on the number of participants.
In the specified group, ask absolutely any questions, within the framework of our training. Watched the video, tried to repeat. It turned out great. Something did not work out, write a question in the group. I will answer everyone and help.
Link to the group in Telegram: https://t.me/joinchat/LlHDMBmN0SAxM5_...
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
★ Dear friends! If you like what I do and you want to support the project financially, link: https://www.donationalerts.com/r/exce...
★ Let's be friends:
Facebook | / excelstore.pro
Vkontakte | https://vk.com/ExcelStore
Telegramm | https://t.me/ExcelStore
#SQLTraining #SQLCourses #SQLLessons #CookMaxim #ExcelStore