How I use SQL as a Data Analyst
YouTube Viewers YouTube Viewers
434K subscribers
788,281 views
0

 Published On Jan 28, 2022

SQL for Data Science ๐Ÿ‘‰๐Ÿผ https://lukeb.co/SQLdataScience
Coursera Plus (7-day free trial) ๐Ÿ‘‰๐Ÿผ https://lukeb.co/CourseraPlus

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-anal...

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-reco...
๐Ÿ“— 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-...
๐ŸชŸ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: ย ย /ย lukebarousseย ย 
โฐ TikTok: ย ย /ย lukebarousseย ย 
๐Ÿ“˜ Facebook: ย ย /ย 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

show more

Share/Embed