SQL with PYTHON | Manage SQL databases using PYTHON ONLY
12 هزار بار بازدید -
پارسال
-
GET YOUR DATA JOB ➡
GET YOUR DATA JOB ➡ https://mochen.info/
ULTIMATE DATA PORTFOLIO: Everything you need to get your data job ➡ https://mochen.info/ultimate-data-por...
AI JOB QUEST: Change the way you apply to jobs ➡ https://mochen.info/ai-job-quest-lp/
PATREON ➡ Patreon: mo_chen
1:1 MENTORSHIP: I put my heart and soul into this program. I'm here to help you succeed ➡ https://mochen.info/1-1-mentorship-lp/
CourseCareers: Start the FREE Data Analytics Introduction Course Now ➡ https://coursecareers.com/a/mochen?co...
Portfolio Projects Playlist: End-to-end, FREE guided portfolio projects covering Excel, SQL, Tableau, Power BI and Python ➡ Portfolio Projects
┋Community & Socials┋
Discord: discord ⬅ Join our Discord Data Community
Instagram: mo_chen1 ⬅ My IG is personal -- only follow if you're interested in non-data stuff as well
LinkedIn: mo-chen1 ⬅ Daily tips & advice on how to enhance your data analysis skills
Twitter: mo_chen_1 ⬅ Figuring out what I want to do in this space...
┋Professional Certificates┋
CourseCareers ➡ https://coursecareers.com/a/mochen
DataCamp Courses & Certifications ➡ https://datacamp.pxf.io/c/4216860/111...
Google Data Analytics Professional Certificate ➡ https://www.coursera.org/google-certi...
Google Advanced Data Analytics Professional Certificate ➡ https://www.coursera.org/google-certi...
Tableau Business Intelligence Professional Certificate ➡ https://imp.i384100.net/TableauBIAnalyst
Microsoft Power BI Data Analyst Professional Certificate ➡ https://www.coursera.org/professional...
IBM Data Science Professional Certificate ➡ https://imp.i384100.net/IBMdataScience
Google Project Management Professional Certificate ➡ https://imp.i384100.net/GoogleProject...
┋Timestamps┋
00:00 Intro
01:17 The data
01:37 Libraries
03:01 Load parameters
03:55 Create coffeeshops database
05:47 Drop table then create table
06:53 Read in csv file and explore the dataframe
07:54 Insert values into table
09:35 Sample SQL queries
11:44 Scripting
17:41 Outro
┋Files┋
Github repo for files ➡︎ https://github.com/mochen862/sql-with...
Install Jupyter notebook only ➡︎ https://jupyter.org/install
Install Anaconda distribution (this is what I have) ➡︎ https://docs.anaconda.com/free/anacon...
Install pgAdmin ➡︎ https://www.postgresql.org/download/
Thanks so much for taking a little time out of your day to watch this!
ULTIMATE DATA PORTFOLIO: Everything you need to get your data job ➡ https://mochen.info/ultimate-data-por...
AI JOB QUEST: Change the way you apply to jobs ➡ https://mochen.info/ai-job-quest-lp/
PATREON ➡ Patreon: mo_chen
1:1 MENTORSHIP: I put my heart and soul into this program. I'm here to help you succeed ➡ https://mochen.info/1-1-mentorship-lp/
CourseCareers: Start the FREE Data Analytics Introduction Course Now ➡ https://coursecareers.com/a/mochen?co...
Portfolio Projects Playlist: End-to-end, FREE guided portfolio projects covering Excel, SQL, Tableau, Power BI and Python ➡ Portfolio Projects
┋Community & Socials┋
Discord: discord ⬅ Join our Discord Data Community
Instagram: mo_chen1 ⬅ My IG is personal -- only follow if you're interested in non-data stuff as well
LinkedIn: mo-chen1 ⬅ Daily tips & advice on how to enhance your data analysis skills
Twitter: mo_chen_1 ⬅ Figuring out what I want to do in this space...
┋Professional Certificates┋
CourseCareers ➡ https://coursecareers.com/a/mochen
DataCamp Courses & Certifications ➡ https://datacamp.pxf.io/c/4216860/111...
Google Data Analytics Professional Certificate ➡ https://www.coursera.org/google-certi...
Google Advanced Data Analytics Professional Certificate ➡ https://www.coursera.org/google-certi...
Tableau Business Intelligence Professional Certificate ➡ https://imp.i384100.net/TableauBIAnalyst
Microsoft Power BI Data Analyst Professional Certificate ➡ https://www.coursera.org/professional...
IBM Data Science Professional Certificate ➡ https://imp.i384100.net/IBMdataScience
Google Project Management Professional Certificate ➡ https://imp.i384100.net/GoogleProject...
┋Timestamps┋
00:00 Intro
01:17 The data
01:37 Libraries
03:01 Load parameters
03:55 Create coffeeshops database
05:47 Drop table then create table
06:53 Read in csv file and explore the dataframe
07:54 Insert values into table
09:35 Sample SQL queries
11:44 Scripting
17:41 Outro
┋Files┋
Github repo for files ➡︎ https://github.com/mochen862/sql-with...
Install Jupyter notebook only ➡︎ https://jupyter.org/install
Install Anaconda distribution (this is what I have) ➡︎ https://docs.anaconda.com/free/anacon...
Install pgAdmin ➡︎ https://www.postgresql.org/download/
Thanks so much for taking a little time out of your day to watch this!
پارسال
در تاریخ 1402/02/02 منتشر شده
است.
12,058
بـار بازدید شده