These are the projects required to obtain the database certification on freecodecamp.org, and some other exercises of the certification that I deemed interesting enough to save.
The scripts need permission to execute : $ chmod +x <script_name>
-
universe.sql is a postgreSQL database built from scratch. It is one of the required learning projects for the certification.
-
five_shell_programs is a collection of 5 shell scripts.
-
student_database_part_1 is a postgreSQL database with a shell script to populate it from 2 csv files.
-
student_database_part_2 is a script with queries on the 'student.sql' database.
-
worldcup is a postgreSQL database with a shell script to populate it from a csv file, and another script with queries on the 'worldcup.sql' database. It is one of the required learning projects for the certification.
-
kitty_ipsum_translator is a collection of shell scripts that give basic info about the content of text files and translate kitty into doggy.
-
bike_shop is a postgreSQL database with a shell script to access and update the database.
-
salon is a postgreSQL database with a shell script to access and update the database. It is one of the required learning projects for the certification.
-
periodic_table is a postgreSQL database with a shell script to get information from the database. It is one of the required learning projects for the certification.
-
number_guesser is a shell script to guess a random number, with a database to store user info and previous games records. It is the final project of the certification.