World Cup Database | FreeCodeCamp

This video will guide you through one of the required projects to earn your certification. In this project, you will learn how to create a Bash script that automates the process of entering information from World Cup games into PostgreSQL. Once the data is entered, you will be shown how to query the database for useful statistics, such as the number of goals scored by a specific team or the average number of goals scored per game.

The project will require a basic understanding of Bash scripting and PostgreSQL, but no prior experience is necessary. By the end of this project, you will have gained practical experience in creating Bash scripts and using PostgreSQL to manipulate data.

Whether you're looking to earn your certification or simply wanting to learn a new skill, this World Cup Bash Script Project is a great opportunity to improve your knowledge and take your programming skills to the next level. So, let's get started! Thanks for watching and have a great day!

Timestamps:
00:00 Connecting
02:50 Creating games and teams tables
12:40 Getting reference for insert_data bash script
52:20 Running tests and fixing mistakes

[tearn]

Thank you ... I needed that ... and thank for D3 too ... Big Up bro !!

[スイ-or]

I have reached gitpod usage limit, and I am trying to use replit for the alternative, did you use any paid plans for those?

[piusgathuita]

Having this error: psql: error: FATAL: Peer authentication failed for user "freecodecamp", help out.

[Franck_Major_X]

Thanks, I would've appreciated more you would've shown a bit more the 'final product' of the insert_data and queries files.

[almandohafenaaje]

Did anyone managed to complete this? I'm stuck for about two weeks now. can someone please help me?

[yasuie]

can i ask how to rearrange the teams in order like the expected output
instead of brazil going first its going to be algeria

[EviElvina-zf]

hi i like your tutorial sm but now my database error. I followed until runned the database and i do reset as you do it too but now my world cup database error (cant save it, cant run it, it said psql error) so how i can fix it? thank you so much

[HaitamAberdaa]

I have that problem of SUBTASK database should exist how to fix that?

[ItsDave]

i did the code step by step from start to finish but suddenly all my code disappeared im furstrated i cant solve the last errors

[DontaeCreek]

Could you explain how you set the COLUMN name to NOT NULL ?

[blackslash]

error: worldcup should exist
HOW did you DEBUG the echo thing?