Week 4 Viewing
Views. CREATE VIEW
. Views for Simplifying. Views for Aggregating. Temporary Views. CREATE TEMPORARY VIEW
. Common Table Expressions. Views for Partitioning. Views for Securing. Soft Deletions.
How to download lecture source code into Visual Studio Code
-
Log into cs50.dev.
-
In your terminal window, type
wget https://cdn.cs50.net/sql/2023/x/lectures/4/src4.zip
followed by Enter in order to download a Zip file of lecture’s source code into your codespace.
-
In your terminal window, type
unzip src4.zip
followed by Enter to unzip (i.e., decompress) that Zip file.
-
In your terminal window, type
cd src4
followed by Enter in order to “change directory” into that
src4
directory (i.e., folder). -
In your terminal window, type, e.g.,
ls
followed by Enter in order to see the files.