How I use SQL as a Data Analyst

SQL for Data Science 👉🏼 https://lukeb.co/SQLdataScience Coursera Plus (7-day free trial) 👉🏼 https://lukeb.co/CourseraPlus 👨🏼‍💻 My FREE Course to be a Data Analyst 👉 https://lukebarousse.com/5daycourse Data Nerds!! Let's discuss how SQL is used in Data Science. For this, I cover the basics of how to use SQL; Additionally, we talk about popular database options (MySQL, PostgreSQL, SQLite, SQL Server, Oracle) and editors to use (VS Code, DBeaver, Access). Certificates & Courses ================================== Coursera Courses: 📜 Google Data Analytics Certificate (START HERE) 👉🏼 https://lukeb.co/GoogleCert 💿 SQL for Data Science 👉🏼 https://lukeb.co/SQLdataScience 🧾 Excel Skills for Business 👉🏼  https://lukeb.co/ExcelBusinessAnalyst 🐍 Python for Everybody 👉🏼 https://lukeb.co/PythonForEverybody 📊 Data Visualization with Tableau 👉🏼 https://lukeb.co/Tableau_UCDavis 🏴‍☠️ Data Science: Foundations using R 👉🏼 https://lukeb.co/RforDataScienceJH Coursera Plus Subscription (Monthly $59USD) 👉🏼 https://lukeb.co/CourseraMonthly Coursera Plus Subscription (Annual $399USD) 👉🏼 https://lukeb.co/CourseraYearly 👨🏼‍🏫 All courses 👉🏼 https://kit.co/lukebarousse/data-analytics-courses Build a Portfolio Online ================================== 👩🏻‍💻Build portfolio here 👉🏼 http://hostinger.com/luke Rebate Code: "LUKE" My Portfolio 👉🏼 https://lukebarousse.tech/ Books for Data Nerds ================================== 📚 Books I’ve read 👉🏼 https://kit.co/lukebarousse/book-recommendations 📗 Data Science Must Read 👉🏼 https://geni.us/StorytellingWithData 📙 Tableau 👉🏼 https://geni.us/tableau 📘 Power BI👉🏼 https://geni.us/powerbi 📕 Python 👉🏼 https://geni.us/pythontricks Tech for Data Nerds ================================== ⚙️ Tech I use 👉🏼 https://kit.co/lukebarousse/computer-accessories 🪟Windows on a Mac (Parallels VM) 👉🏼 https://lukeb.co/ParallelsFreeTrial 👨🏼‍💻 M1 Macbook Air (Mac of choice) 👉🏼 https://geni.us/M1macAir8GB 💻 Dell XPS 13 (PC of choice) 👉🏼 https://geni.us/DellNewXPS13 💻 Asus Vivo Book (Lowest Cost PC) 👉🏼 https://geni.us/AsusVivoBook15 💻Lenovo IdeaPad (Best Value PC)👉🏼 https://geni.us/LenovoIdeaPad15 Social Media / Contact Me ====================== 🙋🏼‍♂️Newsletter: https://www.lukebarousse.com/ 🌄 Instagram: https://www.instagram.com/lukebarousse/ ⏰ TikTok: https://www.tiktok.com/@lukebarousse 📘 Facebook: https://www.facebook.com/datavizbyluke 📥 Business Inquiries: [email protected] 00:00 Intro 00:44 Types of analysis w/ SQL 02:34 What is SQL? 03:14 How to query w/ SQL? 05:25 What database to use? 06:12 NoSQL vs SQL 07:09 SQL Course Recommendation 08:16 Where to keep database? 09:27 Cloud database options 10:14 SQL editors 11: 57 How I use SQL! 14:16 Suprise ending As a member of the Amazon, Coursera, Hostinger, Parallels, and Interview Query Affiliate Programs, I earn a commission from qualifying purchases on the links above. It costs you nothing but helps me with content creation. #datanerd #dataanalyst #datascience