Learning Documentation
This project was developed as part of the "Learn SQL by Building a Student Database: Part 1 and Part 2" courses, which are part of the Relational Database certification from FreeCodeCamp.
Here's a quick overview of the process followed in this course:
- Created a database using
PostgreSQLusing thecommand line. - Developed a
bash scriptto automate the process of inserting data into the database. - Developed another
bash scriptfor querying the database.
The detailed explanation of each step is provided in the following sections.
In the first part of the course, I learned how to build a database using the command line in PostgreSQL. This part of the course consisted of 140 lessons, each one contributing to my understanding of SQL and database management.
In addition to building the database, I also created a bash script to automate the process of inserting data into the database. This allowed me to practice and reinforce my understanding of both SQL and bash scripting.
The second part of the course focused on querying the database that was built in Part 1. I created another bash script, this time for querying the database.
I learned how to perform both simple and complex queries, which has given me a solid foundation in SQL and will be invaluable in my future projects.
This diagram provides a visual representation of the database structure, making it easier to understand the relationships between different tables and fields.
The script documents contain the bash scripts used for inserting data into the database and querying the database. By analyzing these scripts, I was able to gain a deeper understanding of how SQL queries work and how they can be automated using bash scripts.
Through this project, I have gained a solid foundation in SQL, database management, and bash scripting. I look forward to applying these skills in my future projects.