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
  1. Log into cs50.dev.

  2. 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.

  3. In your terminal window, type

    unzip src4.zip
    

    followed by Enter to unzip (i.e., decompress) that Zip file.

  4. In your terminal window, type

    cd src4
    

    followed by Enter in order to “change directory” into that src4 directory (i.e., folder).

  5. In your terminal window, type, e.g.,

    ls
    

    followed by Enter in order to see the files.