SQL with PYTHON | Manage SQL databases using PYTHON ONLY

How I Built 50+ Data Projects in 90 DAYS: https://mochen.info/50-projects-90-days/
Data Analysis Lab - Build Your Data Portfolio in 30 DAYS: https://www.skool.com/data-analysis-lab
1:1 Mentorship: https://tidycal.com/mochen/1-to-1-men...

Sponsorships: enquiries@mochen.info

Hi! I'm Mo, and I help career switchers transitioning into Data Analytics. I'm a Data & Analytics Manager, and I've been working in the Financial and Banking Data space for 7 years now.

COURSES & CERTIFICATES
Get 25% OFF DataCamp's Courses & Certificates: https://datacamp.pxf.io/DataCampMoChen

INDUSTRY RECOGNIZED CERTIFICATIONS
Data Analyst Certification Program: https://datacamp.pxf.io/dataAnalystCe...
PowerBI Data Analyst Certification Program: https://datacamp.pxf.io/PowerBIDataAn...
Data Scientist Certification Program: https://datacamp.pxf.io/DataScientist...
SQL Associate Certification Program: https://datacamp.pxf.io/SQLAssociateCert

TOP DATA ANALYST COURSES
Data Analyst with Python: https://datacamp.pxf.io/dataAnalystWi...
Data Analyst with PowerBI: https://datacamp.pxf.io/dataAnalystPo...
Associate Data Analyst in SQL: https://datacamp.pxf.io/AssociateData...

TOP DATA SCIENTIST COURSES
Associate Data Scientist in Python: https://datacamp.pxf.io/AssociateData...
Associate Data Scientist in R: https://datacamp.pxf.io/AssociateData...

TOP DATA ENGINEER COURSES
Data Engineer in Python: https://datacamp.pxf.io/DataEngineerI...

TOP BUSINESS INTELLIGENCE COURSES
PowerBI Fundamentals: https://datacamp.pxf.io/PowerBIFundam...
Tableau Fundamentals: https://datacamp.pxf.io/TableauFundam...

TOP PROGRAMMING LANGUAGE COURSES
Python Fundamentals for Data Science: https://datacamp.pxf.io/PythonFundame...
Python Fundamentals for Programming: https://datacamp.pxf.io/PythonFundame...
SQL Fundamentals: https://datacamp.pxf.io/SQLFundamentals
R Programming Fundamentals: https://datacamp.pxf.io/RFundamentals

TOP AI COURSES
AI Engineer for Developers Course: https://datacamp.pxf.io/AIEngineerDev...
AI Engineer for Data Scientists Course: https://datacamp.pxf.io/AIEngineerDat...
Developing AI Applications Course: https://datacamp.pxf.io/AIApplications

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

PROJECT 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/