Signing you in…

Views and Materialized Views

Views: virtual tables for clean code

Imagine that for a simple sales report you need to write JOINs on several tables each time - for example, orders, users and products. It's tedious, it's easy to make mistakes in connection conditions and duplicate the same logic in different reports. A View is a named query stored in the database directory: you access it as a table, and the DBMS substitutes the view definition and executes it.

Content is available with subscription.
Get full access to all courses on the platform for one year with a single payment.
Unlike other platforms that charge per course, here you get everything for one price, and after one year of use there will be no automatic charge for the following year.