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/
-
36:36
Andy Frisella
15 hours agoThe Mindset Shift That Transformed My Path to Success - Ep 729 Q&AF
16.8K6 -
1:53:34
Kim Iversen
7 hours agoEXPOSED: Pentagon’s Secret Anti-Vax Campaign | Establishment Starts To Finally Ask “Are We Baddies?”
65.4K142 -
1:53:49
Melonie Mac
6 hours agoGo Boom Live Ep 9!
36.1K8 -
1:22:22
Precision Rifle Network
14 hours agoGuns & Grub S2E9 - Rex Shoots A Match
23.1K2 -
1:25:41
Break The Cycle w/ Joshua Smith
5 hours agoBreak The Cycle Ep: 241 Trump isn't going to jail w/ Harrison Wells
25.9K1 -
1:55:59
Glenn Greenwald
8 hours agoAIPAC's Singular Ability to Remove and Influence Members of Congress; Senator Rand Paul On More COVID Cover-Ups; PLUS: Media Denies Biden's Decline | SYSTEM UPDATE #286
79.6K88 -
1:02:54
The StoneZONE with Roger Stone
6 hours agoThe Epic Corruption of JB Pritzker + Chaos at Democrat Convention in Chicago? The StoneZONE
34.3K10 -
1:29:03
Donald Trump Jr.
12 hours agoRight Wing Revolution: How to Win on the Ground, at the Ballot Box, and Save the West, Charlie Kirk & Sean Parnell | TRIGGERED Ep.147
119K212 -
1:42:49
The Quartering
11 hours agoDisney BUSTED On Secret Recording & Star Wars The Acolyte Backlash GOES NUCLEAR!
68.8K26 -
6:48
One Bite Pizza Reviews
1 day agoBarstool Pizza Review - Christo's Restaurant & Bar (Wallingford, CT)
48.6K26