-
Book Overview & Buying
-
Table Of Contents
Microsoft Certified Azure Data Fundamentals (Exam DP-900) Certification Guide
By :
There are components in a relational database that are important to maintain the organization and productivity. The four most common components among database systems are as follows:
Let’s take a look at each of them in detail in the following sections.
A view can be considered a virtual table because it is composed of rows and columns of data, the results of a SELECT SQL instruction in one or more database tables. Views are great resources for organizing information from different tables to create reports.
The following is a view example, with the name High_price_products, which is constructed with a SELECT statement in the PRODUCTS table, filtering the Price field by the average greater than that of the other products in the table:
CREATE VIEW [High_price_products] AS
SELECT Product_Name, Product_Price
FROM Products
WHERE Product_Price > (SELECT AVG(Product_Price...