Premium Only Content
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/
-
LIVE
FusedAegisTV
19 hours agoNYE Eve! - 2025 Incoming 🎉 - 12hr Variety Stream!
144 watching -
1:18:52
Awaken With JP
6 hours agoSomehow The World DIDN’T End This Year! - LIES Ep 72
52.5K27 -
1:19:34
Michael Franzese
4 hours agoWhat 2024 Taught Us About the Future?
60K16 -
1:48:09
The Quartering
5 hours agoBird Flu PANIC, Sam Hyde DESTROYS Elon Musk & Patrick Bet David & Woke Witcher?
78.6K49 -
4:47
SLS - Street League Skateboarding
3 days agoLiz Akama’s 2nd Place Finish at SLS Tokyo 2024 | Best Tricks
23.1K3 -
LumpyPotatoX2
4 hours agoHappy New Year Rumble ! - #RumbleGaming
15.5K -
10:37
One Bite Pizza Reviews
23 hours agoBest of Barstool Pizza Reviews 2024
45.7K29 -
2:37
Tate Speech by Andrew Tate
6 hours ago2025 WILL BE YOUR YEAR
80.2K31 -
3:51:31
Sgtfinesse
7 hours agoRumble New Years Eve with Sarge
53.2K -
LIVE
Sm0k3m
8 hours agoNew Years Eve | Good bye 2024
86 watching