Creating Python Projects #6 - Phone Book
Hello there,
In the last few weeks I have been trying to develop projects, specifically using Python, for beginners. So far, it has been pretty good, and I could see and increasing difficulty with these projects. In fact, today I am at number 6 which is a phone book...a simple phone book.
Why is this so important?
Well, because it introduces something that is paramount in programming, whether you are a beginner or more which is databases. I am not gonna stay here explaining different types of db, just know that the most important ones are 2: relationional and non-relational. In the first case, we talk about SQL the other no-SQL.
For this project I'll use a relationl db, therefore I need to use a bit of SQL, it's very basic but it is extremely useful for all the wannabe programmers out there.
As far as I can tell spending time learnign SQL at the beginning is absolutely priceless, because later on when confronting whith bigger, harder projects...web apps or website etcs, you won' really have a chance to experiment with SQL mainly because all the most used framewors, like django or flask in python, or express etc use what is commonly know as ORM (object relational Mappers) which in someway abstracts the entire SQL part and enables the programmer to interact with databases using the native language they are currently using. This might not be true if you are using, or plan to use php, there still might be a bit of SQL there.
I can give you a few reasons to learn SQL, other than what I just mentioned, for instance it is extremely easy. The basics are super easy, as it is not a programmiing language, but a declerative language..which means it does what you declare. There may be a bit of logic, variables exists, as well as if statements but for the most part you just type and it runs. In addition, dealing with SQL introduces you to relational databases, what tables are? what a foreign key or a primary key are? What does many-to-many or one-to-many relationships mean? and this comes in handy all those times when you have to think about database design, how you want to structure your data, if your app has data. So this project or any other project that forces you to learn SQL is absolutely welcome.
As always stay tuned for more, if you liked the content hit a like button so that more people can see it, and don't forget to subscribe that would really help this channel grow. Feel free to comment down below any suggestions, or personal projects you are willing to share.
For now it's all, I'll see you to the next video, Bye Bye.
Pythons projects: https://www.upgrad.com/blog/python-pr...
by Rohit Sharma
Music: https://www.bensound.com/
Github: https://github.com/BeGeos/YT-projects...
Images: https://www.freepik.co
Intro: 00:00
Databases: 00:36
Importance of SQL: 00:57
Project Setup: 02:43
Create DB and Table: 03:50
CRUD: 05:04
Main Logic: 08:59
Outro: 10:40
