CS50 2019 - Lecture 7 - SQL

From the creator

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 https://www.youtube.com/playlist?list=PLhQjrBD2T381L3iZyDTxRwOBuUt6m1FnW *** HOW TO SUBSCRIBE http://www.youtube.com/subscription_center?add_user=cs50tv 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: https://discord.gg/T8QZqRx Ed: https://cs50.harvard.edu/x/ed Facebook Group: https://www.facebook.com/groups/cs50/ Faceboook Page: https://www.facebook.com/cs50/ GitHub: https://github.com/cs50 Gitter: https://gitter.im/cs50/x Instagram: https://instagram.com/cs50 LinkedIn Group: https://www.linkedin.com/groups/7

Published 2019-12-16 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.