Misty-42 · @Misty42
33 followers · 237 posts · Server hachyderm.ioThe last project has been completed and I've claimed the #RelationalDatabase #certification from #freeCodeCamp.
https://freecodecamp.org/certification/Misty-42/relational-database-v8
#relationaldatabase #certification #freecodecamp #getfedihired #rdbms #keepthemomentum
Misty-42 · @Misty42
32 followers · 234 posts · Server hachyderm.io
Another project down, very satisfying. I created a bash script to pull element, type, and property information from a postgresql db with minor additions/fixes to said db first.
One more to go for the #RelationalDatabase Certification path via #freeCodeCamp.
#relationaldatabase #freecodecamp #getfedihired #rdbms #keepthemomentum
Misty-42 · @Misty42
32 followers · 229 posts · Server hachyderm.ioThe next to last project for the #RelationalDatabase Certification path via #freeCodeCamp brings together what we've covered while working with a Periodic Table Database.
The project focuses on #git, #PostgreSQL, and, as always, #bash shell.
#relationaldatabase #freecodecamp #git #postgresql #bash #getfedihired #rdbms #keepthemomentum
Misty-42 · @Misty42
32 followers · 229 posts · Server hachyderm.ioThe next to last project for the #RelationalDatabase Certification path via #freeCodeCamp brings together what we've covered while working with a Periodic Table Database.
The project focuses on #git and, as always, #bash shell.
#relationaldatabase #freecodecamp #git #bash #getfedihired #postgresql #rdbms #keepthemomentum
Misty-42 · @Misty42
32 followers · 229 posts · Server hachyderm.ioThe next project for the #RelationalDatabase Certification path via #freeCodeCamp was primarily about using #git. I learned a few things and got myself lost a couple times but I successfully completed the lesson.
The project also used #nano and, as always, #bash shell.
There are 2 projects left to complete the certification path.
#relationaldatabase #freecodecamp #git #nano #bash #getfedihired #rdbms #keepthemomentum
Misty-42 · @Misty42
31 followers · 218 posts · Server hachyderm.ioThe next project for the #RelationalDatabase Certification path via #freeCodeCamp uses #nano. This will be a learning project as I've used vi or emacs in the past to edit text files.
As always, this project uses #bash.
#relationaldatabase #freecodecamp #nano #bash #getfedihired #rdbms #keepthemomentum
Misty-42 · @Misty42
31 followers · 216 posts · Server hachyderm.ioAnother project down for the #RelationalDatabase Certification path via #freeCodeCamp and 4 left.
I took a bit longer than usual for this project since I took some time for myself during the last couple weeks.
I did get stuck. I ended up reviewing the test code for the project and realized that I had a column that wasn't big enough for the test data. Once I corrected that, it was all good.
Next project has new to me stuff :D
#relationaldatabase #freecodecamp #getfedihired #rdbms #keepthemomentum
Misty-42 · @Misty42
31 followers · 216 posts · Server hachyderm.ioAnother project down for the #RelationalDatabase Certification path via #freeCodeCamp and 4 left.
It took a bit longer than usual as I took some time for myself and then I got stuck at the end.
I had to look at the code to see what was being tested for and realized that I'd set one of my columns too small for the test to complete successfully. Once I made that correction, it was all good.
#relationaldatabase #freecodecamp #getfedihired #rdbms #keepthemomentum
Misty-42 · @Misty42
30 followers · 211 posts · Server hachyderm.io
The next project for the #RelationalDatabase Certification path via #freeCodeCamp is to build an appointment scheduler program. This project uses #bash and #PostgreSQL.
#relationaldatabase #freecodecamp #bash #postgresql #getfedihired #rdbms #keepthemomentum
Misty-42 · @Misty42
30 followers · 211 posts · Server hachyderm.ioAnother project down for the #RelationalDatabase Certification path via #freeCodeCamp and 5 left. This project had SQL joins, updates and more inserts, and a bash script with more loops, functions, and nested if...then...else...fi blocks.
#relationaldatabase #freecodecamp #getfedihired #rdbms #keepthemomentum
Misty-42 · @Misty42
30 followers · 207 posts · Server hachyderm.ioAnother project down for the #RelationalDatabase Certification path via #freeCodeCamp and 5 left. This project had SQL joins, updates and more inserts, and a bash script with more loops, functions, and nested if...then...else...fi blocks.
#relationaldatabase #freecodecamp #getfedihired #rdbms #keepthemomentum
Misty-42 · @Misty42
30 followers · 211 posts · Server hachyderm.ioThe next project for the #RelationalDatabase Certification path via #freeCodeCamp is to build a bike rental program. This project uses #bash and #PostgreSQL.
#relationaldatabase #freecodecamp #bash #postgresql #getfedihired #rdbms #keepthemomentum
Misty-42 · @Misty42
30 followers · 211 posts · Server hachyderm.ioWith the kitty ipsum translator project, I got a refresher for grep, sed, diff, and regex.
It really is nice to be working through a skill training/validation projects that include a sense of satisfaction.
Another project down and I'm more than halfway through the #RelationalDatabase Certification path.
#relationaldatabase #getfedihired #rdbms #keepthemomentum
Misty-42 · @Misty42
28 followers · 206 posts · Server hachyderm.io
The next project in the #RelationalDatabase Certification path from #freeCodeCamp uses advanced #bash
commands to build a kitty Ipsum translator 👀
Certainly sounds interesting :blobfoxnerd:
#relationaldatabase #freecodecamp #bash #getfedihired #rdbms #keepthemomentum
Misty-42 · @Misty42
28 followers · 206 posts · Server hachyderm.ioThe World Cup Database project completed for the #RelationalDatabase Certification path via #freeCodeCamp. Tomorrow I'll be on to the next.
#relationaldatabase #freecodecamp #getfedihired #training #rdbms #keepthemomentum
Misty-42 · @Misty42
20 followers · 106 posts · Server hachyderm.ioI keep learning new things whilst working on the Celestial Bodies projects for the #RelationalDatabase Certification path via #FreeCodeCamp
#TodayILearned about the Hubble image catalogs based on observations by #astronomer Robert Messier and amateur astronomer Sir Patrick Moore. I'm fascinated.
https://www.nasa.gov/content/goddard/hubble-s-messier-catalog#grid
https://www.nasa.gov/content/goddard/hubble-s-caldwell-catalog#grid
#relationaldatabase #freecodecamp #todayilearned #astronomer #Astronomy #celestialbodies #training #rdbms #keepthemomentum
Amber Manfree PhD · @Amber
132 followers · 209 posts · Server mapstodon.space...spent way too long trying to get a table join to work thinking it was a formatting issue, then remembered that the area had recently been redistricted. Works like a charm, now! 😠😂
#gischat #GIS #datascience #mapping #relationaldatabase
Francesco Tisiot · @ftisiot
168 followers · 46 posts · Server data-folks.masto.host
Can I use a #relationaldatabase to store, parse and analyse #semistructured #JSON data?
It turns out #PostgreSQL is pretty good at it with the dedicated #jsonb functions
Check out an example, finding a good restaurant in India!
#relationaldatabase #semistructured #json #PostgreSQL #jsonb