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
GritsGG
22 minutes ago24+ Hour Marathon Stream! Most Wins in WORLD! 3704+!
15 watching -
LIVE
The Mike Schwartz Show
1 hour agoTHE MIKE SCHWARTZ SHOW with DR. MICHAEL J SCHWARTZ 10-07-2025
4,094 watching -
LIVE
GloryJean
22 minutes ago[MnK] Gaming w/ The Boys 🖱️ 6.7 K/D
11 watching -
12:46
RTT: Guns & Gear
5 hours agoThis Might Be the Best .45 Cal Suppressor: Anechoic Suppressors AnechoX 45L
451 -
LIVE
Matt Kohrs
11 hours agoLive Day Trading: Ripping Higher || Stock Market Open
528 watching -
LIVE
Wendy Bell Radio
5 hours agoWorse Than Watergate
7,728 watching -
LIVE
Barry Cunningham
1 hour agoMUST SEE LIVE: PAM BONDI SENATE HEARING!
1,366 watching -
LIVE
LFA TV
12 hours agoLIVE & BREAKING NEWS! | TUESDAY 10/7/25
2,607 watching -
1:01:26
Chad Prather
14 hours agoTake Away the Stone: When Faith Meets the Impossible
35.1K19 -
24:26
Tucker Carlson
16 hours agoThe 9/11 Files: They Could Have Stopped It | Ep 3
62.9K54