CREATE VIEW Statement (SQL) - Creating Virtual Tables
In SQL, the CREATE VIEW statement creates a virtual table based on the results of a SQL statement. One reason for creating views is to prevent unauthorized access to data. We can grants users access to the view, instead of an entire table. This video also covers the DROP VIEW statement.
Видео CREATE VIEW Statement (SQL) - Creating Virtual Tables канала Cody Baldwin
Видео CREATE VIEW Statement (SQL) - Creating Virtual Tables канала Cody Baldwin
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Introduction to Database Normalization
Introduction to Entity Relationship Diagrams (ERDs)
Introduction to the Snowflake & Star Schemas
Cleaning Strings (SQL) - LEFT, RIGHT, TRIM, UPPER, LOWER, CONCAT
CAST Function (SQL) - Converting Data Types
Working with Dates (SQL) - EXTRACT, DATE_PART, DATE_TRUNC, DATEDIFF
Introduction to Robotic Process Automation (RPA)
Introduction to Process Mining
Introduction to Machine Learning
Introduction to Big Data
Introduction to Data Warehouses
Introduction to Cloud Computing
CREATE TABLE Statement (SQL) - Creating Database Tables
CREATE INDEX Statement (SQL) - Creating New Database Indexes
WHERE Clause (SQL) - Filtering Records
SQL Query Optimization - Tips for More Efficient Queries
UNION Operator (SQL) - Combining Results (UNION, UNION ALL)
Window Functions in SQL - Performing Calculations across Rows
LAG and LEAD Functions (SQL) - Accessing Data in Other Rows
Introduction to Joins (SQL) - Combining Data (INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN)