SQL with PYTHON | Manage SQL databases using PYTHON ONLY

Опубликовано: 22 Апрель 2023
на канале: 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!