CS50 SQL - Lecture 4 - Viewing

***

This is CS50, Harvard University's introduction to the intellectual enterprises of computer science and the art of programming.

***

TABLE OF CONTENTS

00:00:00 - Introduction
00:00:17 - Views
00:06:18 - Simplifying
00:21:15 - Aggregating
00:32:58 - Temporary Views
00:38:49 - Common Table Expressions
00:44:28 - Partitioning
00:53:10 - Securing
01:00:22 - Triggers with Views

***

HOW TO SUBSCRIBE

HOW TO TAKE CS50

HOW TO JOIN CS50 COMMUNITIES

HOW TO FOLLOW DAVID J. MALAN

***

CS50 SHOP

***

LICENSE

CC BY-NC-SA 4.0
Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International Public License

David J. Malan

[Mohamed-edro]

Carter!! you are a great man thank you for this legendary explaination .

[nadiasemprini]

Following you from Italy! A great fan of yours, Carter!!! _

[francisco_ponce]

Seeing that this video doesn't have those many views that it should its mind blowing, specially cuz many people want to learn SQL and then they do what?

[ahmedshakkhor]

I have to write almost the same for CTE compared to multiple joins and sub-querying.
Why should I then use CTE?
TIA. <3

[ahmedshakkhor]

What If we just delete from the underlying table and not from the view?
Is creating triggers necessary?

[КонстантинКонашенков-иф]

I hope that whoever is watching it understands that 3 selects (1 select over created view + 1 select over a temp view + 1 over a view) is not not good from Performance perspective.

[el.elenaaa]

Does anyone know how to register for CS50 classes so that I could attend through zoom? And do they provide certificates ?

[aidanthompson]

A view is a SQL script stored inside a DB

[DimitarRad]

syntax BEGIN...END doesnt work in postgres as it been shown in this video

[superfreiheit]

People need to realize that a View is not a table stored inside the DB. Its rather a SQL script stored inside a DB.