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

Join Course Python for Data Engineering - https://bit.ly/4140KI9

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.

Here is the Part 3 of this series #LearnByDoing - https://youtu.be/POjDCe-_G8k

Join Discord Channel - https://discord.gg/dHjvD8JCG3

=====================Resources=====================
? Installing Python and Jupyter Notebook (First part)
? https://youtu.be/eInHnOxTA-0

? PostgresSQL
? https://www.postgresql.org/download

? Get Data Set For Project
? https://registry.opendata.aws/
? https://datasetsearch.research.google.com/
? https://archive.ics.uci.edu/ml/datasets.php
? https://www.kaggle.com/datasets

? Data Model Building
? https://www.youtube.com/watch?v=acNmHwl9iPs
? https://www.guru99.com/data-modelling-conceptual-logical.html



===================Follow Me Here===================
?? My Linkedin - https://www.linkedin.com/in/darshil-parmar/
? Instagram - https://www.instagram.com/darshilparmarr
?Twitter - https://twitter.com/parmardarshil07

===================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
? Mic -https://amzn.to/3Bnu53n
? Camera (I use my phone) - https://amzn.to/3wOogIU
? Headphone - https://amzn.to/3BsJxLB
⌨ Mouse and Keyboard - https://amzn.to/3zeF1yq
? Monitor - https://amzn.to/3zk0Dts

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