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-server/sql-server-downloads SQL SERVER MANAGEMENT STUDIO: https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15 LAHMAN'S BASEBALL DATA: http://www.seanlahman.com/baseball-archive/statistics/ 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: https://www.youtube.com/watch?v=Z9dGmL2G-4k&list=PL2zq7klxX5ATPC8RuqCuTDdki3b4NqKQv&index=2 Fundamentals Manipulation: https://www.youtube.com/watch?v=yIJrCFXs0rU&list=PL2zq7klxX5ATPC8RuqCuTDdki3b4NqKQv&index=3 Fundamentals Clearning: https://www.youtube.com/watch?v=4yI3vVe0Jos Fundamentals Regression: https://www.youtube.com/watch?v=EAezvs0eL1s #datascience #KenJee #SQL #DataScienceFundamentals ⭕ Subscribe: https://www.youtube.com/c/kenjee1?sub_confirmation=1 🎙 Listen to My Podcast: https://www.youtube.com/c/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=kenjee MORE DATA SCIENCE CONTENT HERE: 🐤My Twitter - https://twitter.com/KenJee_DS 👔 LinkedIn - https://www.linkedin.com/in/kenjee/ 📈 Kaggle - https://www.kaggle.com/kenjee 📑 Medium Articles - https://medium.com/@kenneth.b.jee 💻 Github - https://github.com/PlayingNumbers 🏀 My Sports Blog -https://www.playingnumbers.com Check These Videos Out Next! My Leaderboard Project: https://www.youtube.com/watch?v=myhoWUrSP7o&ab_channel=KenJee 66 Days of Data: https://www.youtube.com/watch?v=qV_AlRwhI3I&ab_channel=KenJee How I Would Learn Data Science in 2021: https://www.youtube.com/watch?v=41Clrh6nv1s&ab_channel=KenJee My Playlists Data Science Beginners: https://www.youtube.com/playlist?list=PL2zq7klxX5ATMsmyRazei7ZXkP1GHt-vs Project From Scratch: https://www.youtube.com/watch?v=MpF9HENQjDo&list=PL2zq7klxX5ASFejJj80ob9ZAnBHdz5O1t&ab_channel=KenJee Kaggle Projects: https://www.youtube.com/playlist?list=PL2zq7klxX5AQXzNSLtc_LEKFPh2mAvHIO