Войти
  • 915138Просмотров
  • 3 года назадОпубликованоLuke Barousse

How I use SQL as a Data Analyst

SQL for Data Science 👉🏼 Coursera Plus (7-day free trial) 👉🏼 👨🏼‍💻 My FREE Course to be a Data Analyst 👉 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) 👉🏼 💿 SQL for Data Science 👉🏼 🧾 Excel Skills for Business 👉🏼  🐍 Python for Everybody 👉🏼 📊 Data Visualization with Tableau 👉🏼  🏴‍☠️ Data Science: Foundations using R 👉🏼 Coursera Plus Subscription (Monthly $59USD) 👉🏼 Coursera Plus Subscription (Annual $399USD) 👉🏼 👨🏼‍🏫 All courses 👉🏼 Build a Portfolio Online ================================== 👩🏻‍💻Build portfolio here 👉🏼 Rebate Code: "LUKE" My Portfolio 👉🏼 Books for Data Nerds ================================== 📚 Books I’ve read 👉🏼 📗 Data Science Must Read 👉🏼 📙 Tableau 👉🏼 📘 Power BI👉🏼 📕 Python 👉🏼 Tech for Data Nerds ================================== ⚙️ Tech I use 👉🏼 🪟Windows on a Mac (Parallels VM) 👉🏼 👨🏼‍💻 M1 Macbook Air (Mac of choice) 👉🏼 💻 Dell XPS 13 (PC of choice) 👉🏼 💻 Asus Vivo Book (Lowest Cost PC) 👉🏼 💻Lenovo IdeaPad (Best Value PC)👉🏼 Social Media / Contact Me ====================== 🙋🏼‍♂️Newsletter: 🌄 Instagram: ⏰ TikTok: @lukebarousse 📘 Facebook: 📥 Business Inquiries: luke@ 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