CS50 SQL - Introduction

CS50 · Beginner ·📊 Data Analytics & Business Intelligence ·2y ago

Key Takeaways

Introduces databases with SQL, including querying a table of data and defining relationships

Full Transcript

foreign [Music] hello world this is cs50's Introduction to databases with SQL or SQL my name is David Malin and my name is Carter zenke cs50 itself is an introduction to computer science and along the way you learn about SQL and more this course Dives all the more deeply into SQL specifically and you can take it before during or after cs50 itself whether you're a computer scientist data scientist programmer or simply someone who's interested in databases now we'll begin with software called SQL Lite which you can use to query a table of data maybe a table of books for instance you will then graduate and work not just with one table but multiple and see how to define relationships among them afterwards you'll figure out how to design your very own database from scratch learning about schemas and data types and then you'll see how to add data to that database how to insert update and delete some data all together soon after you'll see how to write alternate views for your data new ways of simplifying your data for yourself and for others and then towards the end of the course you will see how to optimize your queries how to reduce the time that they take although at the cost of some space and then finally to cap it all off you'll learn other dbms's database Management Systems like MySQL and postgres that you can use do all of this and more at a much bigger scale now this is cs50

Original Description

*** 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_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/cs50 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/7437240/ LinkedIn Page: https://www.linkedin.com/school/cs50/ Medium: https://cs50.medium.com/ Quora: https://www.quora.com/topic/CS50 Reddit: https://www.reddit.com/r/cs50/ Slack: https://cs50.edx.org/slack Snapchat: https://www.snapchat.com/add/cs50 SoundCloud: https://soundcloud.com/cs50 Stack Exchange: https://cs50.stackexchange.com/ TikTok: https://www.tiktok.com/@cs50 Twitter: https://twitter.com/cs50 YouTube: http://www.youtube.com/cs50 HOW TO FOLLOW DAVID J. MALAN Facebook: https://www.facebook.com/dmalan GitHub: https://github.com/dmalan Instagram: https://www.instagram.com/davidjmalan/ LinkedIn: https://www.linkedin.com/in/malan/ Quora: https://www.quora.com/profile/David-J-Malan TikTok: https://www.tiktok.com/@davidjmalan Twitter: https://twitter.com/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/by-nc-sa/4.0/ David J. Malan https://cs.harvard.edu/malan malan@harvard.edu
Watch on YouTube ↗ (saves to browser)
Sign in to unlock AI tutor explanation · ⚡30

Playlist

Uploads from CS50 · CS50 · 0 of 60

← Previous Next →
1 Hello, World: Hadi Partovi
Hello, World: Hadi Partovi
CS50
 2 Content Distribution and Archival in a Digital Age
Content Distribution and Archival in a Digital Age
CS50
 3 CS50 2014 - Week 1
CS50 2014 - Week 1
CS50
 4 CS50 2014 - Week 3
CS50 2014 - Week 3
CS50
 5 CS50 2014 - Week 0, continued
CS50 2014 - Week 0, continued
CS50
 6 CS50 2014 - Week 4
CS50 2014 - Week 4
CS50
 7 Week 3, continued
Week 3, continued
CS50
 8 Quiz 0 Review
Quiz 0 Review
CS50
 9 CS50 2014 - Week 3, continued
CS50 2014 - Week 3, continued
CS50
 10 CS50 2014 - Week 7
CS50 2014 - Week 7
CS50
 11 CS50 2014 - Week 7, continued
CS50 2014 - Week 7, continued
CS50
 12 Breaking Through The (Google) Glass Ceiling by Christopher Bartholomew
Breaking Through The (Google) Glass Ceiling by Christopher Bartholomew
CS50
 13 Introduction to Amazon Web Services by Leo Zhadanovsky
Introduction to Amazon Web Services by Leo Zhadanovsky
CS50
 14 CS50 2014 - Week 9
CS50 2014 - Week 9
CS50
 15 How to Build Innovative Technologies by Abby Fichtner
How to Build Innovative Technologies by Abby Fichtner
CS50
 16 Light Your World (with Hue Bulbs) by Dan Bradley
Light Your World (with Hue Bulbs) by Dan Bradley
CS50
 17 Building Dynamic Web Apps with Laravel by Eric Ouyang
Building Dynamic Web Apps with Laravel by Eric Ouyang
CS50
 18 CS50 2014 - CS50 Lecture by Steve Ballmer
CS50 2014 - CS50 Lecture by Steve Ballmer
CS50
 19 CS50 2014 - Week 10
CS50 2014 - Week 10
CS50
 20 This is CS50 with Steve Ballmer?
This is CS50 with Steve Ballmer?
CS50
 21 Meteor: a better way to build apps by Roger Zurawicki
Meteor: a better way to build apps by Roger Zurawicki
CS50
 22 Data Analysis in R by Dustin Tran
Data Analysis in R by Dustin Tran
CS50
 23 Data Visualization and D3 by David Chouinard
Data Visualization and D3 by David Chouinard
CS50
 24 CS50 2014 - Week 6
CS50 2014 - Week 6
CS50
 25 Build Tomorrow's Library by Jeffrey Licht
Build Tomorrow's Library by Jeffrey Licht
CS50
 26 CS50 2014 - Week 9, continued
