CS50 2020 - Lecture 7 - SQL скачать в хорошем качестве

CS50 2020 - Lecture 7 - SQL

TABLE OF CONTENTS 00:00:00 - Introduction 00:00:49 - Data 00:01:34 - Spreadsheets 00:08:50 - Flat-File Databases 00:10:53 - CSV Files 00:11:44 - favorites.py 00:21:05 - Data Cleaning 00:23:06 - sorted 00:47:03 - Lambda Functions 00:56:49 - Relational Databases 00:57:55 - SQLite 01:04:54 - SQL 01:05:04 - CRUD 01:09:17 - SELECT 01:12:49 - DISTINCT 01:14:55 - LIKE 01:17:37 - ORDER BY 01:18:49 - GROUP BY 01:26:42 - INSERT 01:31:44 - UPDATE 01:32:36 - DELETE 01:33:57 - Relational Data 01:37:55 - Data Types 01:38:40 - Constraints 01:39:46 - PRIMARY KEY 01:41:09 - FOREIGN KEY 01:42:59 - CS50 Library 01:44:35 - Many-to-Many Relationships 02:05:00 - IMDb 02:12:45 - Indexes 02:15:11 - JOINs 02:20:34 - SQL Injection 02:26:02 - Race Conditions 02:32:00 - Race Conditions (Demo) *** This is CS50, Harvard University's introduction to the intellectual enterprises of computer science and the art of programming. *** HOW TO SUBSCRIBE http://www.youtube.com/subscription_c... HOW TO TAKE CS50 edX: https://cs50.edx.org/ Harvard Extension School: https://cs50.harvard.edu/extension Harvard Summer School: https://cs50.harvard.edu/summer OpenCourseWare: https://cs50.harvard.edu/x HOW TO JOIN CS50 COMMUNITIES Discord:   / discord   Ed: https://cs50.harvard.edu/x/ed Facebook Group:   / cs50   Faceboook Page:   / cs50   GitHub: https://github.com/cs50 Gitter: https://gitter.im/cs50/x Instagram:   / cs50   LinkedIn Group:   / 7437240   LinkedIn Page:   / cs50   Reddit:   / cs50   Quora: https://www.quora.com/topic/CS50 Slack: https://cs50.edx.org/slack Snapchat:   / cs50   Twitter:   / cs50   YouTube:    / cs50   HOW TO FOLLOW DAVID J. MALAN Facebook:   / dmalan   GitHub: https://github.com/dmalan Instagram:   / davidjmalan   LinkedIn:   / malan   Quora: https://www.quora.com/profile/David-J... Twitter:   / davidjmalan   *** CS50 SHOP https://cs50.harvardshop.com/ *** LICENSE CC BY-NC-SA 4.0 Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International Public License https://creativecommons.org/licenses/... David J. Malan https://cs.harvard.edu/malan malan@harvard.edu