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

#webdev #database #postgres #learning

I document my learning journey until I become a full-stack web developer (41 Part Series)

1 [DAY 0] My Journey So Far: About Me, My Purpose, & My Goals 2 [DAY 1] First Time Learning HTML & CSS With ZERO Experience ... 37 more parts... 3 [DAY 2] Playing Around With HTML & CSS 4 [DAY 3] First Time Using CSS To Add An Animated Gradient Background To My Webpage 5 [DAY 4] I Decided To Try FreeCodeCamp 6 [DAY 5] I Built A Cafe Menu 7 [DAY 6-8] I Learned CSS Colors, HTML Forms, & Built A Survey Form Project 8 [DAY 9-11] I Learned CSS Box Model, Flexbox, Typography, HTML Accessibility, & Built A Tribute Page 9 [DAY 12-14] I Built A Piano, City Skyline, Magazine, & More Using HTML & CSS 10 [DAY 15-17] I Got My First Web Dev Certification & Started Learning Javascript 11 [DAY 18-20] I Built A Game & A Calorie Counter In Javascript 12 [DAY 21-23] I Built A Palindrome Checker, Music Player, & Date Formatter 13 [DAY 24-26] I Built A Todo App, Decimal To Binary Converter, & Player Filter 14 [DAY 27-29] I Tried LeetCode Challenges For The First Time 15 [DAY 30-32] I Built A Spam Filter, Number Sorter, And Statistics Calculator 16 [DAY 33-35] I Built A Statistics Calculator, A Spreadsheet, and Solved Leetcode Challenges 17 [DAY 36-38] I Built An Ecommerce Webpage 18 [DAY 39-41] I Built 2 Minigames & Solved 4 Leetcode Challenges 19 [DAY 42-47] I Built A Cash Register App 20 [DAY 48-53] I Built A Pokemon Search App 21 [DAY 54-56] I Learned Bootstrap, jQuery, SASS, and React 22 [DAY 57-59] I learned React & Redux 23 [DAY 60-62] I built a random quote machine using React 24 [DAY 63-65] I built a markdown previewer using React 25 [DAY 66-68] I built a drum set app using React 26 [DAY 69-71] I started building a calculator using React and I failed 27 [DAY 72–74] I built a calculator using React 28 [DAY 75-77] I built a timer app using React 29 [DAY 78-80] I learned about APIs, D3 library, and rebuilt my pokemon app 30 [DAY 81-83] I skipped a course and went straight into learning databases 31 [DAY 84-86] I Learned PostgreSQL & Bash Scripting 32 [DAY 87-89] I created a bash script to build a student database 33 [DAY 90-92] I made a shell script to build me a world cup database 34 [DAY 93-95] I built an interactive database in PostgreSQL using a shell script 35 [DAY 96-98] I built a script that gets info from a periodic table database 36 [DAY 99-101] I acquired a database certificate from freecodecamp 37 [DAY 102-104] I took a backend course in freecodecamp 38 [DAY 105-107] I built a contacts manager using Node.js & Express 39 [DAY 108-112] I built my first full-stack app with CRUD and auth logins 40 [DAY 113-117] I built 5 backend projects to acquire a backend certificate 41 [DAY 118-122] I learned full-stack by building my 2nd app

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!