CS50 2014 - Week 9, continued
CS50
 27 Essential Scale-Out Computing by James Cuff
Essential Scale-Out Computing by James Cuff
CS50
 28 iOS App Development with Swift by Dan Armendariz
iOS App Development with Swift by Dan Armendariz
CS50
 29 Sam Clark Leads Yale Students on Tour to CS50 at Harvard
Sam Clark Leads Yale Students on Tour to CS50 at Harvard
CS50
 30 3D Modeling and Manufacture by Ansel Duff
3D Modeling and Manufacture by Ansel Duff
CS50
 31 CS50 2014 - Week 5, continued
CS50 2014 - Week 5, continued
CS50
 32 hello, world
hello, world
CS50
 33 CS50 2014 - Deep Thoughts - Hash Table
CS50 2014 - Deep Thoughts - Hash Table
CS50
 34 CS50 2014 - Deep Thoughts - Binary Tree
CS50 2014 - Deep Thoughts - Binary Tree
CS50
 35 CS50 2014 - Deep Thoughts - Scratch
CS50 2014 - Deep Thoughts - Scratch
CS50
 36 CS50 2014 - Deep Thoughts - MySQL
CS50 2014 - Deep Thoughts - MySQL
CS50
 37 LaunchCode Visits CS50
LaunchCode Visits CS50
CS50
 38 CS50 Live, Episode 100
CS50 Live, Episode 100
CS50
 39 CS50 Field Trip to Google
CS50 Field Trip to Google
CS50
 40 This is CS50 AP
This is CS50 AP
CS50
 41 Week 4: Monday - CS50 2011 - Harvard University
Week 4: Monday - CS50 2011 - Harvard University
CS50
 42 Week 2: Wednesday - CS50 2011 - Harvard University
Week 2: Wednesday - CS50 2011 - Harvard University
CS50
 43 Week 1: Wednesday - CS50 2011 - Harvard University
Week 1: Wednesday - CS50 2011 - Harvard University
CS50
 44 Week 11: Monday - CS50 2011 - Harvard University
Week 11: Monday - CS50 2011 - Harvard University
CS50
 45 Week 3: Wednesday - CS50 2011 - Harvard University
Week 3: Wednesday - CS50 2011 - Harvard University
CS50
 46 Week 12: Monday - CS50 2011 - Harvard University
Week 12: Monday - CS50 2011 - Harvard University
CS50
 47 Week 1: Friday - CS50 2011 - Harvard University
Week 1: Friday - CS50 2011 - Harvard University
CS50
 48 Week 3: Monday - CS50 2011 - Harvard University
Week 3: Monday - CS50 2011 - Harvard University
CS50
 49 Week 10: Wednesday - CS50 2011 - Harvard University
Week 10: Wednesday - CS50 2011 - Harvard University
CS50
 50 Week 2: Monday - CS50 2011 - Harvard University
Week 2: Monday - CS50 2011 - Harvard University
CS50
 51 Week 9: Monday - CS50 2011 - Harvard University
Week 9: Monday - CS50 2011 - Harvard University
CS50
 52 Week 7: Monday - CS50 2011 - Harvard University
Week 7: Monday - CS50 2011 - Harvard University
CS50
 53 Week 5: Monday - CS50 2011 - Harvard University
Week 5: Monday - CS50 2011 - Harvard University
CS50
 54 Week 5: Wednesday - CS50 2011 - Harvard University
Week 5: Wednesday - CS50 2011 - Harvard University
CS50
 55 Week 7: Wednesday - CS50 2011 - Harvard University
Week 7: Wednesday - CS50 2011 - Harvard University
CS50
 56 Week 8: Monday - CS50 2011 - Harvard University
Week 8: Monday - CS50 2011 - Harvard University
CS50
 57 Week 9: Wednesday - CS50 2011 - Harvard University
Week 9: Wednesday - CS50 2011 - Harvard University
CS50
 58 Week 8: Wednesday - CS50 2011 - Harvard University
Week 8: Wednesday - CS50 2011 - Harvard University
CS50
 59 Week 10: Monday - CS50 2011 - Harvard University
Week 10: Monday - CS50 2011 - Harvard University
CS50
 60 Week 2: Wednesday - CS50 2010 - Harvard University
Week 2: Wednesday - CS50 2010 - Harvard University
CS50

Related Reads

📰
12.4 Million US Business Registrations Are Sitting on State Open-Data Portals, Free
Unlock 12.4 million US business registrations for free from state open-data portals and boost your business intelligence
Dev.to · Brad Ju
 📰
Mau Naik Level? Ini Advanced Data Science Techniques untuk Data Analytics
Learn advanced data science techniques for data analytics to improve business decision-making
Medium · Data Science
 📰
I Finally Understood AWS Data Pipelines After Following a Single Customer Click
Learn how to understand AWS Data Pipelines by following a customer click, making it easier to design and implement data workflows
Dev.to · Anupa Supul
 📰
Beyond the Basics: Streamlit, Dash, and Bokeh for Interactive Dashboards
Learn to create interactive dashboards with Streamlit, Dash, and Bokeh, going beyond basic data visualization tools
Dev.to · RoyserVillanueva
Up next
ChatGPT Will Make Your Excel & Google Sheets x10 Better!
Educraft
Watch →