SQL with PYTHON | Manage SQL databases using PYTHON ONLY

Published: 22 April 2023
on channel: Mo Chen

13,313

448

https://mochen.info/ ⬅ Exclusive Community┋Ultimate Data Portfolio┋Ultimate Data Roadmap┋Ultimate Excel Projects┋Data Analysis Bundle

  / mo-chen1   ⬅ Daily tips & advice on how to enhance your data analysis skills

  / mo_chen   ⬅ Support me on Patreon

   • Data Analysis Portfolio Projects   ⬅ Portfolio Projects Playlist: End-to-end, FREE guided portfolio projects covering Excel, SQL, Tableau, Power BI and Python

┋Professional Certificates┋

DataCamp Certifications ➡ https://datacamp.pxf.io/c/4216860/205...

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!

On this page of the site you can watch the video online SQL with PYTHON | Manage SQL databases using PYTHON ONLY with a duration of hours minute second in good quality, which was uploaded by the user Mo Chen 22 April 2023, share the link with friends and acquaintances, this video has already been watched 13,313 times on youtube and it was liked by 448 viewers. Enjoy your viewing!

44,835

465