This content originally appeared on DEV Community and was authored by Thomas Cansino
Hi everyone! Welcome back to another blog where I document the things I learned in web development. I do this because it helps retain the information and concepts as it is some sort of an active recall.
On days 99-101, I built a number guessing game where I built a bash script that asks you to guess the random number and a database that stores all games’ history and user information. This is also part 5 which is the last project needed to complete to get the database certificate from freecodecamp.
What I did first is to make a database with 2 tables: game_history and usernames
After that, I assigned primary keys for each table:
- game_id for game_history table
- username_id for usernames table
I also linked the tables with foreign keys:
- username_id to link usernames and game_history table
Lastly, this is the script that I created:
Finally, I acquired the relational database certificate from freecodecamp!
I learned alot from this course and I recommend it if you want to learn about databases in your full-stack journey. It’s project-based so there's a few readings and mostly writing code (which I like). It mainly teaches about PostgreSQL, Bash, and Git.
Anyways, that’s all for now. More updates in my next blog! See you there!
This content originally appeared on DEV Community and was authored by Thomas Cansino
Thomas Cansino | Sciencx (2024-08-12T09:41:30+00:00) [DAY 99-101] I acquired a database certificate from freecodecamp. Retrieved from https://www.scien.cx/2024/08/12/day-99-101-i-acquired-a-database-certificate-from-freecodecamp/
Please log in to upload a file.
There are no updates yet.
Click the Upload button above to add an update.