CS50 2019 - Lecture 7 - SQL

Описание: TABLE OF CONTENTS

00:00:00 - Introduction
00:01:22 - favorites.py
00:19:08 - SQLite
00:23:40 - Relational Databases
00:38:45 - IMDb
00:47:37 - import.py
00:51:41 - shows.csv
00:59:55 - title.basics.tsv
01:13:44 - import4.py
01:24:32 - shows.db
01:25:01 - DB Browser
01:39:10 - Race Conditions
01:42:57 - SQL Injection Attacks

TOPICS

SQL
Tables
Types
Statements
Constraints
Indexes
Keywords, Functions
Transactions
Race Conditions
SQL Injection Attacks

***

This is CS50, Harvard University's introduction to the intellectual enterprises of computer science and the art of programming. Demanding, but definitely doable. Social, but educational. A focused topic, but broadly applicable skills. CS50 is the quintessential Harvard course.

FALL 2019

   • CS50 Lectures 2019  

***

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  
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
[email protected]