How I use SQL as a Data Analyst

SQL for Data Science 👉🏼 https://lukeb.co/SQLdataScience
Coursera Plus ($100 off until Jan. 31st) 👉🏼 https://lukeb.co/CourseraPlus100off

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

Interview Prep
==================================
👩🏽‍🏫 Interview Questions & Coaching 👉🏼 https://lukeb.co/InterviewQuery

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: luke@lukebarousse.com

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.

#dataanalyst #datascience #dataanalytics

data viz by lukebusiness intelligencedata science