relational-database

Tsurugi - next generation RDB for the new era

The SingleStoreDB Dev Container is the fastest way to develop with SingleStore on your laptop or in a CI/CD environment.

☢️ Relational Database. This is one of the required projects to earn your certification. For this project, you will create an interactive Bash program that uses PostgreSQL to track the customers and appointments for your salon.

A RESTful Gilhari microservice demonstrating ORM for JSON objects with an e-commerce application object model having one-to-one and one-to-many relationships (using PostgreSQL)

This repository contains the "Kitty Ipsum Translator" project, demonstrating advanced Bash commands and scripting. It includes a translate.sh script that translates 'kitty ipsum' to 'doggy ipsum'. The repository is a reference for Bash scripting.

This repository contains the "Bike Rental Shop" project, a Bash and SQL application developed during the freeCodeCamp course. It includes interactive Bash scripts and SQL queries for a PostgreSQL database, providing practical examples of database interaction, data manipulation, and data analysis.

Solutions to the freecodecamp relational database projects

Apply MySQL service from Azure Cloud.

Reuse existing MySQL service.

A Bash-based interactive program for managing a salon appointment scheduler. It uses PostgreSQL to track customer information and appointments. The project includes a database dump (salon.sql) and a script file (salon.sh) for managing the system.

Hands-on relational database development in PostgreSQL, featuring complex SQL queries, database normalization, and Bash shell scripting.

Human-readable Relational Database

This is one of the required projects to earn the Relational Databases certification from freeCodeCamp. I wrote a Bash script to enter data from World Cup games into PostgreSQL and then query the database for useful statistics for this project.

Deploy containerized MySQL service on Kubernetes.

Able to manage postgres wal files with a simple interactive bash script

Reuse existing PostgreSQL service.

A Bash script for querying a periodic table database to retrieve information about chemical elements. The project includes a database dump (periodic_table.sql) and a script file (element.sh) to interact with the data.

Practical database administration project using PostgreSQL, MySQL, and Datasette (SQLite). Covers backups, user/role management, indexing, and performance optimization.

This is one of the required projects to earn the Relational Databases certification from freeCodeCamp. For this project, I created an interactive Bash program that uses PostgreSQL to keep track of clients and appointments for a salon.