Creating Database and Building tables with python | #LearnByDoing (Part ⅔)

USE CODE: COMBO50 for a 50% discount

In the first video of their series, we got to know about Basics Data Models, starting from what is data model, why is data modeling important, who requires to learn data modeling, relational model and database to ACID properties continued with an exercise of creating a table with postgres. In this video, I will show you the process of building a table with python. You will also find a free database at the end of this video followed by a homework project for you. Watch Part 3 of this series to complete the data engineering project we started together.

=====================Resources=====================
🎯 Installing Python and Jupyter Notebook (First part)

🎯 PostgresSQL

🎯 Get Data Set For Project

🎯 Data Model Building

===================Follow Me Here===================

===================About Me===================
Freelance Data Engineer and Solution Architect.
I love learning about technology and teaching thing I know to other people. The goal of creating this channel was to teach everything I know to the world, I have spent most of my time learning things online and I want to share all my learning on this youtube channel.
I will be posting content related to data engineering, architecting systems, data science, machine learning, and interview preparation.

Thank you for watching the video, see you in the next video :)

My Accessories

TIMESTAMP
0:00 Introduction to Python and PostgreSQL
2:40 Table Structure
3:15 Creating Table using Python
16:50 Free Dataset
17:24 Next Week Project

#dataengineer #dataengineerproject #dataengineering

[TheAbroadLinkTravelAndVisa]

Great work. People need really real project work and it should be done only this way.

[karanangiah]

Thanks for taking the time to teach other people. Looking forward towards more videos

[bhagirathpandey]

Roadmap is crisp and practical in your videos, thanks for it, expecting similar real world use cases and actual e2e projects, thanks

[AAND]

Thank you Darshil for the brilliant tutorial, looking forward to doing the projects from your channel, keep up the good work 🙂

[anketlale]

Great tutorial, Thank you for proper explanation !!

[ShArK-ujhx]

I have a question what is the advantage or benefit of connecting python to postgresql and executing sql queries through python when it can be done through pgadmin?

[chiragnaik]

Awesome bro... This series is really helpful.

[JCGarcia]

Great video! Followed through with db creation and confirmed it to be created in sql shell but I receive the error "Did not find any relations" within the shell. I had to manually create the table and insert the values in shell but the python code outputs the values as inserted 4 times (twice for both entries). Is there a reason I was getting the error, although the python code outputs the data 4 times?

[hassanumair]

just watched your video and it is way easy to learn, thanks

[aishashaikh]

"did not find my relation error" when trying to display table. both from myfirstdb database and postgre database

[batoonihub]

Thankd Darshil, to explain in an easy and simple way!!

[sirichoudhary]

hey tutorial is wonderful, I have small question at 15:03 you said we can also use for loop to get the rows. can you please tell the syntax.
TIA

[chandann]

darshil parmer as i have started this project now. is it mandatory to use python because every thing u did in the above video can be done in mysql . and task provided at last like adding also can be doen without writing a code in mysql. sorry iam new to this field please correct me if am wrong and help me with a solution like why we should use python instead of doing it using mysql

[chiragnaik]

Bro can you please provide the correct syntax to delete repeated rows because I created a duplicate row for Raj bymistake.

I searched on Google also but I'm not getting the correct syntax.

[newagegenre]

Hello, thanks for the tutorial. The discord link is no more working

[akshaymohite]

hi darshil, why this concept python + postgresql needed for create DB and tables if we can directly create using postgre sw ?

[alex]

in row 9 regarding inserting the values, i have tried the same way as you did but its throwing up error "except psycopg2.Error as e:
^
SyntaxError: invalid syntax
" I have checked thrice but still the same error

[ritzysquad]

hi Darshil, thankyou so much for valuable content. Can we connect to MYSQL instead of Postgres? if yes then how ?

[nishantpruthi]

Can anyone help me finding a dataset which is adequate for relational modelling

[surakshanaik]

Can i import mysql to Jupiter instead prostgresql?
Can we use mysql or prostgresql which is better?