SQL with PYTHON | Manage SQL databases using PYTHON ONLY

┋Professional Certificates┋

┋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┋

Thanks so much for taking a little time out of your day to watch this!

[oscar-]

I just found out your content, i do like it.
Its straight to the point and honest.
Couple days ago i started the google analyst course on coursera, currently trying to study 2 hours each day besides my job what I have now (25 years old).
I would love to see a video with like websites or links where you can keep up with the actual stuff that is going on in the analyse world.

I will follow your yourny and im curious what will come :).
Greatings from The Netherlands ;)

[BillyT]

Clear and detailed explanations! Thanks for sharing Mo! Hope to see more in the future!

[hiovanycubillosgomez]

Thank you man, I could understand and start to learn about this, the video is complete example and step-by-step to get knowledge and build small projects, awesome that you took the time to do it and then explain and lastly share it with us. I am from Bogota Colombia south America, I appreciate it, have a good one there.

[ramprasadsomaraju]

the happiest part is when u showed the other way to implement 😃😃😃happy for the content pls make on data cleaning more detailed

[grapefruitomega]

This is beyond helpful, you are one of a kind 🙇‍♂️🙇‍♂️

[YashAndTioShow]

Amazing video Mo, please could you make a video on Settings up Postgres and linking to VS Code/however you set it up for workflow 🧑‍💻

[thitiboat]

This is inspiring me to learn more about data sci. Thank you for sharing. I'm a complete beginner but wants to learn data engineering to break into tech. I'm feeling lost and don't know where to start.

What kind of education / courses do you recommend? Thank you in advance for taking the time to answer.

[mohammedhosayn]

Hi Mo Chen, Thanks a lot for making such an amazing very useful video. Sir, I just want to know how you create config file, because I don't understand that part. Please help me Sir that how can I create a config file in jupyter. Thanks again.

[jamesbelk]

Hello! I am getting an error when trying to iterate through the dataframe 'Perhaps you need a different "datestyle' setting. Would you happen to have any guidance on how to solve this?

[atharvakgb]

Hi i have video request for you can you make a video on remote job scenario for data analyst job role in uk companies and startups for the non uk resident

[katarinaoldakowski]

OMG I need something like this with MySQL ;(

[tvpoujj]

import psycopg2
import configparser
import pandas as pd
#magic function that will allow us to connect the postgresql database
%load_ext sql

ModuleNotFoundError Traceback (most recent call last)
in <module>
----> 1 import psycopg2
2 import configparser
3 import pandas as pd
4 #magic function that will allow us to connect the postgresql database
5 get_ipython().run_line_magic('load_ext', 'sql')

ModuleNotFoundError: No module named 'psycopg2'
How do I resolve this?

[Butimnotatrader]

Bro you’re not a data analyst, this is engineering work

I.E am a data engineer