[DAY 99-101] I acquired a database certificate from freecodecamp

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!