Data Science Fundamentals: SQL Queries

In this video, I show you how to query a SQL database. I go over the SQL basics that are relevant for data science. SQL SERVER DOWNLOAD: https://www.microsoft.com/en-us/sql-s... SQL SERVER MANAGEMENT STUDIO: https://docs.microsoft.com/en-us/sql/... LAHMAN'S BASEBALL DATA: http://www.seanlahman.com/baseball-ar... Covered in this Video: 1) 7:35 SQL Clauses (SELECT, FROM, WHERE, GROUP BY, HAVING) 2) 11:00 TOP, DISTINCT 3) 12:45 AGGREGATION (GROUP BY, HAVING, COUNT, AVG, SUM, MIN, MAX) 4) 17:38 JOINS 5) 28:50 SUBQUERIES 6) 32:32 VIEWS Fundamentals Exploration:    • Data Science Fundamentals: Data Exploratio...   Fundamentals Manipulation:    • Data Science Fundamentals: Data Manipulati...   Fundamentals Clearning:    • Data Science Fundamentals: Data Cleaning i...   Fundamentals Regression:    • Data Science Fundamentals: Linear Regression   #datascience #KenJee #SQL #DataScienceFundamentals ⭕ Subscribe: https://www.youtube.com/c/kenjee1?sub... 🎙 Listen to My Podcast:    / kensnearestneighborspodcast   🕸 Check out My Website - https://kennethjee.com/ ✍️Sign up for My Newsletter - https://www.kennethjee.com/newsletter 📚 Books and Products I use - https://www.amazon.com/shop/kenjee (affiliate link) Partners & Affiliates 🌟 365 Data Science - Courses ( 57% Annual Discount): https://365datascience.pxf.io/P0jbBY 🌟 Interview Query - https://www.interviewquery.com/?ref=k... MORE DATA SCIENCE CONTENT HERE: 🐤My Twitter -   / kenjee_ds   👔 LinkedIn -   / kenjee   📈 Kaggle - https://www.kaggle.com/kenjee 📑 Medium Articles -   / kenneth.b.jee   💻 Github - https://github.com/PlayingNumbers 🏀 My Sports Blog -https://www.playingnumbers.com Check These Videos Out Next! My Leaderboard Project:    • I Built the FIRST EVER YouTube Subscriber ...   66 Days of Data:    • What is the #66DaysOfData?   How I Would Learn Data Science in 2021:    • How I Would Learn Data Science in 2021 (Wh...   My Playlists Data Science Beginners:    • Data Science Beginners   Project From Scratch:    • Data Science Project from Scratch - Part 1...   Kaggle Projects:    • Kaggle Projects