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!
Top comments (0)