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
17:30 Creating the insert_data.sh script
36:00 Doing the queries in queries.sh
49:09 worldcup.sql on github and try to submit
52:20 Running tests and fixing mistakes

Connect on LinkedIn: https://www.linkedin.com/in/landon-schlangen-a3989a16b/